Stimulsoft Business Intelligence System | Forum

Hello,
Would you be able to provide an java example report with the data being populated from oracle Stored Procedure (using JDBC connection or other)?

It would also be good if for example, there is some parameters being passed to a query.

Question 1. We design a mrt report in .net designer, when we submit "Retrieve Columns", it display this error. But it can select data: Question 2. we design a java report in java designer ,But this is not RefCursor type like .net designer. We also try to edit the JDBC Datasource's Sql like :
call STIMULSOFTTEST(?)
call STIMULSOFTTEST(cur_out out sys_refcursor)
call STIMULSOFTTEST
STIMULSOFTTEST
...
Anyone is not work.
What can i do?We need your help!thank you!

Hello,

We need some additional time for check the issue. We will let you know about the result.

Thank you.

Hello.
Java version now is not support refcursor.
List of stored procedures you can collect by next code:

Hello,
Thank you for your reply!But I still do not know how to use stored procedure in the java report.

Vadim wrote:Hello.
Java version now is not support refcursor.
List of stored procedures you can collect by next code:

Code: Select all

String connectionString = "url=jdbc:oracle:thin:@192.168.157.128:1521:orcl;user=sys as sysdba;password=oracle";
StiOracleDatabase db = new StiOracleDatabase("test", "test", connectionString);
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.157.128:1521:orcl", "sys as sysdba", "oracle");
StiDatabaseInformation inform = db.getDatabaseInformation(con, new StiOracleAdapter(connectionString));
inform.getStoredProcedures();

Hello,

We need some additional time for check the issue. We will let you know about the result.

Thank you.

Jia Sheng wrote: Thank you for your reply!But I still do not know how to use stored procedure in the java report.

Hello.
From version 2016.1.16 you can use Oracle stored procedures with refcursor.
https://www.stimulsoft.com/en/samples/j ... e-database

Vadim wrote: Hello.
From version 2016.1.16 you can use Oracle stored procedures with refcursor.
https://www.stimulsoft.com/en/samples/j ... e-database

Hello.
Recently we upgraded the stimulsoft report to 2017.1.7 version, when we verify the function of Oracle stored procedures, we found that it still does not support.Can you give us a demo? Include mrt file

We tried the following three cases, we found that it still does not support the function of Oracle stored procedures. ( Iava designer still does not support RefCursor type)
1. We design a mrt report in .net designer,like: But we put the report on the jsp page(stiwebviewer), The following error occurred： 2. We design a mrt report in .net designer,like: But we put the report on the jsp page(stiwebviewer), The following error occurred： 3. We design a mrt report in .net designer,like: But we put the report on the jsp page(stiwebviewer), The following error occurred： Can you give us a demo? Include mrt file
Thanks

Hello,

How many arguments does the get_test2 stored procedure have?
Please, check this query with some values instead of the parameters.
Does it work?

Thank you.

Hello,

I do it follow the example (from https://www.stimulsoft.com/en/samples/j ... e-database), the stored procedure is also provided inside the example. like:
Can you give us a java demo project(use stiwebviewer)? Include a mrt file using oracle Stored Procedure
Thanks

Hello,

Sorry, we can't find the attachment.
Could you send it again?

Thank you.