[jira] [Comment Edited] (TOMEE-2246) DataSources created in tomee.xml don't appear in JMX

[Jonathan S Fisher (JIRA)]

    [ 
https://issues.apache.org/jira/browse/TOMEE-2246?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16627916#comment-16627916
 ] 

Jonathan S Fisher edited comment on TOMEE-2246 at 9/25/18 9:36 PM:
-------------------------------------------------------------------

Ok I figured out *exacty* how to reproduce it. First, your configuration is 
using a Driver, not a DataSource. So I flipped mine to use a Driver as well. 
Next, I added this line to your configuration: {code}DataSourceCreator = 
dbcp{code} and I got the jmx tree. I also had to change user to username.

So working configuration using the latest mysql driver is:
{code}
        <Resource
                id="jdbc/myDataSource"
                type="DataSource">
                JdbcUrl=jdbc:mysql://localhost:3306/database?serverTimezone=UTC
                userName=me
                password=wahoo
                JdbcDriver=com.mysql.cj.jdbc.Driver
                MinIdle=5
                MaxWait=5000
                MaxTotal=75
                InitialSize=5
                ValidationQuery=SELECT 1
                TestOnBorrow=true
                DataSourceCreator = dbcp
        </Resource>
{code}

I'm unsure if there are any disadvantages to specifying dbcp instead of the 
default.


was (Author: exabrial):
Ok I figured out *exacty* how to reproduce it. First, your configuration is 
using a Driver, not a DataSource. So I flipped mine to use a Driver as well. 
Next, I added this line to your configuration: {code}DataSourceCreator = 
dbcp{code} and I got the jmx tree. I also had to change user to username.

So working configuration using the latest mysql driver is:
{code}
        <Resource
                id="jdbc/myDataSource"
                type="DataSource">
                JdbcUrl=jdbc:mysql://localhost:3306/database?serverTimezone=UTC
                userName=me
                password=wahoo
                JdbcDriver=com.mysql.cj.jdbc.Driver
                MinIdle=5
                MaxWait=5000
                InitialSize=5
                ValidationQuery=SELECT 1
                TestOnBorrow=true
                DataSourceCreator = dbcp
        </Resource>
{code}

I'm unsure if there are any disadvantages to specifying dbcp instead of the 
default.

> DataSources created in tomee.xml don't appear in JMX
> ----------------------------------------------------
>
>                 Key: TOMEE-2246
>                 URL: https://issues.apache.org/jira/browse/TOMEE-2246
>             Project: TomEE
>          Issue Type: Bug
>    Affects Versions: 7.0.5
>            Reporter: Jonathan S Fisher
>            Priority: Major
>         Attachments: Snip20180925_2.png
>
>
> If I recall correctly, you used to be able to see "datasrouces" in jmx 
> openejb.management. Am I imagining that? Just noticed they're no longer 
> there. Perphaps I'm declaring my datasource incorrectly?
> {code:java}
>       <Resource
>               id="jdbc/myDataSource"
>               type="DataSource">
>               
> JdbcUrl=jdbc:mysql:/example.com:3306?verifyServerCertificate=true&amp;requireSSL=true&amp;useSSL=true
>               user=itsme
>               password=password
>               JdbcDriver=com.mysql.cj.jdbc.MysqlXADataSource
>               MinIdle=5
>               MaxActive=75
>               MaxWait=5000
>               InitialSize=5
>               ValidationQuery=SELECT 1
>               TestOnBorrow=true
>                 JmxEnabled=true
>       </Resource>
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)