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'?