Warnings when using MSSQL 2000 sp4

Openfire Openfire Support
1

Hi,

We’'ve just performed a fresh install of 2.1.5 on a win2003 box that is also running SQL 2000 sp4.

I’'ve followed the instuctions for connecting to a SQL database and it seems to be working.

I get the following in the warning log file pretty much continuously. I’‘m happy to ignore them but was wondering if there’'s anything to be concerned about or how I fix it.

2005.07.21 09:17:15 Connection 0 had warnings: java.sql.SQLWarning: [SQLServer 2000 Driver for JDBC]Database changed to JiveMessenger

2005.07.21 09:17:15 Connection 1 had warnings: java.sql.SQLWarning: [SQLServer 2000 Driver for JDBC]Database changed to JiveMessenger

2005.07.21 09:17:15 Connection 2 had warnings: java.sql.SQLWarning: [SQLServer 2000 Driver for JDBC]Database changed to JiveMessenger

2005.07.21 09:17:15 Connection 3 had warnings: java.sql.SQLWarning: [SQLServer 2000 Driver for JDBC]Database changed to JiveMessenger

2005.07.21 09:17:15 Connection 4 had warnings: java.sql.SQLWarning: [SQLServer 2000 Driver for JDBC]Database changed to JiveMessenger

2005.07.21 09:17:45 Connection 0 had warnings: java.sql.SQLWarning: [SQLServer 2000 Driver for JDBC]Database changed to JiveMessenger

2005.07.21 09:18:15 Connection 0 had warnings: java.sql.SQLWarning: [SQLServer 2000 Driver for JDBC]Database changed to JiveMessenger

2005.07.21 09:18:32 Connection 0 had warnings: java.sql.SQLWarning: [SQLServer 2000 Driver for JDBC]Database changed to JiveMessenger

2005.07.21 09:18:32 Connection 1 had warnings: java.sql.SQLWarning: [SQLServer 2000 Driver for JDBC]Database changed to JiveMessenger

2005.07.21 09:18:32 Connection 2 had warnings: java.sql.SQLWarning: [SQLServer 2000 Driver for JDBC]Database changed to JiveMessenger

2005.07.21 09:18:32 Connection 3 had warnings: java.sql.SQLWarning: [SQLServer 2000 Driver for JDBC]Database changed to JiveMessenger

2005.07.21 09:18:32 Connection 4 had warnings: java.sql.SQLWarning: [SQLServer 2000 Driver for JDBC]Database changed to JiveMessenger

2005.07.21 09:18:47 Connection 0 had warnings: java.sql.SQLWarning: [SQLServer 2000 Driver for JDBC]Database changed to JiveMessenger

2005.07.21 09:18:47 Connection 1 had warnings: java.sql.SQLWarning: [SQLServer 2000 Driver for JDBC]Database changed to JiveMessenger

2005.07.21 09:18:47 Connection 2 had warnings: java.sql.SQLWarning: [SQLServer 2000 Driver for JDBC]Database changed to JiveMessenger

2005.07.21 09:18:47 Connection 3 had warnings: java.sql.SQLWarning: [SQLServer 2000 Driver for JDBC]Database changed to JiveMessenger

2005.07.21 09:18:47 Connection 4 had warnings: java.sql.SQLWarning: [SQLServer 2000 Driver for JDBC]Database changed to JiveMessenger

thanks

Steve

2

I’'ve asked for this question! And here is the answer from dombiak_gaston:

This is a normal message from the MS jdbc driver when the database that you are using for JM isn’‘t the default database for the sql server account you are using to access the database. Pretty much ignore it - it’'s completely harmless.

Hope it is useful for you!

3

Hi,

Thanks for the prompt response - strangely the JiveMessenger database IS the default database for my JiveMessenger user.

wierd…