[opencms-dev] Accessing a table from a JSP

[Arash Kaffamanesh]

Hi Nik,
 
in the following thread:  howto setup additional connection pool to
access an external database 
 
http://www.pomegranate.de:9000/cms/forum/viewthread?thread=12
 
there is an example how to do it.
 
HTH,
 
Regards, Arash

-----Original Message-----
From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Michael, Nick N
Sent: Mittwoch, 19. Oktober 2005 10:28
To: 'The OpenCms mailing list'
Subject: [opencms-dev] Accessing a table from a JSP



Hi there 
I have added a table called membership_applications to the database. 

How do I set up a JDBC connection to that table ? 
I cant figure out the Connection Name to do this. 

I want to write : 
a JSP with a Insert (SQL) Query 
and 
a JSP with a Select (SQL) Query 

Can I use the OpenCms API to make calls to the database to access my
table? 



With kind regards 
Nick Michael 
tel 2-9032 
cell 082-508-1950 

________________________________________________________________________
__________________________________________________________
Standard Bank Disclaimer and Confidentiality Note 



This e-mail, its attachments and any rights attaching hereto are, unless
the context clearly indicates otherwise, the property of Standard Bank
Group Limited and/or its subsidiaries ("the Group"). It is confidential,
private and intended for the addressee only.

Should you not be the addressee and receive this e-mail by mistake,
kindly notify the sender, and delete this e-mail, immediately and do not
disclose or use same in any manner whatsoever. Views and opinions
expressed in this e-mail are those of the sender unless clearly stated
as those of the Group. The Group accepts no liability whatsoever for any
loss or damages whatsoever and howsoever incurred, or suffered,
resulting, or arising, from the use of this email or its attachments.

The Group does not warrant the integrity of this e-mail nor that it is
free of errors, viruses, interception or interference. 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).



For information about the Standard Bank Group Limited visit our website
<http://www.standardbank.co.za> http://www.standardbank.co.za

________________________________________________________________________
__________________________________________________________


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20051019/467afb47/attachment.htm>