Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Date: Fri, 16 Nov 2007 08:17:17 +0100
From: Thomas Nielsen <Thomas.Nielsen@Sun.COM>
Subject: Re: Newbie Blues : Unable to connect to derby database using JDBC
In-reply-to: <921377.5260.qm@web51601.mail.re2.yahoo.com>
Sender: Thomas.Nielsen@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <473D43FD.7050303@sun.com>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 8BIT
References: <921377.5260.qm@web51601.mail.re2.yahoo.com>
User-Agent: Thunderbird 2.0.0.6 (X11/20070802)

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