Re: mysql issues
Re: mysql issues
- Subject: Re: mysql issues
- From: Michael Halliday <email@hidden>
- Date: Thu, 3 Nov 2005 13:45:11 -0500
Hi Justin,
You need to specify the length of the varchar field in eomodeler (the
width column). So, then when you go to create the SQL it will look
like (for example):
CREATE TABLE CUSTOMER (CUSTOMERCITY VARCHAR(100) NOT NULL, ....
On 3-Nov-05, at 1:41 PM, 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:
email@hidden
This email sent to email@hidden
_______________________________________________
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>) |