Return-Path: 
 <user-return-5809-apmail-roller-user-archive=roller.apache.org@roller.apache.org>
Delivered-To: apmail-roller-user-archive@www.apache.org
Received: (qmail 31296 invoked from network); 16 Oct 2009 00:51:23 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 16 Oct 2009 00:51:23 -0000
Received: (qmail 15190 invoked by uid 500); 16 Oct 2009 00:51:22 -0000
Delivered-To: apmail-roller-user-archive@roller.apache.org
Received: (qmail 15129 invoked by uid 500); 16 Oct 2009 00:51:22 -0000
Mailing-List: contact user-help@roller.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@roller.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@roller.apache.org>
List-Post: <mailto:user@roller.apache.org>
List-Id: <user.roller.apache.org>
Reply-To: user@roller.apache.org
Delivered-To: mailing list user@roller.apache.org
Received: (qmail 15116 invoked by uid 99); 16 Oct 2009 00:51:22 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 16 Oct 2009 00:51:22 +0000
X-ASF-Spam-Status: No, hits=-2.6 required=5.0
	tests=BAYES_00,HTML_MESSAGE
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of levine_brian@hotmail.com
 designates 65.54.246.101 as permitted sender)
Received: from [65.54.246.101] (HELO bay0-omc1-s29.bay0.hotmail.com)
 (65.54.246.101)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 16 Oct 2009 00:51:19 +0000
Received: from BAY141-W13 ([65.55.152.48]) by bay0-omc1-s29.bay0.hotmail.com
 with Microsoft SMTPSVC(6.0.3790.3959);
	 Thu, 15 Oct 2009 17:50:59 -0700
Message-ID: <BAY141-W13295923747F01FFE495D0FBC40@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_40d0a51a-a351-461b-8a5c-4ffe73615a8d_"
X-Originating-IP: [69.136.235.176]
From: Brian Levine <levine_brian@hotmail.com>
To: <user@roller.apache.org>
Subject: DB connection pooling
Date: Thu, 15 Oct 2009 20:50:59 -0400
Importance: Normal
MIME-Version: 1.0
X-OriginalArrivalTime: 16 Oct 2009 00:50:59.0224 (UTC)
 FILETIME=[BA0FC980:01CA4DFA]

--_40d0a51a-a351-461b-8a5c-4ffe73615a8d_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable



I'm trying to setup DB Connection pooling with roller=2C but I'm having tro=
uble.

I'm using tomcat 5.5 and mysql 5.x.

I've placed a context.xml file in the META_INF directory that looks like th=
is:

<Context debug=3D"0">

  <Resource name=3D"jdbc/rollerdb" auth=3D"Container" type=3D"javax.sql.Dat=
aSource"
    driverClassName=3D"com.mysql.jdbc.Driver"
    url=3D"jdbc:mysql://localhost:3306/rollerblog?autoReconnect=3Dtrue"
    username=3D"blevine"
    password=3Dxxxxxx
    maxActive=3D"20" maxIdle=3D"3" removeAbandoned=3D"true" maxWait=3D"3000=
" />

  <Resource name=3D"mail/Session" auth=3D"Container" type=3D"javax.mail.Ses=
sion"
     mail.smtp.host=3D"smtp-server.example.com" />

</Context>

And then created the WAR and deployed it.

When I load up roller in my browser (firefox) I get this error:

A database error occurred=2C probably because your database connection
is misconfigured. You will have to fix this problem and then restart or
redeploy Roller before you can proceed. Here's what happened when
Roller tried to establish a connection:

SUCCESS: Got parameters. Using configuration type JNDI_NAME-- Using JNDI da=
tasource name: java:comp/env/jdbc/rollerdbSUCCESS: located JNDI DataSource =
[java:comp/env/jdbc/rollerdb]ERROR: unable to obtain database connection. L=
ikely problem: bad connection parameters or database unavailable.
 [org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of =
class '' for connect URL 'null'
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSourc=
e.java:1150)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.j=
ava:880)
	at org.apache.roller.weblogger.business.DatabaseProvider.getConnection(Dat=
abaseProvider.java:179)
	at org.apache.roller.weblogger.business.DatabaseProvider.<init>(DatabasePr=
ovider.java:141)
	at org.apache.roller.weblogger.business.startup.WebloggerStartup.prepare(W=
ebloggerStartup.java:171)
	at org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(Ro=
llerContext.java:138)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.=
java:3764)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:421=
6)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.j=
ava:760)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java=
:626)
	at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.jav=
a:553)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:3=
11)
	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleS=
upport.java:120)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
	at org.apache.catalina.core.StandardService.start(StandardService.java:448=
)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja=
va:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso=
rImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja=
va:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso=
rImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:=
177)
Caused by: java.lang.NullPointerException
	at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
	at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
	at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
	at java.sql.DriverManager.getDriver(DriverManager.java:253)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSourc=
e.java:1143)
	... 33 more]
I removed the "docBase" and "path" attributes from the "Context" element be=
cause I saw something in the tomcat docs that says leaving those in will me=
ss up the deployment.  I tried it with those in and got the same errors.

I copied over the url=2C username=2C password=2C and driverClassName from r=
oller-custom.properties so I'm pretty sure those were right.

Anyone have any suggestions?

Thanks!
/Brian

 		 	   		 =20
_________________________________________________________________
Hotmail: Trusted email with Microsoft=92s powerful SPAM protection.
http://clk.atdmt.com/GBL/go/177141664/direct/01/=

--_40d0a51a-a351-461b-8a5c-4ffe73615a8d_--