Re: WebObjects and mySQL
Re: WebObjects and mySQL
- Subject: Re: WebObjects and mySQL
- From: Dov Rosenberg <email@hidden>
- Date: Fri, 30 Jan 2004 08:22:35 -0500
MySQL has some other weird traits, including the fact that it is case
sensitive to table names depending on the OS it is running on. Unix based
installations typically use lower case table names, while developers on
Windows installs tend to use a mixture. The mixed case doesn't usually cause
any problems until the app is deployed on *nix machine. This really shows up
RawRowsForSQL and when you have mixed case for table names in your EOModel.
Dov Rosenberg
Conviveon Corporation
http://www.conviveon.com
On 1/29/04 11:22 PM, "Chuck Hill" <email@hidden> wrote:
> I'll hazard a guess that USER is a reserverd word and needs to be
> double-quoted:
> INSERT INTO "USER"(name, userID) VALUES ('fasdfasdfsdf', 2);
>
> That job is usually handled by the plug-in as it is aware of any DB
> specific reserved words. However, the mySQL plugin is part of the JDBC
> adaptor so that does not make much sense. You could try a different table
> name...
>
>
> Chuck
>
>
>
> At 03:02 PM 30/01/2004 +1100, Owen McKerrow wrote:
>> Hi guys,
>>
>> Thanks for the help. I have down what you have suggested and now
>> EOModler can see the DB. I've started with a test one, with one table
>> USER and 2 attributes name and userID. I did a quick WODisplayGroup
>> Application and try to insert and save a new user. But I receive the
>> following error...
>>
>> INSERT INTO USER(name, userID) VALUES (?, ?)" withBindings:
>> 1:"fasdfasdfsdf"(name), 2:2(userID)>:
>> Next exception:SQL State:42000 -- error code: 1064 -- msg: Syntax
>> error or access violation, message from server: "You have an error in
>> your SQL syntax near 'USER(name, userID) VALUES ('fasdfasdfsdf', 2)' at
>> line 1"
>>
>> It all seems very simple and straight fwd so Im not sure what could be
>> causing the error. Any ideas on things I should check for ?
>>
>> Owen
>>
>> On Thursday, January 29, 2004, at 02:30 PM, David Holt wrote:
>>
>>> In addition to what Jonathon wrote:
>>>
>>> in the database url put jdbc:mysql://localhost/your_database_name
>>> put in user/password combo if you have one for the database
>>>
>>> filling in the driver box is not necessary for WO 5.2 (EOModeler)
>>>
>>> david
>>>
>>> --
>>> The only way to make a man worthy of love is by loving him.
>>>
>>> Thomas Merton
>>>
>>> from Sunbeams: http://www.thesunmagazine.org
>>> On 28-Jan-04, at 7:22 PM, Jonathan 'Wolf' Rentzsch wrote:
>>>
>>>> Owen McKerrow, email@hidden, wrote:
>>>>> People keep referring to Anjo Krank's page (
>>>>> http://www.kcmedia.de/RegEx/mysql-wo.html ) for setting up mySQl and
>>>>> WebObjects but that page is down. Does any one have copy of the info
>>>>> on
>>>>> it that they could send me ?
>>>>
>>>> All I had to do to get MySQL to work with WO is plop
>>>> mysql-connector-java-3.0.9-stable-bin.jar into
>>>> /Library/Java/Extensions.
>>>> After that is Just Worked. WO 5.2.2, by the way.
>>>>
>>>> .......................................................
>>>> Jonathan 'Wolf' Rentzsch http://rentzsch.com
>>>> Red Shed Software http://redshed.net (847) 584-7465
>>>> PGP: b2af 1a09 f881 ebde c9d6 c4d2 c04f a3c0 3ec5 d5f2
>>>>
>>>> "better" necessarily means "different"
>>>> _______________________________________________
>>>> webobjects-dev mailing list | email@hidden
>>>> Help/Unsubscribe/Archives:
>>>> http://www.lists.apple.com/mailman/listinfo/webobjects-dev
>>>> Do not post admin requests to the list. They will be ignored.
>>> _______________________________________________
>>> webobjects-dev mailing list | email@hidden
>>> Help/Unsubscribe/Archives:
>>> http://www.lists.apple.com/mailman/listinfo/webobjects-dev
>>> Do not post admin requests to the list. They will be ignored.
>>>
>>>
>> 'The test of a first-rate intelligence is the ability to hold two
>> opposed ideas in the mind at the same time and still be able to
>> function.'
>> -F.Scott Fitzgerald,
>> _______________________________________________
>> webobjects-dev mailing list | email@hidden
>> Help/Unsubscribe/Archives:
> http://www.lists.apple.com/mailman/listinfo/webobjects-dev
>> Do not post admin requests to the list. They will be ignored.
>>
>
> --
>
> Chuck Hill email@hidden
> Global Village Consulting Inc. http://www.global-village.net
> _______________________________________________
> webobjects-dev mailing list | email@hidden
> Help/Unsubscribe/Archives:
> http://www.lists.apple.com/mailman/listinfo/webobjects-dev
> Do not post admin requests to the list. They will be ignored.
--
Dov Rosenberg
Conviveon Corporation
370 Centerpointe Circle, suite 1178
Altamonte Springs, FL 32701
http://www.conviveon.com
email@hidden
(407) 339-1177 X102
(407) 339-6704 (FAX)
(800) 475-9890
(407) 310-8316 (cell)
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.