Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Rounding decimal values during syncronization #192

Open
Marco9700 opened this issue Jun 28, 2024 · 0 comments
Open

Rounding decimal values during syncronization #192

Marco9700 opened this issue Jun 28, 2024 · 0 comments

Comments

@Marco9700
Copy link

Hi, i tryed to use your sotfware to synchronize a schema from Oracle to Postgres DBMS.I wrote all the tables i wanted to synchronize in a .txt file.I created a bash script to read the name of the table and put them in the source.table and sink.table option with 2 enviroment variables and call replica db n times,one for each tables i want to sync. I used a program to figure out if all the entries were added correctly and i found out that the values of some columns of long decimal were rounded.
For exemple:

  • 0.1033449074074074074074074074074074074074 this value misses the last 4 in the sink table,
    -48.21666666666666666666666666666666666667 this misses a 6(couse the 7 is rounded)
    -47.84444443333333333333333333333333333333 this misses a 3
    seems like the maximus number of digit allowed after the . is 40
    I can already tell you that is not something related to the sink database settings, since it let me add values like this in the problematic columns without any issue with a classic INSERT statement

this is the call I make within my .sh file:

some code to load enviorment variables from the .txt file
./bin/replicadb --options-file=import.config

and this is how the import.config file is made:

mode=incremental

source.connect=jdbc:oracle_MyconnectionOr_
source.user=myUserOr
source.password=myPswOr
source.table=${SOURCE_TABLE}

sink.connect=jdbc:postgresql_MyconnetionPsql_
sink.user=myUserPSQL
sink.password=myPswPSQL
sink.table=${DEST_TABLE}

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant