Hi,
I'm having an issue using a LocalDate field in my MariaDB table.
I'm using mysql Ver 15.1 Distrib 10.0.30-MariaDB, for debian-linux-gnu
(x86_64) using readline 5.2
The table is defined as the following...
<?xml version="1.0" encoding="utf-8"?>
<obj-attribute name="defaultTimeZone" type="java.lang.String"
db-attribute-path="defaultTimeZone"/>
<obj-attribute name="expireDate" type="java.time.LocalDate"
db-attribute-path="expireDate"/>
<obj-attribute name="maintenanceDate" type="java.time.LocalDate"
db-attribute-path="maintenanceDate"/>
<obj-attribute name="name" type="java.lang.String"
db-attribute-path="name"/>
<obj-attribute name="status" type="short" db-attribute-path="statusID"/>
The code generating the error is the following ...
Client client = context.newObject(Client.class);
client.setExpireDate(LocalDate.now());
client.setMaintenanceDate(LocalDate.now());
client.setDefaultTimeZone(TimeZone.getDefault().getID());
client.setName(CLIENT_TEMPLATE_NAME);
client.setStatus(EnumSimpleStatus.STATUS_INACTIVE.toShort());
context.commitChanges();
Upon execution of this code I'm getting
java.sql.SQLException: Cannot convert class [B to SQL type requested due
to java.lang.ClassCastException - [B cannot be cast to java.util.Date
I'm not sure why I'm getting the casting error. Is there some
underlying version compatibility?
Thanks,
Andrew
The full trace is as follows...
2017-04-29,16:56:45:263,INFO
,[http-nio-8080-exec-610],org.apache.cayenne.log.CommonsJdbcEventLogger,INSERT
INTO Client (contactID, defaultTimeZone, expireDate, id,
maintenanceDate, name, statusID) VALUES (?, ?, ?, ?, ?, ?, ?)
2017-04-29,16:56:45:264,INFO
,[http-nio-8080-exec-610],org.apache.cayenne.log.CommonsJdbcEventLogger,[batch
bind: 1->contactID:NULL, 2->defaultTimeZone:'America/Toronto',
3->expireDate:2017-04-29, 4->id:200, 5->maintenanceDate:2017-04-29,
6->name:'Template', 7->statusID:1]
2017-04-29,16:56:45:273,INFO
,[http-nio-8080-exec-610],org.apache.cayenne.log.CommonsJdbcEventLogger,***
error.
java.sql.SQLException: Cannot convert class [B to SQL type requested due
to java.lang.ClassCastException - [B cannot be cast to java.util.Date
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
~[mysql-connector-java-5.1.41.jar:5.1.41]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
~[mysql-connector-java-5.1.41.jar:5.1.41]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
~[mysql-connector-java-5.1.41.jar:5.1.41]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
~[mysql-connector-java-5.1.41.jar:5.1.41]
at
com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:3761)
~[mysql-connector-java-5.1.41.jar:5.1.41]
at
com.mysql.jdbc.JDBC42PreparedStatement.setObject(JDBC42PreparedStatement.java:99)
~[mysql-connector-java-5.1.41.jar:5.1.41]
at
com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:3580)
~[mysql-connector-java-5.1.41.jar:5.1.41]
at
com.mysql.jdbc.JDBC42PreparedStatement.setObject(JDBC42PreparedStatement.java:83)
~[mysql-connector-java-5.1.41.jar:5.1.41]
at
org.apache.cayenne.access.types.ByteArrayType.setJdbcObject(ByteArrayType.java:160)
~[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.access.types.ByteArrayType.setJdbcObject(ByteArrayType.java:40)
~[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.access.types.ExtendedTypeDecorator.setJdbcObject(ExtendedTypeDecorator.java:63)
~[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.dba.JdbcAdapter.bindParameter(JdbcAdapter.java:548)
~[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.dba.mysql.MySQLAdapter.bindParameter(MySQLAdapter.java:214)
~[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.dba.AutoAdapter.bindParameter(AutoAdapter.java:204)
~[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.access.jdbc.BatchAction.bind(BatchAction.java:57)
~[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.access.jdbc.BatchAction.runAsBatch(BatchAction.java:114)
~[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.access.jdbc.BatchAction.performAction(BatchAction.java:85)
~[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:97)
~[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.access.DataNode.performQueries(DataNode.java:293)
[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.access.DataDomainFlushAction.runQueries(DataDomainFlushAction.java:239)
[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:155)
[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:629)
[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.access.DataDomain.onSyncNoFilters(DataDomain.java:598)
[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.access.DataDomain$DataDomainSyncFilterChain.onSync(DataDomain.java:746)
[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.tx.TransactionFilter$1.perform(TransactionFilter.java:73)
[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.tx.TransactionFilter$1.perform(TransactionFilter.java:70)
[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.tx.DefaultTransactionManager.performInTransaction(DefaultTransactionManager.java:87)
[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.tx.DefaultTransactionManager.performInLocalTransaction(DefaultTransactionManager.java:59)
[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.tx.DefaultTransactionManager.performInTransaction(DefaultTransactionManager.java:52)
[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.tx.DefaultTransactionManager.performInTransaction(DefaultTransactionManager.java:40)
[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.tx.TransactionFilter.onSync(TransactionFilter.java:70)
[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.access.DataDomain$DataDomainSyncFilterChain.onSync(DataDomain.java:746)
[cayenne-server-4.0.M5.jar:4.0.M5]
at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:585)
[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:742)
[cayenne-server-4.0.M5.jar:4.0.M5]
at
org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:691)
[cayenne-server-4.0.M5.jar:4.0.M5]
<?xml version="1.0" encoding="utf-8"?>
<obj-attribute name="defaultTimeZone" type="java.lang.String"
db-attribute-path="defaultTimeZone"/>
<obj-attribute name="expireDate" type="java.time.LocalDate"
db-attribute-path="expireDate"/>
<obj-attribute name="maintenanceDate" type="java.time.LocalDate"
db-attribute-path="maintenanceDate"/>
<obj-attribute name="name" type="java.lang.String"
db-attribute-path="name"/>
<obj-attribute name="status" type="short" db-attribute-path="statusID"/>
