Hello, I have a trouble wwith my connection=DriverManger.getconnection(jdbc:ucanaccess:\\*.accdb) I have all ucanacces's libraries (5) and my url isnt a trouble, but my driver jdbc:ucanaccess\\ isnt recognized. I found all possible bugs, but all is fine. But my connection is not possible. This is my source:
package PaquetePrincipal;
import java.sql.*;
import javax.swing.JOptionPane;
import java.io.File;
public class Interfaz1 extends javax.swing.JFrame {
public Connection conexion;
public Statement codigo;
public File archivo;
public Interfaz1() {
initComponents();
setTitle("LAZULI");
}
public boolean AbrirConexion(){
archivo=new File("LazuliBD.accdb");
try{
String controlador="net.ucanaccess.jdbc.UcanaccessDriver";
Class.forName(controlador);
}catch(Exception error){
JOptionPane.showMessageDialog(this, error.getMessage(), "No se encuentra el conrolador requerido: ", JOptionPane.ERROR_MESSAGE);
return false;
}
try{
String DSN="jdbc:ucanaccess:\\"+archivo.getAbsolutePath();
String Usuario="";
String Contraseña="";
conexion=DriverManager.getConnection(DSN, Usuario, Contraseña);
}catch(Exception error){
JOptionPane.showMessageDialog(this, error.getMessage() ,"Error al cargar la base de datos" , JOptionPane.ERROR_MESSAGE);This is error, i dont understand
return false;
}
try{
codigo=conexion.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
}catch(Exception error){
JOptionPane.showMessageDialog(this, error.getMessage(), "Error de conexion", JOptionPane.ERROR_MESSAGE);
return false;
}
return true;
}