[OPENJPA-516] Exceptions when persisting Entities with fields map to NVARCHAR columns

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0, 1.0.1, 1.0.2
• Fix Version/s: 1.1.0
• Component/s: jdbc
• Environment: Test run on windows against Oracle
• Assignee: Srinivasa Segu
• Reporter: Srinivasa Segu
• Created: 14/Feb/08 21:01
• Updated: 09/Mar/10 18:32
• Resolved: 14/Feb/08 21:46

Description

Attempting to persist the entity results in a SQLException. Appears that the value for the NVARCHAR column is not being set.

Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Missing IN or OUT parameter at index:: 2

{prepstmnt 22481221 INSERT INTO Holder (id, STRING_FIELD) VALUES (?, ?) [params=(long) 51]}

[code=17041, state=null]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$800(LoggingConnectionDecorator.java:57)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:858)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1363)
at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:97)