Trying to fetch data form KDE digicam SQLite DB not working. There are some
fixes within DefaultBinding related to SQLite.
Current (3.11.0-SNAPSHOT) traces when executing
ImagesRecord image =
dslContext.selectFrom(IMAGES).where(IMAGES.ID.eq(imgId)).fetchOne();
shows:
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ Thank you for using jOOQ 3.11.0
org.jooq.exception.DataAccessException: SQL [select Images.id,
Images.album, Images.name, Images.status, Images.category,
Images.modificationDate, Images.fileSize, Images.uniqueHash from Images
where Images.id = ?]; Error while reading field:
"Images"."modificationDate", at JDBC index: 6
at org.jooq_3.11.0.SQLITE.debug(Unknown Source)
at org.jooq.impl.Tools.translate(Tools.java:2293)
at
org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:730)
at org.jooq.impl.CursorImpl$CursorIterator.fetchNext(CursorImpl.java:1628)
at org.jooq.impl.CursorImpl$CursorIterator.hasNext(CursorImpl.java:1579)
at org.jooq.impl.CursorImpl.fetchNext(CursorImpl.java:401)
at org.jooq.impl.Tools.fetchOne(Tools.java:1695)
at org.jooq.impl.AbstractResultQuery.fetchOne(AbstractResultQuery.java:535)
at org.jooq.impl.SelectImpl.fetchOne(SelectImpl.java:2814)
Caused by: java.sql.SQLException: Error while reading field:
"Images"."modificationDate", at JDBC index: 6
at
org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.setValue(CursorImpl.java:1724)
at
org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.operate(CursorImpl.java:1683)
at
org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.operate(CursorImpl.java:1648)
at org.jooq.impl.RecordDelegate.operate(RecordDelegate.java:125)
at org.jooq.impl.CursorImpl$CursorIterator.fetchNext(CursorImpl.java:1612)
... 6 more
Caused by: java.lang.IllegalArgumentException: Timestamp format must be
yyyy-mm-dd hh:mm:ss[.fffffffff]
at java.sql.Timestamp.valueOf(Timestamp.java:204)
at org.jooq.impl.DefaultBinding.parse(DefaultBinding.java:421)
at org.jooq.impl.DefaultBinding.access$000(DefaultBinding.java:174)
at
org.jooq.impl.DefaultBinding$DefaultTimestampBinding.get0(DefaultBinding.java:3262)
at
org.jooq.impl.DefaultBinding$DefaultTimestampBinding.get0(DefaultBinding.java:3194)
at org.jooq.impl.DefaultBinding$AbstractBinding.get(DefaultBinding.java:755)
at
org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.setValue(CursorImpl.java:1714)
... 10 more
Same error (other lines) with 3.10.5
As far as I can see timestamps in digikam DB are strings different
formatted, e.g.
when using sqlit3 shell cmd the returned values look like
2011-12-12T13:14:29
Anyone any idea how to adapt timestanp parser?
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
