Unable to load specified JDBC driver?

haha · December 21, 2004, 6:47am

I installed the Jive Messenger Server ,then installed

JDK 1.5, and installed Microsoft SQL Server 2000 JDBC Driver.

I setup the user environment variables, created a database on SQL Server 2000 with Jive’'s

messenger_sqlserver_2000.sql file.

I restarted My Computer,at last, I started the Jive Messenger Server program.I clicked the “Launch Admin” button to config step by step.but at the "Datasource Settings - Standard

Connection" page, prompt error:

Unable to load specified JDBC driver. Please verify the name of the driver is correct and that the driver is in the classpath of this server (usually the ‘‘lib’’ directory). If you add a driver to your classpath you will neeed to restart the server.

What can I do ?

My platform:

Windows 2003 Server

SQL Server 2000 enterprise edition

Jive Messenger 2.0.1

JDK 1.5

matt · December 21, 2004, 7:45am

hahaha,

First, nice name. Second, how did you install the JDBC driver? Did you copy the JAR file to the messenger lib directory?

Regards,

Matt

haha · December 21, 2004, 8:15am

Thank you very much,Matt.

Must copy the JDBC Driver’'s JAR file to the messenger lib directory? I install the Microsoft JDBC Driver to C:\JDBC

directory,not the default directory,and setup the environment variables.

My ‘‘classpath’’ environment variable’'s value is:

.;C:\Program Files\Java\jdk1.5.0\lib\tools.jar;C:\Program Files\Java\jdk1.5.0\lib\dt.jar;C:\Program Files\Java\jdk1.5.0\bin;C:\JDBC\lib\msbase.jar;C:\JDBC\lib\mssqlserver.jar;C:\J DBC\lib\msutil.jar

is right?

matt · December 21, 2004, 8:51am

Setting the classpath should work. However, if it doesn’'t I would recommend just copying the JDBC jar files into the Messenger lib directory – it looks like msbase.jar, mssqlserver.jar and msutil.jar.

Regards,

Matt

haha · December 21, 2004, 9:00am

OK,I have a try,copy these files to the Messenger lib directory.

BTW,can Jive Messenger run on Windows 2003 Server?

matt · December 21, 2004, 5:01pm

BTW,can Jive Messenger run on Windows 2003 Server?

We haven’‘t specifically tested on Win 2003 server ourselves, but it shouldn’'t be a problem.

Regards,

Matt

haha · December 22, 2004, 3:25am

Thank you very much,Matt.

Now,I have settled this problem,but new error appears,

prompt:

A connection to the database could not be made. View the error message by opening the “\logs\error.log” log file, then go back to fix the problem.

what can I do?

I am a biginer at java,Thanks a lot!

haha · December 22, 2004, 3:44am

sorry, spells a word error

biginer->beginer

matt · December 22, 2004, 6:00am

Check out the logs\error.log file in directory that you installed Messenger in. So, if you installed into c:\messenger, it would be c:\messenger\logs\error.log

Please paste in anything from that file that looks like it might be the cause of the problem.

Regards,

Matt

haha · December 22, 2004, 7:19am

error.log file contents:

2004.12.22 15:12:10 [org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:107)

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

java.sql.SQLException: [SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at org.jivesoftware.database.ConnectionPool.createCon(ConnectionPool.java:414)

at org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:84)

at org.jivesoftware.database.DefaultConnectionProvider.start(DefaultConnectionProv ider.java:83)

at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:252)

at org.jivesoftware.messenger.admin.setup_002ddatasource_002dstandard_jsp._jspServ ice(setup_002ddatasource_002dstandard_jsp.java:268)

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

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

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

at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(WebApplicationHa ndler.java:520)

at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:76)

at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(WebApplicationHa ndler.java:511)

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

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

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

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

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

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

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

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

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

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

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

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

2004.12.22 15:12:20 [org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:107)

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