Search:

When I changed the filtering on both profilers to provide more detailed information, they both showed the majority of the time being spent in the mapRow method, specifically, in the Oracle calls...

I'm profiling an application, and finding that significant time is being spent processing the result set from a stored procedure.

The problem is that JProbe gives one set of statistics and IBM's...

The cause of the exception was a test in the stored procedure of the XMLType argument. The argument is declared with a default value in the stored proc as follows:

p_claim_attribute_xml_in IN...

Minor point, but in testing, I found that the exception is thrown at > 4,000 characters, not 4KB, i.e. 4.096 characters.

Hi Thomas,

I implemented your suggestion, and it worked after I assigned the argument to my execute method, documentDvo, to a final temp variable within the method:


final DocumentDVO...

Thanks. I'll try this and let you know the results.

Thomas,

Thanks for your help. The attached class contains the method, saveDocument, which invokes a stored procedure with an XMLTYPE parameter. Here is the specific statement:
...

Using Spring's support for stored procedures, how can I specify a parameter of type oracle.xdb.XMLType?

Currently, the constructor of my subclass of org.springframework.jdbc.object.StoredProcedure...

Nevermind.
I went back to the reference doc, and realized I need a singleton property in the body of the bean definition for the ProxyFactoryBean.

Cheers,
Ed

I reviewed this thread, as I have discovered that I am receiving the same singleton from a ProxyFactoryBean when I expect unique instances.
I have followed Perryn's example and replaced target with...

Can anyone confirm that they are able to access a native Oracle jdbc connection via WebSphereNativeJdbcExtractor in Websphere 6.0, and use it for Oracle proprietary functions? It was my...

Excellent. Thank you very much.

The network performance group at my organization has been analyzing the Oracle database network traffic, and they recommend increasing the array size of the prefetch buffer (The default size is 10). ...

Sweet! :D
I just joined the forum, because I had exactly the same question. I entered "enumeration" as my search criterion, found this thread, and have my answer. Life is good.
Thanks!
Ed