Re: WebObjects and mySQL
Re: WebObjects and mySQL
- Subject: Re: WebObjects and mySQL
- From: Owen McKerrow <email@hidden>
- Date: Fri, 30 Jan 2004 15:02:02 +1100
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.