Description Mitesh Meswani 2011-03-01 15:31:51 EST

Created attachment 190086 [details]
testapp sources with build scripts to reproduce the issue

We have an issue while inserting LOBs in Oracle when delimited identifiers are in effect.  The issue is caused at following line in Oracle10Platform  (Line 70 in my workspace) We get  exception at [1] while executing it

    java.sql.Blob blob = (java.sql.Blob)resultSet.getObject(field.getNameDelimited(this));

Attached is a test case that reproduces the issue. To execute unzip and modify build.properties and test.properties for your environment and execute "ant run"

This results in GlassFish issue http://java.net/jira/browse/GLASSFISH-16079

[1] Exception stack
[java] Caused by: java.sql.SQLException: Invalid column name     [java]
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)     [java]
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)     [java]
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)     [java]
at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:3047)     [java]
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1861)     [java]
at oracle.jdbc.driver.OracleResultSet.getObject(OracleResultSet.java:1547)     [java]
at org.eclipse.persistence.platform.database.oracle.Oracle10Platform.writeLOB(Oracle10Platform.java:70)     [java]
at org.eclipse.persistence.internal.helper.LOBValueWriter.fetchLocatorAndWriteValue(LOBValueWriter.java:92)     [java]