jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes import using jdbc Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "import using jdbc" Watch "import using jdbc" New topic

import using jdbc

suresh charan

Joined: Jun 15, 2006
Posts: 8

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

Joined: Apr 14, 2004
Posts: 10336

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.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link: http://aspose.com/file-tools
subject: import using jdbc
It's not a secret anymore!