[dna-issues] [JBoss JIRA] Commented: (DNA-515) JPA connector reports error when inserting default (and blank) namespace URI into Oracle database

[Randall Hauch (JIRA)]

    [ https://jira.jboss.org/jira/browse/DNA-515?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12485408#action_12485408 ] 

Randall Hauch commented on DNA-515:
-----------------------------------

Although the previous change did address the possibility that Oracle will return null, it did not yet change the Hibernate annotations to allow for a null URI value.  Changing the NamespaceEntity annotations to account for null values.

> JPA connector reports error when inserting default (and blank) namespace URI into Oracle database
> -------------------------------------------------------------------------------------------------
>
>                 Key: DNA-515
>                 URL: https://jira.jboss.org/jira/browse/DNA-515
>             Project: DNA
>          Issue Type: Bug
>          Components: Connectors
>    Affects Versions: 0.6
>            Reporter: Randall Hauch
>            Assignee: Randall Hauch
>            Priority: Blocker
>             Fix For: 0.6
>
>         Attachments: DNA-515.patch
>
>
> The user meetoblivion reported on the forums [1] that he was getting an error when he called
>       session.getRootNode().addNode("somepage")
> and 
>       session.getRootNode().addNode("somepage","nt:unstructured");
> The full stack trace is listed on the forum thread, but the relevant part is here:
>       2009-09-08 10:45:10,059 WARN  [org.hibernate.util.JDBCExceptionReporter] (pool-159-thread-2) SQL Error: 1400, SQLState: 23000
>       2009-09-08 10:45:10,108 ERROR [org.hibernate.util.JDBCExceptionReporter] (pool-159-thread-2) ORA-01400: cannot insert NULL into ("JCRPUBLIC"."DNA_NAMESPACES"."URI")
>       2009-09-08 10:45:10,108 WARN  [org.hibernate.util.JDBCExceptionReporter] (pool-159-thread-2) SQL Error: 1400, SQLState: 23000
>       2009-09-08 10:45:10,108 ERROR [org.hibernate.util.JDBCExceptionReporter] (pool-159-thread-2) ORA-01400: cannot insert NULL into ("JCRPUBLIC"."DNA_NAMESPACES"."URI")
> Oracle doesn't like empty VARCHAR values, and attempts instead to insert a NULL value rather than the empty VARCHAR value.  This is currently a problem, because the DNA_NAMESPACES.URI column is not nullable.
> [1] http://www.jboss.org/index.html?module=bb&op=viewtopic&t=160723

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira