Olá estou fazendo uma conexão com ubuntu+java+mdb , mas , até a linha do class.forname ele passa qaundo chega no get conection ele da esse err:
Exception in thread “main” java.sql.SQLException: [unixODBC]Could not find Database parameter
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3073)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at Teste.(Teste.java:29)
at Teste.main(Teste.java:47)
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
Connection con = DriverManager.getConnection("jdbc:odbc:cadastro");
Statement stmt = con.createStatement();
String SqL = "SELECT * FROM CLIENTES";
ResultSet rs = stmt.executeQuery(SqL);
Could not find Database parameter -> o que falta de parameter ? no meu etc/odbc.ini está assim:
[cadastro]
Description = cadastro
Driver = /usr/local/lib/libmdbodbc.so.0
Driver64 =
Database = /home/andre/advogados/advogados/BD/cadastros.mdb
Setup64 =
Setup =
UsageCount = 1
CPTimeout =
CPReuse =
FileUsage = 1
Servername = localhost
UserName =
Password =
port = 5432
e no odbcinst.ini:
[cadastro]
Description = cadastro
Driver = /usr/local/lib/libmdbodbc.so.0
Driver64 =
Setup = /home/andre/advogados/advogados/BD/cadastros.mdb
Setup64 =
UsageCount =
CPTimeout =
CPReuse =
Trace = Yes
TraceFile = /tmp/freetds.log
FileUsage = 1
[ODBC]
Trace = Yes
TraceFile = /tmp/sql.log
ForceTrace = Yes
Pooling = Yes
ja conferi os caminhos tanto da biblioteca qto o do mdb e estão corretos.