Saturday, September 15, 2012

How to use JPA using data-source on tomcat?

How to use JPA using data-source on tomcat?

Step :1 Add following details to context.xml of tomcat server
    <Resource auth="Container"
   driverClassName="com.mysql.jdbc.Driver"
   maxActive="20"
   maxIdle="10"
   maxWait="-1"
   name="jdbc/myconnection"
   password="admin"
   type="javax.sql.DataSource"
   url="jdbc:mysql://localhost:3306/test?auto_reconnect=true&amp;relaxAutoCommit=true"
   username="root"/>

Step 2 : Add resource-ref in web.xml
<resource-ref>
      <description>DB Connection</description>
      <res-ref-name>jdbc/myconnection</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
  </resource-ref>


Step 3: Add following details in persistence.xml
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence"
    version="1.0">
<persistence-unit name="jpa" transaction-type="RESOURCE_LOCAL">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    <non-jta-data-source>java:comp/env/jdbc/myconnection</non-jta-data-source>
     <properties>
            <property name="hibernate.connection.datasource" value="java:comp/env/jdbc/myconnection"/>
            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
            <property name="hibernate.id.new_generator_mappings" value ="true"/>
  
        </properties>
    </persistence-unit>
</persistence>


Now your data-source is ready to connect database.

33 comments:

  1. Thanks for publishing such high-quality content. Keep up the great work!workday hcm course

    ReplyDelete
  2. DataStage learning offers a structured approach to understanding IBM DataStage and its role in enterprise data integration. This datastage learning covers ETL concepts, job design, data processing, job sequencing, metadata management, and optimization. Students strengthen their knowledge through practical exercises and real-world projects.

    ReplyDelete
  3. Very informative content for Salesforce aspirants. A Salesforce administrator course online can help learners gain knowledge of configuration, user management, reporting, and other essential Salesforce administration skills.salesforce administrator course online

    ReplyDelete
  4. A Salesforce Admin Course Online can help learners develop skills in user management, security, data management, reports, dashboards, and automation. Flexible online learning is especially useful for professionals who want to improve their Salesforce knowledge alongside their current work.salesforce admin course online

    ReplyDelete
  5. Online Power BI Training can help students, analysts, and working professionals develop practical skills in data analysis and visualization. Learners can understand how to connect and transform data, create relationships, develop DAX measures, and build interactive reports. Consistent practice with real datasets can help turn Power BI knowledge into valuable professional expertise.online power bi training

    ReplyDelete

Thanks for your valuable comment. You comment will go live soon.