February 2012 - discuss - lists.mariadb.org

[Maria-discuss] New KB Question: millisecond part is trimmed away when saving Java Date obj by hibernate
by Daniel Bartholomew 14 Feb '12

14 Feb '12

A new question has been posted in the Knowledgebase: http://kb.askmonty.org/en/millisecond-part-is-trimmed-away-when-saving-java… ---------------------------------------- Hi, I recently upgraded my MySQL DB to MariaDB for millisecond support. I can see the millisecond part in my upgraded database. And I tested the millisecond support by inserting a row to a table of my db. It functions well. But when I use hibernate to save a java.util.Date obj into database, millisecond part is trimmed and in MariaDB date obj is saved as: 2012-02-13 18:40:55.000. Do I need to set up something to activate millisecond support? Or I need to config hibernate for millisecond support? Thanks a lot! ---------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

Re: [Maria-discuss] MySQL's future in Debian and Ubuntu
by Marc Deslauriers 13 Feb '12

13 Feb '12

On Mon, 2012-02-13 at 02:20 -0500, Eddie Bachle wrote: > In general, I am generally an simply an observer on most of these > mailing lists, however my concerns with a switch are far less > technical and far more practical. I work currently for a college in > Michigan which utilizes almost solely Windows servers simply because > it is what the IT staff here knows. As a student here, I was brought > in to assist with the web server administration, and as time went by > because I have a degree of Linux knowledge, I was given permission to > put together a Ubuntu LAMP server to serve a couple of interested > parties on campus who wanted simply to demo several small scale web > apps that were Linux exclusive. This server would serve as an > exception to the general rule of our server architecture. However as > time has went by and my knowledge looks more like it will be a fixture > here after graduation, along with the simple instability of PHP and > Apache on the Windows platform, my boss is giving far more > consideration to moving to Linux. > > > As Linux gains more public recognition, more and more Windows-only > organizations will consider using it as an alternative, especially for > their web servers. This is especially true because of the fact that > each of the necessarily main components of a web server exist in Linux > in the same form as the do on Windows and often run much better. > Then, the only piece one would need to learn would be the new > operating system, not the database, HTTP server, or PHP scripting > language software. However, this is going to be a more difficult > proposition if the aforementioned advantage is somewhat eliminated. > Were I to have to tell my boss that we could switch to Ubuntu but it > would mean that would need to use a "MySQL compatible" database if we > want to use the native database (which we likely would because it's > tested to be stable and it is supported by the developers), then she > would be much more hesitant. If you prefer MySQL, you'll still be able to manually install it MySQL on Ubuntu and Debian, much like you manually install it on Windows. > > > There simply is a much greater sense of trepidation for those who are > not significantly Linux savvy if there exists a possibility that they > would have to make something work in an unfamiliar environment, > especially if it were to happen unexpectedly. If we ported our www > website server over to Ubuntu and then 6 months down the road we were > to upgrade our Joomla version and there became an issue with MariaDB > because it lacks some MySQL feature that it needs, or even that Joomla > would fail to recognize Maria as being equivalent to MySQL at some > point, then that would be a huge detraction against switching. I predict it will be the opposite. Once distros and people start switching to MariaDB, other projects will be testing on MariaDB by default, and compatibility with MySQL will then become problematic. Marc.

1 0

[Maria-discuss] New KB Question: ODBC
by Daniel Bartholomew 08 Feb '12

08 Feb '12

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/mariadb-odbc ==================== Is there an ODBC driver for use with MariaDB that is compatible with the driver provided with MySQL? ==================== Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] New KB Question: Locking SQL_MODE against client changes
by Daniel Bartholomew 05 Feb '12

05 Feb '12

A new question has been posted in the Knowledgebase: http://kb.askmonty.org/en/locking-sql_mode-against-client-changes ==================== Is there any way for locking out sql_mode against client-side changes other than MySQL Proxy (which does not allow for SSL connections)? Perhaps some MariaDB-specific setting? ==================== Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0