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:[email protected]]
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:[email protected]]
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
[email protected] wrote:
Sandra,
Did you get that installer from the website download area?
Just making sure before I try to duplicate.
Randy
--- [email protected] wrote:
From: "Dahl, Sandra" <[email protected]>
To: "[email protected]"
<[email protected]>
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:[email protected]>, 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: [email protected]
For additional commands, e-mail: [email protected]
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.