incompatible with SQLite???
I would like to use "Stream Database' operator to feed data to my module in RapidMiner. So I first got a SQLite JDBC Drive from here
And successfully install it on my RapidMiner through 'Manage Database Drivers' dialog.
Also, a new database connection was added through "Manage Database Connections' dialog. When I press the "Test' button, the connection status shows 'Connection OK'.
However, after I add a "Stream Database" to my 'Process' and then run it, I got an error message:
"Database error occured: SQLite only supports TYPE_FORWARD_ONLY cursors"
Reason: SQLite only supports TYPE_FORWARD_ONLY cursors
Offending operator: Stream Database
Forward-only-cursor probably is the only type of cursor supported by SQLite. (Precisely speaking, SQLite does not actually have cursors. But SQLite behaves like having a forward only cursor).
So, is SQLite really incompatible with RapidMiner? If not, then how could I bypass this error?
BTW, I searched the forum and found these two relevant topics
sqlite db import: http://rapid-i.com/rapidforum/index.php/topic,2449.0.html
Using SQLite DB with RM: http://rapid-i.com/rapidforum/index.php?topic=3581.0
Unfortunately, they couldn't provide any help in my case.