Tag Info

New answers tagged

8

Preamble I will try to illustrate several possibilities. Some of the following will be purely "manual" manipulations based on some top-level code of the type one would write. Test data for SQL and HDF methods, and a tabular format For SQL and HDF methods, I will use a simple tabular format for the data: {columnNames:{__String}, data:{__List}} which is, ...


4

Using the built in SQLite you may try the following Needs["DatabaseLink`"] conn = OpenSQLConnection[JDBC["SQLite(Memory)", ""]]; SQLCreateTable[conn, SQLTable["TEST"], {SQLColumn["i", "DataTypeName" -> "INTEGER", "Nullable" -> True]}]; SQLInsert[conn, "TEST", {"i"}, {Null}] SQLSelect[conn, "TEST"] SQLDropTable[conn, "TEST"]; ...


2

It seems Mathematica is trying to execute a PreparedStatement on OrientDB JDBC connection. OrientDB JDBC does not support prepared statements at this stage, this is the reason why you are having this exception. The solution is to let Mathematica use Connection.createStatement() instead of Connection.prepareStatement(), but I cannot help you further because ...



Top 50 recent answers are included