JBoss Community

7.1.1. final cannot define Datasource for MySQL

created by Hans-Michael Rupp in JBoss AS 7 Development - View the full discussion

Hallo,

 

I have tried to follow

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

Start a new discussion in JBoss AS 7 Development at Community