[TP12] glassfish domain.xml mysql

[ply]

Bonjour Mr GRAFFION,

pouvez-vous donner la configuration du fichier domain.xml pour mysql dans glassfish ?

[graffiop]

Bonjour,

ant check (plus précisément ant checkglassfish) contrôle la présence du DataSource jdbc/petstoreDS12 dans domain.xml et donne les instructions pour le définir si absent (instructions présentes dans ${yaps.config.dir}/DataSource.for.domain.xml).

[ply]

Le datasource-classname est bien ="com.mysql.jdbc.jdbc2.optional.MysqlDataSource" ?

Peut être une erreur dans l'URL value="jdbc:mysql://localhost:3306/petstoreDB12?zeroDateTimeBehavior=convertToNull"

domain.xml de glassfish

<resources>
<jdbc-resource pool-name="mysql_petstoredb12_rootPool" jndi-name="jdbc/petstoreDS12"></jdbc-resource>

<jdbc-connection-pool connection-validation-method="auto-commit" datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlDataSource" wrap-jdbc-objects="false" res-type="javax.sql.DataSource" name="mysql_petstoredb12_rootPool">
<property name="URL" value="jdbc:mysql://localhost:3306/petstoreDB12?zeroDateTimeBehavior=convertToNull"></property>
<property name="driverClass" value="com.mysql.jdbc.Driver"></property>
<property name="Password" value=""></property>
<property name="portNumber" value="3306"></property>
<property name="databaseName" value="petstoredb12"></property>
<property name="User" value="root"></property>
<property name="serverName" value="localhost"></property>
</jdbc-connection-pool>
</resources>

<servers>
<server name="server" config-ref="server-config">
<application-ref ref="hello" virtual-servers="server"></application-ref>

<resource-ref ref="jdbc/__TimerPool"></resource-ref>
<resource-ref ref="jdbc/__default"></resource-ref>
<resource-ref ref="jms/__defaultConnectionFactory"></resource-ref>
<resource-ref ref="jdbc/sample"></resource-ref>
<resource-ref ref="concurrent/__defaultContextService"></resource-ref>
<resource-ref ref="concurrent/__defaultManagedExecutorService"></resource-ref>
<resource-ref ref="concurrent/__defaultManagedScheduledExecutorService"></resource-ref>
<resource-ref ref="concurrent/__defaultManagedThreadFactory"></resource-ref>
<resource-ref ref="jdbc/petstoreDS12"></resource-ref>
</server>
</servers>