This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes JDBC DB-Converter Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC DB-Converter" Watch "JDBC DB-Converter" New topic
Author

JDBC DB-Converter

Arno Reper
Ranch Hand

Joined: Mar 14, 2006
Posts: 286
Hello,
for school i have to make a database converter wich is : your give one db and my programm has to extract the metadata and the data, and insert all that stuff into a new db. Like going from db(mysql) to db(interbase) ...
here is my little problem...
i got this :

the thing im sure is : root has acces to the db and the server...
here is my code :
i test my prog with a mysql db...only the metadata extraction should work ( never test it...yet...)
thx for your help,
arno

[ November 27, 2006: Message edited by: Arno Reper ]

The man who makes no mistakes does not usually make anything<br /> <br />>>> SCJP 5.0 >> SCJD B&S <<< In progress
Arno Reper
Ranch Hand

Joined: Mar 14, 2006
Posts: 286
I 'm not a db champion...
but http://www.coderanch.com/t/304878/JDBC/java/MySQL-Access-denied-mysqldump
do you think it would help?
doesn't root have full right?
ps: its not my linux-root ;-)
its the mysql root...

[ November 27, 2006: Message edited by: Arno Reper ]
Arno Reper
Ranch Hand

Joined: Mar 14, 2006
Posts: 286
ok...its solved...damn it, it had nothing to do with the way i connect to the db...the pwd wasn't ok lool

i have another question : i have to extract the procedures and triggers does anybody know a way to do that?
thanks
arno
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 15951
    
  19

You can tell I'm scarred. The first thing I though when I saw that message was "I bet that's a mysql database!".
:p


Customer surveys are for companies who didn't pay proper attention to begin with.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC DB-Converter
 
Similar Threads
How to find the column names..???
dynamically loading a class file from a jar file
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
table list
jdbc