openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Donald Woods (JIRA)" <j...@apache.org>
Subject [jira] Commented: (OPENJPA-964) Finish updating sql-error-state- codes.xml for query timeout support on other DBs
Date Tue, 07 Apr 2009 21:12:12 GMT

    [ 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.


Mime
View raw message