September 20, 2007 at 4:29 PM
Hi..i tried the EJB example with CMP. here i m using MySql as database.when i m deploying the ear file, i got a deployment exception.
the exception is
org.jboss.deployment.DeploymentException: Error while creating table table1; - nested throwable: (com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 'VARCHAR(250) BINARY NOT NULL, name VARCHAR(250) BINARY, place VARCHAR(250) BINAR' at line 1)