Blogging Roller

Dave Johnson on social software, open source and Java

Almost there.

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.

Dave in Roller Comments[0]

Tags: Roller

Comments:

Post a Comment:
  • HTML Syntax: Allowed

Welcome

You're viewing a weblog entry titled Almost there.. If you like this entry you might want to:

del.icio.us Bookmark it submit to dig digg.com Digg it
slashdot Slashdot it technorati See who links to it

This is just one entry in the weblog Blogging Roller. Why don't you visit the main page of the weblog?

Related entries

Below are the most recent entries in the category Roller, some may be related to this entry.

Apache feather

Powered by Apache Roller