aspose file tools*
The moose likes JDBC and the fly likes Creating a database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Creating a database" Watch "Creating a database" New topic
Author

Creating a database

chandana kotamraju
Greenhorn

Joined: Jun 14, 2001
Posts: 6
I am new to Java.My Question is I want to create a database instead of querrying a database. What I want to do is I have a list of create statements in a text file Is there anyway by which I can connect to database server and execute these create table statements in my text file.
Example
Database.txt is my file and I have
create table entity {
char Name[3];
int SSN[10];
}
create table ChildEntity {
char childname[4];
}
as the content of txt file
chandana kotamraju
Greenhorn

Joined: Jun 14, 2001
Posts: 6
I am still waiting for Java Database Guru's to help me.Thanks in advance any suggestion is wellcome including books or sites to refer.I need a start.
[This message has been edited by chandana kotamraju (edited July 15, 2001).]
rani bedi
Ranch Hand

Joined: Feb 06, 2001
Posts: 358
Assuming that your DDL statements are in correct syntax.
You will have to read the database text file and parse it into strings which represent indivual SQL statements.
Store them into an array of Strings.

Now establish a database connection in your program.
[CODE]
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc dbc armeet", "sa", "");
Statement stmt = con.createStatement();
for(int i =0; i<=tableStatements.length; i++)
{
stmt.executeUpdate(s[i]);
}
[CODE]


Cheers,<br />Rani<br />SCJP, SCWCD, SCBCD
wael chatila
Greenhorn

Joined: Jul 14, 2001
Posts: 8
The easiest thing to do is if your database support batch mode operations.
With MySQL, for example (which is free for download) u can simple write this at the prompt:
mysql -h yourhost -u userid -p < your.txt.file
Enter password; ****
If you need to do this directly from ur java app, the easiest you solution is to spawn a new shell with the this argument:
mysql -h yourhost -u userid -pYoUrPaSsWoRd < your.txt.file
Salam
chandana kotamraju
Greenhorn

Joined: Jun 14, 2001
Posts: 6
I appreciate for trying to help me.I will work on this and inform new developments or any interesting problems.Thank you once again.
Chandanakrishna
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Creating a database
 
Similar Threads
Dynamic table using struts
Migration data to Oracle (Urgent
connectivity with my sql without connecting to existing database
Reading text in a table from word document
How to read the DESede encrypted value using a Java Program