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
