Re: Is the db name roller required?

[Aurélien DEHAY]

Hello.

Charles Baker wrote:
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"

I think that here, the name of the resource should always be 
jdbc/rollerdb. But the name in the DB engine can change.


Regards.
--
Aurélien