JNDI and database connection pool

[Stephan Wannenwetsch]

Hallo,

I try to establish a database connection pool with Tomcat and MS
SQLServer JDBC-Driver. But when I run the program I get the following
error:

1000 [http8080-Processor2] INFO connection.DatasourceConnectionProvider
- Using datasource: java:comp/env/jdbc/demo
1000 [http8080-Processor2] INFO impl.SessionFactoryImpl  - Use outer
join fetching: false
1000 [http8080-Processor2] WARN util.JDBCExceptionReporter  - SQL Error:
0, SQLState: null
1000 [http8080-Processor2] ERROR util.JDBCExceptionReporter  - Cannot
create JDBC driver of class '' for connect URL 'null'
1000 [http8080-Processor2] WARN impl.SessionFactoryImpl  - Could not
obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of
class '' for connect URL 'null', cause: 
java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getDriver(DriverManager.java:243)


My server.xml:

        <Context path="/demo" docBase="demo">
            
        <Resource name="jdbc/demo" scope="Shareable" auth="Container"
type="javax.sql.DataSource"/>
        <ResourceParams name="jdbc/demo">
        <parameter>
                <name>factory</name>
        
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
        </parameter>
        <!-- DBCP database connection settings -->
        <parameter>
                <name>url</name>
        
<value>jdbc:microsoft:sqlserver://ASTERIX:1433;DatabaseName=Diplom</valu
e>
        </parameter>
        <parameter>
                <name>driverClassName</name>
        
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
        </parameter>

        <parameter>
                <name>username</name>
                <value>sa</value>
        </parameter>
        <parameter>
                <name>password</name>
                <value>a</value>
        </parameter>
        <!-- DBCP connection pooling options -->
        <parameter>
                <name>maxWait</name>
                <value>5000</value>
        </parameter>
        <parameter>
                <name>maxIdle</name>
                <value>2</value>
        </parameter>
        <parameter>
                <name>maxActive</name>
                <value>4</value>
        </parameter>
        </ResourceParams>
        </Context>        
      </Host>
    </Engine>
  </Service>
</Server>


My web.xml:

        <resource-ref>
                <res-ref-name>jdbc/demo</res-ref-name> 
                <res-type>javax.sql.DataSource</res-type> 
                <res-auth>Container</res-auth> 
        </resource-ref> 

</web-app>


I hope someone can help me.

Thanks Stephan

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]