This week's giveaway is in the EJB and other Java EE Technologies forum. We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line! See this thread for details.
I have only used JAVA with an Access Database (while in school). Is there a major difference on how I connect to an Oracle database? Is it just a matter of setting up the the ODBC driver on the PC for Oracle? And if so, which file do I direct it to? I am about to graduate and they have never used an Oracle database to connect to, except for when we were using Oracle Forms. Thanks, Michael
if you continue to use the same driver, the process will be the same. However, if you upgrade to a Oracle database you might want to upgrade from an odbc driver to an Oracle driver(classes12.zip) at http://technet.oracle.com/software/tech/java/sqlj_jdbc/htdocs/listing.htm the Oracle drivers are a type 4 driver(pure java) and have much more functionality than the odbc drivers. Jamie [This message has been edited by Jamie Robertson (edited August 14, 2001).]
Joined: Apr 17, 2001
Thank you, I will take a look at that link a little later. I am sure I will have more questions after that. Also, with this new driver do you have to map to a specific file? If so, which one do I use for the Oracle Database? I have only used Oracle databases within Oracle software, so I only had to log into the correct schema to use them. Thanks, Michael