Oracle Datasource

[christianorios]

Hi, how doo I configure database connection?
I have got error below when trying to run anonymization:

java.lang.IllegalArgumentException: Database null is not supported

[christianorios]

Trying this: ./datadefender anonymize --requirement-file=requirement.xml -u=hr -p=oraclepwd --schema=hr --url=jdbc.oracle://hostname:1521/pdb1 --vendor=oracle

But got this error:
com.strider.datadefender.database.DatabaseException: No suitable driver found for jdbc.oracle://hostname:1521/pdb1

I have copied ojdbc6.jar to my target directory.

[christianorios]

The right syntax:
--url=jdbc:oracle:thin:@hostname:1521/pdb1
Got it to work.

[christianorios]

Almost there.
How do I anonymize a number(8,2) collumn?

[armenak]

Use "number" data type.

[christianorios]

Trying to use this plan for number (8,2) column

Starting anonymizer
Anonymizing table jobs... 100% │||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||│ 19/19 (0:00:00 / 0:00:00)
[ERROR] java.sql.BatchUpdateException: ORA-01438: value larger than specified precision allowed for this column

[armenak]

Try decimal data type

[christianorios]

Would you please send an example for 'decimal'?