Re: OpenBase vs MySQL
Re: OpenBase vs MySQL
- Subject: Re: OpenBase vs MySQL
- From: Erwin <email@hidden>
- Date: Tue, 12 Apr 2005 08:31:52 +0200
thanks to all of you for your help , I am going to check which version my ISP is using .... before upgrading
In the meantime I converted this 'subqueries' (the SELECT COUNT(*)... being 'derived attributes' ) into java logic in my class...
which seems to be a better solution (according to some of you)
Erwin
Le Apr 11, 2005, à 9:40 PM, Jacky Gagnon a écrit :
I did a migration to MySQL 4.1 last week and its seems to be OK for the moment.
You need to replace "mm.mysql-2.0.14-bin.jar" by "mysql-connector-java-3.1.7-bin.jar". In EOModeler just change the Driver with "com.mysql.jdbc.Driver".
If you stored your data in UTF-8 in 4.0.x and you want to use the new UTF-8 encoding, don't forget to adjust the width of all char/varchar attribute (see documentation for more information). You must choose TEXT type over BLOB for UTF-8 string (or you cannot read/store them correctly).
Jacky
On 05-04-11, at 15:00, Kieran Kelleher wrote:
Hi Erwin,
MySQL 4.0.X does NOT support SUB-QUERIES. (EOF does not generate sub-queries, so that's why MySQL 4.0 works well with EOF which tries to be simple and agnostic in its database operations).
In any case, you can get full support for subqueries if you upgrade to MySQL 4.1.X (which is now a stable/production release.
http://dev.mysql.com/doc/mysql/en/subqueries.html
I have not yet tested 4.1.X with WebObjects. If you do try 4.1.X, the first thing you will find as the new password hashing is incompatible with older clients, so it may affect EOModeler connection dictionary .... I don't know .... I have not has time to check it out yet. A simple my.cnf file change will revert to the old password behaviour though. See the online MySQL docs for more info on 4.1
Regards, Kieran
On Apr 10, 2005, at 1:31 PM, Erwin wrote:
I know it's not a generic WO Question, but ... I am sure some MySQL expert will have the answer (origin WODev Guide Ravi..)
I have the following fetch in my EOModel , it's running fine with OpenBase but it's seems to be wrong with MySQL 4
-------
<x-tad-bigger>SELECT FORUM_ID, NAME,
(SELECT COUNT(*) FROM POST, TOPIC WHERE POST.TOPIC_ID = TOPIC.TOPIC_ID AND TOPIC.FORUM_ID = FORUM.FORUM_ID),
(SELECT COUNT(*) FROM TOPIC WHERE TOPIC.FORUM_ID = FORUM.FORUM_ID)
FROM FORUM
------
</x-tad-bigger>the <x-tad-bigger>SELECT FORUM_ID, NAME FROM FORUM</x-tad-bigger> alone runs well...
the <x-tad-bigger>SELECT COUNT(*) FROM POST, TOPIC, FORUM WHERE POST.TOPIC_ID = TOPIC.TOPIC_ID AND TOPIC.FORUM_ID = FORUM.FORUM_ID</x-tad-bigger> alone runs well...
the SELECT COUNT( * ) FROM TOPIC, FORUM WHERE TOPIC.FORUM_ID = FORUM.FORUM_ID alone runs well...
but all together they generate a syntax error :
<x-tad-smaller>#1064 - 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 'SELECT COUNT( * )
FROM POST, TOPIC
WHERE POST.TOPIC_ID = TOP</x-tad-smaller>
_______________________________________________
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 _______________________________________________
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
_______________________________________________
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