ERROR using the tomcat db connection pool against one SQL SERVER 200 database. Please help me

Discussion in 'Java' started by _XaToA_, Oct 30, 2003.

  1. _XaToA_

    _XaToA_ Guest

    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
    _XaToA_, Oct 30, 2003
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    0
    Views:
    384
  2. =?Utf-8?B?Sm9lU2Vw?=
    Replies:
    2
    Views:
    1,464
    =?Utf-8?B?Sm9lU2Vw?=
    Oct 9, 2006
  3. =?Utf-8?B?SmVycnkgSg==?=

    SQL Server connection Pool error in Debug

    =?Utf-8?B?SmVycnkgSg==?=, Apr 23, 2007, in forum: ASP .Net
    Replies:
    1
    Views:
    485
    Cowboy \(Gregory A. Beamer\)
    Apr 23, 2007
  4. JTL.zheng
    Replies:
    7
    Views:
    414
    JTL.zheng
    Nov 14, 2007
  5. cooldv
    Replies:
    3
    Views:
    263
    WIlliam Morris
    Oct 6, 2003
Loading...

Share This Page