aspose file tools*
The moose likes JNLP and Web Start and the fly likes cannot access database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JNLP and Web Start
Bookmark "cannot access database" Watch "cannot access database" New topic
Author

cannot access database

Tolu Ajayi
Greenhorn

Joined: Feb 26, 2013
Posts: 11
I developed a swing application and hosted it using apache tomcat. Every thing works fine on my system but on deployment to other client system, I can not access the ms access database I used.
Nam Ha Minh
Ranch Hand

Joined: Oct 31, 2011
Posts: 498

tolu ajayi wrote:I developed a swing application and hosted it using apache tomcat. Every thing works fine on my system but on deployment to other client system, I can not access the ms access database I used.


Hmm, this is the first time I heard "Swing app hosted on Tomcat". I am guessing you are running a Java applet (Swing GUI) in a web page (running on Tomcat), or do you mean Spring application?
Are you missing the important things like what have you tried to do, what are the errors?


PM Me If You Want to get Urgent Help on Java Programming
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42929
    
  68
How are you accessing the DB? Post the DB URL. Most likely the DB file is not accessible from the client computers - Access is not a network DB, after all.
Tolu Ajayi
Greenhorn

Joined: Feb 26, 2013
Posts: 11
Nam Ha Minh wrote:
tolu ajayi wrote:I developed a swing application and hosted it using apache tomcat. Every thing works fine on my system but on deployment to other client system, I can not access the ms access database I used.


Hmm, this is the first time I heard "Swing app hosted on Tomcat". I am guessing you are running a Java applet (Swing GUI) in a web page (running on Tomcat), or do you mean Spring application?
Are you missing the important things like what have you tried to do, what are the errors?


It is actually a swing app, i hosted it with jnlp, anyway I figured out I could not connect to client systems using msaccess so I have changed to MySQL
Tolu Ajayi
Greenhorn

Joined: Feb 26, 2013
Posts: 11
Ulf Dittmer wrote:How are you accessing the DB? Post the DB URL. Most likely the DB file is not accessible from the client computers - Access is not a network DB, after all.



Thankyou, I actually figured the database has to be on a server and msaccess does not have that capability, so I have changed to MySQL
Almalyn caguioa
Greenhorn

Joined: Feb 01, 2013
Posts: 8
Access is a database tool for gathering and understanding all your information—your phone numbers, inventory, guest lists, whatever you’re tracking—and providing a convenient way to enter, navigate, and report out your data.

When you need do Access?
..When you want to keep track of not only who’s on your guest list, but where they’re staying, and any dietary needs.
..When you need to be able to collect contact information accurately from large groups.
..When you want a database that is easy for colleagues to explore your information without training.
..When you need to run the same report daily, weekly, or monthly.
..When you want to know who your most valuable customers are so you can target your marketing.
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3611
    
  60

That's true of any database, Almalyn. Furthermore, Access is certainly not the best database to use with Java, there is a number of better, free alternatives around.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: cannot access database