Win a copy of TDD for a Shopping Website LiveProject this week in the Testing forum!
  • 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
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
Bartenders:
  • Piet Souris
  • Himai Minh

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: 25463
180
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
 
The moth suit and wings road is much more exciting than taxes. Or this tiny ad:
free, earth-friendly heat - a kickstarter for putting coin in your pocket while saving the earth
https://coderanch.com/t/751654/free-earth-friendly-heat-kickstarter
reply
    Bookmark Topic Watch Topic
  • New Topic