[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 168
  • Last Modified:

Mysql installation with Java application

Hi,

I have java application which uses mysql as backend.

How can I deploy mysql with the java application if its not installed on the client envirnoment.

I mean how do i create a setup that includes mysql with my application and installs both on the system.

Thanks & Regards,
Karunakar
0
gowni
Asked:
gowni
1 Solution
 
CEHJCommented:
You need to use an installer. You'd be better to use a java-based db that doesn't need installing, such as Derby or HSQL
0
 
borislavmarkovCommented:
You can use MYSQL with no installer :)
Just pack the files of mysql and read options to start from command line with no service.
Proceed like follows:
pack mysqlfiles in zip, then use your installer to unpack to mysql. If your mysql is 4.0/5.0 you have to place an init file and this file to configure your installation folder. like follows:
==== my.ini ====
...
basedir="E:/path .../MySQL/"
....
==============
if your mysql is 4.0/3.x it's even easy, just copy paste.
Then unpack a bat that you previously created which looks like follows:

=====mysqlstartup.bat======
mysqld-nt --standalone --character-set-server=utf8 --init-file=E:/path.../my.ini
======================

You have to make all this in your installer.
0
 
Mayank SAssociate Director - Product EngineeringCommented:
>> You'd be better to use a java-based db that doesn't need installing, such as Derby or HSQL

Generally, if the client has agreed to MySql, its not easy to change the DB just like that :)

>> How can I deploy mysql with the java application if its not installed on the client envirnoment.

What do you use to install your application as of now? IzPack or Web-start or something of the sort?
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now