- discuss - lists.mariadb.org

[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 28 Mar '16

28 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

[Maria-discuss] stream sql
by Roberto Spadim 23 Mar '16

23 Mar '16

hi guys, anyone know if there's a stream sql interface to mysql? something like pipelinedb with postgresql? -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle

1 0

[Maria-discuss] New Question: Is MariaDB effected by the US trade sanctions?
by AskMonty KB 22 Mar '16

22 Mar '16

Hello, A new question has been asked in "Questions about licensing (MariaDB, plugins etc)" by tuomas_backman_g. Please answer it at http://mariadb.com/kb/en/is-mariadb-effected-by-the-us-trade-sanctions/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- My company is Finnish based company that was bought by US origin company. We are distributing an application running MariaDB under GPL to various countries including Iran. Since Mariadb foundation is registered to US, I wonder if US trade restrictions apply, ie. can't deliver MariaDB to Iran? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/is-mariadb-effected-by-the-us-trade-sanctions/

1 0

[Maria-discuss] New Question: mariaDB installation
by AskMonty KB 22 Mar '16

22 Mar '16

Hello, A new question has been asked in "Starting and Stopping MariaDB" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/starting-and-stopping-mariadb-mariadb-installation/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I want to install MariaDB in a directory which i have created and use it from there. Is there any way to do that? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/starting-and-stopping-mariadb-mariadb-installation/

1 0

[Maria-discuss] New Question: MariaDB Installation
by AskMonty KB 22 Mar '16

22 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-faq-mariadb-installation/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to install MariaDB as a non root user?? If yes,please provide a way to do the same. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-faq-mariadb-installation/

1 0