tomee-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "KARR, DAVID" <>
Subject RE: Define datasource, reference JDBC driver, and see init in console
Date Tue, 02 Aug 2016 22:35:28 GMT
Although mentions the "classpath" attribute,
this is not mentioned in the "Supported Properties" list at

-----Original Message-----
From: Daniel Cunha [] 
Sent: Tuesday, August 02, 2016 2:10 PM
To: TomEE Users <>
Subject: Re: Define datasource, reference JDBC driver, and see init in console

Hi David,

yea, resources on TomEE is a mix (XML/Properties) Your definition should following the pattern:
 <Resource id="jdbc/sus2" type="DataSource">
            maxActive = 5
            maxIdle = 2
            maxWait = 10000
            driverClassName = oracle.jdbc.driver.OracleDriver
            url = jdbc:oracle:thin:@<host>:1521:<sid>
            username = <user>
            password = <password>

References you can see here:
About maven, should be enough have the configuration in your settings.xml.

On Tue, Aug 2, 2016 at 5:52 PM, KARR, DAVID <> wrote:

> (I posted this first to tomcat-user, but I realized technically it 
> should go to tomee-user.  I apologize if this is a duplicate for you. 
> In any case, this note has a little more info than the first note.)
> I'm attempting to use Tomcat(tomee) to run a REST service that will 
> return some data from some SQL queries (Oracle).  I've installed Tomee 
> 7.0.1, which uses Tomcat 8.5.3.
> The JDBC driver is available from a private enterprise maven repo.  
> I'd prefer to get it from there, as opposed to storing it locally.  I 
> noticed at , 
> there is the possible notation of "mvn:g:a:v" for the "classpath" 
> attribute.  However, I don't see any way to configure the Maven repositories this will
> How do I tell it to look in a particular repo for this?  Would it just 
> implicitly use my $HOME/.m2/settings.xml file?
> My Resource definition in "conf/tomee.xml" looks something like this:
> -----------------------
>   <Resource id="jdbc/sus2" type="DataSource"
>             maxActive="5" maxIdle="2" maxWait="10000"
>             driverClassName="oracle.jdbc.driver.OracleDriver"
>             url="jdbc:oracle:thin:@<host>:1521:<sid>"
>             username="<user>" password="<password>"/>
> ----------------
> Does this look correct?  I find the Tomcat docs confusing, with 
> respect to the required syntax for this.  It's not clear whether a 
> pure XML syntax is required, or a mixed XML/property syntax.
> If I start the instance, should I see any default output that will 
> show Tomcat connecting to this datasource?  If it doesn't show this by 
> default, is there a way to turn this on?
> I tried writing the code to obtain the JNDI resource (Spring context 
> references), but it just says it can't find it (fails at "jdbc"), so 
> perhaps my Resource definition was ignored, or my JNDI path is wrong.

Daniel Cunha
View raw message