Re: JNDI and database connection pool

2003-11-21 Thread Christopher Schultz
Stephan,
I'm sorry to be so short, but...
Search the archives for the string "Cannot create JDBC driver of class 
'' for connect URL 'null'". I think this question gets asked every day.

-chris

Stephan Wannenwetsch wrote:
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:

	

	
type="javax.sql.DataSource"/>
	
	
		factory
	
org.apache.commons.dbcp.BasicDataSourceFactory
	
	
	
		url
	
jdbc:microsoft:sqlserver://ASTERIX:1433;DatabaseName=Diplom
e>
	
	
		driverClassName
	
com.microsoft.jdbc.sqlserver.SQLServerDriver
	

	
		username
		sa
	
	
		password
		a
	
	
	
		maxWait
		5000
	
	
		maxIdle
		2
	
	
		maxActive
		4
	
	
	
  

  


My web.xml:

	
		jdbc/demo 
		javax.sql.DataSource 
		Container 
	 



I hope someone can help me.

Thanks Stephan

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



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


JNDI and database connection pool

2003-11-21 Thread 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:






factory

org.apache.commons.dbcp.BasicDataSourceFactory



url

jdbc:microsoft:sqlserver://ASTERIX:1433;DatabaseName=Diplom


driverClassName

com.microsoft.jdbc.sqlserver.SQLServerDriver



username
sa


password
a



maxWait
5000


maxIdle
2


maxActive
4



  

  



My web.xml:


jdbc/demo 
javax.sql.DataSource 
Container 
 




I hope someone can help me.

Thanks Stephan

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