Problemas com Firebird

Programação Java
#1

Gente, estou começando com JDBC e está dando um erro estranho aki… Lá vai o code:

import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;

public class Conexao {
	   private static Connection conexao;
	   
	   private final String driver = "org.firebirdsql.jdbc.FBDriver";
	   private final String url = "jdbc:firebirdsql:localhost/3050:/c:/db.gdb";
	   private final String usuario = "SYSDBA";
	   private final String senha = "masterkey";
	   
	   public Conexao() throws SQLException, ClassNotFoundException {
	     if(conexao == null)
	      conectar();    
	   }
	   
	   public Connection getConexao() throws SQLException, ClassNotFoundException {
	     if(conexao == null)
	      conectar();
	     return conexao;    
	   }
	   
	   private void conectar() throws SQLException, ClassNotFoundException {
	     if(conexao == null){
	      try{
	      	DriverManager.registerDriver((Driver)Class.forName(driver).newInstance());
	      	conexao = DriverManager.getConnection(url, usuario, senha); 
	      	System.out.println("Acesso Concedido!!!");
	      }catch(IllegalAccessException iae){ 
	      	System.err.println("Acesso Ilegal."); 
	      }catch(InstantiationException ie){ 
	      	System.err.println("Exceção na instanciação.");
	      }
	     }
	   }
		public static void main(String[] args) throws SQLException, ClassNotFoundException{
			new Conexao();
		}
}

e aki a exception gerada:

Exception in thread "main" org.firebirdsql.jdbc.FBSQLException: Resource Exception. Unable to complete network request to host "unknown".
Failed to locate host machine.
Undefined service c/tcp.
Reason: Unable to complete network request to host "unknown".
Failed to locate host machine.
Undefined service c/tcp.
	at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:107)
	at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:275)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at Conexao.conectar(Conexao.java:30)
	at Conexao.<init>(Conexao.java:17)
	at Conexao.main(Conexao.java:40)
at org.firebirdsql.gds.GDSException: Unable to complete network request to host "unknown".
Failed to locate host machine.
Undefined service c/tcp.
	at org.firebirdsql.jgds.GDS_Impl.readStatusVector(GDS_Impl.java:1698)
	at org.firebirdsql.jgds.GDS_Impl.receiveResponse(GDS_Impl.java:1651)
	at org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:290)
	at org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:252)
	at org.firebirdsql.jca.FBManagedConnectionFactory.createDbHandle(FBManagedConnectionFactory.java:543)
	at org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:109)
	at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:374)
	at org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:61)
	at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:104)
	at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:275)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at Conexao.conectar(Conexao.java:30)
	at Conexao.<init>(Conexao.java:17)
	at Conexao.main(Conexao.java:40)

Na verdade e minha dúvida é se a String url está certa…(parece meio embolada)

Se alguém tiver algum tutorial de conexão com o firebird e outros bancos pra me indicar, será de bom grado…

#2

Tem uma barra a mais na URL, antes da unidade c:.

O correto seria assim:

“jdbc:firebirdsql:localhost/3050:c:/db.gdb”

#3

blz…

Vou testar…

#4

valeu mesmo… depois de tanto tempo consegui fazer uma query no meu tão estimado firebird… agora estou preparado para a luta com o mysql e o JConnector…

#5