"sqlite db import"

tokmakoff

Dear RM Developers,

I'd like to import data from an sqlite DB and I've succeeded in installing a driver for it within RM 5.0.010.
(in fact I've tried two: sqlite-jdbc-3.6.20.1.jar and sqlitejdbc-v056.jar)

However, when I make a simple process using the Stream Database operator, I am encountering the
following error:

Aug 10, 2010 1:23:56 PM WARNING: Failed to fetch database tables: java.sql.SQLException: No SQL value type found for date

After some digging, it seems that sqlite does not have a Date type.  http://www.sqlite.org/datatype3.html
"SQLite does not have a storage class set aside for storing dates and/or times. Instead, the built-in Date And Time Functions of SQLite are capable of storing dates and times as TEXT, REAL, or INTEGER values"
I looked through the code and see that DatabaseHandler makes use of an Ontology to create Attributes and fails on "date".

Is there any way I can use sqlite for data input within RM, or should I just try to export the data to a DB that works out of the box?

thanks,

Andrew.

fischer

Hi,

Does your example set contain date attributes? In that case I would say, it won't work out. If it does not, I would say we should make the database reader ignore  this problem unless a date column is really needed.

Can you post a stack trace?

Best,
Simon