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
Problem running in tomcat
prasanna
2006-09-22 00:06:44.0
Hello,

Im using hxtt access driver for connecting to ms access database which is password protected.It is working fine both as an application and applet(running under appletviewer), but not working in tomcat.I don't know why,im new to this development field i have 0 yrs experience.I don't know how to write an xml file for connecting to database in web-inf and meta-inf folder .The tomcat version im using is tomcat 5.5.17.Can we connect to database without using databaseconnection pool.I not able to understand database connection pooling.
Re:Problem running in tomcat
HXTT Support
2006-09-22 00:14:12.0
>Can we connect to database without using databaseconnection pool
Yeah. What's your jdbc url in tomcat?
Re:Re:Problem running in tomcat
prasanna
2006-09-22 00:41:25.0
These are the url s which i have used for my project

jdbc:access://ip-address of the local machine which i have the database:80/databasename.mdb?password=password when i use this url and run in gui
which u have provided it is working fine but at the same time if i run tomcat using http://ip-address of the local machine i get HXTT Remote Connectionv1.2TeV instead of tomcat home page i don't why this happens.

jdbc:access:/c:/databasename.mdb?password=password when i click a html page im able to get the data but the same thing when im running in tomcat it is not so..
Please help me,
Thank u..

Re:Re:Re:Problem running in tomcat
HXTT Support
2006-09-22 00:46:18.0
Where is your tomcat server, and where is your mdb file?
Re:Re:Re:Re:Problem running in tomcat
prasanna
2006-09-22 00:49:16.0
Both are running on the same machine
Re:Re:Re:Re:Re:Problem running in tomcat
HXTT Support
2006-09-22 00:59:25.0
Then you can use:
jdbc:access:////c:/mdbfiles/databasename.mdb?password=password

if that databasename.mdb is at c:/mdbfiles .
Re:Re:Re:Re:Re:Re:Problem running in tomcat
prasanna
2006-09-22 02:07:27.0
I also tried that it was working fine when i run in appletviewer but not in tomcat,so please help me..when i run whith http://ipaddress-0f-localmachine/webpage.html when i use this url i get the web page and applet but not connecting to database..
Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
HXTT Support
2006-09-22 02:25:49.0
Sorry. It should be:
jdbc:access:///c:/mdbfiles/databasename.mdb?password=password
if that databasename.mdb is at c:/mdbfiles .

What's your code and error message?
Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
prasanna
2006-09-22 02:28:17.0
I also use

http://remote-machine-ip:8029/C:/Databasename.mdb?password=password in the gui and it is also working fine to connect to database which is present in the remote system.Then i use localhost/ip address of the local machine using tomcat the page is displayed but not connected to the database.I don't know where i made a mistake..I kept the folder which contains html file and class files in tomcat->webapps->root,then i kept that Access_JDBC30.jar in tomcat->common->lib
please help me,
thank u
Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
HXTT Support
2006-09-22 02:36:19.0
> http://remote-machine-ip:8029/C:/Databasename.mdb?password=password in the
> gui and it is also working fine to connect to database which is present
> in the remote system.
>Then i use localhost/ip address of the local machine using tomcat the page is
>displayed but not connected to the database.
It seems that you're placing tomcat and mdb file on one host, then wish to visit those data though an application on another host?
Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
p
2006-09-22 02:40:37.0
No ,i tried with jdbc:access:///C:/databasename.mdb?password=password only but it is not working . I don know where to find error messages in tomcat.
First of all i want to know why i get HXTT Remote Connectionv1.2Te when i run http://local-machine-ip instead of tomcat home page..
I explain clearly im running access server,and in url info i specify
jdbc:access://local-machine-ip:80/C:/databasename.mdb?password=password
Its get connected and im able to retrieve the records but at the same time when i run tomcat using http://localmachine-ip/ im not able to get the homepage of tomcat.
I also tried http://localhost/webpage-which-contain-all-files/webpage.html i get the applet but not connected to database.
Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
prasanna
2006-09-22 02:40:48.0
No ,i tried with jdbc:access:///C:/databasename.mdb?password=password only but it is not working . I don know where to find error messages in tomcat.
First of all i want to know why i get HXTT Remote Connectionv1.2Te when i run http://local-machine-ip instead of tomcat home page..
I explain clearly im running access server,and in url info i specify
jdbc:access://local-machine-ip:80/C:/databasename.mdb?password=password
Its get connected and im able to retrieve the records but at the same time when i run tomcat using http://localmachine-ip/ im not able to get the homepage of tomcat.
I also tried http://localhost/webpage-which-contain-all-files/webpage.html i get the applet but not connected to database.
Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
HXTT Support
2006-09-22 02:48:25.0
>jdbc:access://local-machine-ip:80/C:/databasename.mdb?password=password
>Its get connected and im able to retrieve the records but at the same time
>when i run tomcat using http://localmachine-ip/ im not able to get the
> homepage of tomcat.
>I also tried http://localhost/webpage-which-contain-all-files/webpage.html i
> get the applet but not connected to database.
You can't run AccessServer at 80 port, because Tomcat need that port. You should stop AccessServer, and remove that service, and add a new service like jdbc:access://local-machine-ip:8029/C:/databasename.mdb?password=password, then you can access data through 8029, and can see html page at 80 port:)
Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
prasanna
2006-09-22 02:48:40.0
No sir,

While connecting to the remote machine i have the database in the remote machine and tomcat in the local machine.
Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
HXTT Support
2006-09-22 02:51:19.0
>While connecting to the remote machine i have the database in the remote
> machine and tomcat in the local machine.
What's your JDBC url on JSP or servlet of Tomcat to visit remote AccessServer?
Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
prasanna
2006-09-22 02:59:20.0
I think im very unfortunate i tried that also but it is working when i run with

appletviewer ,but not working with tomcat..Should i need to place any xml files in

tomcat ..

Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
prasanna
2006-09-22 03:07:13.0
Im using applet to connect to the database.

The url which i have specified inside the init() method is

These are the url i have tried

jdbc:access://local-machine-ip:8029/C:/database-name.mdb?password=password

jdbc:access:///C:/database-name.mdb?password=password

jdbc:access://local-machine-ip:80/C:/database-name.mdb?password=password when im runnin access server in this url, i use the above url

I tried every url which i placed in url info of the access server gui

but nothing is working....Please give me a solution

Thank u
Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
HXTT Support
2006-09-22 03:19:02.0
>Im using applet to connect to the database.
Applet has security limitation. Whether you are downloading that applet from your server, or used appletviewer to run your applet?
Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
prasanna
2006-09-22 03:26:18.0
The client machines can access the applets from the server.I set a policy file.

The applets are downloaded from the server.

When i run appletviewer with

working directory:appletviewer -J-Djava.security.policy=policy webpage.hmtl

The applets are connected to the database and working fine.

I also tried jdbc:access:/D:/prasanna/project1/passwordverification/databasename.mdb this url

and when i click the html page im able to connect to the databse it is working

fine,but not in tomcat.
Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
HXTT Support
2006-09-22 03:40:02.0
Now you can use appletviewer to run that applet to visit remote data without error, but you can't download and run applet from tomcat web server to visit remote data at the same time? It seems to be a security issue.
Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
prasanna
2006-09-22 03:47:08.0

I also tried with tomcat to view the database which is present in the local

machine where the tomcat server is running (both database and tomcat are on the

same machine)it is also not working?Why?(But running in appletviewer)

Please suggest a solution?So it is definitely not possible in applets?

Thank u
Prasanna.B
Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
prasanna
2006-09-22 04:16:45.0
OKay if we use servelts what type of url we have to specify both in Access

Server and in java program.

Please help me,thank u for your reply so far,
Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
HXTT Support
2006-09-22 04:23:58.0
It should be a security limitation issue. Your applet failed to visit other port except that 80 of tomcat, and you can catch that exception of DriverManger.getConnection(...), and print that exception message in your applet to make sure it.
Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
HXTT Support
2006-09-22 04:26:52.0
If you wish to skip that security limitation, you can sign your applet.

>if we use servelts what type of url we have to specify both in Access
>Server and in java program.
Same url.

Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
prasanna
2006-09-22 04:34:37.0
Sir i get the applet downloaded in other client machine,the web page and applets

are visible but not connecting to the database.Thats what the problem.Anyway

applets are insecure we have to move to servlets.Let u please expalin how to

specify the url in case of servlets and what kind of xml files we have to place in

META-INF(Context.xml) for connecting to database using access server .Then if u

don't mind will u please explain what is database pooling and how can we connect

to the database without using pooling

Thank u
Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
prasanna
2006-09-22 05:16:55.0
Thanks for HXTTSUPPORT for your quick response and guidance

Thank u,
Prasanna.B
Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
HXTT Support
2006-09-22 06:43:08.0
>what kind of xml files we have to place in META-INF(Context.xml) for
> connecting to database using access server.
>Then if u don't mind will u please explain what is database pooling and
> how can we connect to the database without using pooling
You can write similar JDBC url and code like your application:) You needn't to use context.xml or connection pool. You can find a simple testServlet.java sample in Excel demo package. In fact, you can seperate all JDBC code into other class.
Re:Re:Re:Re:Re:Re:Re:Re:Problem running in tomcat
HXTT Support
2006-09-22 06:44:14.0
If your application has many web pages, you can use jsp to replace servlet. All development is similar to Java application, except for html syntax.

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