mysql and swing application

Thread view:

kivanchleo@gmail.com - 21 Dec 2005 10:20 GMT

hi everyone. i working on a java swing application. i want to load
mysql program as automatic with nullsoft install program and i want the
define mysql user and password as automatic. i dont know these, how to
copying mysql database as offline file (such as ms access file .mdb
extension). This question is very important for me. Please help this
subject. Thanks for everything...

Reply to this Message

Mladen Adamovic - 21 Dec 2005 20:30 GMT

> hi everyone. i working on a java swing application. i want to load
> mysql program as automatic with nullsoft install program and i want the
> define mysql user and password as automatic. i dont know these, how to
> copying mysql database as offline file (such as ms access file .mdb
> extension).

I would consider moving to Java embedded SQL database like HSQLDB.

Signature

Mladen Adamovic
http://home.blic.net/adamm

Reply to this Message

Arto Viitanen - 22 Dec 2005 07:58 GMT

>> hi everyone. i working on a java swing application. i want to load
>> mysql program as automatic with nullsoft install program and i want the
[quoted text clipped - 3 lines]
>
> I would consider moving to Java embedded SQL database like HSQLDB.

Fine answer. We are thinking on doing the same thing (using HSQLDB
instead of MySQL, so that installation can be automated). Also think:
MySQL is a database server, which needs DBA to upgrade it, monitor its
behavior, take backups etc. If you install it automatic, does the user
of your Java program even know that there is a database installed to
his machine? HSQLDB (hsqldb.org) has limit of 2 GB (8 GB "cached")
database, so it should be big enough. And if it is not, then your
users _really_ need DBA for the MySQL !

--
Arto Viitanen
Espoo, Finland

Reply to this Message

kivanchleo (DEAD.or.GONE) - 22 Dec 2005 10:47 GMT

thanks for your answers. i will try to hsqldb for my application. good
works and thank you again...

Reply to this Message

Jon Martin Solaas - 29 Dec 2005 09:36 GMT

mysqldump will export a schema to one single sql file, with data,
table-definitions and everything. the mysql command can then be used to
import the data again into another mysql instance. This is somewhat
similart to saving an Access database into a .mdb file and have another
Access instance open it.

Signature

jon martin solaas

Reply to this Message

mysql and swing application

Free Magazines