XSQL and Java Servlet intergration using a JDBC connection

From: Han <J.C.M.C.Vermolen_at_tue.nl>
Date: 21 Mar 2003 00:21:10 -0800
Message-ID: <ebd4d0bd.0303210021.6f769f1e_at_posting.google.com>



Hi,

I'm trying to create a site onto which you log on using a simple html page. This page asks the user for his/her usercode and password with which to login. I'm using JDBC to connect to my Oracle database. But the following problem has occured.

I don't want to use XSQLConfig.xml (or any other file for that matter) to get the connection information from. I simply want to connect using my java servlet and somehow pass on the connection information to the XSQL page. So it can simple use a line like: <FAQ xmlns:xsql="urn:oracle-xsql" connection="MyCon">

Now, I saw that there is an option to perform this task. I've read something about XSQLConnectionManager and XSQLConnectionManagerFactory. I just don't understand quite how to use them. In other words, how do I use these interfaces so I can set up a connection and use it in XSQL pages? Any actual code examples would be very much appreciated.

Regards,

Han Vermolen Received on Fri Mar 21 2003 - 09:21:10 CET

Original text of this message