Use the URL:
jdbc:microsoft:sqlserver://localhost:1433/jive
the sane 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.
error.log file contents:
2004.12.22 17:09:54 [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 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 17:10:04 [org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:107)
] Failed to create new connections on startup. Attempt 1 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 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 17:10:14 [org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:107)
] Failed to create new connections on startup. Attempt 2 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 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 17:10:24 [org.jivesoftware.database.DefaultConnectionProvider.start(DefaultConnectionPro vider.java:88)
]
java.io.IOException
at org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:119)
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 17:10:24 [org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConne ctionProvider.java:68)
] Warning: DbConnectionDefaultPool.getConnection() was called before the internal pool has been initialized.
2004.12.22 17:10:25 [org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnecti onManager.java:260)
]
java.lang.NullPointerException
at org.jivesoftware.database.DbConnectionManager.setMetaData(DbConnectionManager.j ava:403)
at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:257)
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 17:10:25 [org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConne ctionProvider.java:68)
] Warning: DbConnectionDefaultPool.getConnection() was called before the internal pool has been initialized.
2004.12.22 17:10:25 [org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManage r.java:95)
] WARNING: ConnectionManager.getConnection() failed to obtain a connection.