openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Dick (JIRA)" <>
Subject [jira] Commented: (OPENJPA-1197) NativeQueries fail with MySQL
Date Mon, 27 Jul 2009 17:08:14 GMT


Michael Dick commented on OPENJPA-1197:

Hi Milosz, 

That's another way to address the issue I suppose. Since the 5.1.6 driver allows us to use
prepareCall without hitting the issue (at least on Linux), I'm content to use that instead
of making a code change though. 

That would explain why I didn't see the problem with trunk / 1.3.x though. 

> NativeQueries fail with MySQL 
> ------------------------------
>                 Key: OPENJPA-1197
>                 URL:
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 1.0.3, 1.2.1
>            Reporter: Michael Dick
>            Assignee: Michael Dick
>            Priority: Minor
> 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(
>     at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(
>     at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(
>     at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(
>     at org.apache.openjpa.jdbc.kernel.SQLStoreQuery$SQLExecutor.executeUpdate(
>    <snip>
> Caused by: java.sql.SQLException: Unable to retrieve metadata for procedure.
>     at com.mysql.jdbc.SQLError.createSQLException(
>     at com.mysql.jdbc.CallableStatement.extractProcedureName(
>     at com.mysql.jdbc.CallableStatement.determineParameterTypes(
>     at com.mysql.jdbc.CallableStatement.&lt;init&gt;(
>     at com.mysql.jdbc.Connection.parseCallableStatement(
>     at com.mysql.jdbc.Connection.prepareCall(
>     at com.mysql.jdbc.Connection.prepareCall(
>     at org.apache.commons.dbcp.DelegatingConnection.prepareCall(
> 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.

View raw message