- discuss - lists.mariadb.org

[Maria-discuss] Fwd: java.sql.Timestamp works in MySQL, fails in MariaDB
by Diego Dupin 31 Mar '16

31 Mar '16

---------- Forwarded message ---------- From: Diego Dupin <diego.dupin(a)mariadb.com> Date: Tue, Mar 29, 2016 at 10:15 PM Subject: java.sql.Timestamp works in MySQL, fails in MariaDB To: lyallex(a)gmail.com Hi, That must normally work, since the mysql connector use the same binary protocol. Could you send the exact connection string to know the options you use ? Diego Recently I changed servers, my old server was running MySQL and my > Java code worked perfectly. My new server is apparently running Ver 15 > 5.5.44-MariaDB, for Linux (x86 64) > The following code works and has worked perfectly well for the past 4 years > java.sql.Timestamp transactionTimestamp = new > java.sql.Timestamp(System.currentTimeMillis()); > PreparedStatement pstmt > ... > pstmt.setTimestamp(4, transactionTimestamp); > pstmt.executeUpdate(); // EPIC FAIL, writes all 0s to the database > I'm currently using mysql-connector-java-5.1.22-bin.jar in WEB-INF/lib > Can anyone throw any light on this please? > Many thanks > Lyallex

1 0

[Maria-discuss] New Question: tarball support
by AskMonty KB 30 Mar '16

30 Mar '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/tarball-support/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- MariaDB Enterprise provides only RPM packages to be downloaded and tarball packages are considered as non enterprise package..So is support from mariaDB corporation provided for tarball installation?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/tarball-support/

1 0

[Maria-discuss] New Question: mariadb os support
by AskMonty KB 30 Mar '16

30 Mar '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-os-support/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- does mariadb client binary support both 64bit/32bit. or do u want to install seperate binaries -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-os-support/

1 0

[Maria-discuss] New Question: According to wikipedia link, MariaDB does not have Security Evaluation Assurance Level (EAL)
by AskMonty KB 30 Mar '16

30 Mar '16

Hello, A new question has been asked in "MariaDB Community" by aferrett. Please answer it at http://mariadb.com/kb/en/according-to-wikipedia-link-mariadb-does-not-have-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Looking at the link below, MariaDB shows "No" for Security Certification. This is based on no Security Evaluation Assurance Level (EAL). https://en.wikipedia.org/wiki/Comparison_of_relational_database_management_… Does anyone have any information on whether this can be a problem? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/according-to-wikipedia-link-mariadb-does-not-have-…

1 0

[Maria-discuss] New Question: MariaDB migration
by AskMonty KB 29 Mar '16

29 Mar '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-migration/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- how do i migrate MariaDB from windows to linux?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-migration/

1 0

[Maria-discuss] New Question: mysqli_connect didnot work
by AskMonty KB 29 Mar '16

29 Mar '16

Hello, A new question has been asked in "SQL Commands" by mifuji235_43584. Please answer it at http://mariadb.com/kb/en/mysqli_connect-didnot-work/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- i will try the make local database from csv File. but Sql didnot connect local Mysql server , why? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mysqli_connect-didnot-work/

1 0

[Maria-discuss] java.sql.Timestamp works in MySQL, fails in MariaDB
by Lyallex 28 Mar '16

28 Mar '16

Recently I changed servers, my old server was running MySQL and my Java code worked perfectly. My new server is apparently running Ver 15 5.5.44-MariaDB, for Linux (x86 64) The following code works and has worked perfectly well for the past 4 years java.sql.Timestamp transactionTimestamp = new java.sql.Timestamp(System.currentTimeMillis()); PreparedStatement pstmt ... pstmt.setTimestamp(4, transactionTimestamp); pstmt.executeUpdate(); // EPIC FAIL, writes all 0s to the database I'm currently using mysql-connector-java-5.1.22-bin.jar in WEB-INF/lib Can anyone throw any light on this please? Many thanks Lyallex

1 0

[Maria-discuss] MariaDB 10.1.13 and Connector/J 1.3.7 now available
by Daniel Bartholomew 25 Mar '16

25 Mar '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.13, and MariaDB Connector/J 1.3.7. These are both Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.13 - Release Notes: https://mariadb.com/kb/en/mdb-10113-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10113-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.13 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/J 1.3.7 - Release Notes: https://mariadb.com/kb/en/mcj-137-rn/ - Changelog: https://mariadb.com/kb/en/mcj-137-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.3.7 About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] New Question: Unsupported DBF type M (Memo)
by AskMonty KB 24 Mar '16

24 Mar '16

Hello, A new question has been asked in "CONNECT" by lucio.minetti_44167. Please answer it at http://mariadb.com/kb/en/unsupported-dbf-type-m-memo/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm using 10.0.22-MariaDB openSUSE package. I've received this "Unsupported DBF type M" for memo field. I think that memo filed datatype is not supported. Is it possible that this datatype is supported in any new MariaDB version ? If yes, from which version ? Thank you -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unsupported-dbf-type-m-memo/

1 0

[Maria-discuss] New Question: Problem with stored procedures after migration from mysql to mariadb with jdbc driver from mariadb
by AskMonty KB 24 Mar '16

24 Mar '16

Hello, A new question has been asked in "Stored Procedures" by Andreas.duhamel_43935. Please answer it at http://mariadb.com/kb/en/problem-with-stored-procedures-after-migration-fro… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have a problem with stored procedures after migration from mysql to mariadb 10.1. With the old jdbc driver from mysql mysql-connector-java-5.1.13-bin all is ok. If i change the driver to the mariadb driver mariadb-java-client-1.3.6 it's not ok. Here the queries.log: 2 Query set @_jdbc_var_1='Check',@_jdbc_var_2='',@_jdbc_var_3='Benutzer',@_jdbc_var_4='Aktuell',@_jdbc_var_5='Passwort',@_jdbc_var_6=NULL,@_jdbc_var_7=0,@_jdbc_var_8='Administrator',@_jdbc_var_9='7b7bc2512ee1fedcd76bdc68926d4f7b',@_jdbc_var_10=NULL,@_jdbc_var_11=NULL,@_jdbc_var_12=NULL,@_jdbc_var_13=0,@_jdbc_var_14=0,@_jdbc_var_15=0 2 Query call spmzBenutzer(@_jdbc_var_1,@_jdbc_var_2,@_jdbc_var_3,@_jdbc_var_4,@_jdbc_var_5,@_jdbc_var_6,@_jdbc_var_7,@_jdbc_var_8,@_jdbc_var_9,@_jdbc_var_10,@_jdbc_var_11,@_jdbc_var_12,@_jdbc_var_13,@_jdbc_var_14,@_jdbc_var_15) 2 Query SET @AKTIO NAME_CONST('p_AKTION',_utf8'Check' COLLATE 'utf8_general_ci')TION 2 Query SET @Sortierun NAME_CONST('p_Sortierung',_utf8'' COLLATE 'utf8_general_ci')rung 2 Query SET @MODU NAME_CONST('p_MODUS',_utf8'Benutzer' COLLATE 'utf8_general_ci')ODUS 2 Query SET @MODUS NAME_CONST('p_MODUS2',_utf8'Aktuell' COLLATE 'utf8_general_ci')DUS2 2 Query SET @MODUS NAME_CONST('p_MODUS3',_utf8'Passwort' COLLATE 'utf8_general_ci')DUS3 2 Query SET @IDBenutze NAME_CONST('p_IDBenutzer',0)tzer 2 Query SET @Benutze NAME_CONST('p_Benutzer',_utf8'Administrator' COLLATE 'utf8_general_ci')tzer 2 Query SET @Passwor NAME_CONST('p_Passwort',_utf8'7b7bc2512ee1fedcd76bdc68926d4f7b' COLLATE 'utf8_general_ci')wort 2 Query SET @Vornam NAME_CONST('p_Vorname',NULL)name 2 Query SET @Nachnam NAME_CONST('p_Nachname',NULL)name 2 Query SET @AnlegeDatu NAME_CONST('p_AnlegeDatum',NULL)atum 2 Query SET @Statu NAME_CONST('p_Status',0)atus 2 Query SET @IDRo NAME_CONST('p_IDRow',0)DRow 2 Query SET @IDGrupp NAME_CONST('p_IDGruppe',0)uppe 2 Query SELECT IDBenutzer into p_NeuerIdent FROM bvwbenutzer WHERE Benutzer = @Benutzer AND Passwort = @Passwort AND Status < 9 2 Query SELECT NULL,NULL,NULL,NULL,NULL,@_jdbc_var_6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL 2 Query ROLLBACK And here the jbossprotokol: 2016-03-24 11:02:55,313 ERROR [org.jboss.ejb.plugins.LogInterceptor] (WorkerThread#0[10.19.12.113:50404]) EJBException in method: public abstract java.lang.Integer mmts.benutzer.interfaces.BenutzerFacade.Pruefen_Benutzer_Passwort(java.lang.String,java.lang.String) throws java.rmi.RemoteException, causedBy: java.sql.SQLException: CallableStatement.executeQuery() did not return a resultset at org.mariadb.jdbc.MariaDbCallableStatement.executeQuery(MariaDbCallableStatement.java:1268) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342) at mmts.benutzer.ejb.BenutzerFacade.Pruefen_Benutzer_Passwort(BenutzerFacade.java:551) Who can help me? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/problem-with-stored-procedures-after-migration-fro…

1 0