Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT ACCESS
Using MS Access on Solaris
sandro fadiga
2006-08-09 07:10:05.0
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.0
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.0
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.0
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.0
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.0
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.0
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.0
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.0
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.0
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.0
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


Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap