We are using
- evaluation version of hxttAccess 3.0
- Tomcat 5.5 on redhat 3
We have a problem to connect to the access database located in a sub directory of our application.
Webapps\myAppli\data\mydb.mdb
We use the following url : "jdbc:access:////data/mydb.mdb"
We receive the error : org.hibernate.exception.GenericJDBCException: Cannot open connection
|
>Webapps\myAppli\data\mydb.mdb
>We use the following url : "jdbc:access:////data/mydb.mdb"
You should try:
"jdbc:access:///"+request.getRealPath("../")+"/data/mydb.mdb".
Or
"jdbc:access:///"+request.getRealPath("./")+"/data/mydb.mdb".
Or
"jdbc:access:///../data/mydb.mdb"
Or
"jdbc:access:///./data/mydb.mdb"
Or
"jdbc:access:////Webapps/myAppli/data/mydb.mdb"
|