[Question] Java - Standalone App & SQL

dlofnep · 12-10-2009, 17:39

Could someone point me in the right direction for an SQL database that can be used as part of and integrated as part of the application, without any dependancy on an external database for JAVA? I need to use a database, or at least - it would be beneficial to use one as part of my 4th year project. I have previous experience with SQL, so it would be useful to find a self contained SQL database to use as part of an application.

Any help would be greatly appreciated. I've not working with Java & DB's as of yet.

kenbrady · 12-10-2009, 17:45

Quote:

Originally Posted by dlofnep

Could someone point me in the right direction for an SQL database that can be used as part of and integrated as part of the application, without any dependancy on an external database for JAVA? I need to use a database, or at least - it would be beneficial to use one as part of my 4th year project. I have previous experience with SQL, so it would be useful to find a self contained SQL database to use as part of an application.

Any help would be greatly appreciated. I've not working with Java & DB's as of yet.

You're in 4th year, that question sound like someone who has never studied computers. There is no logic or any understanding of database or computer applications work.

dlofnep · 12-10-2009, 18:03

Quote:

Originally Posted by kenbrady

You're in 4th year, that question sound like someone who has never studied computers. There is no logic or any understanding of database or computer applications work.

Thank you Ken Brady for your wonderful contribution to this forum.

It just so happens that I've found what I'm looking for in Apache Derby, without any help from your good self.

It would appear that you are the one who has never studied "computers".

Quote:

Derby provides an embedded JDBC driver that lets you embed Derby in any Java-based solution.

Good day.

kenbrady · 13-10-2009, 07:18

Quote:

Originally Posted by dlofnep

Thank you Ken Brady for your wonderful contribution to this forum.

It just so happens that I've found what I'm looking for in Apache Derby, without any help from your good self.

It would appear that you are the one who has never studied "computers".

Good day.

When you finish your project and hopefully learn something, reread your question and you will see my point.

Will you be using the latest JDK6 to make this project or an older version of java.

**Hobbes** · 13-10-2009, 08:30

Actually his question made perfect sense. He meant that he didn't have to install some ODBC or third party app to have a database he can use in Java (eg. DB2 or MS Access would not be suitable).

Another one you can try is HSQLDB. It is all in one jar file. It has file and live mode. (used by Open Office).

http://hsqldb.org/

dlofnep · 13-10-2009, 10:51

Thank you Hobbes.

Ken, take your condescending comments elsewhere. This forum is for people to ask for help, not for people to talk down to others for asking questions. My question was perfectly valid.

warrenaldo · 13-10-2009, 10:56

Made perfect sense to me too. Dont see your problem.

How about SQLite - i use it for this type of thing all the time.

It stores all the data in a sqlite file. Allows you to run sql on it also.

Very neat. It has its pitfalls but can be very usefull.

http://www.sqlite.org/

kenbrady · 13-10-2009, 11:12

Quote:

Originally Posted by dlofnep

Thank you Hobbes.

Ken, take your condescending comments elsewhere. This forum is for people to ask for help, not for people to talk down to others for asking questions. My question was perfectly valid.

Maybe in your head, but your communication of your needs was poor. The replies will only be as good as the questions.

Before you went looking for what you wanted, did you read the Java documentation ?

**Hobbes** · 13-10-2009, 13:45

Quote:

Originally Posted by kenbrady

Before you went looking for what you wanted, did you read the Java documentation ?

I'm curious. What is that supposed to accomplish?

[edit] Ah I see Java6 has an out of the box Database. Which is based on Apache Derby. You know you could of just told him that instead of berating him.

dlofnep · 13-10-2009, 15:18

Quote:

Originally Posted by kenbrady

Maybe in your head, but your communication of your needs was poor. The replies will only be as good as the questions.

But yet everyone else understood me, except you? Your attitude smacks of elitism to be honest. It would have taken you less effort to just answer my question, than to try and berate me for asking a question. That's what these forums are for.

dlofnep · 13-10-2009, 15:19

Quote:

Originally Posted by Hobbes

[edit] Ah I see Java6 has an out of the box Database. Which is based on Apache Derby. You know you could of just told him that instead of berating him.

Thank you Hobbes, I wasn't aware of it - as like I had said, I've yet to work with a database with Java as of yet. You've been very helpful.

Thanks to everyone else for answering.

Webmonkey · 13-10-2009, 15:28

For the record I thoguht it made perfect sense as well wanting no external component (ie database server etc) as a dependency. Waits for a thanks

12-10-2009, 17:39	#1
dlofnep Hosted Moderator Join Date: Jan 2004 Location: Éire Posts: 11,895 Adverts \| Friends HMod: RaN	Java - Standalone App & SQL Could someone point me in the right direction for an SQL database that can be used as part of and integrated as part of the application, without any dependancy on an external database for JAVA? I need to use a database, or at least - it would be beneficial to use one as part of my 4th year project. I have previous experience with SQL, so it would be useful to find a self contained SQL database to use as part of an application. Any help would be greatly appreciated. I've not working with Java & DB's as of yet. __________________ Private Message for Access for RaN (Irish Republican Discussion)

13-10-2009, 08:30	#5
Hobbes Moderator Join Date: Feb 1998 Location: Dublin Posts: 19,749 Adverts \| Friends Mod: Islam, Korean	Actually his question made perfect sense. He meant that he didn't have to install some ODBC or third party app to have a database he can use in Java (eg. DB2 or MS Access would not be suitable). Another one you can try is HSQLDB. It is all in one jar file. It has file and live mode. (used by Open Office). http://hsqldb.org/ __________________ New Boards.ie Firefox3 plugin!. Faster and more functionality.

13-10-2009, 10:51	#6
dlofnep Hosted Moderator Join Date: Jan 2004 Location: Éire Posts: 11,895 Adverts \| Friends HMod: RaN	Thank you Hobbes. Ken, take your condescending comments elsewhere. This forum is for people to ask for help, not for people to talk down to others for asking questions. My question was perfectly valid. __________________ Private Message for Access for RaN (Irish Republican Discussion)

13-10-2009, 15:28	#12
Webmonkey Registered User Join Date: Mar 2003 Location: Cork City Mainly Posts: 6,250 Adverts \| Friends	For the record I thoguht it made perfect sense as well wanting no external component (ie database server etc) as a dependency. Waits for a thanks __________________ ...

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

13-10-2009, 10:56	#7
warrenaldo Registered User Join Date: Jan 2007 Location: tallaght Posts: 420 Adverts \| Friends	Made perfect sense to me too. Dont see your problem. How about SQLite - i use it for this type of thing all the time. It stores all the data in a sqlite file. Allows you to run sql on it also. Very neat. It has its pitfalls but can be very usefull. http://www.sqlite.org/