Any ideas on how I can get Jetspeed installed? Thanks! Sandi Dahl, Software Engineer | TDI Inc. | 17255 N 82nd Street, Scottsdale AZ 85255| P: 480.538.7747 | F: 480.515.7447
-----Original Message----- From: Dahl, Sandra [mailto:sd...@tdiinc.com] Sent: Wednesday, August 12, 2009 8:28 AM To: Jetspeed Users List Subject: RE: Error installing Jetspeed 2.2.0: Invalid object name 'SECURITY_DOMAIN' I specified a MS SqlServer DB during the installation. Here is the database.properties file: ; Jetspeed Enterprise Portal 2.2.0 Database setup configuration ; db.type supported values: db2, derby, mssql, mysql, oracle, postgres, sapdb db.type=mssql : for db.type other than derby, the properties below need to be specified db.username=xxxxx db.password=xxxxx jdbc.url=jdbc:jtds:sqlserver://localhost/jetspeed jdbc.driver.class=net.sourceforge.jtds.jdbc.Driver ; boolean flag (true/false) indicating if psml is to be imported in the database or will be read from file system dbImportPsml = false Sandi Dahl, Software Engineer | TDI Inc. | 17255 N 82nd Street, Scottsdale AZ 85255| P: 480.538.7747 | F: 480.515.7447 -----Original Message----- From: Ron Wheeler [mailto:rwhee...@artifact-software.com] Sent: Wednesday, August 12, 2009 5:47 AM To: Jetspeed Users List Subject: Re: Error installing Jetspeed 2.2.0: Invalid object name 'SECURITY_DOMAIN' Looks like a mixture of Hsqldb and Derby Ron wat...@wispertel.net wrote: > Sandra, > > Did you get that installer from the website download area? > > Just making sure before I try to duplicate. > > Randy > > --- sd...@tdiinc.com wrote: > > From: "Dahl, Sandra" <sd...@tdiinc.com> > To: "jetspeed-user@portals.apache.org" <jetspeed-user@portals.apache.org> > Subject: Error installing Jetspeed 2.2.0: Invalid object name > 'SECURITY_DOMAIN' > Date: Tue, 11 Aug 2009 12:06:32 -0700 > > I am new to Jetspeed and trying to install and run the demo for 2.2.0 and > getting an error during installation. I am running on windows and am > installing in c:\jetspeed. It appears the database access is ok because > tables were created in the database by the installation. Am I missing > something? Here is the output from the install: > > antinstaller.jarC:\Temp\jetspeed-installer-demo-2.2.0.jar > > install: > [echo] Starting the installation > [echo] Deleting all content from the installation target directory > [echo] Installing Jetspeed-2.2.0 Enterprise Portal > [unzip] Expanding: C:\Temp\jetspeed-installer-demo-2.2.0.jar into > C:\Jetspeed-2.2.0 > [unzip] Expanding: C:\Jetspeed-2.2.0\database.zip into C:\Jetspeed-2.2.0 > [unzip] Expanding: C:\Jetspeed-2.2.0\tomcat-portal.zip into > C:\Jetspeed-2.2.0 > [echo] Setting up the database configuration > [copy] Copying 1 file to C:\Jetspeed-2.2.0\lib > [move] Moving 1 file to C:\Jetspeed-2.2.0\database > [echo] Moving pages out of jetspeed webapp > [move] Moving 1 file to C:\Jetspeed-2.2.0\webapps\jetspeed\WEB-INF\conf > [move] Moving 1 file to C:\Jetspeed-2.2.0\webapps\jetspeed\WEB-INF\conf > [echo] Setting up the Jetspeed database (if selected) > > checkDerby: > > checkImportPsml: > > generateStandardDB: > [echo] Cleaning up possible existing database > [sql] Executing resource: > C:\Jetspeed-2.2.0\database\mssql\drop-schema.sql > [sql] 137 of 137 SQL statements executed successfully > [echo] Starting database generation > [sql] Executing resource: > C:\Jetspeed-2.2.0\database\mssql\create-schema.sql > [sql] 196 of 196 SQL statements executed successfully > [echo] Database generation done! > > generateDerbyDB: > > copyJetspeedContext: > [copy] Copying 1 file to C:\Jetspeed-2.2.0\conf\Catalina\localhost > > filterSpringFilterKey: > > filterSpringFilterKey_db: > > filterSpringFilterKey_file: > [copy] Copying 1 file to C:\Jetspeed-2.2.0\webapps\jetspeed\WEB-INF\conf > Seeding the database > [java] ##### platform = Hsqldb > [java] [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: > SQLException during the execution of the query (for > org.apache.jetspeed.security.impl.SecurityDomainImpl): Invalid object name > 'SECURITY_DOMAIN'. > [java] Invalid object name 'SECURITY_DOMAIN'. > [java] java.sql.SQLException: Invalid object name 'SECURITY_DOMAIN'. > [java] at > net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) > [java] at > net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) > [java] at > net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) > [java] at > net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) > [java] at > net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477) > [java] at > net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) > [java] at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:312) > [java] at > org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74) > [java] at > org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:185) > [java] at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58) > [java] at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1918) > [java] at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1493) > [java] at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(PersistenceBrokerImpl.java:1620) > [java] at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307) > [java] at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307) > [java] at > org.springframework.orm.ojb.PersistenceBrokerTemplate$2.doInPersistenceBroker(PersistenceBrokerTemplate.java:184) > [java] at > org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:138) > [java] at > org.springframework.orm.ojb.PersistenceBrokerTemplate.getObjectByQuery(PersistenceBrokerTemplate.java:182) > [java] at > org.apache.jetspeed.security.spi.impl.JetspeedSecurityPersistenceManager.getDomainByName(JetspeedSecurityPersistenceManager.java:1052) > [java] at > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > [java] at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > [java] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > [java] at java.lang.reflect.Method.invoke(Method.java:597) > [java] at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) > [java] at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) > [java] at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) > [java] at > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) > [java] at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) > [java] at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) > [java] at $Proxy4.getDomainByName(Unknown Source) > [java] at > org.apache.jetspeed.serializer.JetspeedSecuritySerializer.checkDomainExistsOtherwiseCreate(JetspeedSecuritySerializer.java:233) > [java] at > org.apache.jetspeed.serializer.JetspeedSecuritySerializer.recreateSecurityDomains(JetspeedSecuritySerializer.java:253) > [java] at > org.apache.jetspeed.serializer.JetspeedSecuritySerializer.processImport(JetspeedSecuritySerializer.java:172) > [java] at > org.apache.jetspeed.serializer.AbstractJetspeedComponentSerializer.processImport(AbstractJetspeedComponentSerializer.java:47) > [java] at > org.apache.jetspeed.serializer.JetspeedSerializerImpl.importData(JetspeedSerializerImpl.java:131) > [java] at > org.apache.jetspeed.tools.db.serializer.JetspeedSerializerApplicationImpl.importFiles(JetspeedSerializerApplicationImpl.java:189) > [java] at > org.apache.jetspeed.tools.db.serializer.JetspeedSerializerApplicationImpl.main(JetspeedSerializerApplicationImpl.java:117) > [java] org.apache.jetspeed.serializer.SerializerException: Creating an > instance from a serialized representation of SecurityDomains failed with > message Could not create default and / or system domains! > [java] OJB operation; bad SQL grammar []; nested exception is > java.sql.SQLException: Invalid object name 'SECURITY_DOMAIN'. > [java] at > org.apache.jetspeed.serializer.JetspeedSecuritySerializer.recreateSecurityDomains(JetspeedSecuritySerializer.java:256) > [java] at > org.apache.jetspeed.serializer.JetspeedSecuritySerializer.processImport(JetspeedSecuritySerializer.java:172) > [java] at > org.apache.jetspeed.serializer.AbstractJetspeedComponentSerializer.processImport(AbstractJetspeedComponentSerializer.java:47) > [java] at > org.apache.jetspeed.serializer.JetspeedSerializerImpl.importData(JetspeedSerializerImpl.java:131) > [java] at > org.apache.jetspeed.tools.db.serializer.JetspeedSerializerApplicationImpl.importFiles(JetspeedSerializerApplicationImpl.java:189) > [java] at > org.apache.jetspeed.tools.db.serializer.JetspeedSerializerApplicationImpl.main(JetspeedSerializerApplicationImpl.java:117) > [java] Caused by: org.springframework.jdbc.BadSqlGrammarException: OJB > operation; bad SQL grammar []; nested exception is java.sql.SQLException: > Invalid object name 'SECURITY_DOMAIN'. > [java] at > org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97) > [java] at > org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) > [java] at > org.springframework.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107) > [java] at > org.springframework.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89) > [java] at > org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141) > [java] at > org.springframework.orm.ojb.PersistenceBrokerTemplate.getObjectByQuery(PersistenceBrokerTemplate.java:182) > [java] at > org.apache.jetspeed.security.spi.impl.JetspeedSecurityPersistenceManager.getDomainByName(JetspeedSecurityPersistenceManager.java:1052) > [java] at > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > [java] at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > [java] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > [java] at java.lang.reflect.Method.invoke(Method.java:597) > [java] at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) > [java] at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) > [java] at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) > [java] at > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) > [java] at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) > [java] at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) > [java] at $Proxy4.getDomainByName(Unknown Source) > [java] at > org.apache.jetspeed.serializer.JetspeedSecuritySerializer.checkDomainExistsOtherwiseCreate(JetspeedSecuritySerializer.java:233) > [java] at > org.apache.jetspeed.serializer.JetspeedSecuritySerializer.recreateSecurityDomains(JetspeedSecuritySerializer.java:253) > [java] ... 5 more > [java] Caused by: java.sql.SQLException: Invalid object name > 'SECURITY_DOMAIN'. > [java] at > net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) > [java] at > net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) > [java] at > net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) > [java] at > net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) > [java] at > net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477) > [java] at > net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) > [java] at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:312) > [java] at > org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74) > [java] at > org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:185) > [java] at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58) > [java] at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1918) > [java] at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1493) > [java] at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(PersistenceBrokerImpl.java:1620) > [java] at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307) > [java] at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307) > [java] at > org.springframework.orm.ojb.PersistenceBrokerTemplate$2.doInPersistenceBroker(PersistenceBrokerTemplate.java:184) > [java] at > org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:138) > [java] ... 20 more > [java] Exception in thread "main" > org.apache.jetspeed.serializer.SerializerException: Creating an instance from > a serialized representation of SecurityDomains failed with message Could not > create default and / or system domains! > [java] OJB operation; bad SQL grammar []; nested exception is > java.sql.SQLException: Invalid object name 'SECURITY_DOMAIN'. > [java] at > org.apache.jetspeed.serializer.JetspeedSecuritySerializer.recreateSecurityDomains(JetspeedSecuritySerializer.java:256) > [java] at > org.apache.jetspeed.serializer.JetspeedSecuritySerializer.processImport(JetspeedSecuritySerializer.java:172) > [java] at > org.apache.jetspeed.serializer.AbstractJetspeedComponentSerializer.processImport(AbstractJetspeedComponentSerializer.java:47) > [java] at > org.apache.jetspeed.serializer.JetspeedSerializerImpl.importData(JetspeedSerializerImpl.java:131) > [java] at > org.apache.jetspeed.tools.db.serializer.JetspeedSerializerApplicationImpl.importFiles(JetspeedSerializerApplicationImpl.java:189) > [java] at > org.apache.jetspeed.tools.db.serializer.JetspeedSerializerApplicationImpl.main(JetspeedSerializerApplicationImpl.java:117) > [java] Caused by: org.springframework.jdbc.BadSqlGrammarException: OJB > operation; bad SQL grammar []; nested exception is java.sql.SQLException: > Invalid object name 'SECURITY_DOMAIN'. > [java] at > org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97) > [java] at > org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) > [java] at > org.springframework.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107) > [java] at > org.springframework.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89) > [java] at > org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141) > [java] at > org.springframework.orm.ojb.PersistenceBrokerTemplate.getObjectByQuery(PersistenceBrokerTemplate.java:182) > [java] at > org.apache.jetspeed.security.spi.impl.JetspeedSecurityPersistenceManager.getDomainByName(JetspeedSecurityPersistenceManager.java:1052) > [java] at > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > [java] at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > [java] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > [java] at java.lang.reflect.Method.invoke(Method.java:597) > [java] at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) > [java] at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) > [java] at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) > [java] at > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) > [java] at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) > [java] at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) > [java] at $Proxy4.getDomainByName(Unknown Source) > [java] at > org.apache.jetspeed.serializer.JetspeedSecuritySerializer.checkDomainExistsOtherwiseCreate(JetspeedSecuritySerializer.java:233) > [java] at > org.apache.jetspeed.serializer.JetspeedSecuritySerializer.recreateSecurityDomains(JetspeedSecuritySerializer.java:253) > [java] ... 5 more > [java] Caused by: java.sql.SQLException: Invalid object name > 'SECURITY_DOMAIN'. > [java] at > net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) > [java] at > net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) > [java] at > net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) > [java] at > net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) > [java] at > net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477) > [java] at > net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777) > [java] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) > [java] at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:312) > [java] at > org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74) > [java] at > org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:185) > [java] at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58) > [java] at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1918) > [java] at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1493) > [java] at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(PersistenceBrokerImpl.java:1620) > [java] at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307) > [java] at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307) > [java] at > org.springframework.orm.ojb.PersistenceBrokerTemplate$2.doInPersistenceBroker(PersistenceBrokerTemplate.java:184) > [java] at > org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:138) > [java] ... 20 more > > > > Sandi Dahl<mailto:sd...@tdiinc.com>, Software Engineer | TDI > Inc.<http://www.tdiinc.com/> | 17255 N 82nd Street, Scottsdale AZ 85255| P: > 480.538.7747 | F: 480.515.7447 > > > > ________________________________ > Confidentiality Notice: > The information contained in this communication, including attachments, is > privileged and confidential. It is intended only for the exclusive use of the > addressee. If the reader is not the intended recipient, or the employee, or > the agent responsible for delivering it to the intended recipient, you are > hereby notified that any dissemination, distribution or copying of this > communication is strictly prohibited. If you have received this communication > in error, please notify us by return email or telephone immediately. Thank > you. > > > --------------------------------------------------------------------- To unsubscribe, e-mail: jetspeed-user-unsubscr...@portals.apache.org For additional commands, e-mail: jetspeed-user-h...@portals.apache.org Email secured by Check Point Confidentiality Notice: The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader is not the intended recipient, or the employee, or the agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us by return email or telephone immediately. Thank you. Confidentiality Notice: The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader is not the intended recipient, or the employee, or the agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us by return email or telephone immediately. Thank you.
