Sandra,

The configuration for this property is missing: org.apache.jetspeed.production.database.driver

Did you run the installer w/o the database configuration option? If so, you have to configure it manually. Please check conf/Catalina/localhost/jetspeed.xml and set it up using your DB connection settings. Otherwise, search all files for the property name above and set it explicitly.

If you are stuck, I will follow your footsteps and walk you through it.

Randy

Dahl, Sandra wrote:
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:wat...@wispertel.net]
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:sd...@tdiinc.com]
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:rwhee...@artifact-software.com]
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:sd...@tdiinc.com]
Sent: Wednesday, August 12, 2009 8:28 AM
To: Jetspeed Users List
Subject: RE: Error installing Jetspeed 2.2.0: Invalid object name
'SECURITY_DOMAIN'

I specified a MS SqlServer DB during the installation. Here is the
database.properties file:
; Jetspeed Enterprise Portal 2.2.0 Database setup configuration

; db.type supported values: db2, derby, mssql, mysql, oracle,
postgres, sapdb
db.type=mssql

: for db.type other than derby, the properties below need to be
specified
db.username=xxxxx
db.password=xxxxx
jdbc.url=jdbc:jtds:sqlserver://localhost/jetspeed
jdbc.driver.class=net.sourceforge.jtds.jdbc.Driver

; boolean flag (true/false) indicating if psml is to be imported in
the database or will be read from file system
dbImportPsml = false

Sandi Dahl, Software Engineer | TDI Inc. | 17255 N 82nd Street,
Scottsdale  AZ  85255| P: 480.538.7747  | F: 480.515.7447


-----Original Message-----
From: Ron Wheeler [mailto:rwhee...@artifact-software.com]
Sent: Wednesday, August 12, 2009 5:47 AM
To: Jetspeed Users List
Subject: Re: Error installing Jetspeed 2.2.0: Invalid object name
'SECURITY_DOMAIN'

Looks like a mixture of Hsqldb and Derby

Ron

wat...@wispertel.net wrote:


Sandra,

Did you get that installer from the website download area?

Just making sure before I try to duplicate.

Randy

--- sd...@tdiinc.com wrote:

From: "Dahl, Sandra" <sd...@tdiinc.com>
To: "jetspeed-user@portals.apache.org"
<jetspeed-user@portals.apache.org>
Subject: Error installing Jetspeed 2.2.0: Invalid object name
'SECURITY_DOMAIN'
Date: Tue, 11 Aug 2009 12:06:32 -0700

I am new to Jetspeed and trying to install and run the demo for
2.2.0 and getting an error during installation. I am running on
windows and am installing in c:\jetspeed. It appears the database
access is ok because tables were created in the database by the
installation. Am I missing something? Here is the output from the
install:

antinstaller.jarC:\Temp\jetspeed-installer-demo-2.2.0.jar

install:
     [echo] Starting the installation
     [echo] Deleting all content from the installation target
directory
     [echo] Installing Jetspeed-2.2.0 Enterprise Portal
    [unzip] Expanding: C:\Temp\jetspeed-installer-demo-2.2.0.jar
into C:\Jetspeed-2.2.0
    [unzip] Expanding: C:\Jetspeed-2.2.0\database.zip into
C:\Jetspeed-2.2.0
    [unzip] Expanding: C:\Jetspeed-2.2.0\tomcat-portal.zip into
C:\Jetspeed-2.2.0
     [echo] Setting up the database configuration
     [copy] Copying 1 file to C:\Jetspeed-2.2.0\lib
     [move] Moving 1 file to C:\Jetspeed-2.2.0\database
     [echo] Moving pages out of jetspeed webapp
     [move] Moving 1 file to
C:\Jetspeed-2.2.0\webapps\jetspeed\WEB-INF\conf
     [move] Moving 1 file to
C:\Jetspeed-2.2.0\webapps\jetspeed\WEB-INF\conf
     [echo] Setting up the Jetspeed database (if selected)

checkDerby:

checkImportPsml:

generateStandardDB:
     [echo] Cleaning up possible existing database
      [sql] Executing resource:
C:\Jetspeed-2.2.0\database\mssql\drop-schema.sql
      [sql] 137 of 137 SQL statements executed successfully
     [echo] Starting database generation
      [sql] Executing resource:
C:\Jetspeed-2.2.0\database\mssql\create-schema.sql
      [sql] 196 of 196 SQL statements executed successfully
     [echo] Database generation done!

generateDerbyDB:

copyJetspeedContext:
     [copy] Copying 1 file to
C:\Jetspeed-2.2.0\conf\Catalina\localhost

filterSpringFilterKey:

filterSpringFilterKey_db:

filterSpringFilterKey_file:
     [copy] Copying 1 file to
C:\Jetspeed-2.2.0\webapps\jetspeed\WEB-INF\conf
Seeding the database
     [java] ##### platform = Hsqldb
     [java] [org.apache.ojb.broker.accesslayer.JdbcAccessImpl]
ERROR: SQLException during the execution of the query (for
org.apache.jetspeed.security.impl.SecurityDomainImpl): Invalid
object name 'SECURITY_DOMAIN'.
     [java] Invalid object name 'SECURITY_DOMAIN'.
     [java] java.sql.SQLException: Invalid object name
'SECURITY_DOMAIN'.
     [java]               at
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

     [java]               at
net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
     [java]               at
net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
     [java]               at
net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
     [java]               at
net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)

     [java]               at
net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)

     [java]               at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)

     [java]               at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:312)

     [java]               at
org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)

     [java]               at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:185)

     [java]               at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)

     [java]               at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1918)

     [java]               at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1493)

     [java]               at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(PersistenceBrokerImpl.java:1620)

     [java]               at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307)

     [java]               at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307)

     [java]               at
org.springframework.orm.ojb.PersistenceBrokerTemplate$2.doInPersistenceBroker(PersistenceBrokerTemplate.java:184)

     [java]               at
org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:138)

     [java]               at
org.springframework.orm.ojb.PersistenceBrokerTemplate.getObjectByQuery(PersistenceBrokerTemplate.java:182)

     [java]               at
org.apache.jetspeed.security.spi.impl.JetspeedSecurityPersistenceManager.getDomainByName(JetspeedSecurityPersistenceManager.java:1052)

     [java]               at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]               at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

     [java]               at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

     [java]               at
java.lang.reflect.Method.invoke(Method.java:597)
     [java]               at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)

     [java]               at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)

     [java]               at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

     [java]               at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)

     [java]               at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

     [java]               at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

     [java]               at $Proxy4.getDomainByName(Unknown Source)
     [java]               at
org.apache.jetspeed.serializer.JetspeedSecuritySerializer.checkDomainExistsOtherwiseCreate(JetspeedSecuritySerializer.java:233)

     [java]               at
org.apache.jetspeed.serializer.JetspeedSecuritySerializer.recreateSecurityDomains(JetspeedSecuritySerializer.java:253)

     [java]               at
org.apache.jetspeed.serializer.JetspeedSecuritySerializer.processImport(JetspeedSecuritySerializer.java:172)

     [java]               at
org.apache.jetspeed.serializer.AbstractJetspeedComponentSerializer.processImport(AbstractJetspeedComponentSerializer.java:47)

     [java]               at
org.apache.jetspeed.serializer.JetspeedSerializerImpl.importData(JetspeedSerializerImpl.java:131)

     [java]               at
org.apache.jetspeed.tools.db.serializer.JetspeedSerializerApplicationImpl.importFiles(JetspeedSerializerApplicationImpl.java:189)

     [java]               at
org.apache.jetspeed.tools.db.serializer.JetspeedSerializerApplicationImpl.main(JetspeedSerializerApplicationImpl.java:117)

     [java] org.apache.jetspeed.serializer.SerializerException:
Creating an instance from a serialized representation of
SecurityDomains failed with message Could not create default and /
or system domains!
     [java] OJB operation; bad SQL grammar []; nested exception is
java.sql.SQLException: Invalid object name 'SECURITY_DOMAIN'.
     [java]               at
org.apache.jetspeed.serializer.JetspeedSecuritySerializer.recreateSecurityDomains(JetspeedSecuritySerializer.java:256)

     [java]               at
org.apache.jetspeed.serializer.JetspeedSecuritySerializer.processImport(JetspeedSecuritySerializer.java:172)

     [java]               at
org.apache.jetspeed.serializer.AbstractJetspeedComponentSerializer.processImport(AbstractJetspeedComponentSerializer.java:47)

     [java]               at
org.apache.jetspeed.serializer.JetspeedSerializerImpl.importData(JetspeedSerializerImpl.java:131)

     [java]               at
org.apache.jetspeed.tools.db.serializer.JetspeedSerializerApplicationImpl.importFiles(JetspeedSerializerApplicationImpl.java:189)

     [java]               at
org.apache.jetspeed.tools.db.serializer.JetspeedSerializerApplicationImpl.main(JetspeedSerializerApplicationImpl.java:117)

     [java] Caused by:
org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad
SQL grammar []; nested exception is java.sql.SQLException: Invalid
object name 'SECURITY_DOMAIN'.
     [java]               at
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97)

     [java]               at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

     [java]               at
org.springframework.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107)

     [java]               at
org.springframework.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89)

     [java]               at
org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141)

     [java]               at
org.springframework.orm.ojb.PersistenceBrokerTemplate.getObjectByQuery(PersistenceBrokerTemplate.java:182)

     [java]               at
org.apache.jetspeed.security.spi.impl.JetspeedSecurityPersistenceManager.getDomainByName(JetspeedSecurityPersistenceManager.java:1052)

     [java]               at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]               at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

     [java]               at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

     [java]               at
java.lang.reflect.Method.invoke(Method.java:597)
     [java]               at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)

     [java]               at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)

     [java]               at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

     [java]               at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)

     [java]               at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

     [java]               at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

     [java]               at $Proxy4.getDomainByName(Unknown Source)
     [java]               at
org.apache.jetspeed.serializer.JetspeedSecuritySerializer.checkDomainExistsOtherwiseCreate(JetspeedSecuritySerializer.java:233)

     [java]               at
org.apache.jetspeed.serializer.JetspeedSecuritySerializer.recreateSecurityDomains(JetspeedSecuritySerializer.java:253)

     [java]               ... 5 more
     [java] Caused by: java.sql.SQLException: Invalid object name
'SECURITY_DOMAIN'.
     [java]               at
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

     [java]               at
net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
     [java]               at
net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
     [java]               at
net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
     [java]               at
net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)

     [java]               at
net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)

     [java]               at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)

     [java]               at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:312)

     [java]               at
org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)

     [java]               at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:185)

     [java]               at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)

     [java]               at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1918)

     [java]               at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1493)

     [java]               at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(PersistenceBrokerImpl.java:1620)

     [java]               at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307)

     [java]               at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307)

     [java]               at
org.springframework.orm.ojb.PersistenceBrokerTemplate$2.doInPersistenceBroker(PersistenceBrokerTemplate.java:184)

     [java]               at
org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:138)

     [java]               ... 20 more
     [java] Exception in thread "main"
org.apache.jetspeed.serializer.SerializerException: Creating an
instance from a serialized representation of SecurityDomains failed
with message Could not create default and / or system domains!
     [java] OJB operation; bad SQL grammar []; nested exception is
java.sql.SQLException: Invalid object name 'SECURITY_DOMAIN'.
     [java]               at
org.apache.jetspeed.serializer.JetspeedSecuritySerializer.recreateSecurityDomains(JetspeedSecuritySerializer.java:256)

     [java]               at
org.apache.jetspeed.serializer.JetspeedSecuritySerializer.processImport(JetspeedSecuritySerializer.java:172)

     [java]               at
org.apache.jetspeed.serializer.AbstractJetspeedComponentSerializer.processImport(AbstractJetspeedComponentSerializer.java:47)

     [java]               at
org.apache.jetspeed.serializer.JetspeedSerializerImpl.importData(JetspeedSerializerImpl.java:131)

     [java]               at
org.apache.jetspeed.tools.db.serializer.JetspeedSerializerApplicationImpl.importFiles(JetspeedSerializerApplicationImpl.java:189)

     [java]               at
org.apache.jetspeed.tools.db.serializer.JetspeedSerializerApplicationImpl.main(JetspeedSerializerApplicationImpl.java:117)

     [java] Caused by:
org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad
SQL grammar []; nested exception is java.sql.SQLException: Invalid
object name 'SECURITY_DOMAIN'.
     [java]               at
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97)

     [java]               at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

     [java]               at
org.springframework.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107)

     [java]               at
org.springframework.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89)

     [java]               at
org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141)

     [java]               at
org.springframework.orm.ojb.PersistenceBrokerTemplate.getObjectByQuery(PersistenceBrokerTemplate.java:182)

     [java]               at
org.apache.jetspeed.security.spi.impl.JetspeedSecurityPersistenceManager.getDomainByName(JetspeedSecurityPersistenceManager.java:1052)

     [java]               at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]               at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

     [java]               at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

     [java]               at
java.lang.reflect.Method.invoke(Method.java:597)
     [java]               at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)

     [java]               at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)

     [java]               at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

     [java]               at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)

     [java]               at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

     [java]               at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

     [java]               at $Proxy4.getDomainByName(Unknown Source)
     [java]               at
org.apache.jetspeed.serializer.JetspeedSecuritySerializer.checkDomainExistsOtherwiseCreate(JetspeedSecuritySerializer.java:233)

     [java]               at
org.apache.jetspeed.serializer.JetspeedSecuritySerializer.recreateSecurityDomains(JetspeedSecuritySerializer.java:253)

     [java]               ... 5 more
     [java] Caused by: java.sql.SQLException: Invalid object name
'SECURITY_DOMAIN'.
     [java]               at
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

     [java]               at
net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
     [java]               at
net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
     [java]               at
net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
     [java]               at
net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)

     [java]               at
net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)

     [java]               at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)

     [java]               at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:312)

     [java]               at
org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)

     [java]               at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:185)

     [java]               at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)

     [java]               at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1918)

     [java]               at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1493)

     [java]               at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(PersistenceBrokerImpl.java:1620)

     [java]               at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307)

     [java]               at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307)

     [java]               at
org.springframework.orm.ojb.PersistenceBrokerTemplate$2.doInPersistenceBroker(PersistenceBrokerTemplate.java:184)

     [java]               at
org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:138)

     [java]               ... 20 more



Sandi Dahl<mailto:sd...@tdiinc.com>, Software Engineer | TDI
Inc.<http://www.tdiinc.com/> | 17255 N 82nd Street, Scottsdale  AZ
85255| P: 480.538.7747  | F: 480.515.7447



________________________________
Confidentiality Notice:
The information contained in this communication, including
attachments, is privileged and confidential. It is intended only
for the exclusive use of the addressee. If the reader is not the
intended recipient, or the employee, or the agent responsible for
delivering it to the intended recipient, you are hereby notified
that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify us by return email or
telephone immediately. Thank you.





---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscr...@portals.apache.org
For additional commands, e-mail: jetspeed-user-h...@portals.apache.org


Email secured by Check Point

Confidentiality Notice:
The information contained in this communication, including
attachments, is privileged and confidential.  It is intended only
for the exclusive use of the addressee.  If the reader is not the
intended recipient, or the employee, or the agent responsible for
delivering it to the intended recipient, you are hereby notified
that any dissemination, distribution or copying of this
communication is strictly prohibited.  If you have received this
communication in error, please notify us by return email or
telephone immediately.  Thank you.

Confidentiality Notice:
The information contained in this communication, including
attachments, is privileged and confidential.  It is intended only
for the exclusive use of the addressee.  If the reader is not the
intended recipient, or the employee, or the agent responsible for
delivering it to the intended recipient, you are hereby notified
that any dissemination, distribution or copying of this
communication is strictly prohibited.  If you have received this
communication in error, please notify us by return email or
telephone immediately.  Thank you.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscr...@portals.apache.org
For additional commands, e-mail: jetspeed-user-h...@portals.apache.org


Email secured by Check Point

Confidentiality Notice:
The information contained in this communication, including
attachments, is privileged and confidential.  It is intended only for
the exclusive use of the addressee.  If the reader is not the
intended recipient, or the employee, or the agent responsible for
delivering it to the intended recipient, you are hereby notified that
any dissemination, distribution or copying of this communication is
strictly prohibited.  If you have received this communication in
error, please notify us by return email or telephone immediately.
Thank you.
&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: jetspeed-user-unsubscr...@portals.apache.org
For additional commands, e-mail: jetspeed-user-h...@portals.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscr...@portals.apache.org
For additional commands, e-mail: jetspeed-user-h...@portals.apache.org


Email secured by Check Point

Confidentiality Notice:
The information contained in this communication, including attachments, is 
privileged and confidential.  It is intended only for the exclusive use of the 
addressee.  If the reader is not the intended recipient, or the employee, or 
the agent responsible for delivering it to the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this 
communication is strictly prohibited.  If you have received this communication 
in error, please notify us by return email or telephone immediately.  Thank you.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscr...@portals.apache.org
For additional commands, e-mail: jetspeed-user-h...@portals.apache.org

Reply via email to