[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=12485050#action_12485050 ] 

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

I applied the patch locally, and tried running the JPA connector unit tests against PostgreSQL 8.4, and all unit tests passed.  I also changed the JpaRepositoryTckTest configuration to run against a local PostgreSQL database, and everything passed except for 1 failure and 1 error, but in fact I get these same two issues when I run against HSQLDB (and have been for some time).  Interestingly, the nightly Hudson integration job ran last night, and has had no problems.

So in short, I think this patch looks good so far (at least with HSQLDB and PostgreSQL), though I'll have to see if I can test against Oracle tomorrow.

> 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
>            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