[ANN] ODB C++ ORM 2.4.0 released, adds MySQL stored procedure support
I am pleased to announce the release of ODB 2.4.0. ODB is an open source object-relational mapping (ORM) system for C++. It allows you to persist C++ objects to a relational database without having to deal with tables, columns, or SQL and without manually writing any of the mapping code. Major new features in this release: * Support for bulk operations in Oracle and SQL Server. Bulk operations can be used to persist, update, or erase a range of objects using a single database statement execution which often translates to a significantly better performance. * Ability to join and load one or more complete objects instead of, or in addition to, a subset of their data members with a single SELECT statement execution (object loading views). * Support for specifying object and table join types in views (LEFT, RIGHT, FULL, INNER, or CROSS). * Support for calling MySQL and SQL Server stored procedures. * Support for defining persistent objects as instantiations of C++ class templates. A more detailed discussion of these features can be found in the following blog post: http://www.codesynthesis.com/~boris/blog/2015/02/11/odb-2-4-0-released/ For the complete list of new features in this version see the official release announcement: http://codesynthesis.com/pipermail/odb-announcements/2015/41.html ODB is written in portable C++ (both C++98/03 and C++11 are supported) and you should be able to use it with any modern C++ compiler. In particular, we have tested this release on GNU/Linux (x86/x86-64/ARM), Windows (x86/x86-64), Mac OS X (x86/x86_64), and Solaris (x86/x86-64/SPARC) with GNU g++ 4.2.x-5.x, MS Visual C++ 2005, 2008, 2010, 2012, and 2013, Sun Studio 12u2, and Clang 3.x. The currently supported database systems are MySQL, SQLite, PostgreSQL, Oracle, and SQL Server. ODB also provides optional profiles for Boost and Qt, which allow you to seamlessly use value types, containers, and smart pointers from these libraries in your persistent classes. More information, documentation, source code, and pre-compiled binaries are available from: http://www.codesynthesis.com/products/odb/ Enjoy, Boris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
mySQL, mySQL Max and stored procedure support (version problem?)
I'm running: mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) ps says I'm running mysql-max mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00 /usr/sbin/mysqld-max that *should* support stored procedures, shouldn't it? but this fail create procedure pippo begin select 1 end as well as create procedure 'pippo' begin select 1 end and many other combination Is my syntax wrong? am I using the wrong version of mySQL to have SP support? Should I configure anything to have SP support? If I'm using the wrong version of mySQL which one has SP support and is considered the most stable? thx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL, mySQL Max and stored procedure support (version problem?)
Hi, I'm running: mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) ps says I'm running mysql-max mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00 /usr/sbin/mysqld-max that *should* support stored procedures, shouldn't it? As far as I know, MySQL 5 support stored procedures. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL, mySQL Max and stored procedure support (version problem?)
On Tue, 9 Mar 2004 10:52:38 +0100 Martijn Tonies [EMAIL PROTECTED] wrote: I'm running: mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) ps says I'm running mysql-max mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00 /usr/sbin/mysqld-max that *should* support stored procedures, shouldn't it? As far as I know, MySQL 5 support stored procedures. But what about Max version? Docs are not crystal clear. While it is clearly stated that mySQL started to support SP from version 5, nothing is said about Max where docs just say it supports them but it is not clear from which version. It is even not that clear from which source package should I start from to have Max or plain mySQL. I gave a look to SUSE source package of release 4 and it seems that Max and plain are built from the same tarball. Since I'm not sure if I have a version that support SP it is difficult to see if my syntax is wrong or it is a problem of version. Could anyone post a correct 5 line example of working stored procedure to test? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL, mySQL Max and stored procedure support (version problem?)
Ivan Sergio Borgonovo [EMAIL PROTECTED] wrote: On Tue, 9 Mar 2004 10:52:38 +0100 Martijn Tonies [EMAIL PROTECTED] wrote: I'm running: mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) ps says I'm running mysql-max mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00 /usr/sbin/mysqld-max that *should* support stored procedures, shouldn't it? As far as I know, MySQL 5 support stored procedures. But what about Max version? Docs are not crystal clear. While it is clearly stated that mySQL started to support SP from version 5, nothing is said about Max where docs just say it supports them but it is not clear from which version. 5 is a number of version. MySQL-Max is a name of MySQL server, where Max means that this MySQL server supports InnoDB and BDB storage engines. It is even not that clear from which source package should I start from to have Max or plain mySQL. I gave a look to SUSE source package of release 4 and it seems that Max and plain are built from the same tarball. Since I'm not sure if I have a version that support SP it is difficult to see if my syntax is wrong or it is a problem of version. Could anyone post a correct 5 line example of working stored procedure to test? For example: mysql delimiter | mysql create procedure pippo () - begin - select 1; - end | Query OK, 0 rows affected (0.07 sec) Syntax of stored procedures is described at: http://www.mysql.com/doc/en/CREATE_PROCEDURE.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL, mySQL Max and stored procedure support (version problem?)
On Tue, 09 Mar 2004 12:36:30 +0200 Victoria Reznichenko [EMAIL PROTECTED] wrote: 5 is a number of version. MySQL-Max is a name of MySQL server, where Max means that this MySQL server supports InnoDB and BDB storage engines. So this make MaxDB another product Could anyone post a correct 5 line example of working stored procedure to test? For example: mysql delimiter | mysql create procedure pippo () - begin - select 1; - end | Query OK, 0 rows affected (0.07 sec) Syntax of stored procedures is described at: http://www.mysql.com/doc/en/CREATE_PROCEDURE.html Yep but without being sure you've the right software you're always in doubt if you missed something. Anyway result was the same. So I've to upgrade. Any suggestion about which is the way to go to have stored procedure on mySQL. I was compiling 5.0 right now and I had trouble with relayrotate test. First passed, second didn't. Installation script suggest to use --force... Google doesn't offer any page for relayrotate mysql. spasiba -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: stored procedure support
And I hope triggers as a collegue and I have to submit a evaluation report on why our department should consider Mysql to be used in conjuction with Postgrsql which is our default RDBMS in our organisation. So I have a few link's regarding performaces etc as well as the Mysql V PostGresql Any other Plz post Victoria Reznichenko wrote: Tonino, Friday, October 11, 2002, 10:05:42 AM, you wrote: T Just a short question - Does anyone know the progress of stored T procedure support in MySQL 4 Stored procedures will come in v5.0 -- Regards Chuck Robert Amadi ICT Dept Systems Programmer. Rhaglenydd Systemau Adran ICT. Roll on Linux Power too deliver. Rholiwch ar Linux Y gallu i y Dosbarthu. Before you criticize someone, you should walk a mile in their shoes. That way, when you criticize them, you're a mile away, and you have their shoes. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: stored procedure support
Tonino, Friday, October 11, 2002, 10:05:42 AM, you wrote: T Just a short question - Does anyone know the progress of stored T procedure support in MySQL 4 Stored procedures will come in v5.0 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
stored procedure support
Hi, Just a short question - Does anyone know the progress of stored procedure support in MySQL 4 Thanks Tonino - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
