Hello,
We are using the access jdbc driver on linux (debian) machines and the driver reports it cannot find the access database file even if the file really exist on the file system.
Our system logs the following
[2008-09-19 19:57:57,007] [DEBUG] [http-8080-Processor21] [com.cvsft.sal.reftable] - Current Working directory: /srv/cvsft/server/webapps/converso-server/work/interview/7F000101-011C7BB87591-1D07-0079E32F/7F000101-011C7BB87588-69B5-01AF1934
[2008-09-19 19:57:57,007] [DEBUG] [http-8080-Processor21] [com.cvsft.sal.reftable] - Using database URL: jdbc:access://srv/cvsft/server/webapps/converso-server/work/interview/7F000101-011C7BB87591-1D07-0079E32F/7F000101-011C7BB87588-69B5-01AF1934/marquesmodeles.mdb
[2008-09-19 19:57:57,007] [DEBUG] [http-8080-Processor21] [com.cvsft.sal.reftable] - Connecting to reference table datasource (url=jdbc:access://srv/cvsft/server/webapps/converso-server/work/interview/7F000101-011C7BB87591-1D07-0079E32F/7F000101-011C7BB87588-69B5-01AF1934/marquesmodeles.mdb)...
[2008-09-19 19:57:57,007] [ERROR] [http-8080-Processor21] [com.cvsft.sal.reftable] - SQL Error when trying to connect/access to Access database jdbc:access://srv/cvsft/server/webapps/converso-server/work/interview/7F000101-011C7BB87591-1D07-0079E32F/7F000101-011C7BB87588-69B5-01AF1934/marquesmodeles.mdb
[2008-09-19 19:57:57,007] [ERROR] [http-8080-Processor21] [com.cvsft.sal.reftable] - java.sql.SQLException: srv/cvsft/server/webapps/converso-server/work/interview/7F000101-011C7BB87591-1D07-0079E32F/7F000101-011C7BB87588-69B5-01AF1934/marquesmodeles.mdb doesn't exist or can't be accessed. If you're using mapped drives to access database files, you may need to check the security permissions.
Please note that the driver tries to access the file "srv/cvsft/server/webapps/converso-server/work/interview/7F000101-011C7BB87591-1D07-0079E32F/7F000101-011C7BB87588-69B5-01AF1934/marquesmodeles.mdb", which does not have anymore the "/" character at the begining which is the root cause of the error!!!
Many thanks for your help
Best Regards
|
Please check your jdbc url. For unix, you should use jdbc:access:////srv/... Four / is necessary.
|