Problems and Work-arounds

smell of cheap oakley sunglasses

resignation. We often hear that before, many fish farmers, Pee effect of feeding, and silver carp and grass carp to eat this urea, such fish as you can imagine. His wife said, taste good sake is the ingredients, I say not, but the problem with the fish itself, has smell of fish, is a pure, natural. How many years did not eat the fish. Buy fish at the market in the past, when eating the meat of which is powdered toot.

error during jrmp connection establishment nested exception is dbreplicator "java io eofexception"

hello

I have already create the publication and when I am trying to make the new subscription the folloging message appears:

error during jrmp connection establishment nested exception is dbreplicator "java io eofexception"

this is the screen with the postmaster:
....
, Rep_conflict_resolver varchar(255), Primary Key (Rep_PubSub_Name , Rep_Table_Name ) )

Install Issues

Hi all,

Newcomer here (to DBA items in general, much less DBReplicator). I am trying to set up heterogeneous replication from MySQL to PostgreSQL, but can't seem to get past the install of DBReplicator.

I have set up my setpath.bat file as follows:

----------------------------------------------------------
@echo off
@REM Copyright (c) 2008 Regiscope Digital Imaging Co., LLC All rights reserved.

@REM set JAVA_HOME and JDBC_CLASSPATH variables here and remove the REM

@REM For compiling only, path to where ANT is installed
REM SET ANT_HOME=

MySQL publisher and PostgreSQL subscriber problem

Hello,

I've got a problem to subscribe to a MySQL server.

The publication itself is running and the subscription is able to connect to the publication, but it ends up in an error message:
org.dbreplicator.replication.RepException:
Error subscribing subscription 'Unknown host: LocalMySQLReplicator; nested exception is:
java.net.UnknownHostException: LocalMySQLReplicator' : {1}.

I'm using the following versions:
DBReplicator: 2.2.4
MySQL: 5.1.41
PostgreSQL: 8.4.8

The DBReplicator tables where successfully created in both, MySQL and PostgreSQL servers.

create subscription

help me please, it's urgent
I always this error message: "Can not find the xml file at specified path"
when I try to create a subscription. I do not really know what to do.
Windows configuration, database MySQL-> MySQL for two computers in networks.
I count on you thank you.

Sql server to mysql replication error

Hi. I've managed to create a publisher in a debian based server that connects to a Sql server machine
I've also managed to create a subscription in another debian server, using a MySQL database.
I'm using

When I try to pull or snaptshot, I get this error:

Problem in synchronizing data due to -- 'Line 1: Incorrect syntax near 'work'.'.

Can anyone help?

Thanks

Miguel

14:50:20,514 DEBUG [CommonMetaDataInfo] [appendPrimaryConstraints 583] Primary Key (ID )
14:50:20,526 DEBUG [CommonMetaDataInfo] [appendCheckConstraints 683] Primary Key (ID ) , Check ( ID is not null )

DBReplicator speed/scalability

Hello,

I'm thinking about integrating DBReplicator in my Java (Swing -> RMI -> Hibernate) application. We use PostgreSQL as the main database, but that could change anytime if we use DBReplicator.

But my concern is about speed, scalability and Network traffic, basically. How does DBReplicator compares to Bucardo, for instance, in this subject?

Oh, and one other thing: I read somewhere that in DBReplicator a subscriber can subscribe to one publisher per time. Is this true? Isn't it possible to have this structure:
Site 1 - pushes to Site 2, 3 and 4 when data changes are comitted

big problems with Derby and DB2

Hi,
after manually fixing the LIMIT 1 non standard SQL in every java file, we discover that with Derby and DB2 there are a lot of problems.
Many (or all) of this problems are related to some fixes (bjt) that works only on MySQL and/or PostgresSQL!!!.
PS Old Daffodil 2.1 version works very well for us with Derby and DB2 ...

Thanks in advance
Massimo

snapshot problem with DB2 and with Derby

Hi,
we are evaluating DBReplicator with DB2 and Derby (all combinations of publisher and subscriber).
When we make the first snapshot we have a syntax error at line org.dbreplicator.replication.Publication.createSnapShot(Publication.java:734).
The java code is below:
// updating values for bookmark table
String selectMaxSyncID= " select " + RepConstants.shadow_sync_id1 + " from " +
RepConstants.shadow_Table(tableName) + " order by " +
RepConstants.shadow_sync_id1 + " desc limit 1";

Competing updates/inserts create race condition.

Hi,

I have DBReplicator running on a pair of test databases. Works great when there's no concurrency, but when I do two inserts and then sync tables, only the "winning" record remains because they both share the same serial ID. I've tried to investigate setting up the publication to ignore the ID column (since there are no foreign keys, it doesn't matter what the ID value is) but although there appears to be code and structure for ignore columns, I can't find documentation to actually set this up, and the console doesn't appear to support it.

Powered by Drupal - Theme by Danger4k