problems during startup

Maybe this will also be helpful:
http://msdn2.microsoft.com/en-us/library/ms378522.aspx

—Posted by slava on Nov 4, 2007 at 7:36:08 PM

There's also a new JDBC version: http://www.microsoft.com/downloads/details.aspx?familyid=c47053eb-3b64–4794-950d-81e1ec91c1ba&displaylang=en

but I can't figure out how to get AT to use it…

—Posted by slava on Nov 4, 2007 at 7:50:57 PM

I'm not really sure about the error. The code is just relying on the jdbc driver to get an object back. I have a SQL Server 2005 64-bit setup to test on and I never had any problem. I wonder if moving the database from one version of SQLServer to another might have some incompatibilities.

To use a new SQLServer jdbc driver, go to the lib directory of AgileTrack and remove the sqljdbc.jar, or rename it to sqljdbc.jar.old. Then, put the new driver jar in there. The new driver should get loaded automatically.

Does it work if it starts from a clean database?

—Posted by Adam Lane on Nov 6, 2007 at 7:21:33 AM

well, updating jdbc didn't work. gave me a different exception. creating a new table from scratch worked, kind of. I got this exception the first time I ran AT. Connecting to the DB afterwards is fine.

java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: The DBComms.receive operation resulted in an invalid packet header type:0. PktNum:0. nReceived:8.

at agiletrack.server.persistence.GenericSQLDatabase.loadRecord(GenericSQLDatabase.java:474) at agiletrack.server.persistence.TrackerCachedPersistence.loadRecord(TrackerCachedPersistence.java:104) at agiletrack.server.TrackerModel.getRecord(TrackerModel.java:802) at agiletrack.server.TrackerModel.getRecords(TrackerModel.java:814) at agiletrack.server.controller.TrackerLocalAccess.load(TrackerLocalAccess.java:83) at agiletrack.client.controller.TrackerServerBridge.getInternalRecords(TrackerServerBridge.java:329) at agiletrack.client.controller.TrackerServerBridge.getRecords(TrackerServerBridge.java:173) at agiletrack.data.TrackerEnhancedLoaderDefault.getRecords(TrackerEnhancedLoaderDefault.java:128) at agiletrack.data.TrackerEnhancedLoaderDefault.getStateList(TrackerEnhancedLoaderDefault.java:627) at agiletrack.client.controller.TrackerSession.getStateList(TrackerSession.java:441) at agiletrack.client.ClientApplication$1$1.initialization(ClientApplication.java:215) at agiletrack.swing.JSplashScreen$2.run(JSplashScreen.java:73) at java.lang.Thread.run(Thread.java:619)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The DBComms.receive operation resulted in an invalid packet header type:0. PktNum:0. nReceived:8. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at agiletrack.server.persistence.DatabaseResourceProvider.executeQuery(DatabaseResourceProvider.java:47) at agiletrack.server.persistence.GenericSQLDatabase.loadRecord(GenericSQLDatabase.java:427) ... 12 more

—Posted by slava on Nov 6, 2007 at 4:43:06 PM

in fact, I think I got the same exception 1st time I launched AT, before I deleted cache.dat

—Posted by slava on Nov 6, 2007 at 4:43:32 PM

well. I tried to open db back in x86 windows and everything started to work. not sure what the problem was.

—Posted by slava on Nov 7, 2007 at 12:31:12 PM

You may post a reply to this topic, but you must be logged in. If you already have an account, you may login now. If you need to create an account, you may also register now.