Lists

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

mysql issues

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

mysql issues

Subject: mysql issues
From: "Justin Barry" <email@hidden>
Date: Thu, 03 Nov 2005 10:41:56 -0800

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:
This email sent to email@hidden


Follow-Ups:

Re: mysql issues
From: Chuck Hill <email@hidden>
Re: mysql issues
From: Michael Halliday <email@hidden>


Prev by Date:
(no subject)

Next by Date:
Re: mysql issues

Previous by thread:
Re: mySql Issues

Next by thread:
Re: mysql issues

Index(es):

Date
Thread