No working sql under apde


#1

Under the bezier library, sqlite example 1 does the following:

Failed to delete old APK file
Sorry can't find any file named test.db make sure it exists and the path is correct.
Using this database: test.db
SQL.connect(): Could not find the database driver ( org.sqlite.JDBC ).
java.lang.ClassNotFoundException: org.sqlite.JDBC
	at java.lang.Class.classForName(Native Method)
	at java.lang.Class.forName(Class.java:400)
	at java.lang.Class.forName(Class.java:326)
	at de.bezier.data.sql.SQL.connect(Unknown Source)
	at processing.test.sqlite_example1.SQLite_example1.setup(SQLite_example1.java:33)
	at processing.core.PApplet.handleDraw(PApplet.java:1801)
	at processing.core.PSurfaceNone.callDraw(PSurfaceNone.java:471)
	at processing.core.PSurfaceNone$AnimationThread.run(PSurfaceNone.java:503)
Caused by: java.lang.ClassNotFoundException: Didn't find class "org.sqlite.JDBC" on path: DexPathList[[zip file "/data/app/processing.test.sqlite_example1-2/base.apk"],nativeLibraryDirectories=[/data/app/processing.test.sqlite_example1-2/lib/arm64, /system/lib64, /vendor/lib64]]
	at dalvik.system.BaseDexClassLoader.findClass(BaseDexClassLoader.java:56)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:380)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:312)
	... 8 more

I have moved the example to sketchbook, and put copies of test.db everywhere… including the sketch/data folder.

Mysql1 example to db4free.net throws this error:

Failed to delete old APK file
java.lang.ExceptionInInitializerError
	at com.mysql.jdbc.Messages.getString(Messages.java)
	at com.mysql.jdbc.CommunicationsException.<init>(CommunicationsException.java:174)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2643)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
	at java.sql.DriverManager.getConnection(DriverManager.java:569)
	at java.sql.DriverManager.getConnection(DriverManager.java:219)
	at de.bezier.data.sql.SQL.connect(Unknown Source)
	at processing.test.mysql_example1.MySQL_example1.setup(MySQL_example1.java:61)
	at processing.core.PApplet.handleDraw(PApplet.java:1801)
	at processing.core.PSurfaceNone.callDraw(PSurfaceNone.java:471)
	at processing.core.PSurfaceNone$AnimationThread.run(PSurfaceNone.java:503)
Caused by: java.lang.RuntimeException: Can't load resource bundle due to underlying exception java.util.MissingResourceException: Can't find bundle for base name com.mysql.jdbc.LocalizedErrorMessages, locale en_US
	at com.mysql.jdbc.Messages.<clinit>(Messages.java:60)
	... 12 more

I just need sql… nothing works! I’ve made a postgre server, and a mysql server. I’ve tried to use db4free.net under mysql examples… all have failed, most with a can’t find a jbdc driver error…


#2

I am not addressing your chief issue. Instead, I would like to suggest using the sqlite example that comes with the ketai library. I understand you are working with the APDE. Not sure how easy would be to access the ketai library from the APDE. If you have it as part of your resources, then you could give it a try easily by running the provided example.

Kf


#3

Ketai does work… thank you!


#4

that’s been fixed recently. try updating your processing.
https://www.welookups.com
https://www.javacodegeeks.net