Retrieving dateTime using database connector with Apache Jena JDBC

0
Hi! I’d like to access data stored in a Jena Fuseki triple store. I use the latest JDBC connector but retrieving dateTime information causes problems: The data in question looks like this <http://example.org/something> <http://example.org/pubDate> "2021-10-10"^^xsd:dateTime . <http://example.org/anotherthing> <http://example.org/pubDate> "2021-10-10"^^xsd:date .   I drop the SPARQL query into the database connector and get all the resources with their properties, but as soon as I add a line to also get the dateTime information, it fails with the following error:   Caused by: com.mendix.modules.microflowengine.MicroflowException: com.mendix.systemwideinterfaces.MendixRuntimeException: java.lang.RuntimeException: java.sql.SQLFeatureNotSupportedException: Only the single argument form of getTimestamp() is supported at MODULE.getData (JavaAction : 'Execute query')   In the Mendix domain model the pubDate attribute is set to the “Date and Time” datatype. What I tried is to cast datetime information in the query to a timestamp, but that didn’t work.   Do you have any ideas on how to get the information into Mendix?
asked
1 answers
0

i think what would work is getting this back into a string attribute  and parsing the string back into the Date.

answered