I have an addition to my above post. It looks like this plugin is having problems working with SQL Server 2000. I have a few megs worth of error logs:
Creating the table:
2005.10.14 11:20:34 [com.version2software.messenger.plugins.database.StatisticsDAO.createTable(Stat isticsDAO.java:230)
]
java.sql.SQLException: [SQLServer 2000 Driver for JDBC][SQLServer]Incorrect syntax near the keyword ‘‘NOT’’.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.execute(Unknown Source)
at com.version2software.messenger.plugins.database.StatisticsDAO.createTable(Stati sticsDAO.java:225)
at com.version2software.messenger.plugins.database.StatisticsDAO.createTable(Stati sticsDAO.java:205)
at com.version2software.messenger.plugins.StatisticsPlugin.initializePlugin(Statis ticsPlugin.java:78)
at org.jivesoftware.messenger.container.PluginManager.loadPlugin(PluginManager.jav a:273)
at org.jivesoftware.messenger.container.PluginManager.access$200(PluginManager.jav a:49)
at org.jivesoftware.messenger.container.PluginManager$PluginMonitor.run(PluginMana ger.java:636)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)
at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101 (Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodi c(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknow n Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
/code
Updating the table?
2005.10.14 11:20:35 [com.version2software.messenger.plugins.database.StatisticsDAO.deleteOld(Statis ticsDAO.java:649)
]
java.sql.SQLException: [SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name ‘‘v2HourStat’’.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.execute(Unknown Source)
at com.version2software.messenger.plugins.database.StatisticsDAO.deleteOld(Statist icsDAO.java:647)
at com.version2software.messenger.plugins.database.StatisticsDAO.insertHourlyStati stic(StatisticsDAO.java:262)
at com.version2software.messenger.plugins.database.StatisticsDAO.insertStatistic(S tatisticsDAO.java:238)
at com.version2software.messenger.plugins.collector.SessionCountCollector$Collecto rThread.run(SessionCountCollector.java:51)
/code
Some type of conversion?
2005.10.14 11:21:56 [com.version2software.messenger.plugins.database.StatisticsDAO.insertHourlyPack etStatistic(StatisticsDAO.java:454)
]
java.sql.SQLException: [SQLServer 2000 Driver for JDBC][SQLServer]
Disallowed implicit conversion from data type datetime to data type timestamp,
table ‘‘JiveMessenger.dbo.v2HourPacket’’, column ‘‘time’’.
Use the CONVERT function to run this query.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
at com.version2software.messenger.plugins.database.StatisticsDAO.insertHourlyPacke tStatistic(StatisticsDAO.java:452)
at com.version2software.messenger.plugins.database.StatisticsDAO.insertStatistic(S tatisticsDAO.java:434)
at com.version2software.messenger.plugins.collector.PacketCountCollector$PacketCou ntThread.savePackets(PacketCountCollector.java:112)
at com.version2software.messenger.plugins.collector.PacketCountCollector$PacketCou ntThread.run(PacketCountCollector.java:121)
2005.10.14 11:21:56 [com.version2software.messenger.plugins.database.StatisticsDAO.addOrUpdatePacke t(StatisticsDAO.java:628)
/code
And this continued until I removed the plugin.
I looked and the tables exist in the databse, however there is no data in any of them.