The moose likes JDBC and Relational Databases and the fly likes InstantDB is Drivin me NUTS!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "InstantDB is Drivin me NUTS!!!" Watch "InstantDB is Drivin me NUTS!!!" New topic

InstantDB is Drivin me NUTS!!!

Paul McKenna
Ugly Redneck
Ranch Hand

Joined: Jul 08, 2000
Posts: 1006
Having given up on making a connection to MS ACCESS, I decided to check out Instant DB upon seeing a few references in the list here. I installed it successfully, added all the references to my classpath and was able to import the 2 packages well.
I am also able to load the instantdb driver, but the problem is when i say my url.
example :
String URL = "jdbc:idb:sample";
String username = "";
String password = "";
con = DriverManager.getConnection (URL,username,password);

I recieve the error message Problems connecting to sample.
What in world should I do to get one JDBC program working!!!

Commentary From the Sidelines of history
Frank Carver

Joined: Jan 07, 1999
Posts: 6920
I've used InstantDB many times successfully, so stick with it.
Looking at your JDBC URL, I'm surprised at the "sample" at the end. Bear in mind that InstantDB requires a valid, accessible, filename in this position. Have you actually got a file called just "sample" in the working directory of your java program?
I usually use (for example) "sample.prp", "", or "sample.idb", and make sure that the path to the file is included if necessary, ie:

Read about me at ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
Paul McKenna
Ugly Redneck
Ranch Hand

Joined: Jul 08, 2000
Posts: 1006
Yea Frank, Sample is in my directory. But is still giving me weird errors. However, I finally got my ACCESS connection to work and am quite satisfied with it. But, tell me something.. I read somewhere in this forum that ACCESS does not support certain JDBC features. How true is this? And do I HAVE to connect to ACCESS via a jdbc-odbc bridge.. cant i directly find a jdbc driver for ms-access??

Thanks in advance
I agree. Here's the link:
subject: InstantDB is Drivin me NUTS!!!
It's not a secret anymore!