Using MS Access on Solaris |
sandro fadiga |
2006-08-09 07:10:05 |
Hi,
I'm evaluating your product to my company, but I'm having this problem when using it in my environment:
I have a page that upload a MDB file to a Solaris server, then the server side will process the MDB file(open a connection and do some queries). I've already pack the Jar file with my code in the library folder and set up the string connection on the code. When I run the code on my local (development) windows machine, it works nice, connects and do the queries, but when I deployed it to the Test server (witch is a Solaris one) it doesn't work giving me an exception. Do I have to do some more configurations to make it work ?
Thanks,
Sandro.
|
Re:Using MS Access on Solaris |
HXTT Support |
2006-08-09 08:01:11 |
Have the MDB File upload to the solaris server?
If yes,have you put the HXTT Access JDBC Package to the library folder of the Solaris Server?
If yes,please tell us your exception information and which web server you use.
|
Re:Re:Using MS Access on Solaris |
sandro fadiga |
2006-08-09 12:25:57 |
Hi,
We're using the Oracle container (OC4J), and the Access JDBC Package(the Access_JDBC30.jar file) is in the WEB-INF/lib dir, which is in the classpath of the application (Not int the OC4J classpath). The MDB file exists in the path listed in the exception and is valid.
Thanks,
Sandro.
The error log on the server is:
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (prod/oexq1/ora/iAS/oc4j/j2ee/home/applications/ahead/ahead/ahd/files/ERJ170LDI17.3V17.1-I-V08.MDB doesn't exist!) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at br.com.ahd.modelo.dao.DatabaseAccess.open(DatabaseAccess.java:135) at br.com.ahd.modelo.dao.LDIDAO.versionLDIMDB(LDIDAO.java:154) at br.com.ahd.controle.servlets.LDIFileUpload.preProcessLdi(LDIFileUpload.java:139) at br.com.ahd.controle.servlets.LDIFileUpload.processRequest(LDIFileUpload.java:79) at br.com.ahd.controle.servlets.LDIFileUpload.doPost(LDIFileUpload.java:257) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65) at br.com.ahd.controle.servlets.Seguranca.doFilter(Seguranca.java:105) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:604) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: prod/oexq1/ora/iAS/oc4j/j2ee/home/applications/ahead/ahead/ahd/files/ERJ170LDI17.3V17.1-I-V08.MDB doesn't exist! at com.hxtt.global.SQLState.SQLException(Unknown Source) at com.hxtt.sql.bk.a(Unknown Source) at com.hxtt.sql.access.n.(Unknown Source) at com.hxtt.sql.access.EmbeddedDriver.connect(Unknown Source) at com.hxtt.global.SQLState.getConnection(Unknown Source) at com.hxtt.sql.HxttDriver.if(Unknown Source) at com.hxtt.sql.HxttDriver.connect(Unknown Source) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851) ... 17 more
|
Re:Re:Re:Using MS Access on Solaris |
Sandro Fadiga |
2006-08-10 04:53:54 |
Hi, I also forgot to inform the connection string that I'm using to connecto to the database. I read the documentation and follow it, in a Windows environment it works well, but in solaris, it's giving me the error below...
the string is: jdbc:access:/prod/oexq1/ora/iAS/oc4j/j2ee/home/applications/ahead/ahead/ahd/files/ERJ170LDI17.3V17.1-I-V08.MDB
Thanks,
Sandro.
|
Re:Re:Re:Using MS Access on Solaris |
Sandro Fadiga |
2006-08-10 05:11:01 |
Hi, I also forgot to inform the connection string that I'm using to connecto to the database. I read the documentation and follow it, in a Windows environment it works well, but in solaris, it's giving me the error below...
the string is: jdbc:access:/prod/oexq1/ora/iAS/oc4j/j2ee/home/applications/ahead/ahead/ahd/files/ERJ170LDI17.3V17.1-I-V08.MDB
Thanks,
Sandro.
|
Re:Re:Re:Using MS Access on Solaris |
Sandro Fadiga |
2006-08-10 05:27:03 |
Hi, I also forgot to inform the connection string that I'm using to connecto to the database. I read the documentation and follow it, in a Windows environment it works well, but in solaris, it's giving me the error below...
the string is: jdbc:access:/prod/oexq1/ora/iAS/oc4j/j2ee/home/applications/ahead/ahead/ahd/files/ERJ170LDI17.3V17.1-I-V08.MDB
Thanks,
Sandro.
|
Re:Re:Re:Re:Re:Re:Using MS Access on Solaris |
HXTT Support |
2006-08-10 07:19:15 |
You can use the follows URL to try:
jdbc:access:///prod/oexq1/ora/iAS/oc4j/j2ee/home/applications/ahead/ahead/ahd/files/ERJ170LDI17.3V17.1-I-V08.MDB
But at first,you should check whether this mdb files exists.
ls /prod/oexq1/ora/iAS/oc4j/j2ee/home/applications/ahead/ahead/ahd/files/ERJ170LDI17.3V17.1-I-V08.MDB
Ths filename is should be ERJ170LDI17.3V17.1-I-V08.MDB(all characters are uppercase and not the other file).
|
Re:Using MS Access on Solaris |
sandro fadiga |
2006-08-10 11:16:14 |
Hi, I've tried that and still got the same error, the file exists in the dir. Any other idea ?
Thanks,
Sandro.
Information abou the file:
DATE:08/10/2006 15:06:44 -> file name: ERJ170LDI17.3V17.1-I-V08.MDB
DATE:08/10/2006 15:06:44 -> server dir: /prod/oexq1/ora/iAS/oc4j/j2ee/home/applications/ahead/ahead/ahd/files
DATE:08/10/2006 15:06:44 -> access connection string: jdbc:access:///prod/oexq1/ora/iAS/oc4j/j2ee/home/applications/ahead/ahead/ahd/files/ERJ170LDI17.3V17.1-I-V08.MDB
The exception:
DATE:08/10/2006 15:06:45 -> org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (prod/oexq1/ora/iAS/oc4j/j2ee/home/applications/ahead/ahead/ahd/files/ERJ170LDI17.3V17.1-I-V08.MDB doesn't exist!) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at br.com.ahd.modelo.dao.DatabaseAccess.open(DatabaseAccess.java:135) at br.com.ahd.modelo.dao.LDIDAO.versionLDIMDB(LDIDAO.java:152) at br.com.embraer.ahd.controle.servlets.LDIFileUpload.preProcessLdi(LDIFileUpload.java:139) at br.com.ahd.controle.servlets.LDIFileUpload.processRequest(LDIFileUpload.java:79) at br.com.ahd.controle.servlets.LDIFileUpload.doPost(LDIFileUpload.java:257) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65) at br.com.ahd.controle.servlets.Seguranca.doFilter(Seguranca.java:105) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:604) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: prod/oexq1/ora/iAS/oc4j/j2ee/home/applications/ahead/ahead/ahd/files/ERJ170LDI17.3V17.1-I-V08.MDB doesn't exist! at com.hxtt.global.SQLState.SQLException(Unknown Source) at com.hxtt.sql.bk.a(Unknown Source) at com.hxtt.sql.access.n.(Unknown Source) at com.hxtt.sql.access.EmbeddedDriver.connect(Unknown Source) at com.hxtt.global.SQLState.getConnection(Unknown Source) at com.hxtt.sql.HxttDriver.if(Unknown Source) at com.hxtt.sql.HxttDriver.connect(Unknown Source) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851) ... 17 more
|
Re:Re:Re:Re:Re:Re:Re:Re:Using MS Access on Solaris |
HXTT Support |
2006-08-11 06:04:33 |
You can try run a single java program with the same code in the page to see whether it works.
If not,this maybe be that the user have no enough right to access this access when you confirm this file exists.
If yes,please run the follows command
chmod 777 /prod/oexq1/ora/iAS/oc4j/j2ee/home/applications/ahead/ahead/ahd/files/ERJ170LDI17.3V17.1-I-V08.MDB
to change this access file attribute and retry.
|
Re:Re:Re:Re:Re:Re:Re:Re:Using MS Access on Solaris |
HXTT Support |
2006-08-11 06:05:46 |
|
to change this access file attribute and access this page to see whether this page can work normal.
|
Re:Re:Re:Re:Re:Re:Re:Re:Using MS Access on Solaris |
HXTT Support |
2006-08-11 21:48:10 |
If your file is at /prod/oexq1/ora/iAS/oc4j/j2ee/home/applications/ahead/ahead/ahd/files/ERJ170LDI17.3V17.1-I-V08.MDB , you should use jdbc:access:////prod/oexq1/ora/iAS/oc4j/j2ee/home/applications/ahead/ahead/ahd/files/ERJ170LDI17.3V17.1-I-V08.MDB
|
Main
webmaster@hxtt.com