[resolved] Error connecting MSACCESS db with TOS 6

gorotman — Thu, 01 Oct 2015 08:30:53 GMT

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

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

gorotman — Thu, 01 Oct 2015 08:47:21 GMT

these are useful information?

TOS 6.0.1
java 1.7
ms access xp
windows 8.1

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

gorotman — Thu, 01 Oct 2015 10:57:13 GMT

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

topic [resolved] Error connecting MSACCESS db with TOS 6 in Talend Studio

[resolved] Error connecting MSACCESS db with TOS 6

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

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