Hello,

I am using the nested version of the JDBC driver for a final APCS
project. Although I am running into several frustrations due to
limitations of the driver as many things in the JDBC API are
unimplemented. Generally to do with DatabaseMetaData, there is
absolutely no way for me to get or detect a column as having a primary
key unless I physically do:

      SELECT sql FROM sqlite_master WHERE type = 'table';

Both the java.sql.DatabaseMetaData.getPrimaryKeys() function and the
IS_AUTOINCREMENT column which is supposed to be returned in a
ResultSet by java.sql.DatabaseMetaData.getColumns() are not
implemented. In addition to that, the java.sql.Connection.getArray()
function also does not work because it is not implemented and
therefore prevents me from seeing getting all columns and rows
returned by a query at the same time. Maybe someone can point in the
right direction.

Thanks!
-Alec Hussey
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---

Reply via email to