JDBCExceptionReporter SQL Error: 0, SQLState: 08S01
843859Feb 12 2009 — edited Nov 20 2014Hi,
I have a application running on JBoss 4.2.2 and using SQL Server
connection using Hibernate and jdbc
my jdbc.properties:
jdbc.driverClassName=net.sourceforge.jtds.jdbc.Driver
jdbc.url=jdbc:jtds:sqlserver://xxx.xxx.xxx.xxx:xxxx/application
jdbc.username=xxxx
jdbc.password=xxxx
my hibernate.properties:
hibernate.dialect = org.hibernate.dialect.SQLServerDialect
hibernate.show_sql = false
hibernate.format_sql= true
hibernate.use_sql_comments = true
hibernate.jdbc.use_get_generated_keys = true
hibernate.cache.provider_class = net.sf.ehcache.hibernate.EhCacheProvider
hibernate.hbm2ddl.auto = none
hibernate.use_identifer_rollback=true
hibernate.connection.release_mode=on_close
hibernate.bytecode.use_reflection_optimizer=true
Error: when I do a select with many relationships:
ERROR [STDERR] 10:41:45,216 WARN [org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:77)] SQL Error: 0, SQLState: 08S01
ERROR [STDERR] 10:41:45,218 ERROR [org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78)] TDS Protocol error: Invalid packet type 0x1
ERROR [STDERR] org.hibernate.exception.JDBCConnectionException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
...
Caused by: java.sql.SQLException: TDS Protocol error: Invalid packet type 0x1
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2314)
at net.sourceforge.jtds.jdbc.TdsCore.microsoftPrepare(TdsCore.java:1183)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareSQL(ConnectionJDBC2.java:657)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:776)
...
Caused by: net.sourceforge.jtds.jdbc.ProtocolException: Invalid packet type 0x1
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2301)
...
Thanks
Diego