--0016e64cd5326b640a04779d6d9e
Content-Type: text/plain; charset=ISO-8859-1
Sandeep I have worked on it (symmetricDS) and facing the following problem
what i have done is
1. extracted the zip file in a folder
2. created a sample database on two systems.
but when i try to execute under mentionded command i get exception. As
Exception is self explanatory I did as it says. I added the custom varaible
classes in postgresql in postgresql.conf file but still get the same
exception.
I have restarted the postgresql service (as well as system). Still no use.
Please help how to use it
*./sym -p root.properties --auto-create*
2009-11-05 15:50:12,979 INFO
[org.jumpmind.symmetric.service.impl.BootstrapService] [main] Initializing
SymmetricDS database.
2009-11-05 15:50:12,991 ERROR
[org.jumpmind.symmetric.db.postgresql.PostgreSqlDbDialect] [main] Please add
"custom_variable_classes = 'symmetric'" to your postgresql.conf file
------------------------------------------------------------ -----------------------------------
An exception occurred. Please see the following for details:
------------------------------------------------------------ -----------------------------------
org.postgresql.util.PSQLException: ERROR: unrecognized configuration
parameter "symmetric.triggers_disabled"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorRespons e(QueryExecutorImpl.java:1548)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(Quer yExecutorImpl.java:1316)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecut orImpl.java:191)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(Abstract Jdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags (AbstractJdbc2Statement.java:337)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(Abs tractJdbc2Statement.java:236)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(Del egatingStatement.java:205)
at
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCa llback.doInStatement(JdbcTemplate.java:443)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTempl ate.java:396)
[wrapped] org.springframework.jdbc.BadSqlGrammarException:
StatementCallback; bad SQL grammar [select
set_config('symmetric.triggers_disabled', '', false)]; nested exception is
org.postgresql.util.PSQLException: ERROR: unrecognized configuration
parameter "symmetric.triggers_disabled"
at
org.springframework.jdbc.support.SQLStateSQLExceptionTransla tor.doTranslate(SQLStateSQLExceptionTranslator.java:97)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptio nTranslator.translate(AbstractFallbackSQLExceptionTranslator .java:72)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptio nTranslator.translate(AbstractFallbackSQLExceptionTranslator .java:80)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptio nTranslator.translate(AbstractFallbackSQLExceptionTranslator .java:80)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTempl ate.java:407)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplat e.java:458)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplat e.java:466)
at
org.springframework.jdbc.core.JdbcTemplate.queryForList(Jdbc Template.java:497)
at
org.jumpmind.symmetric.db.postgresql.PostgreSqlDbDialect$1.d oInTransactionWithoutResult(PostgreSqlDbDialect.java:118)
at
org.springframework.transaction.support.TransactionCallbackW ithoutResult.doInTransaction(TransactionCallbackWithoutResul t.java:33)
at
org.springframework.transaction.support.TransactionTemplate. execute(TransactionTemplate.java:128)
at
org.jumpmind.symmetric.db.postgresql.PostgreSqlDbDialect.ena bleSyncTriggers(PostgreSqlDbDialect.java:115)
at
org.jumpmind.symmetric.db.postgresql.PostgreSqlDbDialect.ini tForSpecificDialect(PostgreSqlDbDialect.java:60)
[wrapped] java.lang.RuntimeException: Missing custom variable class
'symmetric'
at
org.jumpmind.symmetric.db.postgresql.PostgreSqlDbDialect.ini tForSpecificDialect(PostgreSqlDbDialect.java:63)
at
org.jumpmind.symmetric.db.AbstractDbDialect.initSupportDb(Ab stractDbDialect.java:196)
at
org.jumpmind.symmetric.service.impl.BootstrapService.autoCon figDatabase(BootstrapService.java:107)
at
org.jumpmind.symmetric.service.impl.BootstrapService.setupDa tabase(BootstrapService.java:131)
at
org.jumpmind.symmetric.SymmetricLauncher.autoCreateDatabase( SymmetricLauncher.java:489)
at
org.jumpmind.symmetric.SymmetricLauncher.main(SymmetricLaunc her.java:213)
-
On Wed, Nov 4, 2009 at 4:03 PM, sandeep kumar <s_kumar66 [at] yahoo.com> wrote:
> Shakeel, this can be done using symmetricDS.
>
> cheers
> //Sandeep
>
>
>
>
> --- On Wed, 4/11/09, ABBAS SHAKEEL <shakeel.abbas.qau [at] gmail.com> wrote:
>
> > From: ABBAS SHAKEEL <shakeel.abbas.qau [at] gmail.com>
> > Subject: [ADMIN] Syncronizing Databases at different Remote Location
> > To: pgsql-admin [at] postgresql.org
> > Date: Wednesday, 4 November, 2009, 3:48 PM
> > HelloI am new in the field of Database
> > Management. Most of times i worked with Software development
> > and Database Design.I need some advice regarding
> > database management.
> > I have three Database (DB) servers at different
> > locations. suppose A, B and C as three servers. where as Z
> > is a central server which have VPN to all other
> > servers.
> >
> > I have to insert/update records to central
> > server Z if there is any insert/update in any of the A,B and
> > C server.
> > Now I can write a JAVA code that when ever there
> > is insertion/updation of record of A/B/C do same in central
> > Server Z using JAVA sockets I can send records to central
> > server where Socket server will listen and then insert or
> > update records in DB.
> >
> > But I come to know that there is a concept
> > called Replication. I studied it and found that
> > it is used for load balancing. I dont need load balancing
> > I only need to Syncronize only Two tables of all A,B,C
> > servers to central server Z.
> >
> >
> > Please suggest how to move forward.(Open source
> > solutions )
> >
> > --
> > Best Regards
> > Shakeel Abbas
> >
> >
> >
> >
>
>
> From cricket scores to your friends. Try the Yahoo! India Homepage!
> http://in.yahoo.com/trynew
>
--
Best Regards
Shakeel Abbas
--0016e64cd5326b640a04779d6d9e
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<br>Sandeep I have worked on it (<span class=3D"Apple-style-span" style=3D"=
border-collapse: collapse; ">symmetricDS</span>) and facing the following p=
roblem=A0<div>what i have done is=A0</div><div><br></div><div>1. extracted =
the zip file in a folder</div>
<div>2. created a sample database on two systems.</div><div><br><div>but wh=
en i try to execute under mentionded command i get exception. =A0 As Except=
ion is self explanatory I did as it says. I added the custom varaible class=
es in postgresql in postgresql.conf file but still get the same exception.<=
/div>
<div><br></div><div>I have restarted the postgresql service (as well as sys=
tem). Still no use. Please help how to use it</div><div><br></div><div><br>=
</div><div><b>./sym -p root.properties --auto-create</b></div><div><div>
2009-11-05 15:50:12,979 INFO =A0[org.jumpmind.symmetric.service.impl.Bootst=
rapService] [main] Initializing SymmetricDS database.</div><div>2009-11-05 =
15:50:12,991 ERROR [org.jumpmind.symmetric.db.postgresql.PostgreSqlDbDialec=
t] [main] Please add "custom_variable_classes =3D 'symmetric'&=
quot; to your postgresql.conf file</div>
<div> ------------------------------------------------------------ ----------=
-------------------------</div><div>=A0=A0An exception occurred. =A0Please =
see the following for details:</div><div>----------------------------------=
------------------------------------------------------------ -</div>
<div>org.postgresql.util.PSQLException: ERROR: unrecognized configuration p=
arameter "symmetric.triggers_disabled"</div><div>=A0=A0 =A0 =A0 =
=A0at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorRespons e(QueryEx=
ecutorImpl.java:1548)</div>
<div>=A0=A0 =A0 =A0 =A0at org.postgresql.core.v3.QueryExecutorImpl.processR=
esults(QueryExecutorImpl.java:1316)</div><div>=A0=A0 =A0 =A0 =A0at org.post=
gresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.j ava:191)</div><=
div>=A0=A0 =A0 =A0 =A0at org.postgresql.jdbc2.AbstractJdbc2Statement.execut=
e(AbstractJdbc2Statement.java:452)</div>
<div>=A0=A0 =A0 =A0 =A0at org.postgresql.jdbc2.AbstractJdbc2Statement.execu=
teWithFlags(AbstractJdbc2Statement.java:337)</div><div>=A0=A0 =A0 =A0 =A0at=
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(Abs tractJdbc2Stat=
ement.java:236)</div>
<div>=A0=A0 =A0 =A0 =A0at org.apache.commons.dbcp.DelegatingStatement.execu=
teQuery(DelegatingStatement.java:205)</div><div>=A0=A0 =A0 =A0 =A0at org.sp=
ringframework.jdbc.core.JdbcTemplate$1QueryStatementCallback .doInStatement(=
JdbcTemplate.java:443)</div>
<div>=A0=A0 =A0 =A0 =A0at org.springframework.jdbc.core.JdbcTemplate.execut=
e(JdbcTemplate.java:396)</div><div>=A0[wrapped] org.springframework.jdbc.Ba=
dSqlGrammarException: StatementCallback; bad SQL grammar [select set_config=
('symmetric.triggers_disabled', '', false)]; nested excepti=
on is org.postgresql.util.PSQLException: ERROR: unrecognized configuration =
parameter "symmetric.triggers_disabled"</div>
<div>=A0=A0 =A0 =A0 =A0at org.springframework.jdbc.support.SQLStateSQLExcep=
tionTranslator.doTranslate(SQLStateSQLExceptionTranslator.ja va:97)</div><di=
v>=A0=A0 =A0 =A0 =A0at org.springframework.jdbc.support.AbstractFallbackSQL=
ExceptionTranslator.translate(AbstractFallbackSQLExceptionTr anslator.java:7=
2)</div>
<div>=A0=A0 =A0 =A0 =A0at org.springframework.jdbc.support.AbstractFallback=
SQLExceptionTranslator.translate(AbstractFallbackSQLExceptio nTranslator.jav=
a:80)</div><div>=A0=A0 =A0 =A0 =A0at org.springframework.jdbc.support.Abstr=
actFallbackSQLExceptionTranslator.translate(AbstractFallback SQLExceptionTra=
nslator.java:80)</div>
<div>=A0=A0 =A0 =A0 =A0at org.springframework.jdbc.core.JdbcTemplate.execut=
e(JdbcTemplate.java:407)</div><div>=A0=A0 =A0 =A0 =A0at org.springframework=
..jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458)</div><div>=A0=A0 =A0 =
=A0 =A0at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplat e.jav=
a:466)</div>
<div>=A0=A0 =A0 =A0 =A0at org.springframework.jdbc.core.JdbcTemplate.queryF=
orList(JdbcTemplate.java:497)</div><div>=A0=A0 =A0 =A0 =A0at org.jumpmind.s=
ymmetric.db.postgresql.PostgreSqlDbDialect$1.doInTransaction WithoutResult(P=
ostgreSqlDbDialect.java:118)</div>
<div>=A0=A0 =A0 =A0 =A0at org.springframework.transaction.support.Transacti=
onCallbackWithoutResult.doInTransaction(TransactionCallbackW ithoutResult.ja=
va:33)</div><div>=A0=A0 =A0 =A0 =A0at org.springframework.transaction.suppo=
rt.TransactionTemplate.execute(TransactionTemplate.java:128)</div>
<div>=A0=A0 =A0 =A0 =A0at org.jumpmind.symmetric.db.postgresql.PostgreSqlDb=
Dialect.enableSyncTriggers(PostgreSqlDbDialect.java:115)</div><div>=A0=A0 =
=A0 =A0 =A0at org.jumpmind.symmetric.db.postgresql.PostgreSqlDbDialect.ini t=
ForSpecificDialect(PostgreSqlDbDialect.java:60)</div>
<div>=A0[wrapped] java.lang.RuntimeException: Missing custom variable class=
'symmetric'</div><div>=A0=A0 =A0 =A0 =A0at org.jumpmind.symmetric.=
db.postgresql.PostgreSqlDbDialect.initForSpecificDialect(Pos tgreSqlDbDialec=
t.java:63)</div>
<div>=A0=A0 =A0 =A0 =A0at org.jumpmind.symmetric.db.AbstractDbDialect.initS=
upportDb(AbstractDbDialect.java:196)</div><div>=A0=A0 =A0 =A0 =A0at org.jum=
pmind.symmetric.service.impl.BootstrapService.autoConfigData base(BootstrapS=
ervice.java:107)</div>
<div>=A0=A0 =A0 =A0 =A0at org.jumpmind.symmetric.service.impl.BootstrapServ=
ice.setupDatabase(BootstrapService.java:131)</div><div>=A0=A0 =A0 =A0 =A0at=
org.jumpmind.symmetric.SymmetricLauncher.autoCreateDatabase( SymmetricLaunc=
her.java:489)</div>
<div>=A0=A0 =A0 =A0 =A0at org.jumpmind.symmetric.SymmetricLauncher.main(Sym=
metricLauncher.java:213)</div><div>-</div></div><div><br></div><div><br></d=
iv><div><br></div><div><br></div><div><br></div><div><br></div><div><br></d=
iv><div>
<br></div><div><br><div class=3D"gmail_quote">On Wed, Nov 4, 2009 at 4:03 P=
M, sandeep kumar <span dir=3D"ltr"><<a href=3D"mailto:s_kumar66 [at] yahoo.co=
m">s_kumar66 [at] yahoo.com</a>></span> wrote:<br><blockquote class=3D"gmail_=
quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1=
ex;">
Shakeel, this can be done using symmetricDS.<br>
<br>
cheers<br>
//Sandeep<br>
<br>
<br>
<br>
<br>
--- On Wed, 4/11/09, ABBAS SHAKEEL <<a href=3D"mailto:shakeel.abbas.qau [at] =
gmail.com">shakeel.abbas.qau [at] gmail.com</a>> wrote:<br>
<br>
> From: ABBAS SHAKEEL <<a href=3D"mailto:shakeel.abbas.qau [at] gmail.com"=
>shakeel.abbas.qau [at] gmail.com</a>><br>
> Subject: [ADMIN] Syncronizing Databases at different Remote Location<b=
r>
> To: <a href=3D"mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postgres=
ql.org</a><br>
> Date: Wednesday, 4 November, 2009, 3:48 PM<br>
> HelloI am new in the field of Database<br>
<div><div></div><div class=3D"h5">> Management. Most of times i worked w=
ith Software development<br>
> and Database Design.I need some advice regarding<br>
> database management.<br>
> I have three Database (DB) servers at different<br>
> locations. suppose A, B and C as three servers. where as Z<br>
> is a central server which have VPN to all other<br>
> servers.<br>
><br>
> I have to insert/update records to central<br>
> server Z if there is any insert/update in any of the A,B and<br>
> C server.<br>
> Now I can write a JAVA code that when ever there<br>
> is insertion/updation of record of A/B/C do same in central<br>
> Server Z using JAVA sockets I can send records to central<br>
> server where Socket server will listen and then insert or<br>
> update records in DB.<br>
><br>
> But I come to know that there is a concept<br>
> called Replication.=A0I studied it and found that<br>
> it is used for load balancing. =A0I dont need load balancing<br>
> I only need to Syncronize only Two tables of all A,B,C<br>
> servers to central server Z.<br>
><br>
><br>
> Please suggest how to move forward.(Open source<br>
> solutions )<br>
><br>
> --<br>
> Best Regards<br>
> Shakeel Abbas<br>
><br>
><br>
><br>
><br>
<br>
<br>
</div></div> =A0 =A0 =A0From cricket scores to your friends. Try the Yahoo!=
India Homepage! <a href=3D"http://in.yahoo.com/trynew" target=3D"_blank">h=
ttp://in.yahoo.com/trynew</a><br>
</blockquote></div><br><br clear=3D"all"><br>-- <br>Best Regards<br>Shakeel=
Abbas<br><br>
</div></div>
--0016e64cd5326b640a04779d6d9e--
