Win a copy of Node.js Design Patterns: Design and implement production-grade Node.js applications using proven patterns and techniques this week in the Server-Side JavaScript and NodeJS 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

Refcursor value is invalid, Bigger type length than Maximum, Protocol violation

 
Ranch Hand
Posts: 850
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello,

My code is throwing the following errors:


I am trying to call the "trNewsView()" method from main class as under:


My method code of DAO class:


I checked each and every line of my method and found that rs=ps.executeQuery(); is throwing the aforementioned errors. Stuck with it for the last 3-4 hours. Please help me

Best regards
 
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

It seems the Driver issue, Which Oracle Driver you are using to get Connction?
 
Farakh khan
Ranch Hand
Posts: 850
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Mahendra Suda wrote:Hi,

It seems the Driver issue, Which Oracle Driver you are using to get Connction?



Mahendra Suda wrote:Hi,

It seems the Driver issue, Which Oracle Driver you are using to get Connction?



I am using jdbcracle:thin driver.

My database is Oracle 11.2.0.1.0. with character set UTF-8 and my OS is windows7

As per your advice I have downloaded new driver(s) from Oracle http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html. I have downloaded ojdbc6.jar, ojdbc6_g.jar, ojdbc6dms_g.jar, ojdbc6dms.jar and placed these files into C:\Program Files (x86)\Java\apache-tomcat-6.0.18\lib but still facing the same problem.

Is that right place where these jars should reside?


Mahendra Suda wrote:Hi,

It seems the Driver issue, Which Oracle Driver you are using to get Connction?



Mahendra Suda wrote:

Hi again,


java -cp .;c:\Oracle\dbhome_1\jdbc\lib\ojdbc6.jar Test
Oracle JDBC driver loaded ok.

java -cp .;"c:\Program Files (x86)\Java\apache-tomcat-6.0.18\lib\ojdbc6.jar" Test
Oracle JDBC driver loaded ok.


The driver seems okay what could else be the case?

Best regards

 
Mahendra Suda
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Ok, It seems you are using the correct Driver type, but still i can say it is the Driver issue.

Could you please mentioned which version of DB and Driver type you are using,

Before this you put the latest oracle jar file in your application's lib directory also and deploy.

 
Farakh khan
Ranch Hand
Posts: 850
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Could you please mentioned which version of DB and Driver type you are using,


I am using Oracle 11.2.0.1.0 and driver type is thin

Before this you put the latest oracle jar file in your application's lib directory also and deploy.



I placed all news downloaded files in my .../tomcat/lib folder. Another thing I am thinking that I installed oracle with UTF-8 characterset not by using default that could be the cause?

Best regards
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic