Oracle error 1400

[Ma...@Lazard.com]

I am seeing this exception in my Weblogic jdbc log while attempting to deploy
jpetstore.war by placing it into the jetspeed/WEB-INF/deploy directory running
under Weblogic 8.1:

java.sql.SQLException: ORA-01400: cannot insert NULL into
("LDM_ADMIN"."PORTLET_ENTITY"."APP_NAME")


      at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)

      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)

      at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)

      ...

      at
org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:167)

      at
org.springframework.orm.ojb.PersistenceBrokerTemplate.store(PersistenceBrokerTemplate.java:265)

      at
org.apache.jetspeed.components.portletentity.PersistenceBrokerPortletEntityAccess.storePreferenceSet(PersistenceBrokerPortletEntityAccess.java:345)

      at
org.apache.jetspeed.components.portletentity.PortletEntityImpl.store(PortletEntityImpl.java:253)

      at
org.apache.jetspeed.components.portletentity.PortletEntityImpl.store(PortletEntityImpl.java:241)

      at
org.apache.jetspeed.components.portletentity.PersistenceBrokerPortletEntityAccess.storePortletEntity(PersistenceBrokerPortletEntityAccess.java:322)

Any insight into why this is happening and how I can fix it would be greatly
appreciated.

Mark



---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org

Re: Oracle error 1400

[David Sean Taylor <da...@bluesunrise.com>]

Mark.Easparro@Lazard.com wrote:
> I am seeing this exception in my Weblogic jdbc log while attempting to deploy
> jpetstore.war by placing it into the jetspeed/WEB-INF/deploy directory running
> under Weblogic 8.1:
> 
> java.sql.SQLException: ORA-01400: cannot insert NULL into
> ("LDM_ADMIN"."PORTLET_ENTITY"."APP_NAME")
> 

With Weblogic, you will need to prepare your portlet app for deployment 
using the deploy tool. See:

http://portals.apache.org/jetspeed-2/multiproject/jetspeed-deploy-tools/deploy-tools.html

Recently I changed the build so that all the Jetspeed portlet 
applications are ready for deployment in any application server
With the 2.1 release, we are not deprecating the WEB-INF/deploy 
directory, but we are trying to better support other app servers 
(besides Tomcat), since the WEB-INF/deploy solution was a Tomcat only 
solution

What I've been doing for Weblogic is:

1. build or install Jetspeed as usual (for Tomcat)
2. edit the config.xml (or deploy using the administrator), add entries 
such as:

<Application LoadOrder="201" Name="j2admin"
         Path="/home/david/tomcat/webapps" TwoPhase="true">
         <WebAppComponent Name="j2admin" Targets="myserver" URI="j2admin"/>
</Application>

3. edit the classpath in the startmydomain.sh/cmd file for the 
shared/lib files

The procedure above is not for production, just a verification of 
Jetspeed running on Weblogic 8.1 to get you going.


We are working on tools in 2.1 to install Jetspeed, populate the 
database separate from the build, and migrate databases from older 
versions when new releases come out



---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org