[
https://issues.apache.org/jira/browse/OPENJPA-964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12696759#action_12696759
]
Donald Woods commented on OPENJPA-964:
--------------------------------------
Example output when using MSSQLSimpleDataSourceExample against MS SQL 2005 SP1
with the v2.0 JDBC driver (sqljdbc_2.0.1803.100_enu) for SQL Server
2000/2005/2008 -
Statement = update OPENJPA.dbo.QTimeout set versionField = 2 where id = 1
SQL Message = The query has timed out.
SQL State = HY008
SQL Code = 0
Stack trace = com.microsoft.sqlserver.jdbc.SQLServerException: The query has
timed out.
at
com.microsoft.sqlserver.jdbc.TDSCommand.checkForInterrupt(IOBuffer.java:4214)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:70)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1449)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServerStatement.java:642)
at
MSSQLSimpleDataSourceExample.main(MSSQLSimpleDataSourceExample.java:95)
> Finish updating sql-error-state- codes.xml for query timeout support on other
> DBs
> ---------------------------------------------------------------------------------
>
> Key: OPENJPA-964
> URL: https://issues.apache.org/jira/browse/OPENJPA-964
> Project: OpenJPA
> Issue Type: Sub-task
> Components: query
> Affects Versions: 2.0.0
> Reporter: Donald Woods
> Assignee: Donald Woods
> Fix For: 2.0.0
>
>
> Need to add any SQLStatus codes for query timeouts to sql-error-state-
> codes.xml and handle setting isRecoverable/isFatal in each DBDictionary
> subclass for other supported DBs besides Derby and DB2.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
