thanks for the input. but i need to know if there are any differences between the db schema of Fusion and J2. The problem seems to be in the OJB (broker) tables. I have already checked both but I don't see any differences between the set of table definitions.
Quoting [EMAIL PROTECTED]: > > > > > im fairly new to JetSpeed at this moment, so I can only provide eyes on the > error message. What I can see, at the line 2004-09-09 20:57:15,750 ; there > is an invalid column name insert, from a SQL statement, you might need to > check your insert statements.?? Anyways, sorry if this confuses the point.. > > > > > > > Jaq Marit <[EMAIL PROTECTED]> on 09/09/2004 22:45:05 > > Please respond to "Jetspeed Developers List" > <[EMAIL PROTECTED]> > > To: Jetspeed Developers List <[EMAIL PROTECTED]> > cc: > > Subject: HW_App with J1.6-dev/Fusion > > > I have successfully deployed J1.6-dev with Fusion. I built J2. I was > expecting > that the demo apps (HW_App) from J2 can be successfully deployed on > J1.6-dev/Fusion. Is this really true? Am I missing some things? I get > the > following error on Tomcat 5/J2SDK 1.4.2: > > 2004-09-09 20:57:08,578 [main] INFO deployment - Using PDEF NAME > portlet_definition > 2004-09-09 20:57:08,578 [main] INFO deployment - Using PAPP NAME > portlet_application > 2004-09-09 20:57:08,609 [main] INFO deployment - Deployment server port: > 8080 > 2004-09-09 20:57:08,609 [main] INFO deployment - Deployment server: > localhost > 2004-09-09 20:57:12,562 [main] INFO deployment - Starting auto deployment > service: org.apache.jetspeed.deployment.impl.StandardDeploymentManager > 2004-09-09 20:57:12,562 [main] INFO deployment - Deployment scanning > delay: > 10000 > 2004-09-09 20:57:12,562 [main] INFO deployment - Deployment staging > directory: > C:\java\j1.6dev-tomcat\webapps\jetspeed/WEB-INF/deploy > 2004-09-09 20:57:12,562 [main] INFO deployment - Deployment scanner > successfuly > started! > 2004-09-09 20:57:13,250 [Autodeployment File Scanner Thread] INFO > deployment - > Loading portlet application from web archive > C:\java\j1.6dev-tomcat\webapps\jetspeed\WEB-INF\deploy\demo.war > 2004-09-09 20:57:13,593 [Autodeployment File Scanner Thread] INFO > deployment - > Preparing to (re) deploy portlet app "HW_App" > 2004-09-09 20:57:13,593 [Autodeployment File Scanner Thread] INFO > deployment - > Deploying portlet applicaion WAR demo.war > 2004-09-09 20:57:13,593 [Autodeployment File Scanner Thread] INFO > deployment - > Portlet application deployment target directory is > C:\java\j1.6dev-tomcat\webapps\jetspeed/..//HW_App > 2004-09-09 20:57:15,531 [Autodeployment File Scanner Thread] INFO > deployment - > Loading web.xml into memory.... > 2004-09-09 20:57:15,593 [Autodeployment File Scanner Thread] INFO > deployment - > Saving the portlet.xml in the registry... > 2004-09-09 20:57:15,750 [Autodeployment File Scanner Thread] ERROR > deployment - > Unable to register portlet application, HW_App, through the portlet > registry: > org.apache.ojb.broker.PersistenceBrokerSQLException: SQL failure while > insert > object data for class > org.apache.jetspeed.om.portlet.impl.PortletDefinitionImpl, PK of the given > object is [ id=21], object was > [EMAIL PROTECTED], > exception > message is [ORA-00904: invalid column name > ] > org.apache.ojb.broker.PersistenceBrokerSQLException: SQL failure while > insert > object data for class > org.apache.jetspeed.om.portlet.impl.PortletDefinitionImpl, PK of the given > object is [ id=21], object was > [EMAIL PROTECTED], > exception > message is [ORA-00904: invalid column name > ] > at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown > Source) > at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown > Source) > at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) > at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.storeAndLinkOneToMany(Unknown > > Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.storeCollections(Unknown > Source) > at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown > Source) > at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) > at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) > at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown > Source) > at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown > Source) > at > org.apache.jetspeed.components.persistence.store.ojb.pb.PBStore.store(PBStore.java:407) > > at > org.apache.jetspeed.components.persistence.store.ojb.pb.PBStore.makePersistent(PBStore.java:384) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:59) > > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:138) > > at $Proxy0.makePersistent(Unknown Source) > at > org.apache.jetspeed.components.portletregistry.PortletRegistryComponentImpl.registerPortletApplication(PortletRegistryComponentImpl.java:407) > > at > org.apache.jetspeed.tools.pamanager.FileSystemPAM.registerApplication(FileSystemPAM.java:384) > > at > org.apache.jetspeed.tools.pamanager.FileSystemPAM.sysDeploy(FileSystemPAM.java:304) > > at > org.apache.jetspeed.tools.pamanager.FileSystemPAM.deploy(FileSystemPAM.java:120) > > at > org.apache.jetspeed.fusion.tools.pamanager.FusionPAM.deploy(FusionPAM.java:174) > > at > org.apache.jetspeed.fusion.tools.pamanager.FusionAppServerPAM.deploy(FusionAppServerPAM.java:76) > > at > org.apache.jetspeed.deployment.impl.DeployPortletAppEventListener.doDeploy(DeployPortletAppEventListener.java:251) > > at > org.apache.jetspeed.deployment.impl.DeployPortletAppEventListener.invokeDeploy(DeployPortletAppEventListener.java:164) > > at > org.apache.jetspeed.deployment.impl.StandardDeploymentManager.dispatch(StandardDeploymentManager.java:305) > > at > org.apache.jetspeed.deployment.impl.StandardDeploymentManager.fireDeploymentEvent(StandardDeploymentManager.java:196) > > at > org.apache.jetspeed.deployment.impl.StandardDeploymentManager$FileSystemScanner.run(StandardDeploymentManager.java:459) > > Caused by: java.sql.SQLException: ORA-00904: invalid column name > > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) > at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) > at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) > at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451) > at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862) > at > oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1846) > > at > oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1771) > > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2361) > > at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422) > > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) > > ... 31 more > > > I am wondering if there are some inconsistencies with my database schema > and so > I compared the database schema with my deployed J2 and J1.6-dev/Fusion and > they > are exactly the same. What is possibly wrong? > > Thanks for your inputs... > > ---------------------------------------------------------------- > This message was sent using IMP, the Internet Messaging Program. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
