Issue about java report with oracle Stored Procedure

Stimulsoft Reports.JAVA discussion
Jia Sheng
Posts: 49
Joined: Thu Jul 04, 2013 7:59 am

Issue about java report with oracle Stored Procedure

Post by Jia Sheng »

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:
.net designer
.net designer
11.png (54.77 KiB) Viewed 14336 times
Question 2. we design a java report in java designer ,But this is not RefCursor type like .net designer.
java designer
java designer
1.png (15.4 KiB) Viewed 14336 times
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!
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Issue about java report with oracle Stored Procedure

Post by Alex K. »

Hello,

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

Thank you.
Vadim
Posts: 362
Joined: Tue Apr 23, 2013 11:23 am

Re: Issue about java report with oracle Stored Procedure

Post by Vadim »

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();
Jia Sheng
Posts: 49
Joined: Thu Jul 04, 2013 7:59 am

Re: Issue about java report with oracle Stored Procedure

Post by Jia Sheng »

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();
Vadim
Posts: 362
Joined: Tue Apr 23, 2013 11:23 am

Re: Issue about java report with oracle Stored Procedure

Post by Vadim »

Hello,

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

Thank you.
Vadim
Posts: 362
Joined: Tue Apr 23, 2013 11:23 am

Re: Issue about java report with oracle Stored Procedure

Post by Vadim »

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
Jia Sheng
Posts: 49
Joined: Thu Jul 04, 2013 7:59 am

Re: Issue about java report with oracle Stored Procedure

Post by Jia Sheng »

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:
1
1
00.png (40.75 KiB) Viewed 13895 times
But we put the report on the jsp page(stiwebviewer), The following error occurred:
2
2
000.png (44.95 KiB) Viewed 13895 times
2. We design a mrt report in .net designer,like:
3
3
0000.png (49.08 KiB) Viewed 13895 times
But we put the report on the jsp page(stiwebviewer), The following error occurred:
4
4
00000.png (58.8 KiB) Viewed 13895 times
3. We design a mrt report in .net designer,like:
5
5
000000.png (47.96 KiB) Viewed 13895 times
But we put the report on the jsp page(stiwebviewer), The following error occurred:
2
2
000.png (44.95 KiB) Viewed 13895 times
Can you give us a demo? Include mrt file
Thanks
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Issue about java report with oracle Stored Procedure

Post by HighAley »

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.
Jia Sheng
Posts: 49
Joined: Thu Jul 04, 2013 7:59 am

Re: Issue about java report with oracle Stored Procedure

Post by Jia Sheng »

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:
1
1
000000.png (65.96 KiB) Viewed 13890 times

Can you give us a java demo project(use stiwebviewer)? Include a mrt file using oracle Stored Procedure
Thanks
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Issue about java report with oracle Stored Procedure

Post by HighAley »

Hello,

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

Thank you.
Post Reply