oracle 的sql语句问题
大家好,本人最近用SSH2+oracle10做一个项目,但是遇到了一个问题,就是在实现登录的时候myeclipse报了一个错sql语句命令没有结束的错误java.sql.SQLException: ORA-00933: SQL command not properly ended
我的后台登录代码是:
DetachedCriteria dc=DetachedCriteria.forClass(LoginUser.class).add(Expression.eq("cuser", name.trim())).add(Expression.eq("cpwd",pwd.trim()));
ArrayList<LoginUser> loginUserList=(ArrayList<LoginUser>) this.getHibernateTemplate().findByCriteria(dc);
后台打印出来的sql语句是select loginuser0_.ALERT_CUser as ALERT1_53_, loginuser0_.ALERT_number as ALERT2_53_, loginuser0_.ALERT_CName as ALERT3_53_, loginuser0_.ALERT_CPwd as ALERT4_53_, loginuser0_.ALERT_CType as ALERT5_53_, loginuser0_.ALERT_CState as ALERT6_53_, loginuser0_.ALERT_CFlag as ALERT7_53_ from cserver.SYSTEM.LoginUsers loginuser0_ where CUser='sdfs' and CPwd='sdfs';
我的hibernate映射文件是:
<hibernate-mapping package="com.adsserver.entity">
<class name="LoginUser" table="LoginUsers" schema="SYSTEM" catalog="cserver">
<id name="cuser" type="java.lang.String">
<column name="ALERT_CUser" length="50" not-null="false"/>
<generator class="assigned"></generator>
</id>
<property name="number" type="java.lang.String">
<column name="ALERT_number" length="20" not-null="false" />
</property>
<property name="cname" type="java.lang.String">
<column name="ALERT_CName" length="50" not-null="true" />
</property>
<property name="cpwd" type="java.lang.String">
<column name="ALERT_CPwd" length="50" not-null="true" />
</property>
<property name="ctype" type="java.lang.String">
<column name="ALERT_CType" length="50" not-null="true" />
</property>
<property name="cstate" type="java.lang.Short">
<column name="ALERT_CState" not-null="true" />
</property>
<property name="cflag" type="java.lang.Short">
<column name="ALERT_CFlag" not-null="true" />
</property>
</class>
</hibernate-mapping>
hibernate配置文件:
<hibernate-configuration>
<session-factory>
<property name="connection.url">
jdbc:oracle:thin:@localhost:1521:cserver
</property>
<property name="connection.username">SYSTEM</property>
<property name="connection.password">allan</property>
<property name="connection.driver_class">
oracle.jdbc.driver.OracleDriver
</property>
<property name="dialect">
org.hibernate.dialect.Oracle9Dialect
</property>
请大家帮帮忙哈,小弟不胜感激..