This week's book giveaway is in the OCAJP forum.
We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line!
See this thread for details.
Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC DB-Converter

 
Arno Reper
Ranch Hand
Posts: 286
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Arno Reper
Ranch Hand
Posts: 286
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 286
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 18272
56
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic