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, 14 Apr 2009 20:46:14 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12698918#action_12698918
] 

Donald Woods commented on OPENJPA-964:
--------------------------------------

Example stand-alone test output for Informix Dynamic Server 11.50 using the IBM Universal
JCC drivers (from DB2 9.5) -
Statement = select * from qtimeout where mod(DELAY(2,id),2)=0
SQL Message = IDS SQL Error: SQLCODE=-674, SQLSTATE=IX000, SQLERRMC=delay, DRIVER=3.50.152
SQL State   = IX000
SQL Code    = -674
Stack trace = com.ibm.db2.jcc.b.SqlException: IDS SQL Error: SQLCODE=-674, SQLSTATE=IX000,
SQLERRMC=delay, DRIVER=3.50.152
	at com.ibm.db2.jcc.b.wc.a(wc.java:55)
	at com.ibm.db2.jcc.b.wc.a(wc.java:126)
	at com.ibm.db2.jcc.b.tk.c(tk.java:1901)
	at com.ibm.db2.jcc.b.tk.d(tk.java:1889)
	at com.ibm.db2.jcc.b.tk.a(tk.java:1416)
	at com.ibm.db2.jcc.t4.db.g(db.java:138)
	at com.ibm.db2.jcc.t4.db.a(db.java:38)
	at com.ibm.db2.jcc.t4.t.a(t.java:32)
	at com.ibm.db2.jcc.t4.sb.h(sb.java:141)
	at com.ibm.db2.jcc.b.tk.N(tk.java:1387)
	at com.ibm.db2.jcc.b.tk.a(tk.java:2215)
	at com.ibm.db2.jcc.b.tk.a(tk.java:557)
	at com.ibm.db2.jcc.b.tk.executeQuery(tk.java:541)
	at DirectQueryTimeoutTest.main(DirectQueryTimeoutTest.java:84)



> 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
>
>         Attachments: OPENJPA-964-common.patch, OPENJPA-964-db2.patch, OPENJPA-964-mssql.patch,
OPENJPA-964-oracle.patch
>
>
> 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