Blogging Roller

After setting up the Roller datasource by following the instructions in the Orion docs Roller still would not work. Turns out, unlike Tomcat, OC4J needs to see a resource-ref in web.xml for before it allows access to a datasource. Once I added that resource-ref to web.xml, Roller was able to find it's datasource. I am now able to view weblog pages on OC4J. The next step is to configure authentication so I can login.

This is what I added to OC4J/config/data-sources.xml:

  <data-source   
    class="com.evermind.sql.DriverManagerDataSource" 
    name="rollerdb" location="jdbc/rollerdb" 
    connection-driver="org.gjt.mm.mysql.Driver" 
    username="scott" 
    password="tiger" 
    url="jdbc:mysql://localhost:3306/roller?autoReconnect=true" 
    inactivity-timeout="30" 
    schema="database-schemas/my-sql.xml" /> 

This is what I added to Roller's web.xml:

  <resource-ref>
    <res-ref-name>jdbc/rollerdb</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
  </resource-ref>

It is late and I'm tired of this experiment in install-blogging, so I'm gonna call it a night. I hope I haven't bored you to tears and caused you to unsubscribe from my RSS feed. I'll wrap things up tomorrow night and give you a final report.