JDBC for firebird

alright here is an example for you

1). download firebird jdbc driver from sourceforge

JDK 1.4 : http://sourceforge.net/project/downloading.php?groupname=firebird&filename=Jaybird-2.1.1JDK_1.4.zip&use_mirror=nchc

JDK 1.5: http://sourceforge.net/project/downloading.php?groupname=firebird&filename=Jaybird-2.1.1JDK_1.5.zip&use_mirror=jaist

2). try a similar code below to establish a connection.

boolean flag = false;

Connection con = null;

try{

Class.forName("org.firebirdsql.jdbc.FBDriver").newInstance();

flag = true;

}catch(Exception exp){

System.err.println(exp.getMessage());

exp.printStackTrace();

}

if(flag){

try{

con = DriverManager.getConnection("jdbc:firebirdsql://localhost:3050//home/firebird/test/test.fdb","user","pwd");

}catch(SQLException sqe){

System.err.println(sqe.getMessage()+" "+sqe.getErrorCode());

sqe.printStackTrace();

}finally{

try{

if(con != null && con.isClosed() == false)

con.close();

}catch(SQLException sqe){

System.err.println(sqe.getMessage()+" "+sqe.getErrorCode());

sqe.printStackTrace();

}

}

}

3). make use of the links below for better technical guidance

http://firebird.sourceforge.net/index.php?op=devel&sub=jdbc&id=faq

Hibernate - Firebird : http://www.cstengel.de/tutorial/trails_firebird_tutorial/

hope that might help :)

REGARDS,

RaHuL

RahulSharnaa at 2007-7-12 8:25:29 >