我在解决该反常的方式是:1.依据提醒肯定展现问题的数据类别.(过滤无须要的检验,削减耗费在该问题上的工夫淘宝商城:。看懂反常是
org.hibernate.type.nullabletype nullsafeget could not read column value from result set: contrib23_35_; 无法转换为内部表示
我在解决该反常的方式是:
1.依据提醒肯定展现问题的数据类别.(过滤无须要的检验,削减耗费在该问题上的工夫淘宝商城:。看懂反常是主要问题).
2.核查数据库字段类别与pojo类的字段数据类别是否相称.
3.检验数据库字段内的value.
如:你的数据库字段类别为number那么在手动照射pojo时也许你会把它写成int类别这么本身是不曾错的(在你数据库内的值不曾超出 int的长度前).然而由于数据库的字段类别为number那么在测验时或许你会手动插入一些值.而值的长度超出int所能接纳的长度。那么在过程运行时对该字段举行get时就会展现上面的差错。这是其一。
hibernate几个问题
excel单元格中的回车/换行 alt+enter
2008-2-2 9:45:13 org.hibernate.util.jdbcexceptionreporter logexceptions
严重: unknown column 'tjsaleresu0_.isupdate' in 'field list'
2008-2-2 9:45:13 org.hibernate.event.def.defaultloadeventlistener onload
信息: error performing load command
org.hibernate.exception.sqlgrammarexception: could not load an entity: [ookj.domain.tjsaleresult#293]
--数据库中没有“isupdate”字段
2008-2-2 9:51:42 org.hibernate.util.jdbcexceptionreporter logexceptions
警告: sql error: 1052, sqlstate: 23000
2008-2-2 9:51:42 org.hibernate.util.jdbcexceptionreporter logexceptions
严重: column 'df' in where clause is ambiguous
————find(select tsr from tjsaleresult tsr, tjitemresult tir where tsr=tir.saleresultid and tir=? and df1, new object[]{tir});
————语句中的df不能确定是哪个表的
org.springframework.orm.hibernate3.hibernatequeryexception: could not resolve property: trackdate of: ookj.domain.tjreagenttrack [from ookj.domain.tjreagenttrack trt where trt.trackstage=? and trt.trackdate=? and trt.userid=? and trt.df1]; nested exception is org.hibernate.queryexception: could not resolve property: trackdate of: ookj.domain.tjreagenttrack [from ookj.domain.tjreagenttrack trt where trt.trackstage=? and trt.trackdate=? and trt.userid=? and trt.df1]
caused by: org.hibernate.queryexception: could not resolve property: trackdate of: ookj.domain.tjreagenttrack [from ookj.domain.tjreagenttrack trt where trt.trackstage=? and trt.trackdate=? and trt.userid=? and trt.df1]
————问题是配置中:
private static string[][] properties={
{getreagenttrackid,reagent_trackid,0},
{getreagentid,reagentid,1},
{getuserid,userid,1},
{getguidebookid,guidebookid,1},
{gettracktime,tracktime,0}, //这里名称不对
{trackstage,trackstage,0},
{getdf,df,0}
————还有nd trt.trackdate=? 语句中的值有误。
java.lang.classcastexception: ookj.domain.ookjdatetime
————基本的 类型转换错误
string sql = from tjreagenttrack trt where trt.trackstage=? and trt.tracktime like ? and trt.userid=? and trt.df1;
list list_reagenttrack = srs.find(sql, new object[]{tjreagenttrack.trackstage_qu, %+new ookjdate(new date()).tostring()+%, su});
applicationinstance.getactive().setfocusedcomponent(textfield_register);
————echo2焦点问题
org.springframework.dao.invaliddataaccessapiusageexception: object references an unsaved transient instance - save the transient instance before flushing: ookj.domain.smdept; nested exception is org.hibernate.transientobjectexception: object references an unsaved transient instance - save the transient instance before flushing: ookj.domain.smdept
caused by: org.hibernate.transientobjectexception: object references an unsaved transient instance - save the transient instance before flushing: ookj.domain.smdept
————new了一个新对象,在未保存之前将它保存进了一个新new的对象。
问题1,quartz 1.6 配置问题。需要使用common-collection-1.3.jar
信息: could not read column value from result set: activep19_59_; could not deserialize
exception in thread main org.springframework.orm.hibernate3.hibernatesystemexception: could not deserialize; nested exception is org.hibernate.type.serializationexception: could not deserialize
caused by: org.hibernate.type.serializationexception: could not deserialize
at org.hibernate.util.serializationhelper.deserialize(serializationhelper.java:217)
at org.hibernate.util.serializationhelper.deserialize(serializationhelper.java:240)
at org.hibernate.type.serializabletype.frombytes(serializabletype.java:82)
at org.hibernate.type.serializabletype.get(serializabletype.java:39)
at org.hibernate.type.nullabletype.nullsafeget(nullabletype.java:163)
at org.hibernate.type.nullabletype.nullsafeget(nullabletype.java:154)
at org.hibernate.type.abstracttype.hydrate(abstracttype.java:81)
at org.hibernate.persister.entity.abstractentitypersister.hydrate(abstractentitypersister.java:2096)
at org.hibernate.loader.loader.loadfromresultset(loader.java:1380)
at org.hibernate.loader.loader.instancenotyetloaded(loader.java:1308)
at org.hibernate.loader.loader.getrow(loader.java:1206)
at org.hibernate.loader.loader.getrowfromresultset(loader.java:580)
at org.hibernate.loader.loader.doquery(loader.java:701)
at org.hibernate.loader.loader.doqueryandinitializenonlazycollections(loader.java:236)
at org.hibernate.loader.loader.dolist(loader.java:2220)
at org.hibernate.loader.loader.listignorequerycache(loader.java:2104)
at org.hibernate.loader.loader.list(loader.java:2099)
at org.hibernate.loader.hql.queryloader.list(queryloader.java:378)
at org.hibernate.hql.ast.querytranslatorimpl.list(querytranslatorimpl.java:338)
at org.hibernate.engine.query.hqlqueryplan.performlist(hqlqueryplan.java:172)
at org.hibernate.impl.sessionimpl.list(sessionimpl.java:1121)
at org.hibernate.impl.queryimpl.list(queryimpl.java:79)
at org.springframework.orm.hibernate3.hibernatetemplate$29.doinhibernate(hibernatetemplate.java:849)
at org.springframework.orm.hibernate3.hibernatetemplate.execute(hibernatetemplate.java:372)
at org.springframework.orm.hibernate3.hibernatetemplate.find(hibernatetemplate.java:840)
at ookj.dao.pub.impl.commondaoimpl.find(commondaoimpl.java:96)
at ookj.service.impl.basicserviceimpl.find(basicserviceimpl.java:45)
at sun.reflect.nativemethodaccessorimpl.invoke0(native method)
at sun.reflect.nativemethodaccessorimpl.invoke(unknown source)
at sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source)
at java.lang.reflect.method.invoke(unknown source)
at org.springframework.aop.support.aoputils.invokejoinpointusingreflection(aoputils.java:296)
at org.springframework.aop.framework.reflectivemethodinvocation.invokejoinpoint(reflectivemethodinvocation.java:177)
at org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:144)
at org.springframework.transaction.interceptor.transactioninterceptor.invoke(transactioninterceptor.java:107)
at org.springframework.aop.framework.reflectivemethodinvocation.proceed(reflectivemethodinvocation.java:166)
at org.springframework.aop.framework.jdkdynamicaopproxy.invoke(jdkdynamicaopproxy.java:204)
at $proxy1.find(unknown source)
at ookj.ui.barcode.barcodeperson.returnbookfromcode(barcodeperson.java:63)
at ookj.ui.barcode.barcodeperson.getfengmian(barcodeperson.java:44)
at ookj.ui.barcode.barcodeperson.main(barcodeperson.java:28)
caused by: java.io.eofexception
at java.io.objectinputstream$peekinputstream.readfully(unknown source)
at java.io.objectinputstream$blockdatainputstream.readshort(unknown source)
at java.io.objectinputstream.readstreamheader(unknown source)
at java.io.objectinputstream.(unknown source)
at org.hibernate.util.serializationhelper$customobjectinputstream.(serializationhelper.java:252)
at org.hibernate.util.serializationhelper.deserialize(serializationhelper.java:209)
... 40 more
++++++++++
============
org.hibernate.type.serializationexception could not deserialize;
我用的数据库是mysql,,在通过pojo类自动生成的类中,未为字段指定type,hibernate对自动为其指定,如果它所生成的type不能被反序列化,就会抛出java.util.servilizableexception
比如我产生异常的原因是我建立了一个string[]类型的字段,但在对应的.hbm.xml文件中我没有显式定义它的类型,hibernate自动为其指定了类型,该类型不能被反序列化。
2008-1-29 14:06:31 org.hibernate.util.jdbcexceptionreporter logexceptions
严重: invalid value for getint() - '2008-01-18 12:12:12' in column 24
2008-1-29 14:06:32 org.springframework.beans.factory.xml.xmlbeandefinitionreader loadbeandefinitions
信息: loading xml bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2008-1-29 14:06:32 org.springframework.jdbc.support.sqlerrorcodesfactory
信息: sqlerrorcodes loaded: [db2, derby, h2, hsql, informix, ms-sql, mysql, oracle, postgresql, sybase]
+++++++++
=======
expected positional parameter count: 1, actual parameters: [] [select m from tjmedicalname m, tjsaleresult s where s.guidebookid = ? and s.df1 and s.saleitemid.medicalgroup.medicalid=m.medicalid]
++++bs.find(select m from tjmedicalname m, tjsaleresult s where s.guidebookid = ? and s.df1 and s.saleitemid.medicalgroup.medicalid=m.medicalid);+++
====bs.find(select m from tjmedicalname m, tjsaleresult s where s.guidebookid = ? and s.df1 and s.saleitemid.medicalgroup.medicalid=m.medicalid, new object[]{sgb});===
严重: line 1:143: expecting ident, found '.'
2008-2-3 0:41:01 org.apache.catalina.core.standardwrappervalve invoke
严重: servlet.service() for servlet tijianservlet threw exception
org.springframework.orm.hibernate3.hibernatequeryexception: expecting ident, found '.' near line 1, column 143 [select t.saleitemid.medicalgroup from ookj.domain.tjsaleresult t where t.guidebookid=? and t.saleitemid.medicalgroup.block=? and t.saleitemid..medicalgroup.df1]; nested exception is org.hibernate.hql.ast.querysyntaxexception: expecting ident, found '.' near line 1, column 143 [select t.saleitemid.medicalgroup from ookj.domain.tjsaleresult t where t.guidebookid=? and t.saleitemid.medicalgroup.block=? and t.saleitemid..medicalgroup.df1]
caused by: org.hibernate.hql.ast.querysyntaxexception: expecting ident, found '.' near line 1, column 143 [select t.saleitemid.medicalgroup from ookj.domain.tjsaleresult t where t.guidebookid=? and t.saleitemid.medicalgroup.block=? and t.saleitemid..medicalgroup.df1]
_____多了一个点
java.net.socketexception: java.net.connectexception: connection refused: connect
————数据库未启动
严重: servlet.service() for servlet tijianservlet threw exception
java.lang.indexoutofboundsexception: remember that ordinal parameters are 1-based!
————忘了怎么解决的了,反正不是大问题。
严重: servlet.service() for servlet tijianservlet threw exception
java.lang.nosuchmethoderror: ookj.service.sendreagentservice.savetjsendreagent(lookj/domain/tjreagent;lookj/domain/saleguidebook;)[ljava/lang/string;
————tomcat\java虚拟集中代码未跟上,不能保持同步,重启虚拟机就好了。
严重: unknown column 'tjsendreag0_.tj_sendreagent' in 'field list'
org.springframework.dao.invaliddataaccessresourceusageexception: could not execute query; nested exception is org.hibernate.exception.sqlgrammarexception: could not execute query
caused by: org.hibernate.exception.sqlgrammarexception: could not execute query
caused by: com.mysql.jdbc.exceptions.mysqlsyntaxerrorexception: unknown column 'tjsendreag0_.tj_sendreagent' in 'field list'
————配置文件hbr.xml中写的tj_sendreagent字段,在数据库中找不到。
1,textfield控件textfield_maker.setenabled(false);为禁用true为可用。
2,
groupbox groupbox_gerenjihuo = new groupbox();
groupbox_gerenjihuo.setwidth(new extent(300, extent.px));
groupbox_gerenjihuo.settitle(个人预约激活);
rowlayoutdata groupbox_gerenjihuolayoutdata = new rowlayoutdata();
groupbox_gerenjihuolayoutdata.setinsets(new insets(new extent(20,
extent.px)));
groupbox_gerenjihuo.setlayoutdata(groupbox_gerenjihuolayoutdata);
row_jihuo.add(groupbox_gerenjihuo);
groupbox groupbox_tuanduijihuo = new groupbox();
groupbox_tuanduijihuo.setwidth(new extent(300, extent.px));
groupbox_tuanduijihuo.settitle(团队预约激活);
groupbox_tuanduijihuo.setinsets(new insets(new extent(20, extent.px)));
row_jihuo.add(groupbox_tuanduijihuo);
第二个是内部20的间隙。第一个没表现。