Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: JDBC THIN driver10g query issue

Re: JDBC THIN driver10g query issue

From: Christophe Bonte <chrbonte_at_hotmail.com>
Date: Mon, 17 Jan 2005 10:49:54 +0100
Message-ID: <41eb8acb$0$17414$4d4efb8e@news.be.uu.net> 





"Joe Weinstein" <joeNOSPAM_at_bea.com> wrote in message 
news:41E7FB16.5090801_at_bea.com...


>

>

> Christophe Bonte wrote:

>

>> Hello all

>>

>> I've ran into something I really don't understand and I can't find much 

>> information about it. We have a web application that uses an Oracle 

>> database. First of all, when I use the OCI driver to connect everything 

>> works perfectly.

>>

>> However, I've got one issue with the 10g JDBC THIN driver. This doesn't 

>> occur on my 8i and 9i installations with the THIN driver. The problem is, 

>> at some point, in our application, I get 'numeric overflow' error 

>> messages.

>>

>> java.sql.SQLException Numeric Overflow

>>

>> We use JRE 1.4.1. This error occurs with a rather big select statement. 

>> In the select I try to fetch mutiple columns + 2 CLOB columns.  Doesn 

>> anybody know what could be the cause? Anybody with similar experiences?

>>

>> Thanks in advance

>>

>> Christophe

>

> Hi. If you'll show us the full stacktrace of the SQLException it would 

> help

> us debug it.

> Joe Weinstein at BEA

>




Hello



Here's the stacktrace below. I don't really know where to look fore more 
information though: Tomcat forums, Oracle forums? Information that I find 
about 'numeric overflow' is very vague. I only have this when I use the THIN 
driver. Everything works just fine with OCI.



I use Tomcat 4.1, tried JRE 1.4.2. Still the same thing.



Hope someone can help out. Thanks in advance.



2005-01-17 10:45:29 ** - ** - **  SELECT OBS_ID, OBS_ORDER, OBS_TEST, 

OBS_STATUS, OBS_VALUECLOB, OBS_VALUECHAR, OBS_DEPA

RTMENT, OBS_VALIDATIONUSER,  OBS_UNIT, OBS_RANGE, OBS_FLAG, 

OBS_OUTBOUNDCOMMENTCHAR, OBS_OUTBOUNDCOMMENTCLOB, OBS_SAMPLE

COLLECTIONTIME,OBS_DISCRIMINATOR, OBS_LASTREPORTTIME, 

OBS_SPECIMENSOURCEDESCRIPTION, OBS_SPECIMENSOURCEVARIABLES,  TEST_

VISIBILITYLEVEL



FROM OBSERVATION,  "ORDER",  TEST



WHERE OBS_ORDER = ORD_ID



AND ORD_ID IN (16313,13279,13296,13297)



AND OBS_TEST = TEST_ID



ORDER BY ORD_SAMPLECOLLECTIONTIME DESC, ORD_ID DESC, TEST_ID, 

OBS_SAMPLECOLLECTIONTIME ASC



Elapsed time for query: 0 ms


be.mips.cyberlab.exception.MipsDBSelectException: Observation.java : 
java.sql.SQLException Numeric Overflow


        at 


be.mips.cyberlab.business.Observation.findByPatient(Observation.java:743)


        at 


be.mips.cyberlab.web.resultconsultation.ObservationContainer.loadObservations(ObservationContainer.java:93)


        at 


be.mips.cyberlab.web.resultconsultation.Manager.executeCommand(Manager.java:213)


        at 


be.mips.cyberlab.web.FrontDoor.getHtmlForServlet(FrontDoor.java:115)

        at be.mips.cyberlab.web.AServlet.doGet(AServlet.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
        at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at 
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
        at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at 
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
        at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at 
org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:458)
        at 
org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:551)
        at java.lang.Thread.run(Thread.java:536)
be.mips.cyberlab.exception.MipsException: 


be.mips.cyberlab.web.resultconsultation.Manager : 
be.mips.cyberlab.exception.M


ipsDBSelectException Observation.java : java.sql.SQLException Numeric 
Overflow


        at 


be.mips.cyberlab.web.resultconsultation.Manager.executeCommand(Manager.java:302)


        at 


be.mips.cyberlab.web.FrontDoor.getHtmlForServlet(FrontDoor.java:115)

        at be.mips.cyberlab.web.AServlet.doGet(AServlet.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
        at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at 
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
        at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at 
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
        at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at 
org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:458)
        at 
org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:551)
        at java.lang.Thread.run(Thread.java:536) 


Received on Mon Jan 17 2005 - 03:49:54 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US