sessionbean+hibernate+weblogic+sqlserver查询时报错

Question

对应xml文件
////////////////
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="com.mccs.persistence.Material" table="material">
<id column="mno" name="id" type="string">
<generator class="assigned"/>
</id>
<property column="mname" length="50" name="mname" type="string"/>
<property column="munit" length="10" name="munit" type="string"/>
<property column="mcatalogprice" length="8" name="mcatalogprice" type="float"/>
<property column="mguige" length="70" name="mguige" type="string"/>
<property column="msafeamount" length="8" name="msafeamount" type="float"/>
<property column="mABC" length="1" name="mabc" type="string"/>
<property column="mvolumn" length="20" name="mvolumn" type="string"/>
<property column="mweight" length="20" name="mweight" type="string"/>
<property column="mcolor" length="6" name="mcolor" type="string"/>
<property column="mstatus" length="1" name="mstatus" type="string"/>
<property column="mtype" length="1" name="mtype" type="string"/>
</class>
</hibernate-mapping>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="com.mccs.persistence.Materialtype" table="materialtype">
<id column="mtno" name="id" type="string">
<generator class="assigned"/>
</id>
<property column="mtname" length="10" name="mtname" type="string"/>
</class>
</hibernate-mapping>

Answer 1

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="com.mccs.persistence.Warehouse" table="warehouse">
<id column="wno" name="id" type="string">
<generator class="assigned"/>
</id>
<property column="wname" length="40" name="wname" type="string"/>
</class>
</hibernate-mapping>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="com.mccs.persistence.Storage" table="storage">
<id column="sno" name="id" type="string">
<generator class="uuid.hex"/>
</id>
<property column="mno" length="20" name="mno" type="string"/>
<property column="mname" length="50" name="mname" type="string"/>
<property column="splace" length="8" name="splace" type="string"/>
<property column="mguige" length="70" name="mguige" type="string"/>
<property column="mcatlogprice" length="8" name="mcatlogprice" type="float"/>
<property column="mrealprice" length="8" name="mrealprice" type="float"/>
<property column="mcount" length="8" name="mcount" type="float"/>
<property column="msymbol" length="10" name="msymbol" type="integer"/>
<property column="snumber" length="20" name="snumber" type="string"/>
</class>
</hibernate-mapping><?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="com.mccs.persistence.Mslimit" table="mslimit">
<id column="msno" name="id" type="string">
<generator class="uuid.hex"/>
</id>
<property column="mno" length="20" name="mno" type="string"/>
<property column="snumber" length="30" name="snumber" type="string"/>
<property column="splace" length="30" name="splace" type="string"/>
<property column="msupper" length="8" name="msupper" type="float"/>
<property column="mslower" length="8" name="mslower" type="float"/>
</class>
</hibernate-mapping>

Answer 2

请注意错误信息中的“Invalid column name”无效的列名。

Answer 3

看看数据库中的列和你定义的是不是一样。
把你的SQL语句先在数据库中运行一下应该看得出问题.

Answer 4

这个SQL在查询分析器里运行是没有问题的