Eclipse Community Forums: EclipseLink » Integrate BoneCP and EclipseLink with LOCAL

Home » Eclipse Projects » EclipseLink » Integrate BoneCP and EclipseLink with LOCAL_RESOURCE transaction-type(Integrate BoneCP and EclipseLink with LOCAL_RESOURCE transaction-type)

Integrate BoneCP and EclipseLink with LOCAL_RESOURCE transaction-type [message #1718390]

Wed, 23 December 2015 04:19

Eclipse User

I am setting up a minimal working example where I use EclipseLink in a Java EE (JSF) project. My example works perfectly with the following configuration:

persistence.xml

<persistence
    version="2.0"
    ...
>
    <persistence-unit name="issat_PU_Local" transaction-type="RESOURCE_LOCAL">
        <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
        <class>pro.entity.Utilisateur</class>
        <properties>
            <property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver" />
            <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/issat" />
            <property name="javax.persistence.jdbc.user" value="java" />
            <property name="javax.persistence.jdbc.password" value="JaVa" />
            <property name="eclipselink.logging.level.sql" value="FINE" />
            <property name="eclipselink.logging.parameters" value="true"/>
        </properties>
    </persistence-unit>
</persistence>

Since I don't want to use JTA I am using RESOURCE_LOCAL as transaction type and perfectly leaving with "manually" handling transaction inside my DAO.

I now want to use BoneCP connection pool with my example. How should I precisely modify my persistence.xml to do that?

I found many configuration examples in the internet using also Hibernate, but I want to stay with EclipseLink.

Re: Integrate BoneCP and EclipseLink with LOCAL_RESOURCE transaction-type [message #1719039 is a reply to message #1718390]

Mon, 04 January 2016 11:16

Eclipse User

JPA defines how to define datasources within the persistence unit in a standards way. See http://www.eclipse.org/eclipselink/documentation/2.5/solutions/tlandwls002.htm#BABCGGEJ for an example showing how to define the non-jta-datasource tag, giving the provider a datasource outside of any JTA managed transaction scope, which will be used for resource local transactions.

Re: Integrate BoneCP and EclipseLink with LOCAL_RESOURCE transaction-type [message #1719090 is a reply to message #1719039]

Tue, 05 January 2016 02:26

Eclipse User

Thank you Chris for your reply. Allow me to take my question further:

I used to deploy Java EE applications to a light container (Apache Tomcat), I am now trying full Java EE compliant servers and I started looking at Apache Tomee (Plume version which supports among others EclipseLink).
I learned that with Apache Tomee data sources can be declared globally to the container (in tomee.xml configuration file), then possibly used by many applications (in stead of each time configuring "by hand" the data source per each application).
I also succeeded into using BoneCP as connection pool provider by configuring inherently the data source in tomee.xml, see the use of org.apache.openejb.bonecp.BoneCPDataSourceCreator in tomee.xml below:

<Resource id="jdbc/bonecp_resource_issat" type="DataSource">
	DataSourceCreator org.apache.openejb.bonecp.BoneCPDataSourceCreator
	JtaManaged true
	JdbcDriver com.mysql.jdbc.Driver
	JdbcUrl jdbc:mysql://localhost:3306/issat
	UserName java
	Password JaVa
	PartitionCount 2
	MinConnectionsPerPartition 5
	MaxConnectionsPerPartition 10
	ValidationQuery SELECT 1
</Resource>

If I understood correctly your suggestion: I can get rid of JTA by configuring my application's persistence.xml file as explained by the link your provided, while still using a data source globally defined in Apache Tomee and consequently while still having BoneCP in charge of the data pool.
Is my understanding correct ?

What if I want to use EclipseLink and BoneCP into an application to be deployed under a light container like Apache Tomcat, so using only the application's persistence.xml file to define my data source (and not using a "global" JNDI resource).
Is there a way to tell EclipseLink to use BoneCP as a connection pool provider ?

I'm pretty sure this is possible through Hibernate (I already did it with c3p0 connection pool provider), but could this be done without Hibernate and only with EclipseLink ?

[Updated on: Tue, 05 January 2016 03:06] by Moderator

Re: Integrate BoneCP and EclipseLink with LOCAL_RESOURCE transaction-type [message #1719390 is a reply to message #1719090]

Thu, 07 January 2016 10:36

Eclipse User

I'm not familiar with BoneCP and haven't really done any projects on the Tomcat variants either so maybe someone else might be able to come up with examples or help.

The non-jta-datasource tag tells the provider to look up the datasource from the context - this lookup is controlled through a EclipseLink server platform class. If you run into trouble, you could always make your own custom subclass to handle it how ever you need to, and then specify it using the eclipselink.target-server property http://www.eclipse.org/eclipselink/documentation/2.4/jpa/extensions/p_target_server.htm

Another alternative is that you can pass the datasource directly to EclipseLink as a persistence property as described here:
http://onpersistence.blogspot.com/2008/04/eclipselink-and-datasources.html

Hopefully this points you in the right direction.

Best Regards,
Chris

Re: Integrate BoneCP and EclipseLink with LOCAL_RESOURCE transaction-type [message #1719466 is a reply to message #1719390]

Fri, 08 January 2016 03:45

Eclipse User

Thank you very much Chris, I'll try "digging" in both directions you pointed out, and hopefully will come back with some feedback.

Previous Topic:	Escaping ]]> in MOXy
Next Topic:	(Resolved) EclipseLink 2.6.0 creates too many instances when join fetching ElementCollection

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Jul 14 14:44:52 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter