Beantwoord

PostgreSQL and MySQL

Anoniem 8 jaar geleden • bijgewerkt door 8 jaar geleden • 8

Hello,

I have a question regarding PostgreSQL and MySQL. I have a database in MySQL for now and a stored procedure to insert data. Despite the fact everything is good, and user have authenticated access over procedure, Warewolf seems cannot list the procedure.

Here are the details of procedure:

DELIMITER $$
CREATE PROCEDURE rfidautomatic_INSERT(IN uid varchar(45))
BEGIN
insert into webtest.rfid_uid (rfiduid) values (uid);
END
DELIMITER ;

tool

Stem

Reacties 8
Oudste eerst
- Nieuwste eerst
- Oudste eerst

Under review

8 jaar geleden

Hello,

Note that the DELIMITER keyword is a function of the command line mysql client (and some other clients) only and not a regular MySQL language feature. It won't work if you tried to pass it through a programming language API to MySQL, which is how Warewolf works.

Antwoorden
- Is het?
- Ongepast
- Spam
- Verdubbelen
|

8 jaar geleden

We are looking into why it would not show up in the Action list.
What version of MySQL are you using.
What version of Warewolf are you running?

Antwoorden
- Is het?
- Ongepast
- Spam
- Verdubbelen
|

8 jaar geleden

Hi,

Please confirm that the procedure is actually created in mySQL based on the script you provided will not run as it is missing a $$ on the 'END' line.

The procedure also looks like a duplicate of the one in the following post:

http://community.warewolf.io/topics/368-parameter-warewolf-variable-not-found-in-the-collection

In the post above the procedure is showing in the list however not executing, we are busy with the executing issue and it will be resolved in the next release.

Thanks