search

eclipse-ee4j / glassfish

Eclipse GlassFish
https://eclipse-ee4j.github.io/glassfish/
386 stars 144 forks source link

MSSQL Database : AVG of a column mapped to INTEGER fails #414

Closed glassfishrobot closed 18 years ago

glassfishrobot commented 18 years ago

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].|#]

Environment

Operating System: Windows XP Platform: PC

Affected Versions

[9.0pe]

glassfishrobot commented 6 years ago
glassfishrobot commented 18 years ago

@glassfishrobot Commented mvatkina said: It can be closed if it's a driver bug. A doc bug can be opened instead.

glassfishrobot commented 18 years ago

@glassfishrobot Commented sailajar said:

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

glassfishrobot commented 18 years ago

@glassfishrobot Commented mm110999 said: reassigning it to markus for more investigation

glassfishrobot commented 18 years ago

@glassfishrobot Commented mf125085 said: Created an attachment (id=169) JDBC test reproducing the problem; this is a database issue

glassfishrobot commented 18 years ago

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

glassfishrobot commented 18 years ago

@glassfishrobot Commented File: avg_overflow_test.jar Attached By: mf125085

glassfishrobot commented 18 years ago

@glassfishrobot Commented Was assigned to mf125085

glassfishrobot commented 7 years ago

@glassfishrobot Commented This issue was imported from java.net JIRA GLASSFISH-414

glassfishrobot commented 18 years ago

@glassfishrobot Commented Reported by sailajar

glassfishrobot commented 18 years ago

@glassfishrobot Commented Marked as incomplete on Wednesday, March 22nd 2006, 8:41:07 am