# No working sql under apde

**URL:** https://discourse.processing.org/t/no-working-sql-under-apde/3691
**Category:** Libraries
**Created:** [September 20, 2018, 9:29am UTC](https://discourse.processing.org/t/no-working-sql-under-apde/3691 "2018-09-20T09:29:22Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![BodaciousBrian](https://avatars.discourse-cdn.com/v4/letter/b/958977/32.png) [@BodaciousBrian](https://discourse.processing.org/u/BodaciousBrian)
#### Post date: [September 20, 2018, 9:29am UTC](https://discourse.processing.org/t/no-working-sql-under-apde/3691/1 "2018-09-20T09:29:22Z")

</div>

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

```auto
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](http://db4free.net) throws this error:

```auto
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](http://db4free.net) under mysql examples… all have failed, most with a can’t find a jbdc driver error…

---

<div class="post-metadata">

### Author: ![kfrajer](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.processing.org/kfrajer/32/196_2.png) [@kfrajer](https://discourse.processing.org/u/kfrajer)
#### Post date: [September 20, 2018, 1:39pm UTC](https://discourse.processing.org/t/no-working-sql-under-apde/3691/2 "2018-09-20T13:39:10Z")

</div>

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

---

<div class="post-metadata">

### Author: ![BodaciousBrian](https://avatars.discourse-cdn.com/v4/letter/b/958977/32.png) [@BodaciousBrian](https://discourse.processing.org/u/BodaciousBrian)
#### Post date: [September 21, 2018, 4:28am UTC](https://discourse.processing.org/t/no-working-sql-under-apde/3691/3 "2018-09-21T04:28:55Z")

</div>

Ketai does work… thank you!

---

<div class="post-metadata">

### Author: ![robifub](https://avatars.discourse-cdn.com/v4/letter/r/13edae/32.png) [@robifub](https://discourse.processing.org/u/robifub)
#### Post date: [January 4, 2019, 1:56pm UTC](https://discourse.processing.org/t/no-working-sql-under-apde/3691/4 "2019-01-04T13:56:55Z")

</div>

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