Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

import using jdbc

 
suresh charan
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

The project I'm currently working on is a java application, which has the requirement of importing data from source schema to destination schema including ddl.We are not supposed to make use of import and export utilities provided by oracle.Is it possible to achieve this one through jdbc?or do i need to make use of database links. To solve this problem,how should i approach?
[ February 01, 2007: Message edited by: suresh charan ]
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes you can do this with JDBC. You'll need to use the methods supplied through java.sql.DatabaseMetaData to find out about the database you are exporting from. Be careful to check your chosen driver supports the methods you want to use though.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic