[opencms-dev] Accessing a table from a JSP

[Michael, Nick N]

Thanks chaps for your help.
 
Arash I have visited the link below and found quite a few gems there
 

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

-----Original Message-----
From: Arash Kaffamanesh [mailto:arash.kaffamanesh at pomegranate.de]
Sent: Wednesday, October 19, 2005 17:53
To: 'The OpenCms mailing list'
Cc: Michael, Nick N
Subject: RE: [opencms-dev] Accessing a table from a JSP


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
<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

____________________________________________________________________________
______________________________________________________



__________________________________________________________________________________________________________________________________

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
___________________________________________________________________________________________________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20051020/66777f0e/attachment.htm>