« OC4J can't handle... | Main | You just need to... »

Almost there.

Comments[0] by Dave in 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.



Like this post?  del.icio.us Bookmark it   |   submit to dig digg.com Digg it   |   slashdot Slashdot it   |   technorati See who links to it

Comments:

Post a Comment:
  • HTML Syntax: Allowed

This work is licensed under a Creative Commons License.
Copyright 2002-2007, David M Johnson (dave.johnson at rollerweblogger.org)

This is a personal weblog, I do not speak for my employer.