Retrieving dateTime using database connector with Apache Jena JDBC
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?
i think what would work is getting this back into a string attribute and parsing the string back into the Date.