Search:

Hi Andrew,

When I tried to update, getting the below error :




Cannot complete the install because one or more required items could not be found.
Software being installed: SpringSource...

http://static.springsource.org/spring/docs/3.0.1.RELEASE/api/

It should work .. check the API .. Make sure that you pass required parameters. Send me the code snippets which you are using. I will...

Hi Thomas,

I dont want to extract resultset. I want to pass the same result set object to XSU api in order to generate XML string. If I extract, it works fine which I have tested as well. But my...

Thomas,

Can you please respond to the above posting.

Thanks
Sudhakar

Thomas,

Thanks alot for all the help so far.

I have one more question for you ..

I have a stored function that returns 'nested cursor'. I am trying to call this function using below code,...

Hi

I have a quick question on -servlet.xml !

xyz.servlet.xml - am trying to deploy in weblogic app server and I have directory structure as WEB-INF/abc/xyz.servlet, but the deployment fails. Is...

Thanks Thomas. It works now.

Thomas,

You suggested some work around in some previous post as below :

For now, you probably could call "setAccessCallParameterMetaData(false)" and then leave out the "setCatalogName()" and...

You have replied to one of the post earlier that handling package name is a bug.

http://forum.springframework.org/showthread.php?t=47092&highlight=stored+function

Can u pls tell me the...

Thomas,

What I could notice here is 'package name' which is causing the problem.
I have created the same function without package name, then it works fine !!

But if we have packages in db, how...

Thomas,



public void setDataSource(DataSource dataSource) {
jdbcTemplate = new JdbcTemplate(dataSource);
jdbcTemplate.setResultsMapCaseInsensitive(true);
this.jdbcCall =...

Thomas,

I have tried in all possible ways but couldn't succeed. I have enabled debug, it says

WARN - Unable to locate the corresponding parameter for "in_entity_id" in the parameters used: []...

This is more simplified manner and it comes with Spring 2.5. No need to declare parameters.

Thomas,

Can you pls help me on nested cursor handling using SimpleJdbcCall. I tried my best, still it gives exception. Pls see previous post for more details.

Hi Thomas,

I am trying to call a stored function that returns Nested Cursor. Throws exception :

Stored Function :



FUNCTION ABC_lookup_data(in_tab in VARCHAR2, in_entity_id IN NUMBER )...

Thanks Thomas, it works now.

I have tried with other functions like queryForList(), didn't work. Can you pls suggest me the right method or any other of doing this.

Hi Thomas,

Hopefully this will be the last question for you.

when I tried to run the below code, gives exception.



public static Map getList(int i) {

Thank Thomas. It works fine.

Thomas,

One more question for you.

Now I am trying to call Oracle function which returns REF_CURSOR.

Stored Function :

I have done the same thing Thomas. Yes it works fine finally.
Thanks alot for all the help !!

I will post the final code in the forum tomw, so that it would be helpful for others as well.
...

No Thomas, it gives compilation error since it expects only ParameterizedRowMapper object in the second parameter.




this.jdbcCall =
new SimpleJdbcCall(jdbcTemplate)
...

Thanks alot for your time Thomas. It works fine now.

But I am not able to display the output. Means, I don't have any Actor bean, therefore passing as Object.class. Because i want to make this as...

Thomas,

I have some SOPs and now the exception appears different :



package com.sp.spd.dao.impl;

import java.util.HashMap;
import java.util.List;

Thomas,

I am sorry about the change in stored proc. Wanted to run simple stored proc, therefore its been changed to have one in-param and out-param.

I have tried as below



public...