[jboss-dev-forums] [JBoss AS 7 Development] - 7.1.1. final cannot define Datasource for MySQL

[Hans-Michael Rupp]

Hans-Michael Rupp [https://community.jboss.org/people/MarcusDidiusFalco] created the discussion

"7.1.1. final cannot define Datasource for MySQL"

To view the discussion, visit: https://community.jboss.org/message/728869#728869

--------------------------------------------------------------
Hallo,

I have tried to follow
 https://community.jboss.org/docs/DOC-16657 https://community.jboss.org/wiki/DataSourceConfigurationInAS7
to define a DataSource for MySQL.
I have tried to modify standalone.xml with
<datasources>
    <datasource jndi-name="java:jboss/datasources/Betreuung" pool-name="Betreuung">
        <connection-url>jdbc:mysql://localhost:3306/Betreuung</connection-url>
        <driver>com.mysql</driver>
        <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
        <pool>
            <min-pool-size>10</min-pool-size>
            <max-pool-size>100</max-pool-size>
            <prefill>true</prefill>
        </pool>
        <security>
            <user-name>test</user-name>
            <password>test</password>
        </security>
        <statement>
            <prepared-statement-cache-size>32</prepared-statement-cache-size>
            <share-prepared-statements/>
        </statement>
    </datasource>
    <drivers>
        <driver name="com.mysql" module="com.mysql">
            <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
        </driver>
    </drivers>

However each time I deploy my application or restart the server those changes are lost and the original standalone.xml is back.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/728869#728869]

Start a new discussion in JBoss AS 7 Development at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2225]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-dev-forums/attachments/20120409/02645354/attachment.html