Hi,
I want to insert LocalTime objects into DataType.TIME-columns.
Empire-db:
[...]
this.ABFAHRT_PLAN = addColumn("ABFAHRT_PLAN", DataType.TIME, 0.0, false);
this.ABFAHRT_IST = addColumn("ABFAHRT_IST", DataType.TIME, 0.0, false);
[...]
PostgreSQL:
[...]
ABFAHRT_PLAN TIME,
ABFAHRT_IST TIME,
[...]
but inserting throws an exception:
org.apache.empire.exceptions.InvalidArgumentException: Invalid Argument 02:24
for parameter value.
at org.apache.empire.db.DBSQLBuilder.getDateTimeString(DBSQLBuilder.java:387)
~[empire-db-3.1.1-SNAPSHOT.jar:3.1.1-SNAPSHOT]
at org.apache.empire.db.DBSQLBuilder.appendSimpleValue(DBSQLBuilder.java:297)
~[empire-db-3.1.1-SNAPSHOT.jar:3.1.1-SNAPSHOT]
at org.apache.empire.db.DBSQLBuilder.appendValue(DBSQLBuilder.java:218)
~[empire-db-3.1.1-SNAPSHOT.jar:3.1.1-SNAPSHOT]
at org.apache.empire.db.expr.set.DBSetExpr.addSQL(DBSetExpr.java:143)
~[empire-db-3.1.1-SNAPSHOT.jar:3.1.1-SNAPSHOT]
at org.apache.empire.db.DBCommandExpr.addListExpr(DBCommandExpr.java:669)
~[empire-db-3.1.1-SNAPSHOT.jar:3.1.1-SNAPSHOT]
at org.apache.empire.db.DBCommand.getInsert(DBCommand.java:1685)
~[empire-db-3.1.1-SNAPSHOT.jar:3.1.1-SNAPSHOT]
at
org.apache.empire.db.context.DBContextBase.executeInsert(DBContextBase.java:115)
~[empire-db-3.1.1-SNAPSHOT.jar:3.1.1-SNAPSHOT]
When I convert the LocalTime object to a Date object it works.
Is LocalTime unsupported or is this a bug?
Thanks,
jan