[opencms-dev] Accessing a table from a JSP

[Ernesto De Santis]

Try with this:

 java.sql.Connection con = 
OpenCms.getSqlManager().getConnection(CmsDbPool.getDefaultDbPoolName());

Ernesto.




Michael, Nick N escribió:

> 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
>
> __________________________________________________________________________________________________________________________________
>
>------------------------------------------------------------------------
>
>
>
>_______________________________________________
>This mail is send to you from the opencms-dev mailing list
>To change your list options, or to unsubscribe from the list, please visit
>http://mail.opencms.org/mailman/listinfo/opencms-dev
>

-- 
Ernesto De Santis - Colaborativa.net
La Plata, Argentina.
http://www.colaborativa.net/