From dev-return-9526-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org Wed Nov 19 03:45:36 2008 Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 5151 invoked from network); 19 Nov 2008 03:45:36 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 19 Nov 2008 03:45:36 -0000 Received: (qmail 98737 invoked by uid 500); 19 Nov 2008 03:45:44 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 98570 invoked by uid 500); 19 Nov 2008 03:45:44 -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 98559 invoked by uid 99); 19 Nov 2008 03:45:44 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Nov 2008 19:45:44 -0800 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; Wed, 19 Nov 2008 03:44:30 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 5FF35234C28A for ; Tue, 18 Nov 2008 19:44:44 -0800 (PST) Message-ID: <1657001810.1227066284375.JavaMail.jira@brutus> Date: Tue, 18 Nov 2008 19:44:44 -0800 (PST) From: "Alexey Ousov (JIRA)" To: dev@openjpa.apache.org Subject: [jira] Updated: (OPENJPA-774) Executing native queries with Firebird In-Reply-To: <1376004682.1227066046252.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/OPENJPA-774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexey Ousov updated OPENJPA-774: --------------------------------- Attachment: OPENJPA-774.patch patch for issue > Executing native queries with Firebird > -------------------------------------- > > Key: OPENJPA-774 > URL: https://issues.apache.org/jira/browse/OPENJPA-774 > Project: OpenJPA > Issue Type: Bug > Components: sql > Affects Versions: 1.1.0, 1.2.0 > Environment: Tomcat 5.5, OpenJPA 1.1.0, Firebird 2.1 > Reporter: Alexey Ousov > Attachments: OPENJPA-774.patch > > > Native queries cannot be executed with Firebird database. The following exception occur: > DEBUG - Log4JLogFactory$LogAdapter.trace(72) | Executing query: [insert into ANAGRAFICHE (COD_TITOLARE, NOME, CODICE_FISCALE, DATA_NASCITA) values (?, ?, ?, ?)] with parameters: {2=xz0FEdrz92sd, 0=43, 3=Tue Aug 30 00:00:00 UTC 1644, 1=B95JHSkDV} > WARN - GeronimoConnectionEventListener.connectionErrorOccurred(88) | connectionErrorOccurred called with null > org.firebirdsql.jdbc.FBSQLException: You cannot set value of an non-existing parameter. > at org.firebirdsql.jdbc.FBProcedureCall$NullParam.setValue(FBProcedureCall.java:424) > at org.firebirdsql.jdbc.AbstractCallableStatement.setLong(AbstractCallableStatement.java:1094) > at org.tranql.connector.jdbc.PreparedStatementHandle.setLong(PreparedStatementHandle.java:247) > at org.apache.ode.utils.LoggingStatementWrapper.setLong(LoggingStatementWrapper.java:495) > at org.apache.openjpa.lib.jdbc.DelegatingCallableStatement.setLong(DelegatingCallableStatement.java:299) > at org.apache.openjpa.jdbc.sql.DBDictionary.setLong(DBDictionary.java:998) > at org.apache.openjpa.jdbc.sql.DBDictionary.setUnknown(DBDictionary.java:1283) > at org.apache.openjpa.jdbc.sql.SQLBuffer.setParameters(SQLBuffer.java:568) > at org.apache.openjpa.jdbc.kernel.SQLStoreQuery$SQLExecutor.executeUpdate(SQLStoreQuery.java:231) > at org.apache.openjpa.kernel.QueryImpl.update(QueryImpl.java:1038) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:808) > at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:883) > at org.apache.openjpa.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:573) > at org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:319) > Exception is thrown because for "insert" statement prepareCall is executed instead of prepareStatement. For other databases it is the same, but Firebird's FBProcedureCall is not the same as FBPreparedStatement. Patch for issue follows. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.