This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes jdbc driver and 64 bit oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbc driver and 64 bit oracle" Watch "jdbc driver and 64 bit oracle" New topic
Author

jdbc driver and 64 bit oracle

pendse anagha
Ranch Hand

Joined: Mar 09, 2005
Posts: 44
Hello ,
Today - we tried to migrate our application from a 32 bit Oracle 8i environment
to a 64bit Oracle 9i environment .

Whiel going through the application - we encountered a strange problem
where we invoke a stored procedure - and the stored procedure is supposed to return us a cursor handle which we use to loop through data in java .

What is observed is that on executing the stored procedure through java ( old jdbc driver that was supporting 8i ) the results were kind of screwed up

Executing the stored procedure stand alone from a prompt works fine .
The same code and driver when pointing to 8i 32 bit environment
gave us correct results

I am not good at this - but wanted to know - would the driver play a part ?
Would the driver need to be able to support the 64 bit environment ?
Is there a limitation to the way SQL is built in 91 as compared to 8i which could be causing this problem ?

( we are using a driver which is in a jar file - classes12.jar )

Thanks in advance ,
-anagha
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: jdbc driver and 64 bit oracle
 
Similar Threads
Queries related to JDBC
Which driver to use
which JDBC driver to use
Pass parameter Collection to PL
passing 2D arrays to Oracle Stored Procedure with/without using JPublisher