March 2016 - discuss - lists.mariadb.org

[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

[Maria-discuss] Collations, trailing spaces and unique indexes
by Binarus 21 Mar '16

21 Mar '16

Dear all, I already have done some MySQL development and now eventually would like to switch to MariaDB because I no longer can stand the following: "All MySQL collations are of type PADSPACE. This means that all CHAR, VARCHAR, and TEXT values in MySQL are compared without regard to any trailing spaces. “Comparison” in this context does not include the LIKE pattern-matching operator, for which trailing spaces are significant." "For those cases where trailing pad characters are stripped or comparisons ignore them, if a column has an index that requires unique values, inserting into the column values that differ only in number of trailing pad characters will result in a duplicate-key error. For example, if a table contains 'a', an attempt to store 'a ' causes a duplicate-key error." (taken from https://dev.mysql.com/doc/refman/5.5/en/char.html) I did not find any information whether the collations which MariaDB provides are of type PADSPACE as in MySQL (none of the collation tables from MariaDB's documentation does contain this information) or not. To make a long story short: I would like to have CHAR and VARCHAR fields with unique indexes which consider 'a' and 'a ' to be different values (which is the only reasonable point of view IMHO). This is not possible with MySQL. Is it possible with MariaDB? I am generally working with charset UTF8 and would be happy with a general solution, but also with a non-general solution which only works with UTF8. Since the index behaviour obviously depends on the collation, would building an own collation which does not PADSPACE be an option? I have read vague hints about that in MariaDB's documentation, but didn't try yet (before doing so, I would like to know if there is an easy, clean solution). Thank you very much for any ideas, Binarus

10 27

[Maria-discuss] New Question: netframework support
by AskMonty KB 21 Mar '16

21 Mar '16

Hello, A new question has been asked in "MariaDB Documentation" by juantoledo. Please answer it at http://mariadb.com/kb/en/netframework-support/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Do you plan to support connection for apps with Microsoft net framework? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/netframework-support/

1 0

[Maria-discuss] warning : bison executable not found in PATH
by Shubham Barai 18 Mar '16

18 Mar '16

Hello everyone, I was trying to build MariaDB from source on windows. I have already installed bison in the dir C:\GnuWin32\ but still I am getting this error bison executable not found in PATH Any help would be appreciated. Thanks, Shubham

2 1

[Maria-discuss] MariaDB CONNECT Storage Engine access to Oracle 11GR2
by Ghazi Btissam 16 Mar '16

16 Mar '16

Hi, I saw an article about the equivalent of the Oracle DbLink feature in MariaDb, I found that the connect engine with the ODBC table type can do an insert+select on an Oracle remote table ,but the *update *of the remote data is it possible? Thanks

2 1

[Maria-discuss] New Question: MariaDB Connector for Windows (1.05)
by AskMonty KB 15 Mar '16

15 Mar '16

Hello, A new question has been asked in "MariaDB Connector/ODBC" by fred_taylor_g. Please answer it at http://mariadb.com/kb/en/mariadb-connector-for-windows-105/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm trying to connect to a MariaDB 10 database using the MariaDB ODBC Connector 1.05 on a WIN7 32 bit machine, but I can't get connected using it as I get an "Connectivity Error: Unknown system variable 'max_allowed_packet_size'". I can create a DSN and the "test" says it works, but I get the same error trying to use that DSN from Visual FoxPro 9.0/SP2. It fails with the above error trying a connection string in VFP: SQLSTRINGCONNECT("Driver={MariaDB ODBC 1.0 Driver};Server=localhost;UID=myuser;PWD=mypwd;DB=test;Port=3306;") Any explanations,as I can't find anything on 'max_allowed_packet_size'? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-connector-for-windows-105/

1 0