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 <[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
