Tenho um penqueno exemplo que funciona blz no prompt do DOS, mas no IDE do ECLIPSE não dá certo, já configurei o path(eclipse) mas continua dando erro…ele não encontra a classe…
import java.sql.*;
public class Teste
{
public static void main (String args[]) throws Exception
{
String databaseURL = “jdbc:firebirdsql:local:c:/database/sysform.fdb”;
String user = “sysdba”;
String password = “masterkey”;
Driver d = null;
Connection c = null;
Statement s = null;
ResultSet rs = null;
try {
Class.forName ("org.firebirdsql.jdbc.FBDriver");
c = DriverManager.getConnection(databaseURL, user, password );
String query = "SELECT * FROM tabest where descricao like 'M%'";
s = c.createStatement();
rs = s.executeQuery( query );
System.out.println(rs.getMetaData().getColumnName(1)+" "+rs.getMetaData().getColumnName(3));
while (rs.next()){
System.out.println(rs.getString(1)+" "+rs.getString(3));
}
rs.close();
c.close();
}
catch (ClassNotFoundException e) {
System.out.println ("Firebird JCA-JDBC driver not found in class path");
System.out.println (e.getMessage ());
}
catch ( SQLException e) {
System.out.println (e.getMessage ());
}
}
}