Pls i am working on java database application(Mysql), i need the steps on how to attached the database with
the application , when am deploying it. Thanks.

read this up and get the basic knowledge you need to get started

http://download.oracle.com/javase/tutorial/jdbc/index.html

YOu probably talking about an embedded database. I think you can find some info in the link above. However, the way it works is,

- you develop your application
- you download and install a database driver, most people use the jdbc
- you use an embedded database(obviously you gotta create it first), most people tend to use derby as an embedded database
- connect to it and use it the way you want to

Have a look at this topic --> https://www.nairaland.com/nigeria/topic-737287.0.html

thanks for your comments, am not using neither derby nor any other embedded database,
but i want to able to install the setup on another PC with out installing the DB separately

Am confused!

what am saying is that, i develop an application that connects with mysql as its database, so am trying to deploy, so that installing the application on another system and it will still interact with the DB tables, so am looking for a way to detach the table and deploy it with the application, i have a crook way of doing it,, but i guess its not professional that it why i created this thread

And thats exactly what i explained. If you have a remote database that has remote access, say online and you want the database to be online then fine. You would still need the driver anyways. However, you have to use derby! Thers no 2 ways, you need an embedded database! Go do some little exercises with derby and then when you are good enough with it, you implement in into your application.

How does your application connect to the database currently? sounds like you already have the driver!

@oyewale what you need is an embedded database it cant be far from that, so far you want the database to be installed along with the application.

I think this is what the guy needs: Connector/MXJ


"MySQL Connector/MXJ is a Java utility package for deploying and managing a MySQL database. Connector/MXJ may be bundled with an existing Java application as a "plain old Java object" (POJO), as a Connector/J socket factory, or as a JMX MBean.

Deploying and using MySQL from Connector/MXJ can be as easy as adding an additional parameter to the JDBC connection url, which will result in the database being started when the first connection is made. This makes it easy for Java developers to deploy applications which require a database by reducing installation barriers for their end-users.

MySQL Connector/MXJ makes the MySQL database appear to be a java-based component. It does this by determining what platform the system is running on, selecting the appropriate binary, and launching the executable. It will also optionally deploy an initial database, with any specified parameters"


this is the download link

http://www.mysql.com/downloads/connector/mxj/

this is a short tutorial on how to embed mysql into java app

http://www.jroller.com/mmatthews/entry/yes_it_really_is_this

hope it helps