Re: [Modelj-user] Re: Setting up jboss & mysql

[Neil E. <ne...@os...>]

Good news,

   The address and userRole tables have been created in the database.   
(Installing the JDBC driver seems to have helped :)
   The address table is listed in the web browser and I can add  
addresses.

Not so good news,

   The Options box displays options for Role, User, and Address but not  
for Purchase Order and User Role
   The list option doesn't work for Role and User
   When JBoss starts up I get the following error

> 12:38:59,076 INFO  [Address] Created table 'ADDRESS' successfully.
> 12:38:59,452 INFO  [UserInfo] Created table 'USERINFO' successfully.
> 12:38:59,537 ERROR [EntityContainer] Starting failed
> org.jboss.deployment.DeploymentException: Error while creating table  
> USER; - nested throwable: (java.sql.SQLException: Syntax error or  
> access violation,  message from server: "You have an error in your SQL  
> syntax.  Check the manual that corresponds to your MySQL server  
> version for the right syntax to use near 'USER(id INTEGER NOT NULL,  
> username VARCHAR(250) BINARY, passwor")
>         at  
> org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCo 
> mmand.java:231)

I can see that mysql might have a problem with USER and ROLE, but that  
wouldn't explain why the PurchaseOrder table wasn't created.