RE: [sqlite] SQLite wrapper Java Linux: No suitable driver

[andreas.goetz]

Make sure the sqlite_jni.dll DLL is in your path!

Andi 

-----Original Message-----
From: Pasquale Imbemba [mailto:[EMAIL PROTECTED] 
Sent: Mittwoch, 10. Mai 2006 18:41
To: SQLite
Subject: [sqlite] SQLite wrapper Java Linux: No suitable driver

Hi,

I am using the sqlite wrapper by Christian Werner for Java on my Linux
machine. I use eclipse and I have create da new project which contains
the SQLite.jar stuff.

My code looks like this:

import SQLite.JDBCDriver;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;



public class JDBCTest {

        /**
         * @param args
         */
        public static void main(String[] args) {
                // TODO Auto-generated method stub
                try {
                        Class.forName("SQLite.JDBCDriver");
                        
                        String
url="jdbc:sqlite://home/pasquale/test.db";
                        Connection db =
DriverManager.getConnection(url);
                        Statement st = db.createStatement();
                        
                        //Execute query
                        ResultSet rs = st.executeQuery("SELECT * "+"FROM
tbl1");
                        
                        System.out.println("Output:");
                        
                        while (rs.next()){
                                System.out.println(rs.getString(0)+ " "
+ rs.getString(1));
                        }
                } catch (ClassNotFoundException e){
                        System.err.println("Error: "+e);
                } catch (SQLException e){
                        System.err.println("Error: "+e );
                }
        }
}

Whenever I try to compile, I get the following error:
java.lang.ClassNotFoundException: SQLite.JDBC2y.JDBCConnection
Error: java.sql.SQLException: No suitable driver

I found this link from Sun's Java Technology site
(http://forum.java.sun.com/thread.jspa?threadID=602869&messageID=3248193
), where it says I can't use this wrapper "as is" for 1.5. (I am using
JDK 5.0.6). But I don't have clear what to do.

Could someone please help?
tia
Pasquale



This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information.  If you have received it in 
error, please notify the sender immediately and delete the original.  Any other 
use of the email by you is prohibited.