File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How do I bundle my Database Information in a stand alone Appl

 
Paul Okeke
Ranch Hand
Posts: 58
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Guys, your help is needed.

I developed a Java SE Application that talks to a database tables in my computer
(precisely mysql) and I have it in a jar file called MyAppl.jar. MyAppl.jar is working
perfectly well in my private computer which I used in the development.

But my problem now is that when I take the MyAppl.jar to a diferent Computer
it still works but can not access the database again unless I install and create the
same database in the that other computer.

This is logical.
But I knew that it is still possible to bundle these tables in my database in the MyAppl.jar.

I will appricate your guide on how to achieve this in java (ie to have the database information available in MyAppl.jar)

 
Ulf Dittmer
Rancher
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sounds like a perfect application for an embedded JDBC database like HSQLDB or Apache Derby.
 
Paul Okeke
Ranch Hand
Posts: 58
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes brother!

Do you know the forward?
 
Ulf Dittmer
Rancher
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is a "forward" in the context of databases?
 
Paul Okeke
Ranch Hand
Posts: 58
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Brother am serious please if you know the solution just me.

Thanks in advance............
 
Ulf Dittmer
Rancher
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You'll need to be more explicit ... the solution to what? Are you familiar with embedded databases? Have you read up on the two I mentioned? Do you have concerns using them?
 
Paul Okeke
Ranch Hand
Posts: 58
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ulf Dittmer wrote:You'll need to be more explicit ... the solution to what? Are you familiar with embedded databases? Have you read up on the two I mentioned? Do you have concerns using them?


Am sorry for that, I did'nt understand you for the first time.

Please can you please give any useful link on where I can get topic on this (Embedded database)?
 
Ulf Dittmer
Rancher
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm sure there's a Wikipedia page on that. After that, check out the HSQLDB and Derby documentation about their respective embedded capabilities; that should provide you with enough information to get started. Embedded mode is just another way of running a Java DB - you'll still be using JDBC to work with it.
 
Paul Okeke
Ranch Hand
Posts: 58
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ulf Dittmer wrote:I'm sure there's a Wikipedia page on that. After that, check out the HSQLDB and Derby documentation about their respective embedded capabilities; that should provide you with enough information to get started. Embedded mode is just another way of running a Java DB - you'll still be using JDBC to work with it.



Thank Brother!

That is a good.
It is upto me now carry on with the seach.
I appreciate all.
 
Paul Okeke
Ranch Hand
Posts: 58
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

SORRY FOR THE ENGLISH.

Thanks Brother!

That is a good advice.
It is upto me now, carry on with the search.
I appreciate all.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic