Trying to create new database on connection

[Jonathan Schmidt]

I am trying to create a database in an embedded java program with the following code:

           String dbName = "testdb";
           String driver = "org.sqlite.JDBC";
           String connectString = "jdbc:sqlite::memory:"   (i have also tried "jdbc:sqlite:")
              try
              {
                 Class.forName(driver);
                 System.out.println(driver + " Started");
              }
              catch (java.lang.ClassNotFoundException e)
              {
                 System.err.print("ClassNotFoundException: ");
                 System.err.println(e.getMessage());
                 System.out.println("\n    >>> Please check your CLASSPATH variable   <<<\n");
              }

              try
              {
                  System.out.println("Connecting: " + connectString);
                 conn = DriverManager.getConnection(connectString);
                 System.out.println("Database booted...");

                 s = conn.createStatement();

              }
              catch (Throwable e)
              {
                 System.out.println("Error connecting to database:  " + e);
              }

I get a successful "org.sqlite.JDBC Started" printout
but when it comes to the connection I get:
"Error connecting to Database: java.lang.IncompatibleClassChangeError: class java.lang.reflect.Constructor does not match its skeleton"

Any ideas?

I am running on PERC JVM and have tried version 1.5, 1.6 and 1.7 with no luck.

[Peter Borissow]

I assume you're using the latest snapshot. If so, I think the url is a little off. You need ":file" like this:

jdbc:sqlite:file::memory:?cache=shared

---

From: Jonathan Schmidt <jdsc...@gmail.com>
To: xer...@googlegroups.com
Sent: Thursday, April 25, 2013 4:51 PM
Subject: [xerial 686] Trying to create new database on connection

--
You received this message because you are subscribed to the Google Groups "Xerial" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xerial+un...@googlegroups.com.
To post to this group, send email to xer...@googlegroups.com.
Visit this group at http://groups.google.com/group/xerial?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Jonathan Schmidt]

Thanks for the info. I was just going off the defaults they used int he documentations (and yes I'm using the latest snapshot)
I tried that and got:

org.sqlite.JDBC Started
Connecting: jdbc:sqlite:file::memory:?cache=shared
Error connecting to database:  java.sql.SQLException: opening db: 'file::memory:
?cache=shared': Invalid oflag or omode argument.

[Jonathan Schmidt]

Nevermind... I realized I had my import statements messed up. Thanks!