sedj,
after your recommendation on tek-tips earlier on i decided to go ahead with primrose and give it a try. but i seem to be getting an error coming up:
WARNING: Unexpected exception resolving reference
java.lang.NullPointerException
at uk.org.primrose.pool.datasource.MasterPoolDataSourceFactory.getObjectInstance(MasterPoolDataSourceFactory.java:49)
at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:129)
at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)
at org.apache.naming.NamingContext.lookup(NamingContext.java:792)
at org.apache.naming.NamingContext.lookup(NamingContext.java:139)
at org.apache.naming.NamingContext.lookup(NamingContext.java:780)
at org.apache.naming.NamingContext.lookup(NamingContext.java:139)
at org.apache.naming.NamingContext.lookup(NamingContext.java:780)
at org.apache.naming.NamingContext.lookup(NamingContext.java:139)
at org.apache.naming.NamingContext.lookup(NamingContext.java:780)
at org.apache.naming.NamingContext.lookup(NamingContext.java:152)
at org.apache.naming.SelectorContext.lookup(SelectorContext.java:136)
at javax.naming.InitialContext.lookup(InitialContext.java:351)
at main.MultiFetcher.getMyDatabase(MultiFetcher.java:185)
at main.MultiFetcher.processRequest(MultiFetcher.java:95)
at main.MultiFetcher.doGet(MultiFetcher.java:164)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
this comes up in catalina.out, whether i put it in server.xml and do a ResourceLink or put a resource directly in my apps context.xml I alwasy get this error.
the resources looks like below:
<Resource name="masterPool" auth="Container"
type="java.util.ArrayList"
factory="uk.org.primrose.pool.datasource.MasterPoolDataSourceFactory"
configFile="/opt/tomcat/conf/poolConfig.properties"
description="Holds all the pools"/>
<Resource name="jdbc/devDatabase" auth="Container"
type="uk.org.primrose.pool.datasource.PoolDataSource"
factory="uk.org.primrose.pool.datasource.MasterPoolDataSourceFactory"
description="Dev MySQL Database pool"
poolName="devDatabase" />
<Resource name="jdbc/liveDatabase" auth="Container"
type="uk.org.primrose.pool.datasource.PoolDataSource"
factory="uk.org.primrose.pool.datasource.MasterPoolDataSourceFactory"
description="Live MySQL Database pool"
poolName="liveDatabase" />
and poolConfig.properties has the following -
##### webmap pool instance #####
poolName=devDatabase
base=5
overflow=1
log=../logs/dbpools_${yyyy-MM-dd}.log
idleTime=120000
messageLogging=true
sizeLogging=true
driverClass=org.gjt.mm.mysql.Driver
driverURL=jdbc:mysql://xxx:3306/xml_availability_dev?autoReconnect=true
user=xxx
password=xxx
killActiveConnectionsOverAge=120000
cycleConnections=1000
##### webmap pool instance #####
poolName=liveDatabase
base=5
overflow=1
log=../logs/dbpools_${yyyy-MM-dd}.log
idleTime=120000
messageLogging=true
sizeLogging=true
driverClass=org.gjt.mm.mysql.Driver
driverURL=jdbc:mysql://xxx:3306/xml_availability?autoReconnect=true
user=xxx
password=xxx
killActiveConnectionsOverAge=120000
cycleConnections=1000
any ideas where I went wrong?
thanks in advance!
nayeem
[ps i couldnt post on your forum, is firefox a problem?]
