[
https://issues.apache.org/jira/browse/OPENJPA-3004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18108341#comment-18108341
]
Patrice DUROUX commented on OPENJPA-3004:
-----------------------------------------
The issue was with the mapping of another property of Token and not with its
(String) id.
IntelliJ IDEA generates a java.time.Instant class field for a HSQLDB timestamp
column type.
Replacing by java.time.LocalDateTime solves this.
I am closing this issue.
Sorry for the noise.
> 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
> Priority: Major
>
> 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)
