Hi, I try to deploy Jetspeed 1.5 on Jonas 4.1.2. When I don't touch the database properties of torque.properties, there is no ploblem. Jonas 4.1.2 starts a database server(HSQL) and I try to use the Jonas database for Jetspeed.
Here is my torque.properties # Copyright 2004 The Apache Software Foundation # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. # You may obtain a copy of the License at # # http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. # ------------------------------------------------------------------- # $Id: Torque.properties,v 1.9 2004/03/17 19:10:26 jford Exp $ # # This is the configuration file for Torque. # # Note that strings containing "," (comma) characters must backslash # escape the comma (i.e. '\,') # # ------------------------------------------------------------------- # NOTE NO torque. prefix on properties - this is a kluge to make it also include the TR.properties torque.applicationRoot = . # ------------------------------------------------------------------- # # L O G G I N G # # ------------------------------------------------------------------- # We use Log4J for all Torque logging and we embed the log4j # properties within our application configuration. # ------------------------------------------------------------------- # THIS SEEMS TO BE IGNORED - HENCE IT IS DUPLICATED IN log4j.properties #log4j.category.org.apache.torque = ALL, org.apache.torque #log4j.appender.org.apache.torque = org.apache.log4j.FileAppender #log4j.appender.org.apache.file = ${applicationRoot}/logs/log #log4j.appender.org.apache.layout = org.apache.log4j.PatternLayout #log4j.appender.org.apache.layout.conversionPattern = %d [%t] %-5p %c - %m%n #log4j.appender.org.apache.append = false # ------------------------------------------------------------------- # # T O R Q U E P R O P E R T I E S # # ------------------------------------------------------------------- # These are your database settings. Look in the # org.apache.pool.* packages for more information. # # The parameters to connect to the default database. You MUST # configure these properly. # ------------------------------------------------------------------- torque.database.default=db_jonas torque.database.default.adapter=hypersonic ### torque.database.default.adapter=mysql ### torque.database.default.adapter=oracle ### torque.database.default.adapter=mssql ## ## Using torque's old pool ## torque.dsfactory.db_jonas.connection.driver = org.hsqldb.jdbcDriver torque.dsfactory.db_jonas.connection.url = jdbc:hsqldb:hsql://localhost/db_jonas torque.dsfactory.db_jonas.connection.user = jonas torque.dsfactory.db_jonas.connection.password = jonas torque.dsfactory.db_jonas.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory # The number of database connections to cache per ConnectionPool instance (specified per database) torque.dsfactory.db_jonas.pool.defaultMaxConnections=10 torque.dsfactory.db_jonas.pool.maxExpiryTime=3600 torque.dsfactory.db_jonas.pool.connectionWaitTimeout=10 ### MySQL ### torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver ### torque.dsfactory.default.connection.url = jdbc:mysql://localhost:3306/jetspeed ### torque.dsfactory.default.connection.user = root ### torque.dsfactory.default.connection.password = ### Oracle ### torque.dsfactory.default.connection.driver = oracle.jdbc.driver.OracleDriver ### torque.dsfactory.default.connection.url = jdbc:oracle:thin:@nirvana:1521:bluesun3 ### torque.dsfactory.default.connection.user = jetspeed ### torque.dsfactory.default.connection.password = jetspeed ### Microsoft SQL ### torque.dsfactory.default.connection.driver = net.avenir.jdbc3.Driver ### torque.dsfactory.default.connection.url = jdbc: AvenirDriver://localhost:1433/jetspeed ### torque.dsfactory.default.connection.user = jetspeed ### torque.dsfactory.default.connection.password = jetspeed ### SAP DB ### torque.database=sapdb ### torque.database.url = jdbc:sapdb:///tst ### torque.database.driver=com.sap.dbtech.jdbc.DriverSapDB # The interval (in milliseconds) between which the PoolBrokerService logs # the status of it's ConnectionPools. # # Default: No logging = 0 = 0 * 1000 torque.database.logInterval=0 # Determines if the quantity column of the IDBroker's id_table should # be increased automatically if requests for ids reaches a high # volume. torque.idbroker.cleverquantity=true # Determines whether the managers cache instances of the business objects. # And also whether the MethodResultCache will really cache results. torque.manager.useCache = true ## Using Jdbc2Pool #torque.dsfactory.default.factory=\ # org.apache.torque.dsfactory.Jdbc2PoolDataSourceFactory #torque.dsfactory.default.pool.defaultMaxActive=10 #torque.dsfactory.default.pool.testOnBorrow=true #torque.dsfactory.default.pool.validationQuery=SELECT 1 #torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver #torque.dsfactory.default.connection.url = jdbc:mysql://localhost:3306/torque #torque.dsfactory.default.connection.user = user #torque.dsfactory.default.connection.password = password ## Using jndi #torque.dsfactory.default.factory=org.apache.torque.dsfactory.JndiDataSourceFactory #torque.dsfactory.default.jndi.path=jdbc/default #torque.dsfactory.default.jndi.java.naming.factory.initial = org.apache.naming.java.javaURLContextFactory #torque.dsfactory.default.jndi.java.naming.factory.url.pkgs = org.apache.naming #torque.dsfactory.default.datasource.classname=org.apache.torque.pool.TorqueClassicDataSource #torque.dsfactory.default.datasource.dataSourceName=jdbc/DBdefault #torque.dsfactory.default.datasource.jndiEnvironment.java.naming.factory.initial = org.apache.naming.java.javaURLContextFactory #torque.dsfactory.default.datasource.jndiEnvironment.java.naming.factory.url.pkgs = org.apache.naming #torque.dsfactory.default.datasource.defaultMaxConnections=10 ## ConnectionPoolDataSource #torque.dsfactory.default.factory=org.apache.torque.dsfactory.JndiDataSourceFactory #torque.dsfactory.default.jndi.path=jdbc/DBdefault #torque.dsfactory.default.jndi.java.naming.factory.initial = org.apache.naming.java.javaURLContextFactory #torque.dsfactory.default.jndi.java.naming.factory.url.pkgs = org.apache.naming #torque.dsfactory.default.datasource.classname=org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS #torque.dsfactory.default.datasource.driver = org.gjt.mm.mysql.Driver #torque.dsfactory.default.datasource.url = jdbc:mysql://localhost:3306/torque #torque.dsfactory.default.datasource.user = user #torque.dsfactory.default.datasource.password = password When I start Jonas, all is OK, Jetspeed is deployed. But when I try to access at the Jetspeed portal, an error occurred with the database. I have the trace here: JONAS_BASE set to /home/jabouijc/JONAS_4_1_2 08:50:52,475 : PolicyProvider.init : Using JOnAS PolicyConfigurationFactory provider and JOnAS Policy provider 08:50:52,725 : TraceCarol.infoCarol : Name service for jrmp is started on port 1099 08:50:52,775 : ServiceManager.startRegistry : registry service started 08:50:53,014 : MBeanServerFactory.createMBeanServerImpl : Created MBeanServer with ID: 139eeda:fe32dd3b25:-7ffe:mururoa.frec.bull.fr:1 08:50:53,217 : RMIConnectorServer.start : RMIConnectorServer started at: service:jmx:rmi://localhost/jndi/jrmpconnector_jonas 08:50:53,219 : ServiceManager.startJmx : jmx service started 08:50:53,936 : ServiceManager.startServices : jtm service started 08:50:54,133 : HsqlDBServiceImpl.doStart : Starting HSQLDB server 1.7.2 on port 9001 08:50:54,790 : HsqlDBServiceImpl.doStart : HSQLDB server started. 08:50:54,827 : HsqlDBServiceImpl.doStart : Dropping and adding user 'jonas' with password 'jonas'. 08:50:54,839 : ServiceManager.startServices : db service started 08:50:54,896 : DataBaseServiceImpl.createDataSource : Mapping ConnectionManager jdbc:hsqldb:hsql://localhost/db_jonas on jdbc_1 08:50:54,916 : ServiceManager.startServices : dbm service started 08:50:55,271 : ServiceManager.startServices : security service started 08:50:55,880 : JmsAdminForJoram.startMOM : starting MOM on host localhost, port 16010 08:50:55,881 : JmsAdminForJoram.start : starting JmsAdmin with host localhost, port 16010 08:50:56,257 : ServiceManager.startServices : jms service started 08:50:56,658 : Rar.processRar : /home/jabouijc/JONAS_4_1_2/rars/autoload/JOnAS_jdbcCP.rar available 08:50:56,730 : Rar.processRar : /home/jabouijc/JONAS_4_1_2/rars/autoload/JOnAS_jdbcDM.rar available 08:50:56,786 : Rar.processRar : /home/jabouijc/JONAS_4_1_2/rars/autoload/JOnAS_jdbcDS.rar available 08:50:56,861 : Rar.processRar : /home/jabouijc/JONAS_4_1_2/rars/autoload/JOnAS_jdbcXA.rar available 08:50:56,864 : ServiceManager.startServices : resource service started 08:50:57,601 : JContainer.addBean : MEJB available 08:50:57,612 : ServiceManager.startServices : ejb service started 08:50:58,460 : Http11Protocol.init : Initialisation de Coyote HTTP/1.1 sur http-9000 08:50:58,513 : StandardService.start : Démarrage du service Tomcat-JOnAS 08:50:58,520 : StandardEngine.start : Starting Servlet Engine: Apache Tomcat/5.0.25 08:50:58,573 : StandardHost.start : XML validation disabled 08:50:58,659 : Http11Protocol.start : Démarrage de Coyote HTTP/1.1 sur http-9000 08:51:00,238 : AbsJWebContainerServiceImpl.registerWar : War /home/jabouijc/JONAS_4_1_2/webapps/autoload/jonas-doc-en/ available at the context /jonas-doc-en. 08:51:00,594 : AbsJWebContainerServiceImpl.registerWar : War /home/jabouijc/JONAS_4_1_2/webapps/autoload/jonas-javadoc/ available at the context /jonas-javadoc. 08:51:01,055 : AbsJWebContainerServiceImpl.registerWar : War /home/jabouijc/JONAS_4_1_2/webapps/autoload/ctxroot.war available at the context /. 08:51:02,844 : AbsJWebContainerServiceImpl.registerWar : War /home/jabouijc/JONAS_4_1_2/webapps/autoload/jonasAdmin.war available at the context /jonasAdmin. 08:51:03,052 : AbsJWebContainerServiceImpl.registerWar : War /home/jabouijc/JONAS_4_1_2/webapps/autoload/tomcat-docs.war available at the context /tomcat-docs. Starting Apache Jetspeed Portal/1.5 08:51:09,222 : AbsJWebContainerServiceImpl.registerWar : War /home/jabouijc/JONAS_4_1_2/webapps/autoload/jetspeed.war available at the context /jetspeed. 08:51:09,233 : ServiceManager.startServices : web service started 08:51:09,725 : JContainer.addBean : EarOp available 08:51:10,437 : AbsJWebContainerServiceImpl.registerWar : War /home/jabouijc/JONAS_4_1_2/work/apps/jonas/earsample_2004.07.07-15.41.05/earsample.war available at the context /earsample. 08:51:11,377 : EarServiceImpl.deployEar : Ear file:/home/jabouijc/JONAS_4_1_2/apps/autoload/earsample.ear available. 08:51:11,394 : ServiceManager.startServices : ear service started Le serveur JOnAS 'jonas' version 4.1.2 est actif 08:51:11,397 : Server.start : Le serveur JOnAS 'jonas' est démarré sur rmi/jrmp [EMAIL PROTECTED] jabouijc]$ 08:51:28,201 : IDBroker.<init> : IDBroker is being used with db 'default', which does not support transactions. IDBroker attempts to use transactions to limit the possibility of duplicate key generation. Without transactions, duplicate key generation is possible if multiple JVMs are used or other means are used to write to the database. 08:51:28,227 : BasePeer.initTableSchema : org.apache.torque.TorqueException: Connection is broken: mururoa/db_jonas 08:51:28,232 : BaseTurbineUserPeer.initClass : A FATAL ERROR has occurred which should not have happened under any circumstance. Please notify the Torque developers <[EMAIL PROTECTED]> and give as many details as possible (including the error stack trace). java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER): Connection is broken: mururoa/db_jonas at org.apache.torque.util.BasePeer.initTableSchema(BasePeer.java:274) at org.apache.torque.util.BasePeer.initTableSchema(BasePeer.java:249) at org.apache.jetspeed.om.security.turbine.TurbineUserPeer.<clinit>(TurbineUserPeer.java:49) at org.apache.jetspeed.om.security.turbine.BaseTurbineUser.<clinit>(BaseTurbineUser.java:36) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:141) at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.initClass(BaseTurbineUserPeer.java:141) at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.<clinit>(BaseTurbineUserPeer.java:128) at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.getUser(TurbineUserManagement.java:136) at org.apache.jetspeed.services.JetspeedUserManagement.getUser(JetspeedUserManagement.java:59) at org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAnonymousUser(TurbineAuthentication.java:188) at org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(JetspeedAuthentication.java:64) at org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSecurity.java:134) at org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(TemplateSessionValidator.java:59) at org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform(JetspeedSessionValidator.java:76) at org.apache.turbine.modules.Action.perform(Action.java:87) at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at org.apache.turbine.Turbine.doGet(Turbine.java:521) at javax.servlet.http.HttpServlet.service(HttpServlet.java:743) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) 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:324) at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:241) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAsPrivileged(Subject.java:500) at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:268) at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:157) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:50) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:140) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:136) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:703) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398) at org.apache.catalina.core.ApplicationDispatcher.access$000(ApplicationDispatcher.java:71) at org.apache.catalina.core.ApplicationDispatcher$PrivilegedForward.run(ApplicationDispatcher.java:86) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:304) at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:670) at org.apache.jasper.runtime.PageContextImpl.access$1000(PageContextImpl.java:64) at org.apache.jasper.runtime.PageContextImpl$11.run(PageContextImpl.java:624) at java.security.AccessController.doPrivileged(Native Method) at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:622) at org.apache.jsp.index_jsp._jspService(index_jsp.java:45) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) 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:324) at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:241) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAsPrivileged(Subject.java:500) at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:268) at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:157) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:50) at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:140) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:136) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644) at java.lang.Thread.run(Thread.java:534) Thanks for your help... --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]