Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JDBCExceptionReporter SQL Error: 0, SQLState: 08S01

843859Feb 12 2009 — edited Nov 20 2014
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2009
Added on Feb 12 2009
1 comment
1,123 views