• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Tim Cooke
  • Devaka Cooray
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Rob Spoor
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
  • Mikalai Zaikin
Bartenders:
  • Carey Brown
  • Roland Mueller

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

 
Ranch Hand
Posts: 58
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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)

 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yes brother!

Do you know the forward?
 
Ulf Dittmer
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is a "forward" in the context of databases?
 
Paul Okeke
Ranch Hand
Posts: 58
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Brother am serious please if you know the solution just me.

Thanks in advance............
 
Ulf Dittmer
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Men call me Jim. Women look past me to this tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/wiki/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic