Problems and Work-arounds

Re:

My brother is an university student. He has numbers of task always, however it is impossible to manage with two assignments at the same time. Thus I recommended him to buy the term papers from essays online service. I was hoping that would aid.

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.

FireBird problem

Hi
I'm trying to set up dbreplicator with firebird. The applications starts and connects the database but I can't set up the publisher. I get an exception:

13:32:12,727 DEBUG [ReplicationServer] [getInstance 162] ReplicationServer started

13:32:26,312 DEBUG [ScheduleHandler] [ 62] intializing ScheduleHandler
13:32:26,421 DEBUG [ScheduleHandler] [ 95] org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -204
Table unknown
REP_SCHEDULETABLE
At line 1, column 15.
Exception occurred during event dispatching:

Mysql Transaction isolation leve

Hi,

I am getting error: "Transaction isolation level can't be changed while a transaction is in progress". I am using mysql database. Can you advice ?

Regards.

is the snapshot necessary?

Hi guys,

Powered by Drupal - Theme by Danger4k