Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

cannot access database

 
Tolu Ajayi
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 502
Eclipse IDE Firefox Browser Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic