Re: JDBC THIN driver10g query issue

From: Christophe Bonte <chrbonte_at_hotmail.com>
Date: Tue, 18 Jan 2005 14:37:44 +0100
Message-ID: <41ed11b4$0$17416$4d4efb8e@news.be.uu.net>

Hello

It's true. I can see more useful information now :). Here below the beginning part of the stacktrace.

java.sql.SQLException: Numeric Overflow

        at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)

        at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)

        at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)

        at
oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:6797)

        at
oracle.jdbc.driver.NumberCommonAccessor.getLong(NumberCommonAccessor.java:499)

        at
oracle.jdbc.driver.OracleResultSetImpl.getLong(OracleResultSetImpl.java:521)

        at
oracle.jdbc.driver.OracleResultSet.getLong(OracleResultSet.java:1617)

        at be.mips.cyberlab.util.ResultSetEx.getDate(ResultSetEx.java:117)
        at 

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

It looks like it happens with a query where i select a field that contains a date. When fetching the records the error seems to occur with with the getLong method of the resultset object. To avoid confusion, this column I'm talking about has the LONG datatype, not date. It contains a number (= milliseconds after January 1, 1970, 0:00:00 GMT). Those are rather big numbers (for example 1009797793000, 1009530557171, ...).

What could possibly be wrong? I'll google some more in the meantime. Thanks in advance.

Christophe

"Joe Weinstein" <joeNOSPAM_at_bea.com> wrote in message news:41EBF5A1.1000506_at_bea.com...
>
>
> Christophe Bonte wrote:
>
>> 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.
> ...
>> be.mips.cyberlab.exception.MipsDBSelectException: Observation.java :
>> java.sql.SQLException Numeric Overflow
>> at
>> be.mips.cyberlab.business.Observation.findByPatient(Observation.java:743)
>
> Hi. The trouble is that the code in Observation.java is catching the
> original Numeric Overflow error and creating a SQLException to throw.
> Can you look at that code? Can you print out the full original stacktrace
> of the Numeric Overflow exception?
>
> Joe Weinstein at BEA
>
>> 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 Tue Jan 18 2005 - 07:37:44 CST