Hi All,
I am facing some problem with JDBC Thin Drivers
Environment
Solaris
Oracle 7.3
JDBC 7.3 Thin Driver
Java Sevlets
When my query lenth exceeds certain limit or if use large number
of to_char, nvl funcitons in may query then when I do
statement.executeQuery it gives following exception
I tried running the same query in SqlPlus it runs fine. Also the
moment i make my query lenght short by removing some of the
columns in the select clause if works fine. Any pointers related to this
problem or any workarounds is welcome.
Exception
**************************************************************
**************************************************************
java.lang.ArrayIndexOutOfBoundsException: 960
at oracle.jdbc.oracore.JavaConversion.UTF8toChar(Compiled Code)
at oracle.jdbc.ttc7.Odscrarr.decodeColName(Compiled Code)
at oracle.jdbc.ttc7.Odscrarr.decodeAllColumnNames(Compiled Code)
at oracle.jdbc.ttc7.Odscrarr.receive(Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.describe(Compiled Code)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.j
ava:509)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement
.java:982)
at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java
:1143)
> at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleSta
tement.java:1178)
> at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.j
ava:194)
> at common.dbconnect.DbConnect.executeQuery(Compiled
Code)
> at MOSSPR_DataExtraction.printCustomer(Compiled Code)
> at
MOSSPR_DataExtraction.main(MOSSPR_DataExtraction.java:80)
**************************************************************
**************************************************************
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
