-
1. Re: Database stored procedures
rareddy Jul 4, 2012 10:10 PM (in response to worldzerga)Sergey,
It is indicating that you have not provided the "date" as the input parameter for execution of the procedure. Also make you use proper escaping when providing the date.
Ramesh..
-
2. Re: Database stored procedures
worldzerga Jul 5, 2012 1:20 AM (in response to rareddy)Hi Ramesh,
Thank you for your response.
Here is the client code:
CallableStatement cs = connection.prepareCall("{call PrepFundExchangeView.Pythoness_buf.dbo.prepFundExchange(?,?,?,?,?)}");
cs.setTimestamp(1, new java.sql.Timestamp(System.currentTimeMillis()));
cs.setByte(2, p1);
cs.setByte(3, p2);
cs.setByte(4, p3);
cs.setByte(5, p4);
cs.execute();
So I don't understand why it is complaining that the "date" is not being provided. My be there is a problem with the transformation script?
-
3. Re: Database stored procedures
shawkins Jul 5, 2012 8:30 AM (in response to worldzerga)Sergey,
That exception should only happen using the procedural relational style invocation, such as SELECT * FROM PrepFundExchangeFromPifia WHERE ...
Just calling PrepFundExchangeFromPifia through an EXEC/CALL should work as you expect. Is there anything else going on in this scenario other than what is shown here? If not, then you'll want to log a JIRA.
Thanks,
Steve
-
4. Re: Database stored procedures
worldzerga Jul 5, 2012 9:28 AM (in response to shawkins)Hi Steve,
I have used relational style before but then moved to EXEC approach. I have cleaned all caches in JBOSS and it solved the problem.
Now I have a different problem. Although the procedure is being executed without problem it does not return the result set. Do I have to explicitly specify the result set that the database stored procedure returns?
-
5. Re: Database stored procedures
shawkins Jul 5, 2012 9:39 AM (in response to worldzerga)Sergey,
In many instances vendor's JDBC DatabaseMetadata does not show the columns for returned resultsets, in which case yes you do have to hand model what you expect. If you are using a common DBMS and there is a way to use their system tables to get the result set information, then please open a designer JIRA to enhance the import process.
Steve