Home / Questions / 157868
Accepted
Henriquez10
Asked: 2020-04-21 11:50:36 +0800 CST 2020-04-21 11:50:36 +0800 CST

Access database connection with JAVA

  • 772

Greetings, I don't know why the connection doesn't run, will it be because jackcessit will be obsolete or because of the version of my jdk 1.8? because I already added JAR UCanAccess4.0.4 to the libraries through netbeans

package Frames;
import java.sql.*;
import javax.swing.*;
import java.sql.DriverManager;
/**
 *
* @author 
*/


// creando la clase conexion para conectar a la base de datos en Access
public class Conexion {
static Connection conn = null;
static String driver = "net.ucanaccess.jdbc.UcanaccessDriver";


static String url = "jdbc:ucanaccess://C:\\xxxx\\xxx.accdb";

public static Connection ejecutarConexion(){
    try{
        if(conn==null){
            Class.forName(driver);
            conn = DriverManager.getConnection(url);
            JOptionPane.showMessageDialog(null, "Conectado");

        }
    } catch (Exception ex){
        ex.printStackTrace();
        conn = null;
    }
    return conn;
}


public static void main(String [] args){
    Connection cn= Conexion.ejecutarConexion();
}
}

The error is the following:

enter image description here

java

1 Answers

  1. Best Answer

    The error is in the driveryou are using this: 

    static String driver = "net.ucanaccess.jdbc.UcanaccessDriver";

    Try this one, it worked for me

    this.controlador="sun.jdbc.odbc.JdbcOdbcDriver";

    And you are missing createStatementbut I leave you this example of my connection class to give you an idea of ​​the parts that you were missing

    public class connectBD {


private Connection conexion;
private Statement sentencia;
private final String controlador;
private final String nombre_bd;
private final String usuarioBD;
private final String passwordBD;





public connectBD(){

    this.controlador="sun.jdbc.odbc.JdbcOdbcDriver";

    this.nombre_bd="C:\\Users\\Raul\\Documents\\NetBeansProjects\\BD_Access\\Prueba_Java.accdb";

    this.usuarioBD="";

    this.passwordBD="";
}



public boolean EstablecerConexion() throws SQLException{
    try{
        conexion=DriverManager.getConnection("jdbc:ucanaccess://"+this.nombre_bd,this.usuarioBD,this.passwordBD);
    }catch (SQLException e){
         JOptionPane.showMessageDialog(null,"Error al realizar la conexion "+e);
         return false;
    }



    try {
        this.sentencia=this.conexion.createStatement(
        ResultSet.TYPE_SCROLL_INSENSITIVE,
        ResultSet.CONCUR_READ_ONLY);
    }

    catch (SQLException e) {
        JOptionPane.showMessageDialog(null,"Error al crear el objeto sentencia "+e);
        return false;

    }

    return true;
}



public ResultSet EjecutarSentencia( String sql) throws SQLException{
    ResultSet rs;
    rs = this.sentencia.executeQuery(sql);
    return rs;
}

}
    • 2