Roller gets some respect
From A Baggins Under the Hill (nice looking theme BTW):
There's a surprising (or perhaps not so surprising) number of PHP programs, intricate ones at that, that have developers who didn't bother to abstract away the database layer, and wrote DB-vendor-dependent queries. That's a pretty horrible thing to do, since it ties you quite firmly down to one DB (in many cases MySQL). The SQL code is often very tightly integrate with the display code; it's bad enough in the business layer, but the view layer as well? Good gods.
...
Roller, on the other hand, uses things like Hibernate to abstract away queries from the underlying DB implementations, and Velocity to separate out the display logic from the business logic. And blogging software does have business logic, or a model; blog entries and categories and tags and authentication and the manipulation thereof are not simple. As a result, I see features being added to Roller that I'm surprised to see happening so quickly.
As far as solving the issue with Tomcat 5.5, that's just a matter of updating your $CATALINA_HOME/conf/Catalina/localhost/roller.xml file. Here's what I use for Roller on PostgreSQL:
<Context path="/roller" docBase="roller" debug="99" reloadable="false"
antiJARLocking="true" antiResourceLocking="false">
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="org.postgresql.Driver"
connectionURL="jdbc:postgresql://localhost/roller"
connectionName="postgres" connectionPassword="postgres"
userTable="rolleruser" userNameCol="username" userCredCol="passphrase"
userRoleTable="userrole" roleNameCol="rolename" />
<Resource name="jdbc/rollerdb" auth="Container" type="javax.sql.DataSource"
maxActive="20" maxIdle="10" maxWait="100"
driverClassName="org.postgresql.Driver"
username="postgres" password="postgres"
url="jdbc:postgresql://localhost/roller"/>
<Resource name="mail/Session" auth="Container" type="javax.mail.Session"
mail.smtp.host="localhost" />
</Context>