This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes JDBC and the fly likes How do I bundle my Database Information in a stand alone Appl Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How do I bundle my Database Information in a stand alone Appl" Watch "How do I bundle my Database Information in a stand alone Appl" New topic
Author

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

Paul Okeke
Ranch Hand

Joined: May 16, 2009
Posts: 58
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)



OCJP 1.6
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41634
    
  55
Sounds like a perfect application for an embedded JDBC database like HSQLDB or Apache Derby.


Ping & DNS - my free Android networking tools app
Paul Okeke
Ranch Hand

Joined: May 16, 2009
Posts: 58
Yes brother!

Do you know the forward?
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41634
    
  55
What is a "forward" in the context of databases?
Paul Okeke
Ranch Hand

Joined: May 16, 2009
Posts: 58
Brother am serious please if you know the solution just me.

Thanks in advance............
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41634
    
  55
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

Joined: May 16, 2009
Posts: 58
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
Marshal

Joined: Mar 22, 2005
Posts: 41634
    
  55
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

Joined: May 16, 2009
Posts: 58
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

Joined: May 16, 2009
Posts: 58

SORRY FOR THE ENGLISH.

Thanks Brother!

That is a good advice.
It is upto me now, carry on with the search.
I appreciate all.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How do I bundle my Database Information in a stand alone Appl