Fórum Conexão Firebird e Java (Via JDBC) #566981

import java.sql.*;
import javax.swing.*;


public class conectBD
{
public conectBD()
{
try
{  
Class.forName("org.firebirdsql.jdbc.FBDriver");
String url = "jdbc:firebirdsql:127.0.0.1/3050:database/Spz_bd.gdb";
Connection con = DriverManager.getConnection(url,"SYSDBA","123242");
Statement st = con.createStatement(); 
String s = "SELECT * FROM testeBD";
ResultSet rs = st.executeQuery(s);
while (rs.next())
{
JOptionPane.showMessageDialog(null, rs.getString(1) + "-" + rs.getString(2));
}
 con.close();
}
catch(Exception e)
{
System.out.println(e);
System.exit(0);
}
}
	
	public static void main(String args[])
	{
	conectBD obj = new conectBD();
	}
}

import java.util.*;
import java.io.*;
import java.sql.*;
public class ConnectionFactory
{
	protected Properties conProp;
	public ConnectionFactory(File config) throws IOException
	{
	     FileInputStream input = new FileInputStream(config);
	     conProp = new Properties();
	     conProp.load(input);
	     input.close();
	}
	public Connection getConnection() throws SQLException, ClassNotFoundException, InstantiationException, IllegalAccessException
	{
	     String dri = conProp.getProperty("driver");
	     Class.forName(dri).newInstance();
	     String ur = conProp.getProperty("url");
	     String us = conProp.getProperty("user");
	     String pa = conProp.getProperty("password");
	     Connection c = DriverManager.getConnection(ur,us,pa);
	     return c;
	}
}

driver   = org.firebirdsql.jdbc.FBDriver
url      = jdbc:firebirdsql:192.168.2.33/3050:d:Mid/Db/Mid.fdb
user     = SYSDBA
password = masterkey

set classpath=.;c:/j2sdk1.4.2_05/lib/tools.jar;
c:/j2sdk1.4.2_05/jre/lib/ext/pgjdbc2.jar;c:\j2sdk1.4.2_05\lib\firebirdsql.jar;c:\j2sdk1.4.2_05\lib\jaas.jar;
c:\j2sdk1.4.2_05\lib\log4j-core.jar;
c:\j2sdk1.4.2_05\lib\mini-concurrent.jar;
c:\j2sdk1.4.2_05\lib\mini-j2ee.jar;c:\j2sdk1.4.2_05\lib\jdbc2_0-stdext;

C:\j2sdk1.4.2_05\lib

java.lang.NullPointerException

import java.util.*; 
import java.io.*; 
import java.sql.*;
import javax.swing.*;

public class ConnectionFactory 
{ 
   protected Properties conProp;
   public ConnectionFactory()
   {
   		
   }
   public ConnectionFactory(File config) throws IOException 
   { 
        FileInputStream input = new FileInputStream(config); 
        conProp = new Properties(); 
        conProp.load(input); 
        input.close(); 
   } 
   public Connection getConnection() throws SQLException, ClassNotFoundException, InstantiationException, IllegalAccessException 
   { 
        String dri = conProp.getProperty("org.firebirdsql.jdbc.FBDriver"); 
        Class.forName(dri).newInstance(); 
        String ur = conProp.getProperty("jdbc:firebirdsql:127.0.0.1/3050:c:database/Spz_bd.gdb"); 
        String us = conProp.getProperty("SYSDBA"); 
        String pa = conProp.getProperty("123242"); 
        Connection c = DriverManager.getConnection(ur,us,pa); 
        return c; 
   }
   
   public static void main(String args[])
   {
   		ConnectionFactory obj = new ConnectionFactory();
   		try
   		{
   			Connection conn = obj.getConnection();
   			Statement st = conn.createStatement();
            ResultSet rs = st.executeQuery("SELECT * FROM testeBD");
            while (rs.next())
           	{
            	JOptionPane.showMessageDialog(null, rs.getString(1) + "-" + rs.getString(2)); 
           	}
            //Fechando a conexão: 
            conn.close();
   		}
   		catch(Exception exc)
   		{
   			JOptionPane.showMessageDialog(null,"Exceção gerada: "+exc);
   		}
   }
} 

 public ConnectionFactory()

 public ConnectionFactory(File config) throws IOException

ConnectionFactory factory = new ConnectionFactory(new File("../DB/Mid.properties"));
Connection c = factory.getConnection();

Annotation: Exception occurred in Request Processor
java.lang.NoClassDefFoundError: javax/resource/ResourceException
	at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:147)
	at org.netbeans.modules.db.explorer.DatabaseConnection$1.run(DatabaseConnection.java:340)
	at org.openide.util.Task.run(Task.java:136)
	at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:330)
[catch] at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:686)

Unable to add conection, cannot establish a connection to jdbc:firebirdsql:127.0.0.1/3050:c:database/Spz_bd.gdb using org.firebirdsql.jdbc.FBDriver(Resource Exception. Unable to complete network request to host "127.0.0.1".
Reason: Unable to complete network request to host "127.0.0.1".)