Return-Path: 
 <user-return-4068-apmail-roller-user-archive=roller.apache.org@roller.apache.org>
Delivered-To: apmail-roller-user-archive@www.apache.org
Received: (qmail 30635 invoked from network); 12 Feb 2008 08:44:42 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 12 Feb 2008 08:44:42 -0000
Received: (qmail 26302 invoked by uid 500); 12 Feb 2008 08:44:35 -0000
Delivered-To: apmail-roller-user-archive@roller.apache.org
Received: (qmail 26281 invoked by uid 500); 12 Feb 2008 08:44:35 -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 26272 invoked by uid 99); 12 Feb 2008 08:44:35 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Feb 2008 00:44:35 -0800
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: local policy)
Received: from [193.2.236.35] (HELO mail2.gov.si) (193.2.236.35)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Feb 2008 08:43:50 +0000
Received: from smtp.gov.si (smtp1 [172.24.240.71])
	by mail2.gov.si (MailServer) with ESMTP id 30D00AC0DB
	for <user@roller.apache.org>; Tue, 12 Feb 2008 09:44:10 +0100 (CET)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by smtp.gov.si (MailServer) with ESMTP id C2E9D54031
	for <user@roller.apache.org>; Tue, 12 Feb 2008 09:44:09 +0100 (CET)
X-Virus-Scanned: amavisd-new at gov.si
Received: from smtp.gov.si ([127.0.0.1])
	by localhost (localhost.localdomain [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id zGdXNl3gytvy for <user@roller.apache.org>;
	Tue, 12 Feb 2008 09:44:09 +0100 (CET)
Received: from hp-a180 (mail.mf-rs.si [192.168.220.40])
	by smtp.gov.si (MailServer) with SMTP id A164B54058
	for <user@roller.apache.org>; Tue, 12 Feb 2008 09:41:33 +0100 (CET)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable
X-MimeOLE: Produced By Microsoft Exchange V6.5
Subject: RE: Oracle connection URL issue? (was Re: Error filterStart?)
Date: Tue, 12 Feb 2008 09:42:36 +0100
Message-ID: <401175E741D5334E8D846560862B5B6F02B6A7C4@mfrswdneecs01.mf.si>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Oracle connection URL issue? (was Re: Error filterStart?)
Thread-Index: Achs9zd5GfejmEUWSLCSRpW3pBv9mQAW6urg
References: <8fb9ac720802111342m10626c16sf82f2fcf47cf64f6@mail.gmail.com>
From: =?iso-8859-2?Q?Boris_Miliki=E8?= <boris.milikic@mf-rs.si>
To: <user@roller.apache.org>
X-Virus-Checked: Checked by ClamAV on apache.org

<Context path=3D"/roller" docBase=3D"C:\projects\roller">
  <Resource
    auth=3D"Container"
    name=3D"jdbc/rollerdb"
    type=3D"javax.sql.DataSource"
    driverClassName=3D"oracle.jdbc.driver.OracleDriver"
          factory=3D"org.apache.commons.dbcp.BasicDataSourceFactory"
    username=3D"bm"
    password=3D"bm"
    url=3D"jdbc:oracle:thin:@irisint.com:1521:ROMA"
    maxActive=3D"20" maxIdle=3D"3" removeAbandoned=3D"true" =
maxWait=3D"3000" />
  <Resource
    auth=3D"Container"
    name=3D"mail/Session"
    type=3D"javax.mail.Session"
            mail.smtp.host=3D"smtp.mf.si"=20
            mail.smtp.auth=3D"true"
            mail.smtp.user=3D"bm"
            mail.smtp.password=3D"bm"
            mail.mime.charset=3D"UTF-8"/>
</Context>

- Boris
=20

-----Original Message-----
From: Dave [mailto:snoopdave@gmail.com]=20
Sent: Monday, February 11, 2008 10:42 PM
To: user@roller.apache.org
Subject: Oracle connection URL issue? (was Re: Error filterStart?)

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=20
> 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=20
> contexts, that looks like

That all sounds good.


> <Context path=3D"/roller"
>   docBase=3D"/path-to/roller" debug=3D"0">
>
>         <Resource auth=3D"Container"
>          =
connectionProperties=3D"autoReconnect=3Dtrue&amp;useUnicode=3Dtrue&amp;ch=
aracterEncoding=3Dutf-8&amp;mysqlEncoding=3Dutf8"
>          driverClassName=3D"oracle.jdbc.driver.OracleDriver"
>          maxActive=3D"50"
>          maxIdle=3D"3"
>          maxWait=3D"3000"
>          name=3D"jdbc/rollerdb"
>          password=3D"passwrd"
>          removeAbandoned=3D"true"
>          type=3D"javax.sql.DataSource"
>          url=3D"jdbc:oracle:thin:@dburl"
>          username=3D"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