斑竹莫怪我,是在是csdn的search太烂了,问个jboss跟Mysql的问题
部署一个CMP 2.0,出以下问题:
Depends On Me: org.jboss.deployment.DeploymentException: Error while creating t
able UserBean; - nested throwable: (java.sql.SQLException: Syntax error or acces
s violation, message from server: "You have an error in your SQL syntax near ')
)' at line 1")]
在log4j.xml加了一个DEBUG,结果日志:
2003-08-15 10:24:01,180 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.UserBean] Executing SQL: CREATE TABLE UserBean (email VARCHAR(250) BINARY, password VARCHAR(250) BINARY, CONSTRAINT pk_UserBean PRIMARY KEY ())
2003-08-15 10:24:01,200 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.UserBean] Could not create table UserBean
可以肯定的是jboss生成数据操作语言错误。问题:那个配置文件能够配置该DDL?
再问个问题:ejb-jar.xml中:
<abstract-schema-name>User</abstract-schema-name>
这个标签作用是干吗的?