Pessoal sou novo aqui no fórum e tenho uma dúvida.
Seguinte, criei um código para a conexão do NetBeans com o Firebird:
[b]/*
- To change this template, choose Tools | Templates
- and open the template in the editor.
*/
package br.com.sisvenda.acessobd;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
/**
*
-
@author Guh Coxinha
*/
public class AcessoFirebird {
Connection con;
PreparedStatement pstm;
ResultSet rs;
public static void main (String arg[]) throws ClassNotFoundException, SQLException{
new AcessoFirebird();
}
public AcessoFirebird() throws ClassNotFoundException, SQLException{
conectar();
}
public void conectar() throws ClassNotFoundException, SQLException{
Class.forName(“org.firebirdsql.jdbc.FBDriver”);
con = (Connection) DriverManager.getConnection(“jdbc:firebirdsql:localhost:C:\firebird\sisvenda.fdb”,“sysdba”,“masterkey”);
}
public void desconectar() throws SQLException{
con.close();
}
}[/b]
E esse código gerou a seguinte excessão:
run:
Exception in thread “main” org.firebirdsql.jdbc.FBSQLException: Resource Exception. Unable to complete network request to host “localhost”.
Reason: Unable to complete network request to host “localhost”.
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:106)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:221)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at br.com.sisvenda.acessobd.AcessoFirebird.conectar(AcessoFirebird.java:36)
at br.com.sisvenda.acessobd.AcessoFirebird.(AcessoFirebird.java:31)
at br.com.sisvenda.acessobd.AcessoFirebird.main(AcessoFirebird.java:27)
at org.firebirdsql.gds.GDSException: Unable to complete network request to host “localhost”.
at org.firebirdsql.jgds.GDS_Impl.connect(GDS_Impl.java:1662)
at org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:282)
at org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:258)
at org.firebirdsql.jca.FBManagedConnectionFactory.createDbHandle(FBManagedConnectionFactory.java:540)
at org.firebirdsql.jca.FBManagedConnection.(FBManagedConnection.java:88)
at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:366)
at org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:60)
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:103)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:221)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at br.com.sisvenda.acessobd.AcessoFirebird.conectar(AcessoFirebird.java:36)
at br.com.sisvenda.acessobd.AcessoFirebird.(AcessoFirebird.java:31)
at br.com.sisvenda.acessobd.AcessoFirebird.main(AcessoFirebird.java:27)
Java Result: 1
CONSTRUÍDO COM SUCESSO (tempo total: 2 segundos)
Poderiam me ajudar com esse código, com essa conexão?