I am having some trouble setting up my database in EOModeler using:
Webobjects 5.3
Macos x 10.4.3
Connector/J v. 3.1.11 Filename: mysql-connector-java-3.1.11-bin.jar
Connection string: jdbc:mysql://localhost/myDataBase
I have already created thhe database in PHPmyAdmin.
And I get the following message after I try to generate sql:
Error from JDBC adaptor: EvaluateExpression failed:
<MySQLPlugIn$MySQLExpression: "CREATE TABLE CUSTOMER (CUSTOMERCITY VARCHAR
NOT NULL, CUSTOMERFIRSTNAME VARCHAR NOT NULL, CUSTOMERLASTNAME VARCHAR NOT
NULL, CUSTOMERPHONENUMBER VARCHAR , CUSTOMERSTATEID INT ,
CUSTOMERSTREETADDRESS VARCHAR , CUSTOMERZIPCODE VARCHAR , ID INT NOT NULL,
PLAYERFIRSTNAME VARCHAR NOT NULL, PLAYERHEIGHT VARCHAR , PLAYERLASTNAME
VARCHAR NOT NULL, PLAYERNUMBER INT , PLAYERPOSITION VARCHAR , PLAYERWEIGHT
VARCHAR , TEAM_ID INT NOT NULL)">:
Next exception:SQL State:42000 -- error code: 1064 -- msg: 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 'NOT NULL, CUSTOMERFIRSTNAME
VARCHAR NOT NULL, CUSTOMERLASTNAME VARCHAR NOT NULL,' at line 1
Anyone have any ideas?
Thanks,
Justin
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to archive@mail-archive.com
