CMP 2,0的问题,JBOSS建表出错?

cxj_2000 2003-08-20 12:21:57
错误如下:
23:53:39,775 INFO [MainDeployer] Deployed package: file:/D:/jboss-3.0.8_tomcat-
4.1.24/server/default/deploy/usergroup.jar
23:53:39,785 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean ope
ration 'checkIncompleteDeployments()'
Cause: Incomplete Deployment listing:
Packages waiting for a deployer:
<none>
Incompletely deployed packages:
<none>
MBeans waiting for classes:
<none>
MBeans waiting for other MBeans:
[ObjectName: jboss.j2ee:jndiName=local/RoleBean,service=EJB
state: FAILED
I Depend On:
Depends On Me: org.jboss.deployment.DeploymentException: Error while creating t
able Group; - nested throwable: (java.sql.SQLException: Syntax error or access v
iolation, message from server: "You have an error in your SQL syntax. Check th
e manual that corresponds to your MySQL server version for the right syntax to u
se near 'Group (name VARCHAR(64) NOT NULL, description VARCHAR(225), CON")]


ejb-jar.xml:
...全文
30 6 打赏 收藏 转发到动态 举报
写回复
用AI写文章
6 条回复
切换为时间正序
请发表友善的回复…
发表回复
jkit 2003-09-07
  • 打赏
  • 举报
回复
原来已经解决了啊,看来不用我帮忙了。
cxj_2000 2003-08-20
  • 打赏
  • 举报
回复
DEBUG.log:

2003-08-19 23:39:33,348 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.GroupBean] Remove SQL: DELETE FROM Group WHERE name=?
2003-08-19 23:39:33,348 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.GroupBean] Executing SQL: CREATE TABLE Group (name VARCHAR(64) NOT NULL, description VARCHAR(225), CONSTRAINT pk_Group PRIMARY KEY (name))
2003-08-19 23:39:33,358 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.GroupBean] Could not create table Group
cxj_2000 2003-08-20
  • 打赏
  • 举报
回复
<entity>
<display-name>GroupBean</display-name>
<ejb-name>GroupBean</ejb-name>
<local>cmp.LocalGroup</local>
<local-home>cmp.LocalGroupHome</local-home>
<ejb-class>cmp.GroupBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>java.lang.String</prim-key-class>
<reentrant>False</reentrant>
<cmp-version>2.x</cmp-version>
<abstract-schema-name>GroupBean</abstract-schema-name>
<cmp-field>
<field-name>name</field-name>
</cmp-field>
<cmp-field>
<field-name>description</field-name>
</cmp-field>
<primkey-field>name</primkey-field>

<query>
<description></description>
<query-method>
<method-name>findAll</method-name>
<method-params/>
</query-method>
<ejb-ql><![CDATA[select Object(o) from GroupBean as o]]></ejb-ql>
</query>
</entity>
cxj_2000 2003-08-20
  • 打赏
  • 举报
回复
问题解决了,关键是分如何办?
jhlqab 2003-08-20
  • 打赏
  • 举报
回复
w我来接.大哥我来了。等我哦。
javahui 2003-08-20
  • 打赏
  • 举报
回复
其实你可以自己删除这个帖子,不过现在我跟了,你没法删除啦,呵呵。

67,512

社区成员

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器,保护我们的业务核心组件(中间件),以延续它的生命力,而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧