Thank you for your response. I manually created the MS SqlServer db using the scripts provided. I did a brand new Jetspeed install pointing to the MS SqlServer db. I copied my jdbc driver into C:\Jetspeed-2.2.0\lib and am getting the following error. Do I have the driver in the wrong location?
2009-08-17 12:28:29,964 [http-8080-1] ERROR diagnostics - Id: FYHLMJUK Time: MST 2009-08-17 12:28:29:948 Thread: Thread[http-8080-1,5,main] Internal: false Server: http://localhost:8080 Remote IP address: 127.0.0.1 Local IP address: 127.0.0.1 Context path: /jetspeed Servlet path: /portal Request URI: /jetspeed/portal Request method: GET Error message: java.lang.ClassNotFoundException: ${org.apache.jetspeed.production.database.driver} Exception: javax.servlet.ServletException: Failed to initalize jetspeed. org.apache.jetspeed.exception.JetspeedException: Jetspeed Initialization exception! at: org.apache.jetspeed.engine.JetspeedServlet.doGet(JetspeedServlet.java:275) at: javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at: javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at: org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at: org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at: org.apache.jetspeed.engine.servlet.XXSUrlAttackFilter.doFilter(XXSUrlAttackFilter.java:52) at: org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at: org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at: org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at: org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at: org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at: org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at: org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at: org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at: org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at: org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at: org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at: org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at: java.lang.Thread.run(Thread.java:619) caused by: org.apache.jetspeed.exception.JetspeedException: Jetspeed Initialization exception! at: org.apache.jetspeed.engine.JetspeedEngine.start(JetspeedEngine.java:142) at: org.apache.jetspeed.engine.JetspeedServlet.init(JetspeedServlet.java:208) at: org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1172) at: org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:992) at: org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4058) at: org.apache.catalina.core.StandardContext.start(StandardContext.java:4371) at: org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) at: org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) at: org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at: org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926) at: org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889) at: org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492) at: org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149) at: org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) at: org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117) at: org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at: org.apache.catalina.core.StandardHost.start(StandardHost.java:719) at: org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at: org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at: org.apache.catalina.core.StandardService.start(StandardService.java:516) at: org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at: org.apache.catalina.startup.Catalina.start(Catalina.java:578) 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:597) at: org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at: org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'PlatformConfigurator' defined in ServletContext resource [/WEB-INF/assembly/boot/datasource.xml]: Invocation of init method failed; nested exception is org.apache.ojb.broker.metadata.MetadataException: Could not get the metadata from the given datasource at: org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1338) at: org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473) at: org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at: java.security.AccessController.doPrivileged(Native Method) at: org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at: org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at: org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at: org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at: org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at: org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at: org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429) at: org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728) at: org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380) at: org.apache.jetspeed.components.SpringComponentManager.start(SpringComponentManager.java:297) at: org.apache.jetspeed.engine.JetspeedEngine.start(JetspeedEngine.java:119) at: org.apache.jetspeed.engine.JetspeedServlet.init(JetspeedServlet.java:208) ... 26 more caused by: org.apache.ojb.broker.metadata.MetadataException: Could not get the metadata from the given datasource at: org.apache.ojb.broker.metadata.JdbcMetadataUtils.fillJCDFromDataSource(JdbcMetadataUtils.java:277) at: org.apache.jetspeed.components.rdbms.ojb.DatabasePlatformConfigurator.init(DatabasePlatformConfigurator.java:70) 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:597) at: org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1414) at: org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1375) at: org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335) at: org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473) ... 40 more caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class '${org.apache.jetspeed.production.database.driver}' at: org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136) at: org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) at: org.apache.ojb.broker.metadata.JdbcMetadataUtils.fillJCDFromDataSource(JdbcMetadataUtils.java:261) at: org.apache.jetspeed.components.rdbms.ojb.DatabasePlatformConfigurator.init(DatabasePlatformConfigurator.java:70) ... 48 more caused by: java.lang.ClassNotFoundException: ${org.apache.jetspeed.production.database.driver} at: org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387) at: org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233) at: java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320) at: java.lang.Class.forName0(Native Method) at: java.lang.Class.forName(Class.java:169) at: org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1130) at: org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) ... 50 more Sandi Dahl, Software Engineer | TDI Inc. | 17255 N 82nd Street, Scottsdale AZ 85255| P: 480.538.7747 | F: 480.515.7447 -----Original Message----- From: Randy Watler [mailto:[email protected]] Sent: Thursday, August 13, 2009 3:28 PM To: Jetspeed Users List Subject: Re: Error installing Jetspeed 2.2.0: Invalid object name 'SECURITY_DOMAIN' Ron/Sandra: I believe this is a known bug. See this thread: http://www.nabble.com/Jetspeed-2.2%3A-mssql-database-maven-configuration-td23776729.html#a23778807 And this JIRA issue: https://issues.apache.org/jira/browse/JS2-1024 Sorry that it took me some time to get back to you... I was traveling cross country. Feel free to ping me if you need more help on this issue. Randy Ron Wheeler wrote: > From what you posted, it looked like both Derby and MSSQL were setup. > You might want to wait until next week when David Taylor is back from > holidays. He may be able to help you. > > Early next week, try to use MSSQL again and post the log in the forum. > > Ron > > Dahl, Sandra wrote: >> I just installed with the default Derby database and everything >> worked fine. Is the Invalid object name 'SECURITY_DOMAIN' error >> caused by trying to use a MS SqlServer db with the demo install? >> >> 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: Thursday, August 13, 2009 1:16 PM >> To: Jetspeed Users List >> Subject: RE: Error installing Jetspeed 2.2.0: Invalid object name >> 'SECURITY_DOMAIN' >> >> 1) I will try with Derby >> 2) No. To install, I simply downloaded Jetspeed and followed the >> instructions. During the installation, I set my database to a MS >> SqlServer database. I did nothing else with the db configuration >> other than answer the questions during the installation process so I >> don't understand why the other databases are showing in the install >> message. I did a search to see if I could find a solution to the >> problem I am having before posting and found nothing similar. >> 3) I've done nothing since the last time I've asked because I'm brand >> new to Jetspeed and didn't know what I was supposed to try based on >> the responses I received back. >> >> Thank you for your response. >> >> 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: Thursday, August 13, 2009 12:55 PM >> To: Jetspeed Users List >> Subject: Re: Error installing Jetspeed 2.2.0: Invalid object name >> 'SECURITY_DOMAIN' >> >> 1)Can you get it installed with Derby? >> 2) Last time you sent something, it showed that you seemed to have 2 >> databases configured. Did you fix this yet? >> 3) What have you tried since the last time you asked? Any errors or log >> output that you want to share. >> >> It will install. >> >> Ron >> >> Dahl, Sandra wrote: >> >>> 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. >>> >>> >> >> >> --------------------------------------------------------------------- >> 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. >> &j)ly˫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. >> > > > --------------------------------------------------------------------- > 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] 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.
