Servlet web.xml data-source Tag

Örnek

Şöyle yaparız

<data-source>
  <name>java:global/ExampleDataSource</name>
  <class-name>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</class-name>
  <server-name>localhost</server-name>
  <port-number>3306</port-number>
  <database-name>mysql</database-name>
  <user>root</user>
  <password>root</password>
  <!-- Example of how to use a Payara specific custom connection pool setting -->
  <property>
     <name>fish.payara.sql-trace-listeners</name>
     <value>com.sun.gjc.util.SQLTraceLogger</value>
  </property>
</data-source>

Oracle için şöyle yaparız

<class-name>oracle.jdbc.pool.OracleDataSource</class-name>

PostgreSQL için şöyle yaparız

<class-name>org.postgresql.ds.PGSimpleDataSource</class-name>

Ortam değişkenlerini kullanmak için şöyle yaparız

<server-name>${server.name}</server-name>

Bu kaynağı kullanmak için şöyle yaparız

@Resource(name=”java:global/ExampleDataSource”)

payara-resource.xml

src/main/java/webapp/WEB-INF dizinindedir.

Örnek

Şöyle yaparız

<resources>
  <jdbc-resource pool-name="MyAppDS"
                jndi-name="java:app/jdbc/MyApp"
                enable="true"/>
  <jdbc-connection-pool name="MySQLPool"
           res-type="javax.sql.XADataSource"
           datasource-classname="com.mysql.cj.jdbc.MysqlXADataSource">
    <property name="url" value="jdbc:h2:mem:hibernateExample"/>
    <property name="User" value="testUser"></property>
    <property name="Password" value="testPassword"></property>
    <property name="DatabaseName" value="myapp_db"></property>
    <property name="ServerName" value="localhost"></property>
    <property name="PortNumber" value="3306"></property>
  </jdbc-connection-pool>
</resources>

Şöyle yaparız

@PersistenceContext(unitName="MyAppPU")
private EntityManager entityManager;