openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Dick (JIRA)" <j...@apache.org>
Subject [jira] Created: (OPENJPA-1197) NativeQueries fail with MySQL
Date Mon, 27 Jul 2009 15:39:15 GMT
NativeQueries fail with MySQL 
------------------------------

                 Key: OPENJPA-1197
                 URL: https://issues.apache.org/jira/browse/OPENJPA-1197
             Project: OpenJPA
          Issue Type: Bug
    Affects Versions: 1.2.1, 1.0.3
            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(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.


Mime
View raw message