Deploying Java Desktop application with database (MySQL, ORACLE, other...)

[IndioDoido]

I'm going to developed a java application that will use a database which will be running in a local windows computer.
I want to make this installation program distributable so that any user who does not know anything about java or data bases should be able to run it in his system with just a click. The user should not be forced to install a database or configure it. The only thing the user has to have is the java environment.

Is there a way to do it?

[Eranga]

First of all, please don't post the same question multiple times on the forum. Choose the best sub-forum and post your question more clearly.

Regarding your question, all what you need to do is packaging your application. JAR is the standard packaging in Java application. Read the following tutorial on Suns' official web site.

Lesson: Packaging Programs in JAR Files (The Java™ Tutorials > Deployment)

[IndioDoido]

sorry about that...i really didn't know where to post my question :(

about your reply, i didn't find anything related with databases :confused:

i use netBeans to develop my applications, and my issue is how to distribute my application in a way that the user doesn't need to install and setup, for example, a mysql server to use my app.

[logicbug]

You will have to do this with a "flat file database" like Microsoft Access, etc... If you only need to read from it you can put it in your jar file, if not it will have to be a seperate file.

[IndioDoido]

i need to read/insert/delete data.
i just don't want my client to install 3rd party software to use my app, like for example mysql server.

is this possible?

[Eranga]

i need to read/insert/delete data.
i just don't want my client to install 3rd party software to use my app, like for example mysql server.

is this possible?

Think that if you are using MS Access as the DB, you need to install the office package in the system. If you are using the SQL, need to SQL database in your system.

In general almost all PCs installed with MS Office package. If you are using MS Access as the DB, much easier.

[einarb]

i need to read/insert/delete data.
i just don't want my client to install 3rd party software to use my app, like for example mysql server.

is this possible?

Take a look at hsqldb, i belive it should cover your needs. Just embedd it in your jar.

[Talljeezzy]

Hello, its nice to see that this place could be quite helpful. I'm new to java and i have a similar problem. My app was designed with netbeans & using "apache derby" database. When i ran the app with Netbeans, INSERT, RETRIEVE & UPDATE worked fine on the DB from within the IDE, but when i built the ".jar" file (still with netbeans), and ran it using ... java -j myAppName.jar... at my windows command interface, everything including my GUI still worked fine except that INSERT, RETRIEVE & UPDATE where not working outside the IDE. Please who knows what might be causing it, does it have anything to do with the database connection? (am confused, cos it works from within the IDE).........What do i need to do for it to work in desktop environment outside the Netbeans IDE???????

[doWhile]

Hello, its nice to see that this place could be quite helpful. I'm new to java and i have a similar problem. My app was designed with netbeans & using "apache derby" database. When i ran the app with Netbeans, INSERT, RETRIEVE & UPDATE worked fine on the DB from within the IDE, but when i built the ".jar" file (still with netbeans), and ran it using ... java -j myAppName.jar... at my windows command interface, everything including my GUI still worked fine except that INSERT, RETRIEVE & UPDATE where not working outside the IDE. Please who knows what might be causing it, does it have anything to do with the database connection? (am confused, cos it works from within the IDE).........What do i need to do for it to work in desktop environment outside the Netbeans IDE???????

First, don't resurrect threads that are over 2 years old. Second, I recommend you read How to ask questions. Lastly, add the driver to your classpath

[navanathdivate]

hi,
i have same problem , can u tell me how can i do this task.

Thanks & Regards,
Navanath.