Issue about java report with oracle Stored Procedure
Issue about java report with oracle Stored Procedure
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!
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!
Re: Issue about java report with oracle Stored Procedure
Hello,
We need some additional time for check the issue. We will let you know about the result.
Thank you.
We need some additional time for check the issue. We will let you know about the result.
Thank you.
Re: Issue about java report with oracle Stored Procedure
Hello.
Java version now is not support refcursor.
List of stored procedures you can collect by next code:
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();
Re: Issue about java report with oracle Stored Procedure
Hello,
Thank you for your reply!But I still do not know how to use stored procedure in the java report.
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();
Re: Issue about java report with oracle Stored Procedure
Hello,
We need some additional time for check the issue. We will let you know about the result.
Thank you.
We need some additional time for check the issue. We will let you know about the result.
Thank you.
Re: Issue about java report with oracle Stored Procedure
Hello.Jia Sheng wrote: Thank you for your reply!But I still do not know how to use stored procedure in the java report.
From version 2016.1.16 you can use Oracle stored procedures with refcursor.
https://www.stimulsoft.com/en/samples/j ... e-database
Re: Issue about java report with oracle Stored Procedure
Hello.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
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
Re: Issue about java report with oracle Stored Procedure
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.
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.
Re: Issue about java report with oracle Stored Procedure
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
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
Re: Issue about java report with oracle Stored Procedure
Hello,
Sorry, we can't find the attachment.
Could you send it again?
Thank you.
Sorry, we can't find the attachment.
Could you send it again?
Thank you.