Hi all,
I've discovered that as of the RC2 release, the layout imports fail with
Oracle (10g, in this case). It seems to be failing to insert a null String
as the name of a portlet preference. The offending entry is the first
JA-SIG test portlet instance in the admin.layout fragment file:
<entry entity="admin:/layout/root/tab[4]/column[1]/channel[2]"
channel="jasig-test-portlet" name="">
<value/>
<value/>
</entry>
This produces the following error:
[java] Caused by: java.sql.BatchUpdateException: ORA-01400: cannot
insert NULL into ("UPORTAL25"."UP_PORTLET_PREF"."NAME")
[java] at
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(
DatabaseError.java:367)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(
OraclePreparedStatement.java:9119)
[java] at org.apache.commons.dbcp.DelegatingStatement.executeBatch(
DelegatingStatement.java:294)
[java] at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(
BatchingBatcher.java:48)
[java] at org.hibernate.jdbc.AbstractBatcher.executeBatch(
AbstractBatcher.java:246)
[java] ... 87 more
After looking at the database, it appears that the column for "name" in the
UP_PORTLET_PREF table is a CLOB which is not allowed to be null. Is this
portlet preference entry not supposed to have a blank name, or is the import
tool supposed to try and set the name to an empty string rather than null,
or is the table column supposed to allow null entries?
- Jen
--
Join your friends and colleagues at JA-SIG 2008 - "Higher Education Solutions:
The Community Source Way!"
April 27th - 30th, 2008 in St. Paul, Minnesota USA
Featuring CAS, DSpace, Fedora, Fluid, Internet2, Kuali, Sakai, uPortal, and
more!
Information/Registration at:
http://www.ja-sig.org/conferences/08spring/index.html
Subscribe to the conference blog, The Community Source Way
http://jasig2008.blogspot.com, for news and updates about the event.
Join the Conference networking site at http://ja-sigspring08.crowdvine.com/
You are currently subscribed to [email protected] as: [EMAIL
PROTECTED]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/uportal-dev
