Anaplan Export using JDBC properties files

Kudiarasu
Kudiarasu
in Integrations and extensibility

Hi All

 

I have an issue when trying to execute an insert query using jdbc. 

 

# JDBC Connection string (Oracle, Mysql, H2, etc.)

jdbc.connect.url=*******

# JDBC login username

jdbc.username=******

jdbc.password=******

jdbc.fetch.size=10

jdbc.isStoredProcedure=false

jdbc.query=Insert into flash_rw (Period) Values (?);

jdbc.params=Period

 

My export file after executing has about 30 columns and I am passing one of the columns back into the params. (Tried adding all 30 to params but still same errror)

 

Would anyone know what is going wrong? I tried 'Period' / "Period", but still no change. 

 

 

Tagged:

Categories