Hi,
I have other PostgreSQL problem.
DBReplicator 2.2.3, Postgres 8.3.1
I've successfuly installed the publiser and subscriber sides, snapshot creating works well.
After data modification the subscriber push or sync process raises an exception on the modified table. I've tried change different tables and data columns but the result is similar.
The relevant debug lines:
DBReplicator console:
13:15:06,781 DEBUG [SyncXMLCreator] [getLastSyncId 307] Select Rep_Last_Sync_ID
from public.Rep_BookMarkTable where Rep_LocalName = 'sub1' and Rep_RemoteName =
'fullgas' and Rep_Table_Name= 'public.raktar'
13:15:06,781 DEBUG [SyncXMLCreator] [getResultSet 362] Select Rep_Last_Sync_ID
from public.Rep_BookMarkTable where Rep_LocalName = 'sub1' and Rep_RemoteName =
'fullgas' and Rep_Table_Name= 'public.raktar'
13:15:06,781 DEBUG [SyncXMLCreator] [getResultSet 362] Select * from public.REP_
SHADOW_raktar where Rep_sync_id > 2 and Rep_server_name != 'peter_3001' order by
Rep_sync_id
13:15:06,828 ERROR [SyncXMLCreator] [createXMLFile 243] ERROR: operator does not
exist: bigint > character varying
org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint > char
acter varying
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:1721)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1489)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:193)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:351)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc
2Statement.java:255)
at org.dbreplicator.replication.xml.SyncXMLCreator.getOtherCommonRecord(
SyncXMLCreator.java:530)
at org.dbreplicator.replication.xml.SyncXMLCreator.makeUpdateElement(Syn
cXMLCreator.java:572)
at org.dbreplicator.replication.xml.SyncXMLCreator.createXMLFile(SyncXML
Creator.java:169)
at org.dbreplicator.replication.Subscription.push(Subscription.java:860)
at org.dbreplicator.repconsole.Push.jButtonPush_actionPerformed(Push.jav
a:244)
Postgres log:
2008-04-23 13:15:06 CEST ERROR: operator does not exist: bigint > character varying at character 59
2008-04-23 13:15:06 CEST HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
2008-04-23 13:15:06 CEST STATEMENT: select * from public.REP_SHADOW_raktar where Rep_sync_id > $1 and Rep_common_id = $2 and Rep_status = 'A'
Thanks,
Peter
Ok, I have tried with
Ok, I have tried with Postgres 8.2.7, it works.
Is there any workaround for version 8.3?
Thanks,
Peter
The jdbc jar that ships with
The jdbc jar that ships with the replicator for postgres is for version 8.2. First thing to do is try with the jar for 8.3, which I've attached. You'll need to put it in the CLASSPATH, which on linux is in the 'dbreplicator' executable (default /usr/bin/dbreplicator). Just install the jar file where the others for dbreplicator are (default /usr/share/dbreplicator), and edit the dbreplicator executable and add it to the classpath. Don't forget to remove the other postgres jar from the CLASSPATH definition.
If that doesn't work, we'll have to dig deeper.
I think I tested with the
I think I tested with the newest jdbc jar before, but now tried again:
Postgres 8.3.1 with 8.3-603.jdbc4.jar produces the same error.
WinXP Prof SP2, Java JRE 1.6.0_05
I'll have to fix it so it
I'll have to fix it so it works with Postgres 8.3.
Ok, I believe I've fixed
Ok, I believe I've fixed this problem. I'm testing this weekend, I'll post a new version this week. Thanks for your patience.
Brian