How to create database through java program.??

[me.anchit]

hello everyone,

I have made an application in swing which uses MySQL database. Now I want that whenever my app is made to run on a new system for the first time, the app asks for the ip and port number of mysql from the user and creates the database and its tables automatically. Besides I have created a user in mysql, so it must create it accordingly. This should happen only for the first time.

How can it be done through java...????

[masijade]

By using a db user that has those rights and using sql commands.

[me.anchit]

ok, I got it....
thank you.
but can anyone tell me the logic that how the program is going to know that it is running for the first time on a system...???
Regards

[Tolls]

Check if any of the tables exist?

[RichersooN]

You have several options, one is using the standard JDBC connection(non-hibernate) and the using Hibernate.

[mitra]

Hi everybody......

I have same problem, but I want to create MS Access 2007 (.accdb) database. When my application will run for the first time, the database should be create with some tables.


I have tried by following code, it created .accdb database, but when I tried to open the database it shows unknown access format.

FileOutputStream file = new FileOutputStream("databasename.accdb");

How can I do it?

Thank you.

[Tolls]

Unless Access provides you with an interface in Java to create a database then you won't be able to do it.
Either that or you'll have to rely in there being an existing access database you can add tables to.

Which reminds me, is there a proper JDBC driver for Access?
If you are using the JDBC-ODBC bridge then that's another big problem.

[mitra]

Unless Access provides you with an interface in Java to create a database then you won't be able to do it.
Either that or you'll have to rely in there being an existing access database you can add tables to.

Which reminds me, is there a proper JDBC driver for Access?
If you are using the JDBC-ODBC bridge then that's another big problem.

Thank you for your reply.

I don't know, but is there any interface of access for database creation?

And except JDBC-ODBC bridge how can I connect with database using java?
Please give me a sample code.

[Tolls]

I only know of the bridge for access. I don't use Access, so can't say if there's a "proper" driver.

As for creating the db file via Java, you'll have to do some hunting, but I very much doubt you'll find anything that does it.

Why not use something like Derby instead? A proper Embedded database (presuming it's not for multiple users).

[mitra]

ok
Thanks for help