You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by "Dahl, Sandra" <SD...@TDIinc.com> on 2009/08/12 00:00:08 UTC
RE: [SPAM] Re: Error installing Jetspeed 2.2.0: Invalid object
name 'SECURITY_DOMAIN'
Yes. Here is where I downloaded: http://portals.apache.org/jetspeed-2/download.html.
Sandi Dahl, Software Engineer | TDI Inc. | 17255 N 82nd Street, Scottsdale AZ 85255| P: 480.538.7747 | F: 480.515.7447
-----Original Message-----
From: watler@wispertel.net [mailto:watler@wispertel.net]
Sent: Tuesday, August 11, 2009 2:55 PM
To: Jetspeed Users List
Subject: [SPAM] Re: Error installing Jetspeed 2.2.0: Invalid object name 'SECURITY_DOMAIN'
Importance: Low
Sandra,
Did you get that installer from the website download area?
Just making sure before I try to duplicate.
Randy
--- SDahl@TDIinc.com wrote:
From: "Dahl, Sandra" <SD...@TDIinc.com>
To: "jetspeed-user@portals.apache.org" <je...@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<ma...@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.
f��ǜ���o �y��)
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.