MySQL : Connect locally using Java

Question

I have a MySQL database and a java application using it thru JDBC. I want to distribute the application. I copied the DB to my application folder. I also have myconnectionj jar file included in the project.

How to create the url/connectionString to connect to the database along with the application instead of using server ? I want to connect like we do for Access files. We can distribute it with the application easily and use it. How to achieve the same with MySQL DB without using server.

Access is file-based. It's easy to just point something at a file. MySQL is a full-blown client-server architecture, and can't just be bundled up into a single .mdb-type file as it is with Access. — Marc B
– Marc B, Commented Nov 24, 2011 at 17:54

Ernesto Campohermoso · Accepted Answer · 2011-11-24 17:52:00Z

1

I don't know if MySQL can provide that flexibility. But exist other Databases which enable to you store the data in a file and port it across to clients. You can ckeck the following:

Derby DB
HSQL DB
SQL Lite

answered Nov 24, 2011 at 17:52

Ernesto Campohermoso

7,4411 gold badge42 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Udo Held · Accepted Answer · 2011-11-24 17:52:52Z

0

I'm not sure if there is a mysql-wrapper for such tests. AFAIK you need a running server.

If you need portability you should check file-databases like: H2, HyperSQL or SQLLite.

answered Nov 24, 2011 at 17:52

Udo Held

12.6k11 gold badges73 silver badges94 bronze badges

Collectives™ on Stack Overflow

MySQL : Connect locally using Java

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related