File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "jdbc driver and 64 bit oracle" Watch "jdbc driver and 64 bit oracle" New topic

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 ,
I agree. Here's the link:
subject: jdbc driver and 64 bit oracle
It's not a secret anymore!