[xwiki-users] Using a JDNI DataSource for connection pooling

23 Dec 2014

      I've been exploring connection pooling for an external database, but I'm struggling to use it. I'm running XWiki 6.3 on a Ubuntu server. In /etc/xwiki/context.xml I have

<?xml version="1.0" encoding="UTF-8"?>
<Context>
  <!-- JDBC datasource for myDB -->
  <Resource name="jdbc/mydbds" 
            auth="Container"
            type="javax.sql.DataSource" 
            username="dbuser" 
            password="dbpass"
            driverClassName="org.postgresql.Driver"
            url="jdbc:postgresql:alertdb"
            maxActive="10" 
            maxIdle="4" />
  </Context>

And I have a symlink to this at /usr/lib/xwiki/WEB-INF/context.xml

I'm trying to test that I can access this with a Groovy script. I'm not entirely sure of the correct approach here, but the most successful I've got it with
{{groovy}}
import groovy.sql.Sql
import javax.naming.Context
import javax.naming.InitialContext
import javax.sql.DataSource

Context ctx = new InitialContext();
DataSource dataSource = (DataSource) ctx.lookup("jdbc/mydbds");
def sql = new Sql(dataSource)
{{/groovy}}

However this fails with 
javax.naming.NameNotFoundException: Name [jdbc/mydbds] is not bound in this Context. Unable to find [jdbc].

Would anyone be able to tell me whether this is the right sort of way to be going about using a JNDI resource, and what's wrong with my implementation?

[xwiki-users] Using a JDNI DataSource for connection pooling

Bryn Jeffries