aspose file tools*
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
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
 
Don't get me started about those stupid light bulbs.
 
subject: jdbc driver and 64 bit oracle