Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 86187 invoked from network); 14 Apr 2009 20:46:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 14 Apr 2009 20:46:37 -0000 Received: (qmail 35886 invoked by uid 500); 14 Apr 2009 20:46:36 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 35833 invoked by uid 500); 14 Apr 2009 20:46:36 -0000 Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list dev@openjpa.apache.org Received: (qmail 35658 invoked by uid 99); 14 Apr 2009 20:46:35 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Apr 2009 20:46:35 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Apr 2009 20:46:35 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id CFB22234C003 for ; Tue, 14 Apr 2009 13:46:14 -0700 (PDT) Message-ID: <723949621.1239741974835.JavaMail.jira@brutus> Date: Tue, 14 Apr 2009 13:46:14 -0700 (PDT) From: "Donald Woods (JIRA)" To: dev@openjpa.apache.org Subject: [jira] Commented: (OPENJPA-964) Finish updating sql-error-state- codes.xml for query timeout support on other DBs In-Reply-To: <748785810.1236363476060.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ 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.