[jboss-jira] [JBoss JIRA] Commented: (JBAS-9199) connection properties are being improperly quoted

Thu Mar 31 01:13:37 EDT 2011

    [ https://issues.jboss.org/browse/JBAS-9199?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12592846#comment-12592846 ] 

John Bailey commented on JBAS-9199:
-----------------------------------

I put together a fix for this:  https://github.com/baileyje/jboss-as/commit/7683a03433d9433ed1e76681b50e6ba1e24ccdbf


> connection properties are being improperly quoted
> -------------------------------------------------
>
>                 Key: JBAS-9199
>                 URL: https://issues.jboss.org/browse/JBAS-9199
>             Project: JBoss Application Server
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: JCA service
>    Affects Versions: 7.0.0.Beta1
>            Reporter: Andrig Miller
>            Assignee: Jesper Pedersen
>             Fix For: 7.0.0.Beta2
>
>
> I placed two connection property elements into my standalone.xml configuration for my data source, which is MySQL (5.5.9).
> When every I first try to execute anything I get the following error:
> 17:31:42,646 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/Order].[CreateData]] (http-192.168.1.22%2F192.168.1.22-8080-1) Servlet.service() for servlet CreateData threw exception: java.sql.SQLException: The connection property 'rewriteBatchedStatements' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value '("rewriteBatchedStatements" => "true")' is not in this set.
> The entry in standalone.xml is as follows:
> <connection-property name="rewriteBatchedStatements">true</connection-property>
> As you can see it is the correct value that is enumerated in the error message from MySQL, but it complains that "true" is not valid.  It appears the code is adding the double quotes around the value, instead of leaving it unquoted.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira