Can't connect to Access Base

Fernandez — Sat, 16 Nov 2024 02:12:47 GMT

Hi,

I'm using TOS DI 7.3.1.

I can't connect to an Access database with tDBInput.

I get this error:

Exception in component tDBInput_2 (Enedis_Lot5_Reindex_GetDataFromAccess)
net.ucanaccess.jdbc.UcanaccessSQLException: user lacks privilege or object not found: NULL
at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:247)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at enedis.enedis_lot5_reindex_getdatafromaccess_0_1.Enedis_Lot5_Reindex_GetDataFromAccess.tDBInput_2Process(Enedis_Lot5_Reindex_GetDataFromAccess.java:797)
at enedis.enedis_lot5_reindex_getdatafromaccess_0_1.Enedis_Lot5_Reindex_GetDataFromAccess.runJobInTOS(Enedis_Lot5_Reindex_GetDataFromAccess.java:3974)
at enedis.enedis_lot5_reindex_getdatafromaccess_0_1.Enedis_Lot5_Reindex_GetDataFromAccess.main(Enedis_Lot5_Reindex_GetDataFromAccess.java:3762)
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)
... 5 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)

I succeed to connect to another Access db.

I don't know why I can't connect to the other DB?

Thanks for your help

Re: Can't connect to Access Base

Fernandez — Mon, 08 Jun 2020 08:16:45 GMT

Hi,

I found the solution.

I had to compact the Access db.

topic Can't connect to Access Base in Talend Studio

Can't connect to Access Base

Re: Can't connect to Access Base