ERROR using the tomcat db connection pool against one SQL SERVER 200 database. Please help me
From: _XaToA_ (_XaToA_NOSPAM_at_excite.com)
Date: 10/31/03
- Next message: Real Gagnon: "Re: Read win.ini file?"
- Previous message: Lone Droid: "Re: Struts 1.1 -- Generating unique URL for each JSP"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 31 Oct 2003 00:43:20 +0100
Hello i am trying for using the Tomcat database conecition pool (dbcp)
against one SQL SERVER 2000 but i cannot connect always appears this error:
DBCP borrowObject failed: java.sql.SQLException: [Microsoft][SQLServer 2000
Driver for JDBC]Unable to connect. Invalid URL.
org.apache.commons.dbcp.DbcpException
: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable
to connect. Invalid URL
in the server.xml i have:
<Context path="" docBase="" reloadable="true" crossContext="true">
<Resource name="jdbc/DB" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/DB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://192.168.0.12:1433/Northwind</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<value>sa</value>
but i cannot connect, the error appears when i make:
conn=ds.getConnection();
can anybody helps me?
this question is very important for my job.
Please help me.
Thanks
- Next message: Real Gagnon: "Re: Read win.ini file?"
- Previous message: Lone Droid: "Re: Struts 1.1 -- Generating unique URL for each JSP"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]