Sorry, this one was intended only for Thomas. Please disregard :-))
>>>>>>>>>>>> Bernt M. Johnsen wrote (2007-11-16 09:56:00):
> >>>>>>>>>>>> Thomas Nielsen wrote (2007-11-16 08:17:17):
> > It would probably be better to simply do
> >
> > catch (Throwable e)
>
> Neineinei..... aldri be nybegynnere gjøre "catch Throwable". Det skal
> man ligge langt unna helt til man er så erfaren at man faktisk vet hva
> det innebærer. Denne vil cathe Error som du får f.eks. ved VM-feil,
> hw-feil etc.
>
> catch Exception er ok for debugging, men ikke i produksjonskode.
>
> catch SQLException er det riktige
>
>
>
> > {
> > 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 <[EMAIL PROTECTED]>/* 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
signature.asc
Description: Digital signature
