程序报org.apache.commons.beanutils.ConversionException:错，不知道怎么解决

0 0

程序报org.apache.commons.beanutils.ConversionException:错，不知道怎么解决5

代码：

RowSetDynaClass dyData = null;

Connection conn = null;

PreparedStatement pstmt = null;

List<DynaBean> rows = null;

String code = "select c.code as storageCode,c.label as storageName,d.code oilCode,d.name oilName,oil_tank_id,aft_stock,safe_volume,empty_volume,round(aft_stock*1000/(density-1.1)) dr_v20,total_volume,stock_num from (select a.density,a.aft_stock,a.safe_volume,a.empty_volume,a.oil_id,a.oil_tank_id,a.oil_storage_id,a.measure_date,a.total_volume,a.stock_num from Core_Stock_Tank_Measure a where lastest = 1 and status = 1) b join (select id,code,label from acc_domain where type= 2 ) c on (c.id = b.oil_storage_id) join BASE_OIL_T d on (d.id = b.oil_id)";

ResultSet rs = null;

try {

conn = SessionFactoryUtils.getDataSource(getSessionFactory()).getConnection();

Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);

rs = stmt.executeQuery(code);

// pstmt = conn.prepareStatement(code);

// rs = pstmt.executeQuery();

while (rs.next()) {

System.out.println(rs.getString("storageCode") + "-" + rs.getString("storageName") + "-"

+ rs.getString("oilCode") + "-" + rs.getString("oilName") + "-" + rs.getString("oil_tank_id")

+ "-" + rs.getString("aft_stock"));

}

rs.beforeFirst();// 这里必须使用beforeFirst

dyData = new RowSetDynaClass(rs);

rs.close();

stmt.close();

rows = dyData.getRows();

conn.close();

} catch (Exception e) {

e.printStackTrace();

System.out.println(e.getMessage());

} finally {

conn.close();

}

错误信息：

org.apache.commons.beanutils.ConversionException: Cannot assign value of type 'java.math.BigDecimal' to property 'aft_stock' of type 'java.lang.Double'

at org.apache.commons.beanutils.BasicDynaBean.set(BasicDynaBean.java:305)

at org.apache.commons.beanutils.RowSetDynaClass.copy(RowSetDynaClass.java:294)

at org.apache.commons.beanutils.RowSetDynaClass.<init>(RowSetDynaClass.java:248)

at org.apache.commons.beanutils.RowSetDynaClass.<init>(RowSetDynaClass.java:181)

at org.apache.commons.beanutils.RowSetDynaClass.<init>(RowSetDynaClass.java:105)

at com.petrochina.ykis.dao.core.StockTankMeasureDao.getDynaData(StockTankMeasureDao.java:44)

at com.petrochina.ykis.services.impl.core.StockTankMeasureManager.getDynaData(StockTankMeasureManager.java:133)

at com.petrochina.ykis.services.impl.core.StockTankMeasureManager$$FastClassByCGLIB$$da9b590a.invoke(<generated>)

at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)

at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)

at com.petrochina.ykis.services.impl.core.StockTankMeasureManager$$EnhancerByCGLIB$$c105b019.getDynaData(<generated>)

at com.petrochina.ykis.integration.client.impl.SendStorageDailyClient.getDailyMeasureList(SendStorageDailyClient.java:118)

at com.petrochina.ykis.integration.client.impl.SendStorageDailyClient.sendStorageDaily(SendStorageDailyClient.java:49)

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:597)

at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)

at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:264)

at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)

at org.quartz.core.JobRunShell.run(JobRunShell.java:216)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)

Cannot assign value of type 'java.math.BigDecimal' to property 'aft_stock' of type 'java.lang.Double'