对象名无效!

对象名无效! [已结贴,结贴人:wangju466511977]

wangju466511977
梦想
等级:
可用分等级：短工
总技术分：0
总技术分排名：313963
揭贴率：89.47%

发表于：2008-08-21 10:42:41 楼主

使用struts+spring+hibernate时,出现下面的问题:
org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not fetch initial value; bad SQL grammar [select max(id) from tb_forumSend]; nested exception is java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 'tb_forumSend' 无效。

其中TbForumSend.hbm.xml文件中的内容如下:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
<class name="vo.TbForumSend" table="tb_forumSend" schema="dbo"
catalog="message">
<id name="id" type="java.lang.Integer">
<column name="id" />
<generator class="increment" />
</id>
<property name="sort" type="java.lang.String">
<column name="sort" length="50" />
</property>
<property name="title" type="java.lang.String">
<column name="title" length="50" />
</property>
<property name="content" type="java.lang.String">
<column name="content" />
</property>
<property name="account" type="java.lang.String">
<column name="account" length="50" />
</property>
<property name="ip" type="java.lang.String">
<column name="ip" length="50" />
</property>
<property name="creatime" type="java.lang.String">
<column name="creatime" length="50" />
</property>
</class>
</hibernate-mapping>

applicationContext.xml文件的部分代码如下:
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver </value>
</property>
<property name="url">
<value>jdbc:microsoft:sqlserver://localhost:1433 </value>
</property>
<property name="username">
<value>admin </value>
</property>
<property name="password">
<value>admin </value>
</property>
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
</prop>
<prop key="hibernate.show_sql">true </prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>vo/TbForumUser.hbm.xml </value>
<value>vo/TbForumBack.hbm.xml </value>
<value>vo/TbForumSend.hbm.xml </value>
</list>
</property>
</bean>

问题点数：40 回复次数：6 修改删除举报引用回复