Hi

Am trying to connect to derby database, but have not been successful.

I have created a database called 24k , and have also populated the tables

Here's the code:

---------------------------------

org.apache.derby.jdbc.EmbeddedSimpleDataSource ds = null;
            Connection conn = null;
            Properties props = new Properties();
            props.put("user", username);
            props.put("", "");
    
           Class.forName(driver).newInstance();
            System.out.println("Loaded the appropriate driver.");
       
            conn = DriverManager.getConnection(protocol +"24k;", props);
            System.out.println("Connected to database 24k");

            conn.setAutoCommit(false);

            Statement s = conn.createStatement();

            ResultSet rs = s.executeQuery("SELECT firstname, lastname FROM USERS WHERE uid = 1001");

---------------------------------------------------------------


---------------------------------------------------------------
    ERROR
---------------------------------------------------------------




Loaded the appropriate driver.
Connected to database  24k
exception thrown:
java.sql.SQLDataException: Invalid character string format for type int.

---------------------------------------------------------------

Please guide

Thanks
Aneez





Get easy, one-click access to your favorites. Make Yahoo! your homepage.