aspose file tools*
The moose likes JDBC and the fly likes import using jdbc Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "import using jdbc" Watch "import using jdbc" New topic
Author

import using jdbc

suresh charan
Greenhorn

Joined: Jun 15, 2006
Posts: 8
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

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