RE: Is the db name roller required?

[Charles Baker]

Okay given that and the following context config, in which the
connectionURL is all one line in the
$CATALINA_HOME/conf/Catalina/localhost/oldRoller.xml:

<Context path="/oldRoller" docBase="oldRoller" debug="99"
workDir="work/Catalina/localhost/oldRoller">

        
    <Realm className="org.apache.catalina.realm.JDBCRealm"      
     driverName="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/oldroller?autoReconnect=true&
amp;useUnicode=true&amp;characterEncoding=utf-8&amp;mysqlEncoding=utf8"

      connectionName="roller"
      connectionPassword="rellor"
      userTable="rolleruser" 
      userNameCol="username" 
      userCredCol="passphrase" 
      userRoleTable="userrole" 
      roleNameCol="rolename" debug="99" />

    <Resource name="jdbc/oldrollerdb" auth="Container"
type="javax.sql.DataSource"

      driverClassName="com.mysql.jdbc.Driver"
 
url="jdbc:mysql://localhost:3306/oldroller?autoReconnect=true&amp;useUni
code=true&amp;characterEncoding=utf-8&amp;mysqlEncoding=utf8"
      username="roller"
      password="rellor"
      maxActive="20"
      maxIdle="3"
      removeAbandoned="true"
      maxWait="3000" />

    <!--
      To enable email notification of comments: uncomment the resouce
below, 
      set your mailhost, and make sure you have mail.jar and
activation.jar 
      in <tomcat>/common/lib.
    -->
    <!--
    <Resource name="mail/Session" auth="Container"
type="javax.mail.Session"
      mail.smtp.host="mailhost.example.com" />
    -->

</Context>

What would be causing exceptions like this:

Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
JDBC driver of class '' for connect URL 'null'
        at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSo
urce.java:780)
        at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSourc
e.java:540)
        at
net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(D
atasourceConnectionProvider.java:61)
        at
net.sf.hibernate.impl.SessionFactoryImpl.openConnection(SessionFactoryIm
pl.java:417)
        ... 53 more
Caused by: java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getDriver(Unknown Source)
        at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSo
urce.java:773)
        ... 56 more

I have granted all on oldroller.* to the roller user. I can connect to
oldroller on the command line and on the command line via tcp as the
roller user.

----
Charles H. Baker
O: 864.422.5349 C: 864.201.8456
[EMAIL PROTECTED] 
There's nothing wrong with getting a steady paycheck, unless it
interferes with your ability to earn what you're worth. There's the rub.
It usually does. -- T Harv Eker

> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 31, 2006 10:25 AM
> To: roller-user@incubator.apache.org
> Subject: Re: Is the db name roller required?
> 
> That should work fine. The Roller database does NOT have to be named
> "roller"
> 
> - Dave
> 
> 
> On Jan 30, 2006, at 2:57 PM, Charles Baker wrote:
> 
> > I was thinking of putting my old roller data in a new database, say
> > oldRoller, and giving the old war a similar name. Then I could keep
my
> > old 0.9.8.2 roller blog available in parallel with my new 2.x blog
> > until
> > such time as I can figure out a way to migrate the data.
> >
> > ----
> > Charles H. Baker
> > O: 864.422.5349 C: 864.201.8456
> > [EMAIL PROTECTED]
> > There's nothing wrong with getting a steady paycheck, unless it
> > interferes with your ability to earn what you're worth. There's the
> > rub.
> > It usually does. -- T Harv Eker