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
