db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Nielsen <Thomas.Niel...@Sun.COM>
Subject Re: Newbie Blues : Unable to connect to derby database using JDBC
Date Fri, 16 Nov 2007 07:17:17 GMT
It would probably be better to simply do

    catch (Throwable e)
    {
       System.out.println("exception thrown:");
       e.printStackTrace();
    }

to get the full stacktrace for the SQLException that you see as well.

And just for the record, what version of derby are you using ?

BR,
Thomas


Aneez Backer wrote:
> Hi
> 
> This is what is being printed on the console.
> The error message is in bold
> 
> Loaded the appropriate driver.
> Connected to database  24k
> exception thrown:
> java.sql.SQLDataException: Invalid character string format for type
>  int.
> 
> 
> The catch statement is as follows:-
> 
>         catch (Throwable e)
>         {
>             System.out.println("exception thrown:");
> 
>             if (e instanceof SQLException)
>             {
>                 printSQLError((SQLException) e);
>             }
>             else
>             {
>                 e.printStackTrace();
>             }
>         }
> 
> 
> 
> 
> Hope that clears the picture??
> 
> Thnaks
> Aneez
> */Øystein Grøvlen <Oystein.Grovlen@Sun.COM>/* wrote:
> 
>     Aneez,
> 
>     Can you provide the call stack for the exception you get?
> 
>     --
>     Øystein
> 
> 
>     Aneez Backer wrote:
>      > 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.
>      >
> 
> 
> 
> 
> 
> ------------------------------------------------------------------------
> Never miss a thing. Make Yahoo your homepage. 
> <http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs>

-- 
Thomas Nielsen

Mime
View raw message