Re: mysql issues
Re: mysql issues
- Subject: Re: mysql issues
- From: Chuck Hill <email@hidden>
- Date: Thu, 3 Nov 2005 10:45:51 -0800
CUSTOMERFIRSTNAME VARCHAR NOT NULL
Hmmm, isn't it traditional to give these a max length as in
CUSTOMERFIRSTNAME VARCHAR(50) NOT NULL
Perhaps your model is not complete yet?
Chuck
On Nov 3, 2005, at 10:41 AM, Justin Barry wrote:
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 (email@hidden)
Help/Unsubscribe/Update your Subscription:
40global-village.net
This email sent to email@hidden
--
Coming in 2006 - an introduction to web applications using WebObjects
and Xcode http://www.global-village.net/wointro
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems. http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
| References: | |
| | >mysql issues (From: "Justin Barry" <email@hidden>) |