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

[James M. <jmi...@ap...>]

On Sat, 31 Jan 2004, Neil Earnshaw wrote:

> 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)

Yes, this has to do with a JBoss configuration file.  Open
$JBOSS_HOME/server/default/conf/standardjaws.xml and search for 'binary'.
You'll notice under the mysql type mapping a like like this:

  <sql-type>VARCHAR(255) BINARY</sql-type>
                         ^^^^^^


...remove that and it should work fine.


>
> 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.
>
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Modelj-user mailing list
> Mod...@li...
> https://lists.sourceforge.net/lists/listinfo/modelj-user
>




-- 
James Mitchell
Software Developer / Struts Evangelist
http://www.struts-atlanta.org