Hi

New options for Enterprise Applications.

MySQL 5.0 adds support for stored procedures, which can facilitate the adoption of MySQL for existing legacy database applications. In addition to better accessibility, stored procedures can improve data integrity and developer productivity.

MySQL 5.0 Alpha
http://www.mysql.com/downloads/mysql-5.0.html

I test MySQL 5.0 with MySQL Turbo Manager 2.5.
http://www.mentattech.com

Regards,

Pete

MySQL is just an alpha release and not in stable or production state!

Actually most of the MySQL 5.0 code is the same code as what's in 4.0 and 4.1. It just has some new features like procedures. Is it stable code? Depends on what you call stable. Do you need stored procedures? If you have to have them and you use MySQL I would consider it to be stable enough.

Donny

I am not talking about features but i am talking about stability which is needed for database in production state.

Managers look:

- is it stable version for production state? Answer NO.
- is there support for this release? Answer NO.
- is there some company which have this version in production state? Answer: MAYBE

MySQL developers claims 5.0 only for testing and development purposes.

- is it stable version for production state? Actually it's as stable as MySQL 4.0 and MySQL 4.1.1. Since the source code is exactly the same, it just has some new features. So technically if there are any bugs in the code it would only be with brand new features. If there are bugs in anything else, the bugs would be in every release they have out today.

- is there support for this release? Why would there not be support? I installed it had a question sent it to the mysql list and got a response about 5 minutes later.

- is there some company which have this version in production state? I'm using it on 3 MySQL boxes right now. Do those boxes make me a few million a month? No. But do they make me a few hundred grand a year, sure. But I also have some boxes running 4.1.1 and even one running 4.1.2 which isn't even out yet. Because I want to know everything about every version and which is the best for me to run in the long run.

So if you are already using 4.1.x would I install 5.0 on a backend server, personally I would. If I were using 4.0 or 3.23.x would I upgrade them to 5.0? No. Too many new changes. Do one version number at a time. Your life will be much easier.

Donny

Hi

We agree MySQL 5.0 totally is a not stable database , is only for evaluation but is a good approach of the future of
this popular database.

regards,

Pete

Okay, that sounds fine but...

Connector/J doesn't seem to support stored procedures yet (I use the very late nightly build). I can't manage to retrieve a result from mysql sp to java ... I can't return neither ResultSet nor scalar data type. (But if i call the sp from command-line client it works OK.)

Have you experienced this?? If anyone of you know how to fix the problem please let me know.

Honza

P.S. I use Win 2000 Proff. SP4, j2sdk1.4.2, Connector/J 2004-01-14 nightly.