Two Laptop Bag*
The moose likes JDBC and the fly likes Implications of shifting JSP Application database from Acess to Oracle?? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Implications of shifting JSP Application database from Acess to Oracle??" Watch "Implications of shifting JSP Application database from Acess to Oracle??" New topic
Author

Implications of shifting JSP Application database from Acess to Oracle??

Amit Roy
Ranch Hand

Joined: Oct 10, 2000
Posts: 132
hello friends
I have this entire web based Intranet Application made in JSP it has around 70 tables with almost all type of datatypes which i plan to convert to Oracle 8i what are the implications at present we are using JDBC ODBC Bridge to connect to the Accesss database what will the easiest way to migrate to Oracle 8i without having to make much changes in the application pages....
URGENT


<I>Chance Favours the Prepared minds"</I>
Bjarki Holm
Author
Ranch Hand

Joined: May 25, 2001
Posts: 65
Amit,
obviously, you will have to recreate the tables in Oracle and possibly modify your JDBC-SQL code. Although I am not an expert on MS Access, I suppose this shouldn't be any problem. MS Access is a very simple RDBMS, whilst Oracle can be very complicated, with lots of special features. If you were going the other way around, you would more likely get into trouble, as you would be scaling your application "downwards". Migrating from Access to Oracle, you will be scaling "upwards", which is usually more easy.
As for the data in your Access database, I suppose that the easiest way to migrate that to Oracle is by exporting all of the tables in a tabl-delimetered text file, and then use a product called SQL*Loader (comes with Oracle) to import the text files into Oracle tables. More information on SQL*Loader is available at http://technet.oracle.com/doc/server.815/a67792/ch03.htm#2436.
Then, when you have migrated the actual database, you would have to make sure your application is not using any Access-specific SQL syntax (OUTER JOINs, etc.). Also, make sure the application has the Oracle JDBC drivers in the runtime class path (a common mistake not to), and test if everythings works as it should.
Cheers,

------------------
Bjarki Holm
Author of Professional Java Data


Bjarki Holm
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Implications of shifting JSP Application database from Acess to Oracle??