There is a lot of movement around the release of Open BlueDragon. It is good to see the community reacting positively to the open source endeavors of New Atlanta.
We, here at SixSigns, are currently testing our soon to be released open source Media Asset Management (MAM) with integrated Content Management called RAZUNA with the current release of Open BlueDragon.
As Razuna comes from our commercial product and that product stores every media asset in the Oracle 10G R2 database (future releases will support MySQL and other databases) it was one of the first tasks to get the Oracle database working with Open BlueDragon.
Open BlueDragon does not (yet) feature a full blown Admin section, so you will have to edit the XML file. But don’t let it hold you back. It is simple to understand and easy to change things.
Anyhow to add the Oracle database to Open BlueDragon you have to do the following:
- Download the appropriate JDBC Driver from Oracle (the ojdbc.14.jar) is just fine.
- Place that file into the folder “WEB-INF/lib”.
- Edit the bluedragon.xml file (WEB-INF/bluedragon) and add the following lines. Make sure they are in the <cfquery> section;
<datasource name=”oracle”>
<name>myschema</name>
<logintimeout>120</logintimeout>
<databasename>myschema</databasename>
<initstring></initstring>
<connectionretries>0</connectionretries>
<connectiontimeout>120</connectiontimeout>
<username>myschema</username>
<sqlstoredprocedures>true</sqlstoredprocedures> <hoststring>jdbc:oracle:thin:@mydomain:1521:ORCL</hoststring> <sqlupdate>true</sqlupdate>
<perrequestconnections>true</perrequestconnections>
<drivername>oracle.jdbc.OracleDriver</drivername>
<sqlinsert>true</sqlinsert>
<sqldelete>true</sqldelete>
<password>mypassword</password>
<maxconnections>24</maxconnections>
<sqlselect>true</sqlselect>
</datasource>
Once done, save and restart Jetty, JBoss or Tomcat.
