You are viewing a plain text version of this content. The canonical link for it is here.

Posted to jetspeed-user@portals.apache.org by hm...@ualr.edu on 2003/04/15 02:37:39 UTC

Re: AW: Jetspeed/MySQL Configuration problem

Hello,
               We have setup Jetspeed [1.4beta3] for our project running on Tomcat[4.1.24] running on Windows XP. It runs fine while we are using default HyperSonicSQL. But when we follow these steps to use MySQL , it gives the error 

java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER): Connection object is null!

I understand the error message says report this to turbine-dev list but after posting and waiting on that list for long time now, I think I will get quick pointers from you guys.

Here are the steps we followed.
1) We Have created all tables using turbine-mysql.sql file avilable with Jetspeed installation
2) Populated the database using populate-mysql.sql file avilable with Jetspeed installation.
3) Unzipped MySQL JConnector Jar file classes under jetspeed/WEB-INF/classes folder
4) File - Torque.properties commented HyperSonicSQL portion and added the following

---------------------------------------------------------------------                              

# The number of database connections to cache per ConnectionPool
# instance (specified per database).

database.default.maxConnections=10

# The amount of time (in milliseconds) that database connections will be
# cached (specified per database).
#
# Default: one hour = 60 * 60 * 1000

database.default.expiryTime=3600000

# The amount of time (in milliseconds) a connection request will have to wait
# before a time out occurs and an error is thrown.
#
# Default: ten seconds = 10 * 1000

database.connectionWaitTimeout=10000

# The interval (in milliseconds) between which the PoolBrokerService logs
# the status of it's ConnectionPools.
#
# Default: No logging = 0 = 0 * 1000

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.

idbroker.cleverquantity=true

## Stuff added by Hemant
torque.database.default=default                                                                
torque.database.default.adapter=mysql                                                                                        
torque.dsfactory.default.connection.driver=org.gjt.mm.mysql.Driver

#torque.dsfactory.default.connection.url=jdbc:mysql://144.167.145.138:3306/jetspeed

torque.dsfactory.default.connection.url=jdbc:mysql://localhost:3306/jetspeed
torque.dsfactory.default.connection.user=turbine
torque.dsfactory.default.connection.password=turbine 

torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory

#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.manager.useCache=true           

torque.dsfactory.default.pool.defaultMaxConnections=10
torque.dsfactory.default.pool.maxExpiryTime=36000
torque.dsfactory.default.pool.connectionWaitTimeout=1000

--------------------------------------------------------------------------

5) Put JDBC MySQL driver Jar file 'mysql-connector-java-3.0.6-stable-bin.jar' in /Jetspeed/WEB_INF/lib folder

Here is the error we are getting
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[16:53:53,089 INFO ] Start Initializing service (late): UploadService
[16:53:53,089 INFO ] Finish Initializing service (late): UploadService
[16:53:53,100 INFO ] Start Initializing service (late): AssemblerBrokerService
[16:53:53,150 INFO ] Finish Initializing service (late): AssemblerBrokerService
[16:53:53,410 INFO ] IDBroker thread was started.
[16:53:53,420 WARN ] 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.
[16:53:53,520 ERROR] java.sql.SQLException: Connection object is null!
[16:53:53,520 ERROR] A FATAL ERROR has occurred which should not have happened under any circumstance.  Please notify the Turbine developers <tu...@jakarta.apache.org> and give as many details as possible (including the error stack trace).
java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER): Connection object is null!
at org.apache.torque.util.BasePeer.initTableSchema(BasePeer.java:272)
at org.apache.torque.util.BasePeer.initTableSchema(BasePeer.java:234)
at org.apache.jetspeed.om.security.turbine.TurbineUserPeer.<clinit>(TurbineUserPeer.java:89)
at org.apache.jetspeed.om.security.turbine.BaseTurbineUser.<clinit>(BaseTurbineUser.java:25)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:130)
at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.initClass(BaseTurbineUserPeer.java:117)
at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.<clinit>(BaseTurbineUserPeer.java:109)
at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.getUser(TurbineUserManagement.java:164)
at org.apache.jetspeed.services.JetspeedUserManagement.getUser(JetspeedUserManagement.java:98)
at org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAnonymousUser(TurbineAuthentication.java:184)
at org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(JetspeedAuthentication.java:107)
at org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSecurity.java:157)
at org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(TemplateSessionValidator.java:97)
at org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform(JetspeedSessionValidator.java:103)
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:468)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:432)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:356)
at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:430)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:42)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:536)
[16:53:53,520 ERROR] Turbine.handleException: Error in BasePeer.initTableSchema(TURBINE_USER): Connection object is null!
[16:53:53,520 ERROR] 
java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER): Connection object is null!
at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.initClass(BaseTurbineUserPeer.java:130)
at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.<clinit>(BaseTurbineUserPeer.java:109)
at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.getUser(TurbineUserManagement.java:164)
at org.apache.jetspeed.services.JetspeedUserManagement.getUser(JetspeedUserManagement.java:98)
at org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAnonymousUser(TurbineAuthentication.java:184)
at org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(JetspeedAuthentication.java:107)
at org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSecurity.java:157)
at org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(TemplateSessionValidator.java:97)
at org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform(JetspeedSessionValidator.java:103)
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:468)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:432)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:356)
at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:430)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:42)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:536)
[16:53:53,780 INFO ] Start Initializing service (late): LocalizationService
[16:53:53,780 INFO ] Finish Initializing service (late): LocalizationService
[16:53:53,841 ERROR] Error rendering Velocity template: layouts/default.vm: Unable to find resource 'layouts/default.vm'
[16:53:53,841 ERROR] Error rendering Velocity template: layouts/default.vm: Unable to find resource 'layouts/default.vm'
org.apache.velocity.exception.ResourceNotFoundException: Unable to find resource 'layouts/default.vm'
at org.apache.velocity.runtime.resource.ResourceManagerImpl.loadResource(ResourceManagerImpl.java:501)
at org.apache.velocity.runtime.resource.ResourceManagerImpl.getResource(ResourceManagerImpl.java:384)
at org.apache.velocity.runtime.RuntimeInstance.getTemplate(RuntimeInstance.java:812)
at org.apache.velocity.runtime.RuntimeSingleton.getTemplate(RuntimeSingleton.java:355)
at org.apache.velocity.app.Velocity.mergeTemplate(Velocity.java:482)
at org.apache.velocity.app.Velocity.mergeTemplate(Velocity.java:461)
org.apache.turbine.util.TurbineException: Error rendering Velocity template: layouts/default.vm: Unable to find resource 'layouts/default.vm'
at org.apache.turbine.services.velocity.TurbineVelocityService.renderingError(TurbineVelocityService.java:524)
at org.apache.turbine.services.velocity.TurbineVelocityService.decodeRequest(TurbineVelocityService.java:490)
at org.apache.turbine.services.velocity.TurbineVelocityService.handleRequest(TurbineVelocityService.java:327)
at org.apache.turbine.services.velocity.TurbineVelocity.handleRequest(TurbineVelocity.java:146)
at org.apache.turbine.modules.layouts.VelocityDirectLayout.doBuild(VelocityDirectLayout.java:106)
at org.apache.turbine.modules.Layout.build(Layout.java:91)
at org.apache.turbine.modules.LayoutLoader.exec(LayoutLoader.java:123)
at org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:169)
at org.apache.turbine.modules.Page.build(Page.java:90)
at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
at org.apache.turbine.Turbine.handleException(Turbine.java:670)
at org.apache.turbine.Turbine.doGet(Turbine.java:579)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:432)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:356)
at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:430)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:42)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:536)
[16:53:53,901 DEBUG] JetspeedRunDataService: releasing rundata for thread: Thread[Thread-10,5,main]

Any help is appreciated.
-Jo



---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org

Re: AW: Jetspeed/MySQL Configuration problem

Posted by Stefan Kuhn <st...@uni-koeln.de>.

Hello,
according to my experience such problems are mostly related to permissions 
(although the error message doesn't really say this). I would recommend you 
check this carefully again. For example one problem I had is that if you 
connect to the database via localhost and the user has rights on the database 
only from 127.0.0.1 (or the other way round), it' s not working, but there 
could be other minor problems.
HTH
Stefan

Am Tuesday 15 April 2003 02:37 schrieb hmjoshi@ualr.edu:
> Hello,
>                We have setup Jetspeed [1.4beta3] for our project running on
> Tomcat[4.1.24] running on Windows XP. It runs fine while we are using
> default HyperSonicSQL. But when we follow these steps to use MySQL , it
> gives the error
>
> java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER):
> Connection object is null!
>
> I understand the error message says report this to turbine-dev list but
> after posting and waiting on that list for long time now, I think I will
> get quick pointers from you guys.
>
> Here are the steps we followed.
> 1) We Have created all tables using turbine-mysql.sql file avilable with
> Jetspeed installation 2) Populated the database using populate-mysql.sql
> file avilable with Jetspeed installation. 3) Unzipped MySQL JConnector Jar
> file classes under jetspeed/WEB-INF/classes folder 4) File -
> Torque.properties commented HyperSonicSQL portion and added the following
>
> ---------------------------------------------------------------------
>
> # The number of database connections to cache per ConnectionPool
> # instance (specified per database).
>
> database.default.maxConnections=10
>
> # The amount of time (in milliseconds) that database connections will be
> # cached (specified per database).
> #
> # Default: one hour = 60 * 60 * 1000
>
> database.default.expiryTime=3600000
>
> # The amount of time (in milliseconds) a connection request will have to
> wait # before a time out occurs and an error is thrown.
> #
> # Default: ten seconds = 10 * 1000
>
> database.connectionWaitTimeout=10000
>
> # The interval (in milliseconds) between which the PoolBrokerService logs
> # the status of it's ConnectionPools.
> #
> # Default: No logging = 0 = 0 * 1000
>
> 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.
>
> idbroker.cleverquantity=true
>
> ## Stuff added by Hemant
> torque.database.default=default
> torque.database.default.adapter=mysql
> torque.dsfactory.default.connection.driver=org.gjt.mm.mysql.Driver
>
> #torque.dsfactory.default.connection.url=jdbc:mysql://144.167.145.138:3306/
>jetspeed
>
> torque.dsfactory.default.connection.url=jdbc:mysql://localhost:3306/jetspee
>d torque.dsfactory.default.connection.user=turbine
> torque.dsfactory.default.connection.password=turbine
>
> torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSour
>ceFactory
>
> #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.manager.useCache=true
>
> torque.dsfactory.default.pool.defaultMaxConnections=10
> torque.dsfactory.default.pool.maxExpiryTime=36000
> torque.dsfactory.default.pool.connectionWaitTimeout=1000
>
> --------------------------------------------------------------------------
>
> 5) Put JDBC MySQL driver Jar file
> 'mysql-connector-java-3.0.6-stable-bin.jar' in /Jetspeed/WEB_INF/lib folder
>
> Here is the error we are getting
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> [16:53:53,089 INFO ] Start Initializing service (late): UploadService
> [16:53:53,089 INFO ] Finish Initializing service (late): UploadService
> [16:53:53,100 INFO ] Start Initializing service (late):
> AssemblerBrokerService [16:53:53,150 INFO ] Finish Initializing service
> (late): AssemblerBrokerService [16:53:53,410 INFO ] IDBroker thread was
> started.
> [16:53:53,420 WARN ] 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. [16:53:53,520 ERROR]
> java.sql.SQLException: Connection object is null! [16:53:53,520 ERROR] A
> FATAL ERROR has occurred which should not have happened under any
> circumstance.  Please notify the Turbine developers
> <tu...@jakarta.apache.org> and give as many details as possible
> (including the error stack trace). java.lang.Error: Error in
> BasePeer.initTableSchema(TURBINE_USER): Connection object is null! at
> org.apache.torque.util.BasePeer.initTableSchema(BasePeer.java:272) at
> org.apache.torque.util.BasePeer.initTableSchema(BasePeer.java:234) at
> org.apache.jetspeed.om.security.turbine.TurbineUserPeer.<clinit>(TurbineUse
>rPeer.java:89) at
> org.apache.jetspeed.om.security.turbine.BaseTurbineUser.<clinit>(BaseTurbin
>eUser.java:25) at java.lang.Class.forName0(Native Method)
> at java.lang.Class.forName(Class.java:130)
> at
> org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.initClass(BaseT
>urbineUserPeer.java:117) at
> org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.<clinit>(BaseTu
>rbineUserPeer.java:109) at
> org.apache.jetspeed.services.security.turbine.TurbineUserManagement.getUser
>(TurbineUserManagement.java:164) at
> org.apache.jetspeed.services.JetspeedUserManagement.getUser(JetspeedUserMan
>agement.java:98) at
> org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAnon
>ymousUser(TurbineAuthentication.java:184) at
> org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(Jetspe
>edAuthentication.java:107) at
> org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSecu
>rity.java:157) at
> org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(Temp
>lateSessionValidator.java:97) at
> org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform(Jets
>peedSessionValidator.java:103) 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:468)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher
>.java:684) at
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatc
>her.java:432) at
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatche
>r.java:356) at
> org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:430)
> at org.apache.jsp.index_jsp._jspService(index_jsp.java:42)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:
>210) at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio
>nFilterChain.java:247) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC
>hain.java:193) at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j
>ava:256) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j
>ava:191) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:18
>0) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve
>.java:171) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:641) at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:17
>2) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:641) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav
>a:174) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConn
>ection(Http11Protocol.java:392) at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.ja
>va:619) at java.lang.Thread.run(Thread.java:536)
> [16:53:53,520 ERROR] Turbine.handleException: Error in
> BasePeer.initTableSchema(TURBINE_USER): Connection object is null!
> [16:53:53,520 ERROR]
> java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER):
> Connection object is null! at
> org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.initClass(BaseT
>urbineUserPeer.java:130) at
> org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.<clinit>(BaseTu
>rbineUserPeer.java:109) at
> org.apache.jetspeed.services.security.turbine.TurbineUserManagement.getUser
>(TurbineUserManagement.java:164) at
> org.apache.jetspeed.services.JetspeedUserManagement.getUser(JetspeedUserMan
>agement.java:98) at
> org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAnon
>ymousUser(TurbineAuthentication.java:184) at
> org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(Jetspe
>edAuthentication.java:107) at
> org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSecu
>rity.java:157) at
> org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(Temp
>lateSessionValidator.java:97) at
> org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform(Jets
>peedSessionValidator.java:103) 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:468)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher
>.java:684) at
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatc
>her.java:432) at
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatche
>r.java:356) at
> org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:430)
> at org.apache.jsp.index_jsp._jspService(index_jsp.java:42)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:
>210) at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio
>nFilterChain.java:247) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC
>hain.java:193) at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j
>ava:256) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j
>ava:191) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:18
>0) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve
>.java:171) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:641) at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:17
>2) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:641) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav
>a:174) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConn
>ection(Http11Protocol.java:392) at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.ja
>va:619) at java.lang.Thread.run(Thread.java:536)
> [16:53:53,780 INFO ] Start Initializing service (late): LocalizationService
> [16:53:53,780 INFO ] Finish Initializing service (late):
> LocalizationService [16:53:53,841 ERROR] Error rendering Velocity template:
> layouts/default.vm: Unable to find resource 'layouts/default.vm'
> [16:53:53,841 ERROR] Error rendering Velocity template: layouts/default.vm:
> Unable to find resource 'layouts/default.vm'
> org.apache.velocity.exception.ResourceNotFoundException: Unable to find
> resource 'layouts/default.vm' at
> org.apache.velocity.runtime.resource.ResourceManagerImpl.loadResource(Resou
>rceManagerImpl.java:501) at
> org.apache.velocity.runtime.resource.ResourceManagerImpl.getResource(Resour
>ceManagerImpl.java:384) at
> org.apache.velocity.runtime.RuntimeInstance.getTemplate(RuntimeInstance.jav
>a:812) at
> org.apache.velocity.runtime.RuntimeSingleton.getTemplate(RuntimeSingleton.j
>ava:355) at
> org.apache.velocity.app.Velocity.mergeTemplate(Velocity.java:482) at
> org.apache.velocity.app.Velocity.mergeTemplate(Velocity.java:461)
> org.apache.turbine.util.TurbineException: Error rendering Velocity
> template: layouts/default.vm: Unable to find resource 'layouts/default.vm'
> at
> org.apache.turbine.services.velocity.TurbineVelocityService.renderingError(
>TurbineVelocityService.java:524) at
> org.apache.turbine.services.velocity.TurbineVelocityService.decodeRequest(T
>urbineVelocityService.java:490) at
> org.apache.turbine.services.velocity.TurbineVelocityService.handleRequest(T
>urbineVelocityService.java:327) at
> org.apache.turbine.services.velocity.TurbineVelocity.handleRequest(TurbineV
>elocity.java:146) at
> org.apache.turbine.modules.layouts.VelocityDirectLayout.doBuild(VelocityDir
>ectLayout.java:106) at
> org.apache.turbine.modules.Layout.build(Layout.java:91)
> at org.apache.turbine.modules.LayoutLoader.exec(LayoutLoader.java:123)
> at
> org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:169)
> at org.apache.turbine.modules.Page.build(Page.java:90)
> at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
> at org.apache.turbine.Turbine.handleException(Turbine.java:670)
> at org.apache.turbine.Turbine.doGet(Turbine.java:579)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher
>.java:684) at
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatc
>her.java:432) at
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatche
>r.java:356) at
> org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:430)
> at org.apache.jsp.index_jsp._jspService(index_jsp.java:42)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:
>210) at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio
>nFilterChain.java:247) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC
>hain.java:193) at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j
>ava:256) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j
>ava:191) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:18
>0) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve
>.java:171) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:641) at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:17
>2) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:641) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav
>a:174) at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo
>keNext(StandardPipeline.java:643) at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConn
>ection(Http11Protocol.java:392) at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.ja
>va:619) at java.lang.Thread.run(Thread.java:536)
> [16:53:53,901 DEBUG] JetspeedRunDataService: releasing rundata for thread:
> Thread[Thread-10,5,main]
>
> Any help is appreciated.
> -Jo
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org

-- 
Stefan Kuhn M. A.
Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de)
Zülpicher Str. 47, 50674 Cologne
Tel: +49(0)221-470-7428   Fax: +49 (0) 221-470-5092
My public PGP key is available at http://pgp.mit.edu


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org

Re: AW: Jetspeed/MySQL Configuration problem

Posted by Kevin McIntyre <ke...@west28.com>.

That looks like a username/password problem.

Verify you can connect to the database from the jetspeed machine (even if
it's the same machine) and that
the username/password (in your case turbine/turbine) has rights to that
database.

----- Original Message -----
From: <hm...@ualr.edu>
To: "Jetspeed Users List" <je...@jakarta.apache.org>
Sent: Monday, April 14, 2003 8:37 PM
Subject: Re: AW: Jetspeed/MySQL Configuration problem


> Hello,
>                We have setup Jetspeed [1.4beta3] for our project running
on Tomcat[4.1.24] running on Windows XP. It runs fine while we are using
default HyperSonicSQL. But when we follow these steps to use MySQL , it
gives the error
>
> java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER):
Connection object is null!
>
> I understand the error message says report this to turbine-dev list but
after posting and waiting on that list for long time now, I think I will get
quick pointers from you guys.
>
> Here are the steps we followed.
> 1) We Have created all tables using turbine-mysql.sql file avilable with
Jetspeed installation
> 2) Populated the database using populate-mysql.sql file avilable with
Jetspeed installation.
> 3) Unzipped MySQL JConnector Jar file classes under
jetspeed/WEB-INF/classes folder
> 4) File - Torque.properties commented HyperSonicSQL portion and added the
following
>
> ---------------------------------------------------------------------
>
> # The number of database connections to cache per ConnectionPool
> # instance (specified per database).
>
> database.default.maxConnections=10
>
> # The amount of time (in milliseconds) that database connections will be
> # cached (specified per database).
> #
> # Default: one hour = 60 * 60 * 1000
>
> database.default.expiryTime=3600000
>
> # The amount of time (in milliseconds) a connection request will have to
wait
> # before a time out occurs and an error is thrown.
> #
> # Default: ten seconds = 10 * 1000
>
> database.connectionWaitTimeout=10000
>
> # The interval (in milliseconds) between which the PoolBrokerService logs
> # the status of it's ConnectionPools.
> #
> # Default: No logging = 0 = 0 * 1000
>
> 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.
>
> idbroker.cleverquantity=true
>
> ## Stuff added by Hemant
> torque.database.default=default
> torque.database.default.adapter=mysql
> torque.dsfactory.default.connection.driver=org.gjt.mm.mysql.Driver
>
>
#torque.dsfactory.default.connection.url=jdbc:mysql://144.167.145.138:3306/j
etspeed
>
>
torque.dsfactory.default.connection.url=jdbc:mysql://localhost:3306/jetspeed
> torque.dsfactory.default.connection.user=turbine
> torque.dsfactory.default.connection.password=turbine
>
>
torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSourc
eFactory
>
> #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.manager.useCache=true
>
> torque.dsfactory.default.pool.defaultMaxConnections=10
> torque.dsfactory.default.pool.maxExpiryTime=36000
> torque.dsfactory.default.pool.connectionWaitTimeout=1000
>
> --------------------------------------------------------------------------
>
> 5) Put JDBC MySQL driver Jar file
'mysql-connector-java-3.0.6-stable-bin.jar' in /Jetspeed/WEB_INF/lib folder
>
> Here is the error we are getting
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> [16:53:53,089 INFO ] Start Initializing service (late): UploadService
> [16:53:53,089 INFO ] Finish Initializing service (late): UploadService
> [16:53:53,100 INFO ] Start Initializing service (late):
AssemblerBrokerService
> [16:53:53,150 INFO ] Finish Initializing service (late):
AssemblerBrokerService
> [16:53:53,410 INFO ] IDBroker thread was started.
> [16:53:53,420 WARN ] 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.
> [16:53:53,520 ERROR] java.sql.SQLException: Connection object is null!
> [16:53:53,520 ERROR] A FATAL ERROR has occurred which should not have
happened under any circumstance.  Please notify the Turbine developers
<tu...@jakarta.apache.org> and give as many details as possible
(including the error stack trace).
> java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER):
Connection object is null!
> at org.apache.torque.util.BasePeer.initTableSchema(BasePeer.java:272)
> at org.apache.torque.util.BasePeer.initTableSchema(BasePeer.java:234)
> at
org.apache.jetspeed.om.security.turbine.TurbineUserPeer.<clinit>(TurbineUser
Peer.java:89)
> at
org.apache.jetspeed.om.security.turbine.BaseTurbineUser.<clinit>(BaseTurbine
User.java:25)
> at java.lang.Class.forName0(Native Method)
> at java.lang.Class.forName(Class.java:130)
> at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.initClass(BaseTu
rbineUserPeer.java:117)
> at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.<clinit>(BaseTur
bineUserPeer.java:109)
> at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.getUser(
TurbineUserManagement.java:164)
> at
org.apache.jetspeed.services.JetspeedUserManagement.getUser(JetspeedUserMana
gement.java:98)
> at
org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAnony
mousUser(TurbineAuthentication.java:184)
> at
org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(Jetspee
dAuthentication.java:107)
> at
org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSecur
ity.java:157)
> at
org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(Templ
ateSessionValidator.java:97)
> at
org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform(Jetsp
eedSessionValidator.java:103)
> 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:468)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.
java:684)
> at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatch
er.java:432)
> at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher
.java:356)
> at
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:430)
> at org.apache.jsp.index_jsp._jspService(index_jsp.java:42)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2
10)
> at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
> at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
> at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
> at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
> at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
> at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
> at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
> at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
> at java.lang.Thread.run(Thread.java:536)
> [16:53:53,520 ERROR] Turbine.handleException: Error in
BasePeer.initTableSchema(TURBINE_USER): Connection object is null!
> [16:53:53,520 ERROR]
> java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER):
Connection object is null!
> at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.initClass(BaseTu
rbineUserPeer.java:130)
> at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.<clinit>(BaseTur
bineUserPeer.java:109)
> at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.getUser(
TurbineUserManagement.java:164)
> at
org.apache.jetspeed.services.JetspeedUserManagement.getUser(JetspeedUserMana
gement.java:98)
> at
org.apache.jetspeed.services.security.turbine.TurbineAuthentication.getAnony
mousUser(TurbineAuthentication.java:184)
> at
org.apache.jetspeed.services.JetspeedAuthentication.getAnonymousUser(Jetspee
dAuthentication.java:107)
> at
org.apache.jetspeed.services.JetspeedSecurity.getAnonymousUser(JetspeedSecur
ity.java:157)
> at
org.apache.jetspeed.modules.actions.TemplateSessionValidator.doPerform(Templ
ateSessionValidator.java:97)
> at
org.apache.jetspeed.modules.actions.JetspeedSessionValidator.doPerform(Jetsp
eedSessionValidator.java:103)
> 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:468)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.
java:684)
> at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatch
er.java:432)
> at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher
.java:356)
> at
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:430)
> at org.apache.jsp.index_jsp._jspService(index_jsp.java:42)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2
10)
> at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
> at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
> at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
> at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
> at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
> at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
> at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
> at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
> at java.lang.Thread.run(Thread.java:536)
> [16:53:53,780 INFO ] Start Initializing service (late):
LocalizationService
> [16:53:53,780 INFO ] Finish Initializing service (late):
LocalizationService
> [16:53:53,841 ERROR] Error rendering Velocity template:
layouts/default.vm: Unable to find resource 'layouts/default.vm'
> [16:53:53,841 ERROR] Error rendering Velocity template:
layouts/default.vm: Unable to find resource 'layouts/default.vm'
> org.apache.velocity.exception.ResourceNotFoundException: Unable to find
resource 'layouts/default.vm'
> at
org.apache.velocity.runtime.resource.ResourceManagerImpl.loadResource(Resour
ceManagerImpl.java:501)
> at
org.apache.velocity.runtime.resource.ResourceManagerImpl.getResource(Resourc
eManagerImpl.java:384)
> at
org.apache.velocity.runtime.RuntimeInstance.getTemplate(RuntimeInstance.java
:812)
> at
org.apache.velocity.runtime.RuntimeSingleton.getTemplate(RuntimeSingleton.ja
va:355)
> at org.apache.velocity.app.Velocity.mergeTemplate(Velocity.java:482)
> at org.apache.velocity.app.Velocity.mergeTemplate(Velocity.java:461)
> org.apache.turbine.util.TurbineException: Error rendering Velocity
template: layouts/default.vm: Unable to find resource 'layouts/default.vm'
> at
org.apache.turbine.services.velocity.TurbineVelocityService.renderingError(T
urbineVelocityService.java:524)
> at
org.apache.turbine.services.velocity.TurbineVelocityService.decodeRequest(Tu
rbineVelocityService.java:490)
> at
org.apache.turbine.services.velocity.TurbineVelocityService.handleRequest(Tu
rbineVelocityService.java:327)
> at
org.apache.turbine.services.velocity.TurbineVelocity.handleRequest(TurbineVe
locity.java:146)
> at
org.apache.turbine.modules.layouts.VelocityDirectLayout.doBuild(VelocityDire
ctLayout.java:106)
> at org.apache.turbine.modules.Layout.build(Layout.java:91)
> at org.apache.turbine.modules.LayoutLoader.exec(LayoutLoader.java:123)
> at
org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:169)
> at org.apache.turbine.modules.Page.build(Page.java:90)
> at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
> at org.apache.turbine.Turbine.handleException(Turbine.java:670)
> at org.apache.turbine.Turbine.doGet(Turbine.java:579)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.
java:684)
> at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatch
er.java:432)
> at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher
.java:356)
> at
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:430)
> at org.apache.jsp.index_jsp._jspService(index_jsp.java:42)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2
10)
> at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
> at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
> at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
> at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
> at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
> at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
> at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
> at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
> at java.lang.Thread.run(Thread.java:536)
> [16:53:53,901 DEBUG] JetspeedRunDataService: releasing rundata for thread:
Thread[Thread-10,5,main]
>
> Any help is appreciated.
> -Jo
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org