• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

JDBC DB-Converter

 
Ranch Hand
Posts: 286
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I 'm not a db champion...
but https://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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Saloon Keeper
Posts: 27764
196
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
reply
    Bookmark Topic Watch Topic
  • New Topic