[
https://issues.apache.org/jira/browse/TOMEE-2246?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16627880#comment-16627880
]
Jonathan Gallimore commented on TOMEE-2246:
-------------------------------------------
Resource for the datasource I used:
<Resource id="referralDatasource" type="DataSource">
JdbcDriver com.mysql.jdbc.Driver
JdbcUrl jdbc:mysql://localhost:3306/referral
JtaManaged true
UserName xxxxx
Password xxxxx
initialSize 2
maxActive 50
maxIdle 5
minIdle 0
maxWait 200
validationQuery SELECT 1
testOnBorrow false
testOnReturn false
testWhileIdle true
timeBetweenEvictionRunsMillis 60000
numTestsPerEvictionRun 3
minEvictableIdleTimeMillis 120000
poolPreparedStatements true
maxOpenPreparedStatements 128
jmxEnabled true
removeAbandoned true
removeAbandonedTimeout 10
logAbandoned true
</Resource>
> 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&requireSSL=true&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)