]
Randall Hauch reassigned DNA-515:
---------------------------------
Assignee: Randall Hauch
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: