How to call a HSQLDB stored procedure in Execute query activity?

Help Studio
, ,
1

Not able to call HSQDB stored procedure in Execute query/Execute not query.

While Executing below error comes

image
image1600Ă—900 98.1 KB

2

Hi
Can I have view one parameter collections if any passed

@Tamilarasanaccet

3

image
image1600Ă—900 97.5 KB

no parameter passed and used the Execute query activity

4

Is yet connection validated buddy
Like did we check whether the connection ion is been made with the server

You can check the connection with Connection Wizard and there with Test Connectivity option

Cheers @Tamilarasanaccet

5

yes checked the connection, it’s working as expected.

tryied with select * from table query it also worked

6

Is the procedure mentioned correctly buddy
Because we have checked all the other stuffs
Like
Parameter
Storedprocudure enabled
Tested connectivity

@Tamilarasanaccet

7

call test_procedure(); this executes in backend as expected.

The same procedure name “test_procedure” have given in UiPath activity.

Is UIPATH execute/execute non query activity only depends specific database(i.e SQL SERVER, MYSQL, ORACLE) only? Why because here i am using HSQLDB

8

Hmm not really
We got options to choose the database type na and moreover ours got successfully connected
If there is any such issue then it would have not connected

Try mentioning dbname and schema name before the procedure and run

I remember I saw a similar issue two three days back

Cheers @Tamilarasanaccet

1 Like
9

image
image1600Ă—900 100 KB

after giving the db name above error returns.

10

Fine
I have one last approach to try
Usually we use to have a statement in server to call a procedure right
Use the same text here and change the command type to TEXT instead of Stored Procedure
@Tamilarasanaccet

11

image
image1600Ă—900 101 KB

Same issue bro.

12

Is other statements like select update are working fine @Tamilarasanaccet

13

yes bro other statement are working.

14

So the connection is working fine
Hmm but then how procedure alone not working
Can you click on the Details drop down in the error pop up and let’s see what is the error
@Tamilarasanaccet

15

image
image1600Ă—900 77.6 KB

can you please check the error details bro.

16

What is the outcome of this procedure and are we running in execute query or execute non query activity

@Tamilarasanaccet

17

select all the data from the table (select * from table_name).

Execute query activity is used.

18

may I know how you connect HSQLDB to uipath?

19

Two years and a half… Has anyone found a solution for this?