Six Stars

[resolved] Error connecting MSACCESS db with TOS 6

Hi all,
I've a problem with a job migrated from 5.x to 6.x that uses an access db.
The db does not have problem: I can open it, read tables, modules and so, run a compact and repair.
But tos gives me this error (tAccessInput and verifing metadata connection):
  java.lang.RuntimeException: net.ucanaccess.jdbc.UcanaccessSQLException: user lacks privilege or object not found: NULL
     at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:164)
     at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1081)
     at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:314)
     at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:272)
     at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:2674)
     at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:1)
     at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
     at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
     at java.util.concurrent.FutureTask.run(Unknown Source)
     at java.lang.Thread.run(Unknown Source)
 Caused by: net.ucanaccess.jdbc.UcanaccessSQLException: user lacks privilege or object not found: NULL
     at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:247)
     at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
     at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:155)
     ... 9 more
 Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: NULL
     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
     at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
     at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
     at net.ucanaccess.converters.LoadJet$TablesLoader.sqlInsert(LoadJet.java:1011)
     at net.ucanaccess.converters.LoadJet$TablesLoader.loadTableData(LoadJet.java:769)
     at net.ucanaccess.converters.LoadJet$TablesLoader.loadTablesData(LoadJet.java:928)
     at net.ucanaccess.converters.LoadJet$TablesLoader.loadTables(LoadJet.java:972)
     at net.ucanaccess.converters.LoadJet$TablesLoader.access$3(LoadJet.java:966)
     at net.ucanaccess.converters.LoadJet.loadDB(LoadJet.java:1361)
     at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:236)
     ... 11 more
 Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: NULL
     at org.hsqldb.error.Error.error(Unknown Source)
     at org.hsqldb.error.Error.error(Unknown Source)
     at org.hsqldb.SchemaManager.getTable(Unknown Source)
     at org.hsqldb.ParserDQL.readTableName(Unknown Source)
     at org.hsqldb.ParserDQL.readRangeVariableForDataChange(Unknown Source)
     at org.hsqldb.ParserDML.compileInsertStatement(Unknown Source)
     at org.hsqldb.ParserCommand.compilePart(Unknown Source)
     at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
     at org.hsqldb.Session.compileStatement(Unknown Source)
     at org.hsqldb.StatementManager.compile(Unknown Source)
     at org.hsqldb.Session.execute(Unknown Source)
     ... 20 more

Any idea?
thanks
1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

Re: [resolved] Error connecting MSACCESS db with TOS 6

The simplest solution works : create a new access db, copy all tables in this and then rename correctly.
I don't know why it doesn't connect to original db....
Bye
2 REPLIES
Six Stars

Re: [resolved] Error connecting MSACCESS db with TOS 6

these are useful information?

TOS 6.0.1
java 1.7
ms access xp
windows 8.1
Six Stars

Re: [resolved] Error connecting MSACCESS db with TOS 6

The simplest solution works : create a new access db, copy all tables in this and then rename correctly.
I don't know why it doesn't connect to original db....
Bye