VadOs VadOs - 1 year ago 86
Java Question

How to obtain datasource from resource(s) in TomEE 7?

I'm doing java EE web application with deployment to TomEE 7 and I need to get datasource from tomee.xml. tomee.xml is located in WEB-INF directory and has the following content:

<?xml version="1.0" encoding="UTF-8"?>
<Resource id="rss_db_datasource" type="javax.sql.DataSource">
JdbcDriver = org.hsqldb.jdbcDriver
JdbcUrl = jdbc:hsqldb:file:/rss_db
UserName = sa
Password =

I'm trying to inject Datasource using this code:

@Resource(name="rss_db_datasource", type = javax.sql.DataSource.class)
private DataSource dataSource;

When I try to get connection from the datasource I get NullPointerException. does anybody know how to resolve this?

thank you

Answer Source

META-INF -> context.xml

<?xml version='1.0' encoding='utf-8'?>
    <Resource name="rss_db_datasource" type="javax.sql.DataSource"
              username="sa" password=""
              driverClassName="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:file:D:/rss_db"

and then getting DataSource object

        Context initCtx = new InitialContext();
        Context envCtx = (Context) initCtx.lookup("java:comp/env");
        dataSource = (DataSource) envCtx.lookup("rss_db_datasource");
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download