Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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: 41124
    
  45
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.


Ping & DNS - my free Android networking tools app
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: 3606
    
  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
 
Similar Threads
Socket Permissions
connect to MS Access database file without making a dsn?
Award Travel and integrating the Frequent flier app with the main app
Applets
Jdbc driver not found when putting an application in a jar-file