<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2900.2769" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=766412808-20102005>Thanks
chaps for your help.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=766412808-20102005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=766412808-20102005>Arash
I have visited the link below and found quite a few gems
there</SPAN></FONT></DIV>
<DIV> </DIV>
<P><FONT face=Arial color=#0000ff size=2>With kind regards</FONT> <BR><FONT
face=Arial color=#0000ff size=2>Nick Michael</FONT> <BR><FONT face=Arial
color=#0000ff size=2>tel 2-9032</FONT> <BR><FONT face=Arial color=#0000ff
size=2>cell 082-508-1950</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Arash Kaffamanesh
[mailto:arash.kaffamanesh@pomegranate.de]<BR><B>Sent:</B> Wednesday, October
19, 2005 17:53<BR><B>To:</B> 'The OpenCms mailing list'<BR><B>Cc:</B> Michael,
Nick N<BR><B>Subject:</B> RE: [opencms-dev] Accessing a table from a
JSP<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=833314915-19102005>Hi
Nik,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=833314915-19102005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=833314915-19102005>in
the following thread: <!--StartFragment --><FONT face="Times New Roman"
color=#000000 size=3> howto setup additional connection pool to access an
external database </FONT></SPAN></FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3><SPAN
class=833314915-19102005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=833314915-19102005><A
href="http://www.pomegranate.de:9000/cms/forum/viewthread?thread=12">http://www.pomegranate.de:9000/cms/forum/viewthread?thread=12</A></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=833314915-19102005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=833314915-19102005>there is an example how to do it.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=833314915-19102005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=833314915-19102005>HTH,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2>R<SPAN
class=833314915-19102005>egards, </SPAN><FONT size=+0><SPAN
class=833314915-19102005>Arash</SPAN></FONT></FONT></FONT></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
opencms-dev-bounces@opencms.org [mailto:opencms-dev-bounces@opencms.org]
<B>On Behalf Of </B>Michael, Nick N<BR><B>Sent:</B> Mittwoch, 19. Oktober
2005 10:28<BR><B>To:</B> 'The OpenCms mailing list'<BR><B>Subject:</B>
[opencms-dev] Accessing a table from a JSP<BR><BR></FONT></DIV>
<P><FONT size=2>Hi there</FONT> <BR><FONT size=2>I have added a table called
membership_applications to the database.</FONT> </P>
<P><FONT size=2>How do I set up a JDBC connection to that table ?</FONT>
<BR><FONT size=2>I cant figure out the Connection Name to do this.</FONT>
</P>
<P><FONT size=2>I want to write :</FONT> <BR><FONT size=2>a JSP with a
Insert (SQL) Query </FONT><BR><FONT size=2>and </FONT><BR><FONT size=2>a JSP
with a Select (SQL) Query</FONT> </P>
<P><FONT size=2>Can I use the OpenCms API to make calls to the database to
access my table?</FONT> </P><BR><BR>
<P><FONT size=2>With kind regards</FONT> <BR><FONT size=2>Nick
Michael</FONT> <BR><FONT size=2>tel 2-9032</FONT> <BR><FONT size=2>cell
082-508-1950</FONT> </P>
<DIV>__________________________________________________________________________________________________________________________________</DIV>
<DIV><SPAN class=236492506-24112004><FONT size=2><SPAN lang=EN-ZA
style="FONT-SIZE: 9pt; LAYOUT-GRID-MODE: line; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-ZA; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><STRONG><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Standard
Bank Disclaimer and Confidentiality Note<O:P></O:P></SPAN></STRONG>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 9pt; mso-bidi-font-size: 12.0pt"><O:P></O:P></SPAN></P>
<P class=MsoBodyText
style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: normal; TEXT-ALIGN: justify"><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">This
e-mail, its attachments and any rights attaching hereto are, unless the
context clearly indicates otherwise, the property of Standard Bank Group
Limited </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">and/or
its subsidiaries ("the Group"). It is confidential, private and intended for
the addressee only.</SPAN></P>
<P class=MsoBodyText
style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: normal; TEXT-ALIGN: justify"><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"></SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Should
you not be the addressee and receive this e-mail by </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">mistake,
kindly notify the sender, and delete this e-mail, immediately and do not
disclose or use same in any manner whatsoever. </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Views
and opinions expressed </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">in
this e-mail are those of the sender unless clearly stated as those of the
Group. The Group </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Arial Unicode MS'">accepts
no liability whatsoever for any loss or damages </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Arial Unicode MS'">whatsoever
and howsoever incurred, or suffered, resulting, or arising, from the use of
this email or its attachments.</SPAN></P>
<P class=MsoBodyText
style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: normal; TEXT-ALIGN: justify"><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Arial Unicode MS'"></SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Arial Unicode MS'">The
Group does not warrant the integrity of this </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Arial Unicode MS'">e-mail
nor that it is free of errors, viruses, interception or interference.
</SPAN><SPAN
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-GB">Licensed
divisions of the Standard Bank Group are authorised financial services
providers in terms of the Financial Advisory and Intermediary Services Act,
No 37 of 2002 (FAIS).</SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><O:P></O:P></SPAN></P>
<P class=MsoBodyText
style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: normal; TEXT-ALIGN: justify"><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><O:P></O:P></SPAN></P>
<P class=MsoBodyText style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: normal"><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Arial Unicode MS'">For
information about the Standard Bank Group Limited visit our website <A
href="http://www.standardbank.co.za"><FONT
color=#0000ff>http://www.standardbank.co.za</FONT></A></SPAN></P></SPAN></FONT></SPAN><FONT
color=#0000ff><FONT
color=#000000>__________________________________________________________________________________________________________________________________<BR></FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></FONT>
<DIV>__________________________________________________________________________________________________________________________________</DIV>
<DIV><SPAN class=236492506-24112004><FONT size=2><SPAN lang=EN-ZA
style="FONT-SIZE: 9pt; LAYOUT-GRID-MODE: line; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-ZA; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><STRONG><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Standard
Bank Disclaimer and Confidentiality Note<O:P></O:P></SPAN></STRONG>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 9pt; mso-bidi-font-size: 12.0pt"><O:P></O:P></SPAN></P>
<P class=MsoBodyText
style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: normal; TEXT-ALIGN: justify"><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">This
e-mail, its attachments and any rights attaching hereto are, unless the context
clearly indicates otherwise, the property of Standard Bank Group Limited
</SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">and/or
its subsidiaries ("the Group"). It is confidential, private and intended for the
addressee only.</SPAN></P>
<P class=MsoBodyText
style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: normal; TEXT-ALIGN: justify"><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"></SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Should
you not be the addressee and receive this e-mail by </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">mistake,
kindly notify the sender, and delete this e-mail, immediately and do not
disclose or use same in any manner whatsoever. </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Views and
opinions expressed </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">in this
e-mail are those of the sender unless clearly stated as those of the Group. The
Group </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Arial Unicode MS'">accepts
no liability whatsoever for any loss or damages </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Arial Unicode MS'">whatsoever
and howsoever incurred, or suffered, resulting, or arising, from the use of this
email or its attachments.</SPAN></P>
<P class=MsoBodyText
style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: normal; TEXT-ALIGN: justify"><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Arial Unicode MS'"></SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Arial Unicode MS'">The
Group does not warrant the integrity of this </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Arial Unicode MS'">e-mail
nor that it is free of errors, viruses, interception or interference.
</SPAN><SPAN
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-GB">Licensed
divisions of the Standard Bank Group are authorised financial services providers
in terms of the Financial Advisory and Intermediary Services Act, No 37 of 2002
(FAIS).</SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><O:P></O:P></SPAN></P>
<P class=MsoBodyText
style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: normal; TEXT-ALIGN: justify"><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><O:P></O:P></SPAN></P>
<P class=MsoBodyText style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: normal"><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Arial Unicode MS'">For
information about the Standard Bank Group Limited visit our website <A
href="http://www.standardbank.co.za"><FONT
color=#0000ff>http://www.standardbank.co.za</FONT></A></SPAN></P></SPAN></FONT></SPAN><FONT
color=#0000ff><FONT
color=#000000>__________________________________________________________________________________________________________________________________<BR></FONT></DIV></FONT>
</BODY></HTML>