glassfish
  1. glassfish
  2. GLASSFISH-414

MSSQL Database : AVG of a column mapped to INTEGER fails

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Incomplete
    • Affects Version/s: 9.0pe
    • Fix Version/s: 9.0pe
    • Component/s: entity-persistence
    • Labels:
      None
    • Environment:

      Operating System: Windows XP
      Platform: PC

    • Issuezilla Id:
      414

      Description

      >
      > I tried the query from the command line and it works.
      >
      > SELECT INTEGERDATA from DATATYPES
      >
      > INTEGERDATA
      > 2147483647
      > 0
      >
      > SELECT AVG(INTEGERDATA) from DATATYPES
      >
      > INTEGERDATA
      > 1073741823
      >
      > Thanks,
      > Sailaja
      >
      >
      >
      > Mitesh Meswani wrote:
      >
      >> Thats strange. One last thing. Could you try running the query from command
      line. From the stack, it is obvious that it has to be a driver bug.
      >>
      >> at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError
      (Unknown Source)
      >> at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
      >> at com.microsoft.sqlserver.jdbc.SQLServerStatement.buildNextRowset
      (Unknown Source)
      >> at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown
      Source)
      >> at com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(Unknown
      Source)
      >> at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteQuery
      (Unknown Source)
      >> at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery
      (Unknown Source)
      >> at
      oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect
      (DatabaseAccessor.java:711)
      >>
      >> Thanks,
      >> Mitesh
      >>
      >> Sailaja Rao wrote:
      >>
      >>> Hi Mitesh,
      >>>
      >>> I have tried the same test with mssql 2005 and I still see the same
      exception. Attaching the server.log for a complete trace.
      >>>
      >>> [#|2006-03-15T10:36:00.812-0800|WARNING|sun-appserver-
      pe9.0|oracle.toplink.essentials.file:/C:/Sun/AppServer/domains/domain1/applicati
      ons/j2ee-apps/ejb-cmp-datatypesApp/entity.jar-
      manager|_ThreadID=16;_ThreadName=p: thread-pool-1; w: 3;_RequestID=1572cc07-
      0219-4691-89cc-bcb946f136f6;|
      >>> Local Exception Stack:
      >>>
      >>> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 10g release 4
      (10.1.4.0.0) (Build 060309Dev)):
      oracle.toplink.essentials.exceptions.DatabaseException
      >>> Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException:
      Arithmetic overflow error converting expression to data type int.Error Code:
      8115
      >>> Call:SELECT AVG(INTEGERDATA) FROM DATATYPES
      >>> Query:ReportQuery(ejb30.persistence.datatypes.ejb.DataTypes)
      >>> at oracle.toplink.essentials.exceptions.DatabaseException.sqlException
      (DatabaseException.java:303)
      >>>
      >>>
      >>> Thanks,
      >>> Sailaja
      >>>
      >>> Mitesh Meswani wrote:
      >>>
      >>>> JDBC_DRIVER=/home/mm110999/cmp/sqlserverdriver/sqljdbc.jar
      >>>> DBURL=jdbc:sqlserver://129.145.133.184;iterativeBatching=true
      >>>> DBUSER=sa
      >>>> DBPASSWD=sapassword
      >>>> DBDRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver
      >>>>
      >>>> Sailaja Rao wrote:
      >>>>
      >>>>> What should be the dburl when using mssql 2005 ?
      >>>>>
      >>>>> Mitesh Meswani wrote:
      >>>>>
      >>>>>> /home/mm110999/cmp/sqlserverdriver/sqljdbc.jar
      >>>>>>
      >>>>>> Sailaja Rao wrote:
      >>>>>>
      >>>>>>> Can you send me a pointer to the mssql2005 driver. I cant seem to find
      it in our workspace.
      >>>>>>>
      >>>>>>> thanks,
      >>>>>>> -sailaja
      >>>>>>>
      >>>>>>>
      >>>>>>> Mitesh Meswani wrote:
      >>>>>>>
      >>>>>>>> You should be able to use the one for MSSQL 2005 against MSSQL 2000.
      The aim is to isolate the issue
      >>>>>>>>
      >>>>>>>> Thanks,
      >>>>>>>> Mitesh
      >>>>>>>>
      >>>>>>>> Sailaja Rao wrote:
      >>>>>>>>
      >>>>>>>>> Hi Mitesh,
      >>>>>>>>>
      >>>>>>>>> As far as I aware there is no native mssql driver for MSSQL 2000 :-\
      >>>>>>>>>
      >>>>>>>>> -Sailaja
      >>>>>>>>>
      >>> ------------------------------------------------------------------------
      >>>
      >>>
      >>> [#|2006-03-15T10:35:59.531-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : a
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.546-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.546-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : a
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.546-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.562-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : a
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.562-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.578-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : a
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.578-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.609-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : a
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.609-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.609-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : a
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.609-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.609-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : a
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.609-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.656-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.656-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.656-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.656-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.671-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.671-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.687-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.687-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.718-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : c
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.718-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.718-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : c
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.718-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.718-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : c
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.718-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.718-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : c
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.718-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.734-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.734-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.750-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.750-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.750-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:35:59.750-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.250-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.250-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.250-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.250-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.250-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.250-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.312-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.312-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.312-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.312-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.312-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.312-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.359-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.359-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.359-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.359-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.359-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.359-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.406-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.406-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.406-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.406-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.406-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.406-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.453-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.453-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.453-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.453-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.453-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.453-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.484-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.484-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.484-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.500-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.500-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.500-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.531-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : a
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.531-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.531-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : a
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.531-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.531-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : a
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.531-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.578-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.578-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.578-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.578-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.578-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.578-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.625-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.625-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.625-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.625-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.625-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.625-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.671-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : a
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.671-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.671-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : a
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.671-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.671-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.671-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.671-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.671-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.671-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : c
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.671-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.671-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : c
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.671-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.687-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.687-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.687-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : a
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.687-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.687-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : c
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.687-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.812-0800|WARNING|sun-appserver-
      pe9.0|oracle.toplink.essentials.file:/C:/Sun/AppServer/domains/domain1/applicati
      ons/j2ee-apps/ejb-cmp-datatypesApp/entity.jar-
      manager|_ThreadID=16;_ThreadName=p: thread-pool-1; w: 3;_RequestID=1572cc07-
      0219-4691-89cc-bcb946f136f6;|
      >>> Local Exception Stack: Exception [TOPLINK-4002] (Oracle TopLink Essentials -
      10g release 4 (10.1.4.0.0) (Build 060309Dev)):
      oracle.toplink.essentials.exceptions.DatabaseException
      >>> Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException:
      Arithmetic overflow error converting expression to data type int.Error Code:
      8115
      >>> Call:SELECT AVG(INTEGERDATA) FROM DATATYPES
      >>> Query:ReportQuery(ejb30.persistence.datatypes.ejb.DataTypes)
      >>> at oracle.toplink.essentials.exceptions.DatabaseException.sqlException
      (DatabaseException.java:303)
      >>> at
      oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteC
      all(DatabaseAccessor.java:551)
      >>> at
      oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
      (DatabaseAccessor.java:437)
      >>> at
      oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.executeCall
      (UnitOfWorkImpl.java:1339)
      >>> at
      oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.e
      xecuteCall(DatasourceCallQueryMechanism.java:213)
      >>> at
      oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.e
      xecuteCall(DatasourceCallQueryMechanism.java:199)
      >>> at
      oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.e
      xecuteSelectCall(DatasourceCallQueryMechanism.java:270)
      >>> at
      oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.s
      electAllRows(DatasourceCallQueryMechanism.java:600)
      >>> at
      oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selec
      tAllRowsFromTable(ExpressionQueryMechanism.java:2074)
      >>> at
      oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selec
      tAllReportQueryRows(ExpressionQueryMechanism.java:2040)
      >>> at
      oracle.toplink.essentials.queryframework.ReportQuery.executeDatabaseQuery
      (ReportQuery.java:721)
      >>> at oracle.toplink.essentials.queryframework.DatabaseQuery.execute
      (DatabaseQuery.java:609)
      >>> at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute
      (ObjectLevelReadQuery.java:690)
      >>> at
      oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWor
      k(ObjectLevelReadQuery.java:744)
      >>> at
      oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery
      (UnitOfWorkImpl.java:2194)
      >>> at
      oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery
      (AbstractSession.java:937)
      >>> at
      oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery
      (AbstractSession.java:909)
      >>> at
      oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeReadQuery
      (EJBQueryImpl.java:344)
      >>> at
      oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getSingleResult
      (EJBQueryImpl.java:451)
      >>> at ejb30.persistence.datatypes.ejb.DataTypesSessionBean.getAvgofInteger
      (DataTypesSessionBean.java:56)
      >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      >>> at sun.reflect.NativeMethodAccessorImpl.invoke
      (NativeMethodAccessorImpl.java:39)
      >>> at sun.reflect.DelegatingMethodAccessorImpl.invoke
      (DelegatingMethodAccessorImpl.java:25)
      >>> at java.lang.reflect.Method.invoke(Method.java:585)
      >>> at com.sun.enterprise.security.application.EJBSecurityManager.runMethod
      (EJBSecurityManager.java:1026)
      >>> at com.sun.enterprise.security.SecurityUtil.invoke
      (SecurityUtil.java:165)
      >>> at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod
      (BaseContainer.java:2766)
      >>> at com.sun.ejb.containers.BaseContainer.intercept
      (BaseContainer.java:3847)
      >>> at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke
      (EJBObjectInvocationHandler.java:190)
      >>> at com.sun.ejb.containers.EJBObjectInvocationHandlerDelegate.invoke
      (EJBObjectInvocationHandlerDelegate.java:110)
      >>> at $Proxy35.getAvgofInteger(Unknown Source)
      >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      >>> at sun.reflect.NativeMethodAccessorImpl.invoke
      (NativeMethodAccessorImpl.java:39)
      >>> at sun.reflect.DelegatingMethodAccessorImpl.invoke
      (DelegatingMethodAccessorImpl.java:25)
      >>> at java.lang.reflect.Method.invoke(Method.java:585)
      >>> at com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(Unknown
      Source)
      >>> at
      com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServan
      t(Unknown Source)
      >>> at
      com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch
      (Unknown Source)
      >>> at
      com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest
      (Unknown Source)
      >>> at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest
      (Unknown Source)
      >>> at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput
      (Unknown Source)
      >>> at
      com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback
      (Unknown Source)
      >>> at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest
      (Unknown Source)
      >>> at
      com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.dispatch(Unknown
      Source)
      >>> at com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.doWork
      (Unknown Source)
      >>> at
      com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run
      (Unknown Source)
      >>> Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Arithmetic
      overflow error converting expression to data type int.
      >>> at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError
      (Unknown Source)
      >>> at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
      >>> at com.microsoft.sqlserver.jdbc.SQLServerStatement.buildNextRowset
      (Unknown Source)
      >>> at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult
      (Unknown Source)
      >>> at com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(Unknown
      Source)
      >>> at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteQuery
      (Unknown Source)
      >>> at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery
      (Unknown Source)
      >>> at
      oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect
      (DatabaseAccessor.java:711)
      >>> at
      oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteC
      all(DatabaseAccessor.java:486)
      >>> ... 44 more
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.828-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.container.ejb|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;DataTypesSessionBean;|EJB5018: An exception was thrown during an
      ejb invocation on [DataTypesSessionBean]|#]
      >>>
      >>> [#|2006-03-15T10:36:00.828-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.container.ejb|_ThreadID=16;_ThreadName=p: thread-
      pool-1; w: 3;|
      >>> javax.ejb.EJBException
      >>> at com.sun.ejb.containers.BaseContainer.processSystemException
      (BaseContainer.java:3730)
      >>> at com.sun.ejb.containers.BaseContainer.completeNewTx
      (BaseContainer.java:3630)
      >>> at com.sun.ejb.containers.BaseContainer.postInvokeTx
      (BaseContainer.java:3431)
      >>> at com.sun.ejb.containers.BaseContainer.postInvoke
      (BaseContainer.java:1247)
      >>> at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke
      (EJBObjectInvocationHandler.java:197)
      >>> at com.sun.ejb.containers.EJBObjectInvocationHandlerDelegate.invoke
      (EJBObjectInvocationHandlerDelegate.java:110)
      >>> at $Proxy35.getAvgofInteger(Unknown Source)
      >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      >>> at sun.reflect.NativeMethodAccessorImpl.invoke
      (NativeMethodAccessorImpl.java:39)
      >>> at sun.reflect.DelegatingMethodAccessorImpl.invoke
      (DelegatingMethodAccessorImpl.java:25)
      >>> at java.lang.reflect.Method.invoke(Method.java:585)
      >>> at com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(Unknown
      Source)
      >>> at
      com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServan
      t(Unknown Source)
      >>> at
      com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch
      (Unknown Source)
      >>> at
      com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest
      (Unknown Source)
      >>> at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest
      (Unknown Source)
      >>> at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput
      (Unknown Source)
      >>> at
      com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback
      (Unknown Source)
      >>> at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest
      (Unknown Source)
      >>> at
      com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.dispatch(Unknown
      Source)
      >>> at com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.doWork
      (Unknown Source)
      >>> at
      com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run
      (Unknown Source)
      >>> Caused by: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 10g
      release 4 (10.1.4.0.0) (Build 060309Dev)):
      oracle.toplink.essentials.exceptions.DatabaseException
      >>> Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException:
      Arithmetic overflow error converting expression to data type int.Error Code:
      8115
      >>> Call:SELECT AVG(INTEGERDATA) FROM DATATYPES
      >>> Query:ReportQuery(ejb30.persistence.datatypes.ejb.DataTypes)
      >>> at oracle.toplink.essentials.exceptions.DatabaseException.sqlException
      (DatabaseException.java:303)
      >>> at
      oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteC
      all(DatabaseAccessor.java:551)
      >>> at
      oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
      (DatabaseAccessor.java:437)
      >>> at
      oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.executeCall
      (UnitOfWorkImpl.java:1339)
      >>> at
      oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.e
      xecuteCall(DatasourceCallQueryMechanism.java:213)
      >>> at
      oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.e
      xecuteCall(DatasourceCallQueryMechanism.java:199)
      >>> at
      oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.e
      xecuteSelectCall(DatasourceCallQueryMechanism.java:270)
      >>> at
      oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.s
      electAllRows(DatasourceCallQueryMechanism.java:600)
      >>> at
      oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selec
      tAllRowsFromTable(ExpressionQueryMechanism.java:2074)
      >>> at
      oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selec
      tAllReportQueryRows(ExpressionQueryMechanism.java:2040)
      >>> at
      oracle.toplink.essentials.queryframework.ReportQuery.executeDatabaseQuery
      (ReportQuery.java:721)
      >>> at oracle.toplink.essentials.queryframework.DatabaseQuery.execute
      (DatabaseQuery.java:609)
      >>> at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute
      (ObjectLevelReadQuery.java:690)
      >>> at
      oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWor
      k(ObjectLevelReadQuery.java:744)
      >>> at
      oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery
      (UnitOfWorkImpl.java:2194)
      >>> at
      oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery
      (AbstractSession.java:937)
      >>> at
      oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery
      (AbstractSession.java:909)
      >>> at
      oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeReadQuery
      (EJBQueryImpl.java:344)
      >>> at
      oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getSingleResult
      (EJBQueryImpl.java:451)
      >>> at ejb30.persistence.datatypes.ejb.DataTypesSessionBean.getAvgofInteger
      (DataTypesSessionBean.java:56)
      >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      >>> at sun.reflect.NativeMethodAccessorImpl.invoke
      (NativeMethodAccessorImpl.java:39)
      >>> at sun.reflect.DelegatingMethodAccessorImpl.invoke
      (DelegatingMethodAccessorImpl.java:25)
      >>> at java.lang.reflect.Method.invoke(Method.java:585)
      >>> at com.sun.enterprise.security.application.EJBSecurityManager.runMethod
      (EJBSecurityManager.java:1026)
      >>> at com.sun.enterprise.security.SecurityUtil.invoke
      (SecurityUtil.java:165)
      >>> at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod
      (BaseContainer.java:2766)
      >>> at com.sun.ejb.containers.BaseContainer.intercept
      (BaseContainer.java:3847)
      >>> at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke
      (EJBObjectInvocationHandler.java:190)
      >>> ... 17 more
      >>> Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Arithmetic
      overflow error converting expression to data type int.
      >>> at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError
      (Unknown Source)
      >>> at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
      >>> at com.microsoft.sqlserver.jdbc.SQLServerStatement.buildNextRowset
      (Unknown Source)
      >>> at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult
      (Unknown Source)
      >>> at com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(Unknown
      Source)
      >>> at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteQuery
      (Unknown Source)
      >>> at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery
      (Unknown Source)
      >>> at
      oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect
      (DatabaseAccessor.java:711)
      >>> at
      oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteC
      all(DatabaseAccessor.java:486)
      >>> ... 44 more
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.937-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.937-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.937-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.937-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.937-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|Got characterData as : b
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:00.937-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.stream.out|_ThreadID=15;_ThreadName=p: thread-
      pool-1; w: 2;|returning from the method...
      >>> |#]
      >>>
      >>> [#|2006-03-15T10:36:28.562-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.tools.deployment|_ThreadID=13;_ThreadName=httpWork
      erThread-4848-1;|Java Web Start services ended for application:
      com.sun.enterprise.appclient.jws.ApplicationContentOrigin@98ab04 registration
      name=ejb-cmp-datatypesApp
      >>> com.sun.enterprise.appclient.jws.NestedAppclientContentOrigin@1039f33
      registration name=ejb-cmp-datatypesApp, context root=/ejb-cmp-datatypesApp/ejb-
      cmp-datatypes-client, module name=
      >>> , parent=ejb-cmp-datatypesApp|#]
      >>>
      >>> [#|2006-03-15T10:36:28.703-0800|INFO|sun-appserver-
      pe9.0|oracle.toplink.essentials.file:/C:/Sun/AppServer/domains/domain1/applicati
      ons/j2ee-apps/ejb-cmp-datatypesApp/entity.jar-
      manager|_ThreadID=13;_ThreadName=httpWorkerThread-4848-
      1;file:/C:/Sun/AppServer/domains/domain1/applications/j2ee-apps/ejb-cmp-
      datatypesApp/entity.jar-manager;|logout_successful|#]
      >>>
      >>> [#|2006-03-15T10:36:28.718-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.core|_ThreadID=13;_ThreadName=httpWorkerThread-
      4848-1;ejb-cmp-datatypesApp;|CORE5022: All ejb(s) of [ejb-cmp-datatypesApp]
      were unloaded successfully!|#]
      >>>
      >>> [#|2006-03-15T10:36:33.375-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.tools.admin|_ThreadID=13;_ThreadName=httpWorkerThr
      ead-4848-1;ResourceDeployEvent – reference-removed
      null/jdbc/datatype1;|ADM1041:Sent the event to instance:[ResourceDeployEvent –
      reference-removed null/jdbc/datatype1]|#]
      >>>
      >>> [#|2006-03-15T10:36:33.437-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.core|_ThreadID=13;_ThreadName=httpWorkerThread-
      4848-1;jdbc:jdbc/datatype1;|CORE5006: Resource UnDeployed:
      [jdbc:jdbc/datatype1].|#]
      >>>
      >>> [#|2006-03-15T10:36:36.187-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.tools.admin|_ThreadID=13;_ThreadName=httpWorkerThr
      ead-4848-1;ResourceDeployEvent – reference-removed
      null/jdbc/datatype2;|ADM1041:Sent the event to instance:[ResourceDeployEvent –
      reference-removed null/jdbc/datatype2]|#]
      >>>
      >>> [#|2006-03-15T10:36:36.218-0800|INFO|sun-appserver-
      pe9.0|javax.enterprise.system.core|_ThreadID=13;_ThreadName=httpWorkerThread-
      4848-1;jdbc:jdbc/datatype2;|CORE5006: Resource UnDeployed:
      [jdbc:jdbc/datatype2].|#]

        Activity

        Hide
        marina vatkina added a comment -

        It can be closed if it's a driver bug. A doc bug can be opened instead.

        Show
        marina vatkina added a comment - It can be closed if it's a driver bug. A doc bug can be opened instead.
        Hide
        sailajar added a comment -

        ****
        This is not a driver bug. I tried the test with Datadirect and Native driver
        and it is throwing the same error trace. I tried it from the sql prompt and the
        data is returned correctly. The bug description has all the details.

        Thanks,
        Sailaja

        Show
        sailajar added a comment - **** This is not a driver bug. I tried the test with Datadirect and Native driver and it is throwing the same error trace. I tried it from the sql prompt and the data is returned correctly. The bug description has all the details. Thanks, Sailaja
        Hide
        Mitesh Meswani added a comment -

        reassigning it to markus for more investigation

        Show
        Mitesh Meswani added a comment - reassigning it to markus for more investigation
        Hide
        mf125085 added a comment -

        Created an attachment (id=169)
        JDBC test reproducing the problem; this is a database issue

        Show
        mf125085 added a comment - Created an attachment (id=169) JDBC test reproducing the problem; this is a database issue
        Hide
        mf125085 added a comment -

        This is a database issue. Due to the input data, AVG(INTEGERDATA) produces an
        arithmetic overflow, please see attachment avg_overflow_test.zip.

        Show
        mf125085 added a comment - This is a database issue. Due to the input data, AVG(INTEGERDATA) produces an arithmetic overflow, please see attachment avg_overflow_test.zip.

          People

          • Assignee:
            mf125085
            Reporter:
            sailajar
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: