User Activity

  • Posted a comment on discussion Help on SymmetricDS

    Many Thanks Josh for explain it in detail, i will try to implement the same.

  • Posted a comment on discussion Help on SymmetricDS

    use_stream_lobs was enable so i disabled it and run the application again. So this time postgres (corp side ) error is resolved but new error is occuering at store side (MSSQL) org.jumpmind.db.sql.SqlException: Conversion failed when converting from a char acter string to uniqueidentifier. at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplat e.java:302) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplat e.java:291)) when i looked in sym_incoming_error table...

  • Posted a comment on discussion Help on SymmetricDS

    I am also having same design for multi-tenant application, and looking for solving same issue. please let me know if you find any solution to deal with this problem.

  • Modified a comment on discussion Help on SymmetricDS

    in my case i am using UUID's as primary key and foreign key.

  • Posted a comment on discussion Help on SymmetricDS

    in my case i am using UUID as primary key and foreign key as well.

  • Posted a comment on discussion Help on SymmetricDS

    Thanks Larry for providing you input on this. you mean to say i need to change implementation of IDdlBuilder of mssql and postgres sql ( for both database ? ). https://github.com/JumpMind/symmetric-ds/blob/b917fde35be0c06bfd1a8fa15fa7767e18f8e772/symmetric-db/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDmlStatement.java change should be part of appendColumnParameter, appendColumnEquals method in above class ? Please help me with further guidance as i will be working in SymmtricDS...

  • Posted a comment on discussion Help on SymmetricDS

    I am trying to replicate MS SQL Server 2014 to Postgres 11 with SymmetricDS 3.9.14. I have a database table with primary key of UUID type. It seems like SymmetricDS is not able to cast 'UUID' correctly. One of SymmetricDS replication query is failing with the below error JdbcSqlTemplate - SQL caused exception: [select "id" from "dbo"."groups" where "id"=?] sql args: [ ] org.postgresql.util.PSQLException: ERROR: invalid input syntax for type uuid: " " Postgres understand UUID as binary data as SQL...

  • Posted a comment on discussion Help on SymmetricDS

    i have corp and store database, i have setup configuration to replication bi-directional, but when start corp node and then start store node. i am seeing lots of logs , seems like its running in loop. Corp Log :- [corp-1] - ConfigurationChangedDataRouter - About to refresh the cache of nodes because new configuration came through the data router [corp-1] - RouterService - Routed 5 data events in 49 ms [corp-1] - PullUriHandler - 5 data and 3 batches sent during pull request from store:2:2 [corp-1]...

View All

Personal Data

Username:
anchitanc
Joined:
2013-05-15 19:05:53

Projects

  • No projects to display.

Personal Tools