dbUnit / Bugs / #373 org.apache.commons.dbcp.DelegatingPreparedStatement cannot be cast to oracle.jdbc.OraclePreparedStatement

#373 org.apache.commons.dbcp.DelegatingPreparedStatement cannot be cast to oracle.jdbc.OraclePreparedStatement

Milestone: v2.5.*

Status: pending

Owner: Jeff Jensen

Labels: None

Fixed Release: (not fixed)

Priority: 5

Updated: 2016-04-17

Created: 2015-10-01

Creator: shpelda2

Private: No

When configured oracle connection, i got a classcast exception.
Fixed by extracting the delegate.

org.apache.commons.dbcp.DelegatingPreparedStatement cannot be cast to oracle.jdbc.OraclePreparedStatement

Both stack and fixed class attached.

2 Attachments

OracleNClobDataType.java

Discussion

Jeff Jensen - 2015-10-10

Thanks for reporting the issue and providing a fix.

In the changes, org.apache.commons.dbcp.DelegatingPreparedStatement is not in the current set of dbUnit dependencies. Is it part of your test setup? As is, we can't apply this.

Please let me know your setup and next suggestions.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jeff Jensen - 2015-10-10

status: open --> pending

assigned_to: Jeff Jensen
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

shpelda2 - 2015-10-20

Delegating prepared statement comes from https://commons.apache.org/proper/commons-dbcp/. Fix that I provided is a hack. You should never downcast that statement. That code should be agnostic to jdbc driver.
See https://docs.oracle.com/cd/B14117_01/server.101/b10749/ch7progrunicode.htm, section "Using the SQL NCHAR Datatypes Without Changing the Code"

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jeff Jensen - 2016-04-17

If you are interested, please provide a test(s) and patch.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.