You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomee.apache.org by paulhr <pa...@orthogroup.holdings> on 2016/07/27 19:33:10 UTC

Why unusedProperty warning?

Just getting started.  Noticed during a reboot just after adding a MariaDB
resource I am getting these warnings.  Are the safe to ignore?  Why am I
getting them?  I have not deployed the app yet that needs the MariaDB.

Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
createRecipe
INFO: Creating Resource(id=aForumsDatabase)
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "JdbcUrl" not supported by "aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "UserName" not supported by "aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "Password" not supported by "aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "PasswordCipher" not supported by "aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "ConnectionProperties" not supported by "aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "DefaultAutoCommit" not supported by "aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "DefaultReadOnly" not supported by "aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "InitialSize" not supported by "aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "MaxActive" not supported by "aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "MaxIdle" not supported by "aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "MinIdle" not supported by "aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "ValidationQuery" not supported by "aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "TestOnBorrow" not supported by "aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "TestOnReturn" not supported by "aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "TestWhileIdle" not supported by "aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "NumTestsPerEvictionRun" not supported by
"aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "PoolPreparedStatements" not supported by
"aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "MaxOpenPreparedStatements" not supported by
"aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty
WARNING: Property "AccessToUnderlyingConnectionAllowed" not supported by
"aForumsDatabase"
Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
unusedProperty




--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/Why-unusedProperty-warning-tp4679516.html
Sent from the TomEE Users mailing list archive at Nabble.com.

Re: Why unusedProperty warning?

Posted by paulhr <pa...@orthogroup.holdings>.
Fixed thanks.  



--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/Why-unusedProperty-warning-tp4679516p4679523.html
Sent from the TomEE Users mailing list archive at Nabble.com.

Re: Why unusedProperty warning?

Posted by Romain Manni-Bucau <rm...@gmail.com>.
error is: JdbcDriver = org.mariadb.jdbc.MariaDbDataSource

if you set a datasource and not a driver then the datasource is created
with all properties as well as the poll so the not matching one are logged
(it litterally mixes/merges 2 resources creation in one)

just use org.mariadb.jdbc.Driver instead

Romain Manni-Bucau
@rmannibucau <https://twitter.com/rmannibucau> |  Blog
<https://blog-rmannibucau.rhcloud.com> | Old Wordpress Blog
<http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> |
LinkedIn <https://www.linkedin.com/in/rmannibucau> | Tomitriber
<http://www.tomitribe.com> | JavaEE Factory
<https://javaeefactory-rmannibucau.rhcloud.com>

2016-07-28 1:01 GMT+02:00 paulhr <pa...@orthogroup.holdings>:

> http://pastebin.com/KuCzeFSY
>
>
>
> --
> View this message in context:
> http://tomee-openejb.979440.n4.nabble.com/Why-unusedProperty-warning-tp4679516p4679521.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>

Re: Why unusedProperty warning?

Posted by paulhr <pa...@orthogroup.holdings>.
http://pastebin.com/KuCzeFSY



--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/Why-unusedProperty-warning-tp4679516p4679521.html
Sent from the TomEE Users mailing list archive at Nabble.com.

Re: Why unusedProperty warning?

Posted by Romain Manni-Bucau <rm...@gmail.com>.
means that with this declaration you shouldn't get that much warnings, in
particular 5 first are always supported whatever jdbc pool you use

would be interesting if you can share on a pastebin or gist the actual
tomee.xml file


Romain Manni-Bucau
@rmannibucau <https://twitter.com/rmannibucau> |  Blog
<https://blog-rmannibucau.rhcloud.com> | Old Wordpress Blog
<http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> |
LinkedIn <https://www.linkedin.com/in/rmannibucau> | Tomitriber
<http://www.tomitribe.com> | JavaEE Factory
<https://javaeefactory-rmannibucau.rhcloud.com>

2016-07-28 0:33 GMT+02:00 paulhr <pa...@orthogroup.holdings>:

> Sorry I am so dumb, but I don't know what is meant by "should be fixed".  I
> got the keywords from TomEE documentation  here
> <http://tomee.apache.org/datasource-config.html>  .
>
> <Resource id="aForumsDS" type="DataSource">
> JdbcDriver = org.mariadb.jdbc.MariaDbDataSource
> JdbcUrl = jdbc:mysql://localhost:3306/aforumsdb
> UserName = aforums
> Password = [redacted]
> JtaManaged = true
> maxActive = 10
> maxWaitTime = 10 seconds
> minIdle = 3
> maxIdle = 10
> removeAbandoned = true
> removeAbandonedTimeout = 30
> logAbandoned = true
> validationQuery = SELECT 1
> </Resource>
>
>
>
>
> --
> View this message in context:
> http://tomee-openejb.979440.n4.nabble.com/Why-unusedProperty-warning-tp4679516p4679519.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>

Re: Why unusedProperty warning?

Posted by paulhr <pa...@orthogroup.holdings>.
Sorry I am so dumb, but I don't know what is meant by "should be fixed".  I
got the keywords from TomEE documentation  here
<http://tomee.apache.org/datasource-config.html>  . 

<Resource id="aForumsDS" type="DataSource">
JdbcDriver = org.mariadb.jdbc.MariaDbDataSource
JdbcUrl = jdbc:mysql://localhost:3306/aforumsdb
UserName = aforums
Password = [redacted]
JtaManaged = true
maxActive = 10
maxWaitTime = 10 seconds
minIdle = 3
maxIdle = 10
removeAbandoned = true 
removeAbandonedTimeout = 30 
logAbandoned = true
validationQuery = SELECT 1
</Resource>




--
View this message in context: http://tomee-openejb.979440.n4.nabble.com/Why-unusedProperty-warning-tp4679516p4679519.html
Sent from the TomEE Users mailing list archive at Nabble.com.

Re: Why unusedProperty warning?

Posted by Romain Manni-Bucau <rm...@gmail.com>.
Hi

Looks like you configure a tomee datasource setting a custom class-name. If
so warnings are accurate and config should be fixed.

Le 27 juil. 2016 22:17, "paulhr" <pa...@orthogroup.holdings> a écrit :

> Just getting started.  Noticed during a reboot just after adding a MariaDB
> resource I am getting these warnings.  Are the safe to ignore?  Why am I
> getting them?  I have not deployed the app yet that needs the MariaDB.
>
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> createRecipe
> INFO: Creating Resource(id=aForumsDatabase)
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "JdbcUrl" not supported by "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "UserName" not supported by "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "Password" not supported by "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "PasswordCipher" not supported by "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "ConnectionProperties" not supported by "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "DefaultAutoCommit" not supported by "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "DefaultReadOnly" not supported by "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "InitialSize" not supported by "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "MaxActive" not supported by "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "MaxIdle" not supported by "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "MinIdle" not supported by "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "ValidationQuery" not supported by "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "TestOnBorrow" not supported by "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "TestOnReturn" not supported by "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "TestWhileIdle" not supported by "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "NumTestsPerEvictionRun" not supported by
> "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "PoolPreparedStatements" not supported by
> "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "MaxOpenPreparedStatements" not supported by
> "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
> WARNING: Property "AccessToUnderlyingConnectionAllowed" not supported by
> "aForumsDatabase"
> Jul 27, 2016 4:08:56 PM org.apache.openejb.assembler.classic.Assembler
> unusedProperty
>
>
>
>
> --
> View this message in context:
> http://tomee-openejb.979440.n4.nabble.com/Why-unusedProperty-warning-tp4679516.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>