Re: [eclipselink-users] Updates two database servers in one take

[Edson Carlos Ericksson Richter <edsonrichter@xxxxxxxxxxx>]

Thanks, Phillip.
I do believe this would solve the case.
But when I have activated the replication, I got the error "Missing 
partitioning policy for name".

This is my persistence unit:

<persistence version="2.0" 
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_2_0.xsd";>
  <persistence-unit name="SimuladorFretePU" 
transaction-type="RESOURCE_LOCAL">
<provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
<non-jta-data-source>java:comp/env/jdbc/teste</non-jta-data-source>
<exclude-unlisted-classes>false</exclude-unlisted-classes>
    <shared-cache-mode>ALL</shared-cache-mode>
    <validation-mode>NONE</validation-mode>
    <properties>
      <property name="eclipselink.partitioning" value="Replicate"/>
      <property 
name="eclipselink.connection-pool.node2.nonJtaDataSource" 
value="java:comp/env/jdbc/teste2"/>
    </properties>
  </persistence-unit>


I've not found any additional documentation about how to configure the 
Replication...

What to do now?


Thanks,

Edson





On 12-04-2015 14:57, Phillip Ross wrote:
> Edson, I'm not sure if this is what you're looking for, but
> Eclipselink supports "partitioning" which I believe also has
> replication functionality:
> http://www.eclipse.org/eclipselink/documentation/2.5/solutions/scaling002.htm#BABHHAEJ
>
> hope that helps!
> - Phillip
>
>
> On Sun, Apr 12, 2015 at 10:55 AM, Edson Carlos Ericksson Richter
> <edsonrichter@xxxxxxxxxxx> wrote:
> > It is possible to configure eclipselink in the following way:
> >
> > 1) Every query is send to one "master" server;
> > 2) Every transaction causes insert/update/delete/procedure call to be send
> > in two-phase commit mode to 2~4 servers?
> >
> > - I don't have problems with volatile functions (like "now()") because I do
> > all of this at Java app level. All my functions are predictable stable.
> > - I want to use this a alternative to applying HA-jdbc or C-jdbc proxy
> > libraries.
> >
> >
> > Thanks,
> >
> > Edson
> >
> > _______________________________________________
> > eclipselink-users mailing list
> > eclipselink-users@xxxxxxxxxxx
> > To change your delivery options, retrieve your password, or unsubscribe from
> > this list, visit
> > https://dev.eclipse.org/mailman/listinfo/eclipselink-users
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> To change your delivery options, retrieve your password, or unsubscribe from this list, visit
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users