Compound Key Attribute Causes DataCreationException: JBO-25009 in JDev 11.1.2 (Doc ID 1362985.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle JDeveloper - Version 11.1.2.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 04-Jun-2013***

Symptoms

In JDeveloper 11.1.2.0.0, your ADF Business Components Model includes a View Object with multiple Key attributes of different types, eg Integer and String.
Your ADF BC Model project was created with the "Data Type Map" = "Java Extended for Oracle".

When you run your application and create a new record for that View Object, you get the following error/stack trace:

oracle.jbo.domain.DataCreationException: JBO-25009: Cannot create an object of type:<aType> from type:<anotherType> with value:<theValue>
at oracle.jbo.domain.Number$1.convert(Number.java:73)
at oracle.jbo.domain.TypeFactory.get(TypeFactory.java:854)
at oracle.jbo.domain.TypeFactory.getInstance(TypeFactory.java:101)
at oracle.jbo.server.AttributeDefImpl.convertToJava(AttributeDefImpl.java:2219)
at oracle.jbo.server.ViewRowSetImpl.prepKeyForFind(ViewRowSetImpl.java:5367)
at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5384)
at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5286)
...
## Detail 0 ##
java.lang.NumberFormatException: For input string: "<theValue>"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:447)
at java.lang.Integer.valueOf(Integer.java:553)
at oracle.jbo.common.JboTypeMapEntries$1.convert(JboTypeMapEntries.java:106)
at oracle.jbo.domain.TypeFactory.get(TypeFactory.java:854)
...



You have this problem when you create this application from scratch in JDeveloper 11.1.2.0.0.
The same application created in JDeveloper 11g release 1 (eg 11.1.1.5.0), is working without any error.
Also, this application migrated to JDeveloper 11g Release 2 still works correctly.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms