Datasources

[Mike Cannon-Brookes]

G'day all,

How does one use the datasources and connection pools created by
datasources.xml ?

I believe I have created a pool and a datasource (see below) and Orion
starts up with no errors. How can grab a connection object now to access the
db? Sample code most appreciated ;) I'm trying to access it from a servlet.

<data-source class="com.evermind.sql.ConnectionDataSource"
location="jdbc/BMBDS">
        <name>BookmarkBox Datasource</name>
        <url>jdbc:odbc:BookmarkSQL</url>
        <connection-driver>sun.jdbc.odbc.JdbcOdbcDriver</connection-driver>
        <username>mike</username>
        <password>XXXXXX</password>
</data-source>

<data-source class="com.evermind.sql.DefaultConnectionPoolDataSource"
location="jdbc/BMBPooledDS">
        <name>BookmarkBox ConnectionPool data-source</name>
        <source-location>jdbc/BMBDS</source-location>
        <username>mike</username>
        <password>XXXXXX</password>
        <inactivity-timeout>300</inactivity-timeout>
        <max-connections>5</max-connections>
</data-source>


Cheers,
Mike