jbbc ucanaccess invalid database address

Added by Marica Landini over 1 year ago

Dear all,
I'm trying to import mdb file access as source schema.
I set import location from datavase JDBC MS Access Driver and Database path as C:/folder/hale_soil.mdb

I get this message errore:

invalid database address: jdbc:ucanaccess://%2FC%3A%2Ffolder%2Fhale_soil.mdb;showschema=true;sysschema=false;singleconnection=true
java.sql.SQLException: invalid database address: jdbc:ucanaccess://%2FC%3A%2Ffolder%2Fhale_soil.mdb;showschema=true;sysschema=false;singleconnection=true
at org.sqlite.JDBC.createConnection(JDBC.java:111)
at org.sqlite.JDBC.connect(JDBC.java:88)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at eu.esdihumboldt.hale.io.jdbc.JDBCConnection.getConnection(JDBCConnection.java:74)
at eu.esdihumboldt.hale.io.jdbc.JDBCConnection.getConnection(JDBCConnection.java:113)
at eu.esdihumboldt.hale.io.jdbc.JDBCConnection.getConnection(JDBCConnection.java:89)
at eu.esdihumboldt.hale.io.jdbc.JDBCSchemaReader.getConnection(JDBCSchemaReader.java:139)
at eu.esdihumboldt.hale.io.jdbc.JDBCSchemaReader.loadFromSource(JDBCSchemaReader.java:152)
at eu.esdihumboldt.hale.common.schema.persist.AbstractCachedSchemaReaderBase.execute(AbstractCachedSchemaReaderBase.java:58)
at eu.esdihumboldt.hale.common.core.io.impl.AbstractIOProvider.execute(AbstractIOProvider.java:102)
at eu.esdihumboldt.hale.common.core.io.impl.AbstractImportProvider.execute(AbstractImportProvider.java:74)
at eu.esdihumboldt.hale.ui.io.IOWizard$3.run(IOWizard.java:687)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)

Any suggestion?

Thanks,
Marica


Replies (2)

RE: jbbc ucanaccess invalid database address - Added by Thorsten Reitz over 1 year ago

Dear Marica,

Did you try to load the Access Database via the "From File" or the "From Database (JDBC)" tab?

If you still get this error when loading via "From File", would it be possible to provide us with the database or a part of it for testing?

All the best,
Thorsten

RE: jbbc ucanaccess invalid database address - Added by Marica Landini over 1 year ago

I'm trying to use tab "From Database (JDBC)".
Tab "From File" it's works fine.
Thanksyou,
Marica

(1-2/2)