Micosoft JDBC Driver problem

For some reason, I cannot get the setup to complete. I get an error “A connection to the database could not be made. View the error…”

The log shows a “No suitable driver” problem…

2004.02.20 17:43 [com.jivesoftware.cache.ConnectionPool.(ConnectionPool.java:74)

] Error starting connection pool.

java.sql.SQLException: No suitable driver

at java.sql.DriverManager.getDriver(DriverManager.java:244)

at com.jivesoftware.cache.ConnectionPool.(ConnectionPool.java:68)

at com.jivesoftware.cache.DefaultConnectionProvider.start(DefaultConnectionProvide r.java:88)

at com.jivesoftware.cache.DbConnectionManager.setConnectionProvider(DbConnectionMa nager.java:245)

at com.jivesoftware.messenger.admin.setup_0002ddatasource_0002dstandard_jsp._jspSe rvice(setup_0002ddatasource_0002dstandard_jsp.java:284)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:356)

at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:294)

at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1723)

at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:514)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1673)

at org.mortbay.http.HttpServer.service(HttpServer.java:879)

at org.mortbay.http.HttpConnection.service(HttpConnection.java:783)

at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:945)

at org.mortbay.http.HttpConnection.handle(HttpConnection.java:800)

at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201)

at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)

at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:454)

2004.02.20 17:43 [com.jivesoftware.cache.ConnectionPool.(ConnectionPool.java:109)

] Failed to create new connections on startup. Attempt 0 of 3

java.sql.SQLException: No suitable driver

at java.sql.DriverManager.getConnection(DriverManager.java:532)

at java.sql.DriverManager.getConnection(DriverManager.java:172)

at com.jivesoftware.cache.ConnectionPool.createCon(ConnectionPool.java:407)

at com.jivesoftware.cache.ConnectionPool.(ConnectionPool.java:87)

at com.jivesoftware.cache.DefaultConnectionProvider.start(DefaultConnectionProvide r.java:88)

at com.jivesoftware.cache.DbConnectionManager.setConnectionProvider(DbConnectionMa nager.java:245)

at com.jivesoftware.messenger.admin.setup_0002ddatasource_0002dstandard_jsp._jspSe rvice(setup_0002ddatasource_0002dstandard_jsp.java:284)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:356)

at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:294)

at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1723)

at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:514)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1673)

at org.mortbay.http.HttpServer.service(HttpServer.java:879)

at org.mortbay.http.HttpConnection.service(HttpConnection.java:783)

at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:945)

at org.mortbay.http.HttpConnection.handle(HttpConnection.java:800)

at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201)

at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)

at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:454)

2004.02.20 17:44 [com.jivesoftware.cache.ConnectionPool.(ConnectionPool.java:109)

] Failed to create new connections on startup. Attempt 1 of 3

Anyone have a clue here??? Thanks.

Steve,

Have you copied a JDBC driver into the server’'s lib directory?

Regards,

Matt

Matt,

Interestingly enough…I had the drivers set in my classpath, but for some reason the Messenger application seemed to ignore it. I went ahead and placed the three jar files in the Messenger lib directory, and voila! it worked.

You might want to check the docs…because they mention that as long as they are in the classpath, everything should be ok. In this instance, the system classpath doesn’'t seem to matter, only that they are in the lib directory of the install…

Thanks for looking it to this.

Steve,

Messenger can come bundled with a JRE when installing under Windows. In that case, your normal Java classpath settings would be ignored since Messenger is using its own JVM. Could that have been the case here?

Regards,

Matt

Matt,

Yes, you are absolutely correct. I assumed that the system classpath would be sufficient in this case…but it wasn’'t. Thanks for the help!!