Hi Folks,
Before I delve into code, I thought I'd throw this one on the list and
see what your collective thoughts are.
I've got an app I'm swinging over to hsql from mysql for the purpose of
simplification.
I've tried the hsql and generic engines, but both give me grief.
It appears I am unable to map date fields, longvarchar fields (as
java.lang.String), or longvarbinary (as byte[]) fields to hsql tables.
When trying to create records, the error messages like the following
crop up:
(creating record with date field mapped to java.util.Date)
org.exolab.castor.jdo.PersistenceException: Nested error:
java.lang.IllegalArgumentException
at
org.exolab.castor.persist.TransactionContext.create(TransactionContext.j
ava:841)
at
org.exolab.castor.jdo.engine.DatabaseImpl.create(DatabaseImpl.java:338)
...
(creating record with longvarchar field mapped to String)
java.sql.SQLException: This function is not supported
at org.hsqldb.Trace.getError(Trace.java:180)
at org.hsqldb.Trace.getError(Trace.java:144)
at org.hsqldb.Trace.error(Trace.java:192)
at
org.hsqldb.jdbcPreparedStatement.getNotSupported(jdbcPreparedStatement.j
ava:1602)
at
org.hsqldb.jdbcPreparedStatement.setCharacterStream(jdbcPreparedStatemen
t.java:1375)
at
org.exolab.castor.jdo.engine.SQLTypes.setObject(SQLTypes.java:391)
at
org.exolab.castor.jdo.engine.SQLEngine.create(SQLEngine.java:590)
at
org.exolab.castor.persist.ClassMolder.create(ClassMolder.java:891)
at
org.exolab.castor.persist.LockEngine.create(LockEngine.java:492)
at
org.exolab.castor.persist.TransactionContext.create(TransactionContext.j
ava:804)
at
org.exolab.castor.jdo.engine.DatabaseImpl.create(DatabaseImpl.java:338)
...
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
