Mailing-List: contact user-help@roller.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@roller.apache.org
Received-SPF: pass (athena.apache.org: domain of snoopdave@gmail.com
 designates 66.249.92.171 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
        b=P3lwUUlNBZYd0DaxauBUm86UkVciTn+btjttmavxbzE9cnhWMnp2R07Z3uZZGToAPfxokKHstp3ljQJpSgwkTB5vgvx8MZk5sKxQXCQipfx8383m1hY6hQMk8uuT++gB8WCfjAjqaX3Rzue0F59+PzqR2bdc2gEz001GH2DX5tg=
Message-ID: <8fb9ac720802111342m10626c16sf82f2fcf47cf64f6@mail.gmail.com>
Date: Mon, 11 Feb 2008 16:42:22 -0500
From: Dave <snoopdave@gmail.com>
To: user@roller.apache.org
Subject: Oracle connection URL issue? (was Re: Error filterStart?)
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Feb 11, 2008 1:58 PM, Timothy Mizas <timothy.mizas@villanova.edu> wrote:
> In roller.log I get RollerContext:upgradeDatabaseIfNeeded -
> org.apache.commons.dbcp.SQLNestedException:
> Cannot create JDBC driver of class '' for connect URL 'null'

That Tomcat error message basically means that there is something
wrong with your database configuration, i.e. the JDBC jar is in the
wrong place, the connection URL is wrong, the driver class name is
wrong, etc.


> I'm connecting to Oracle9i and my classes12.jar is in common/lib. My roller-custom.properties file is found and loaded. I have a roller.xml file in conf/Standalone/hostname/ which is where my tomcat looks for contexts, that looks like

That all sounds good.


> <Context path="/roller"
>   docBase="/path-to/roller" debug="0">
>
>         <Resource auth="Container"
>          connectionProperties="autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=utf-8&amp;mysqlEncoding=utf8"
>          driverClassName="oracle.jdbc.driver.OracleDriver"
>          maxActive="50"
>          maxIdle="3"
>          maxWait="3000"
>          name="jdbc/rollerdb"
>          password="passwrd"
>          removeAbandoned="true"
>          type="javax.sql.DataSource"
>          url="jdbc:oracle:thin:@dburl"
>          username="username"/>
> </Context>

I don't think I've ever seen the connectionProperties attribute
before. And it looks like you are putting the MySQL connection
properties in there, that can't be right.

Any Oracle users out there want to offer some connection URL advice to
Mr. Mizas?

- Dave