Patrice DUROUX created OPENJPA-3004:
---------------------------------------
Summary: incompatible type Blob and String with HSQLDB JDBC 2.7.4
Key: OPENJPA-3004
URL: https://issues.apache.org/jira/browse/OPENJPA-3004
Project: OpenJPA
Issue Type: Improvement
Affects Versions: 4.1.1
Reporter: Patrice DUROUX
Hi,
Not sure if this is a issue in HSQL JDBC or in OpenJPA, here is the exception
stack:
<openjpa-4.1.1-r9d2f5f8 fatal general error>
org.apache.openjpa.persistence.PersistenceException: incompatible data type in
conversion
FailedObject:
org.apache.openjpa.enhance.org$imgt$objects$entities$Token$pcsubclass-037bd965-6847-4e08-9505-2ea11ead44a7
[java.lang.String]
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5349)
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5309)
at
org.apache.openjpa.jdbc.sql.HSQLDictionary.newStoreException(HSQLDictionary.java:408)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:83)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:331)
at
org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:123)
at
org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:59)
at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:1118)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:1076)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:992)
at org.apache.openjpa.kernel.DelegatingBroker.find(DelegatingBroker.java:246)
at
org.apache.openjpa.persistence.EntityManagerImpl.find(EntityManagerImpl.java:582)
at org.imgt.dao.TestTokenDAO.testTokenDAO(TestTokenDAO.java:25)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
Caused by: java.sql.SQLSyntaxErrorException: incompatible data type in
conversion
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCResultSet.getBlob(Unknown Source)
at
org.apache.openjpa.lib.jdbc.DelegatingResultSet.getBlob(DelegatingResultSet.java:709)
at org.apache.openjpa.jdbc.sql.DBDictionary.getBlob(DBDictionary.java:745)
at
org.apache.openjpa.jdbc.sql.DBDictionary.getBlobObject(DBDictionary.java:760)
at
org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal(ResultSetResult.java:471)
at
org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java:838)
at
org.apache.openjpa.jdbc.meta.strats.HandlerStrategies.loadDataStore(HandlerStrategies.java:225)
at
org.apache.openjpa.jdbc.meta.strats.HandlerFieldStrategy.load(HandlerFieldStrategy.java:202)
at org.apache.openjpa.jdbc.meta.FieldMapping.load(FieldMapping.java:961)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1161)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1104)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:431)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:326)
... 11 more
Caused by: org.hsqldb.HsqlException: incompatible data type in conversion
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
... 25 more
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
