Hello, I hope that this is the correct list to send this question. I am trying to use SQLite on a Gumstix Linux module running Angstrom armv7l GNU/Linux. (32-bit).
I have installed the sqlite packages and can happily create and query a database using the sqlite command line. I would like to access my database from some Java code – and I am hitting some problems! I see the error: java: codegen.c:2036: codegen_emit: Assertion `(15) != 15' failed. Aborted Whenever I try to make a connection to the database. I have been trying out various jdbc providers and seem to always see the same error. Is this a common problem ?!?! At the moment I am using the jdbc jar file downloaded from http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC#RuninPure-Javamode And am running in “Pure Java” mode. I have a very basic java test which tries to access the database in this way: ; public static void main(String[] args) { Connection conn = null; System.out.println("Logging in to database"); try { System.out.println(String.format("running in %s mode", SQLiteJDBCLoader.isNativeMode() ? "native" : "pure-java")); System.setProperty("sqlite.purejava", "true"); System.out.println(String.format("running in %s mode", SQLiteJDBCLoader.isNativeMode() ? "native" : "pure-java")); Class.forName("org.sqlite.JDBC"); System.out.println("Got jdbc driver"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block System.out.println("Failure when getting jdbc driver"); e.printStackTrace(); } try { conn = DriverManager.getConnection("jdbc:sqlite:testdb.db"); System.out.println("Connected to the database"); } catch (SQLException e) { // TODO Auto-generated catch block# System.out.println("Failure connecting to the database"); e.printStackTrace(); } Output: Logging in to database running in pure-java mode running in pure-java mode Got jdbc driver java: codegen.c:2036: codegen_emit: Assertion `(15) != 15' failed. Judging by the system.out calls my code dies when it reaches conn = DriverManager.getConnection Any tips much appreciated. Best Regards, Katie, Katie Blake, Software Developer Visit us at Metering Europe, Booth B54. Sentec Ltd phone: +44(0) 1223 303800 5 The Westbrook Centre fax: +44(0) 1223 303801 Milton Road mobile: Cambridge email: [email protected] CB4 1YG, UK web: www.sentec.co.uk This email is confidential. If you have received it in error, please notify Sentec Ltd UK at [email protected] immediately, delete it from your system and note that you may not copy, distribute or use its contents. Sentec Limited is registered at the above address UK Company Number 3452194. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
