Websphere issue with casting PreparedStatement to Oracle Prepared Statement

[Rene Smith]

I have a problem running on Websphere only with casting a PreparedStatement object to an OraclePreparedStatement object. The code I am using is as follows:

int BATCH_SIZE = 2000;
((OraclePreparedStatement)pstatementOra).setExecuteBatch(BATCH_SIZE);

The error I am getting is:
Error updating database.java.lang.ClassCastException: com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement


This code runs on our Apache Tomcat environment

Any help would be appreciated!

Thanks!

[David Hibbs]

This would definitely be something I would consider "non portable code". =)

WAS puts a facade layer around the connections pulled from its connection pool in order to properly preserve the connection, state, and operations performed. Hence, the cast in this sense is not possible.

AFAIK, it is not possible to access proprietary properties this way, though you can set custom properties on the datasource configuration.

I would suggest that a bartender move this to the WAS forum...

[David Harkness]

Originally posted by David Hibbs:
This would definitely be something I would consider "non portable code". =)

And yet, sometimes it's necessary.

AFAIK, it is not possible to access proprietary properties this way, though you can set custom properties on the datasource configuration.

If you're lucky, WSJdbcPreparedStatement contains a method to access the underlying PreparedStatement. If you find one, you can use

int BATCH_SIZE = 2000;
PreparedStatement ps = ...
WSJdbcPreparedStatement wasPs = (WSJdbcPreparedStatement) ps;
OraclePreparedStatement oraPs = (OraclePreparedStatement) wasPs.getPreparedStatement();
oraPs.setExecuteBatch(BATCH_SIZE);

[Dirk Schreckmann]

Rene,

Welcome to JavaRanch!

We ain't got many rules 'round these parts, but we do got one. Please change your display name to comply with The JavaRanch Naming Policy.

We request display names follow the pattern FIRST_NAME + SPACE + LAST_NAME.

Thanks Pardner! Hope to see you 'round the Ranch!

[patlo siva]

Hi Rene,
I am facing same problem in WSAD 5.0 version. Where as i am trying to get 'wasPs.getPreparedStatement()', but this method is not existed. Could you tell me which version of WSAD you are working on. My problem is i want to get preparedstatement as 'OraclePreparedStatement', Could any body suggets me how to get it. Thanks in advance.

thanks
Siva

[David Harkness]

I found it in WebLogic's PreparedStatement by disassembling it with javap. You might want to do the same to WebSphere's PS class.