This week's giveaway is in the JDBC forum.
We're giving away four copies of Java Database Connections & Transactions (e-book only) and have Marco Behler on-line!
See this thread for details.
Win a copy of Java Database Connections & Transactions (e-book only) this week in the JDBC 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Knute Snortum
  • Paul Clapham
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Frits Walraven
Bartenders:
  • Ganesh Patekar
  • Tim Holloway
  • salvin francis

Migrating a project from Oracle 8i to 10g  RSS feed

 
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
I have a J2EE web project which runs on WAS and has Oracle 8i as the database. Now we are considering to upgrade the DB from 8i to 10g.

I would like to know what are the steps that need to be taken care of from the front end (java code) so that the project runs similar to how it used to run with 8i.
 
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Nothing should need changed beyond the JDBC url and the version of the driver.

Not an advanced question. Moving...
[ March 02, 2007: Message edited by: Paul Sturrock ]
 
Ranch Hand
Posts: 425
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You need not be concerned about upgrade unless you are DBA. It will be DBA's responsibility to properly configure 10g but as a developer you may have to do some regression testing on load/performance. If you know bit about the DB then you can look at the 8i & 10g configuration for DB mode, SGA size, max open cursor size, max connection and stuff like that. If you are java developer then noticeable difference is the 8i JDBC driver "oracle.jdbc.driver.OracleDriver" has been deprecated, in 10g drivers so you have to use "oracle.jdbc.OracleDriver"

It's definitely worth to take a look at the Oracle JDBC FAQ
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq_0.htm
 
author
Posts: 4106
24
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Upgrading has the potential to completely break your code. That being said, there's really no way to know what will break and what won't without actual testing. What you normally do in a situation like this is perform the upgrade on a test system then perform a full set of system tests.

Its not the JDBC that is 'as likely' to fail but any stored procedurs, triggers, views, etc that your code depends on may stop functioning all together on an upgrade. I've seen upgrades from Oracle 9 to 10 that crashed JDBC code due to some dependence on a problematic function call in a stored procedure. For the most part, you just test it out on a copy of your database, figure out the issues, and if everything goes well, upgrade the real database. Last I checked Oracle lets you download developer versions of 10 for free so getting the software is easy enough.
 
What's gotten into you? Could it be this tiny ad?
how do I do my own kindle-like thing - without amazon
https://coderanch.com/t/711421/engineering/kindle-amazon
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!