Hi, could you please send me a JDBC trace (http://sapdb.2scale.net/moin.cgi/JdbcTrace) reproducing the problem to see more details.
Thanks, Marco > -----Original Message----- > From: Support [mailto:[EMAIL PROTECTED] > Sent: Montag, 9. Mai 2005 18:43 > To: [email protected] > Subject: ConversionExceptionSapDB inside CachedRowSet with Java 1.5 > > Hello! > > For the query: > SELECT count(RELVALUE_I), sum(RELVALUE_I), > sum(1000*RELVALUE_I/INTERVAL_I), min(1000*RELVALUE_I/INTERVAL_I), > max(1000*RELVALUE_I/INTERVAL_I) FROM SN_SNMP_DATA WHERE conf_id_i=1002 > AND oid_i = 1007 AND timestamp_i BETWEEN 1115643540000 AND > 1115647140000 > AND RELVALUE_I >= 0 > > With RELVALUE_I and INTERVAL_I as integers we get the following error: > > 2005-05-09 22:01:06,968 ERROR [stablenet] > net.infosim.stablenet.svc.impl.core.jdbc.JDBCSvcBean > com.sap.dbtech.jdbc.translators.ConversionExceptionSapDB: > Cannot convert > data 5035.7356857523302263648468708388814913 scale: 14 to type FIXED. > at > com.sap.dbtech.jdbc.translators.DBTechTranslator.newParseExcep > tion(DBTec > hTranslator.java:1231) > at > com.sap.dbtech.jdbc.translators.NumericTranslator.getBigDecima > l(NumericT > ranslator.java:129) > at > com.sap.dbtech.jdbc.translators.NumericTranslator.getObject(Nu > mericTrans > lator.java:256) > at > com.sap.dbtech.jdbc.ResultSetSapDB.getObject(ResultSetSapDB.java:1107) > at > org.jboss.resource.adapter.jdbc.WrappedResultSet.getObject(Wra > ppedResult > Set.java:348) > at > com.sun.rowset.CachedRowSetImpl.populate(CachedRowSetImpl.java:646) > at > net.infosim.stablenet.svc.impl.core.jdbc.JDBCSvcBean.executeSQ > LQueryLimi > t(JDBCSvcBean.java:169) > at > sun.reflect.GeneratedMethodAccessor131.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth > odAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.jboss.invocation.Invocation.performCall(Invocation.java:345) > > The result from the query are double values which we read by > resultset.getDouble(x). The query is returned to an > CachedRowSet object > of java 5. The exeception occurs already in the CachedRowset. > We tried different jdbc drivers (7.4, 7.5 and the latest 7.6 from the > website), but all with the same result. > > What are we doing wrong? > Marius > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
