On Thu, 5 Jun 2003 03:57, Schwartz, David (CHR) wrote: > <sql:url>jdbc:oracle:thin:xxxxx:1521:yyyy</sql:url>
I don't think it likes the URL you are giving it, is xxxxx the servername or IP and yyyy the instance name? NB. the thin driver access the server directly so totally ignore your tnsnames.ora, well except for referring to it to get the server name and instance name of course. Also try passing it the username and password with: <sql:userId>root</sql:userId> <sql:password>notVerySecure</sql:password> Another more standard way to use datasources is to use JNDI and define them in your server.xml as per this howto: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html Then you can reduce your connection tag within your JSP pages to something like: <sql:connection id="conn1" dataSource="jdbc/ds1"> Regards, -- Jason Bainbridge http://jblinux.org --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
