Return-Path: 
 <dev-return-15205-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org>
Delivered-To: apmail-openjpa-dev-archive@www.apache.org
Received: (qmail 13038 invoked from network); 24 Feb 2010 14:18:49 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 24 Feb 2010 14:18:49 -0000
Received: (qmail 20566 invoked by uid 500); 24 Feb 2010 14:18:49 -0000
Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org
Received: (qmail 20509 invoked by uid 500); 24 Feb 2010 14:18:48 -0000
Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@openjpa.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@openjpa.apache.org>
List-Post: <mailto:dev@openjpa.apache.org>
List-Id: <dev.openjpa.apache.org>
Reply-To: dev@openjpa.apache.org
Delivered-To: mailing list dev@openjpa.apache.org
Received: (qmail 20378 invoked by uid 99); 24 Feb 2010 14:18:48 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Feb 2010 14:18:48 +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; Wed, 24 Feb 2010 14:18:48 +0000
Received: from brutus.apache.org (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id 159CB29A0013
	for <dev@openjpa.apache.org>; Wed, 24 Feb 2010 06:18:28 -0800 (PST)
Message-ID: <762604509.491801267021108087.JavaMail.jira@brutus.apache.org>
Date: Wed, 24 Feb 2010 14:18:28 +0000 (UTC)
From: "Donald Woods (JIRA)" <jira@apache.org>
To: dev@openjpa.apache.org
Subject: [jira] Updated: (OPENJPA-1197) NativeQueries fail with MySQL
In-Reply-To: <1217476531.1248709155465.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394


     [ https://issues.apache.org/jira/browse/OPENJPA-1197?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Donald Woods updated OPENJPA-1197:
----------------------------------

    Fix Version/s:     (was: 2.0.0)
                   2.0.0-beta

> NativeQueries fail with MySQL 
> ------------------------------
>
>                 Key: OPENJPA-1197
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1197
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 1.0.3, 1.2.1
>            Reporter: Michael Dick
>            Assignee: Michael Dick
>            Priority: Minor
>             Fix For: 1.0.4, 1.2.2, 1.3.0, 2.0.0-beta
>
>
> The TestCase for DataCache included / excluded types relies on a NativeQuery to drop database tables at the end of the test. This fails with some versions of the MySQL JDBC driver. 
> The exception from the testcase looks like this  :
> <openjpa-1.0.4-SNAPSHOT-rexported nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Unable to retrieve metadata for procedure.
>     at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3964)
>     at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97)
>     at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:83)
>     at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:59)
>     at org.apache.openjpa.jdbc.kernel.SQLStoreQuery$SQLExecutor.executeUpdate(SQLStoreQuery.java:242)
>    <snip>
> Caused by: java.sql.SQLException: Unable to retrieve metadata for procedure.
>     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
>     at com.mysql.jdbc.CallableStatement.extractProcedureName(CallableStatement.java:857)
>     at com.mysql.jdbc.CallableStatement.determineParameterTypes(CallableStatement.java:692)
>     at com.mysql.jdbc.CallableStatement.&lt;init&gt;(CallableStatement.java:513)
>     at com.mysql.jdbc.Connection.parseCallableStatement(Connection.java:4422)
>     at com.mysql.jdbc.Connection.prepareCall(Connection.java:4496)
>     at com.mysql.jdbc.Connection.prepareCall(Connection.java:4470)
>     at org.apache.commons.dbcp.DelegatingConnection.prepareCall(DelegatingConnection.java:212)
> Upgrading to a more recent version of the MySQL driver resolves these issues and allows the testcase to pass. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.