WrongType & KeyNotFound Errors

[ZonerDan]

I have modified my configuration file in multiple ways and I continue to get one of the following errors regardless of the changes I make:

When using JSON format:

[main] ERROR com.powerspace.pg2bq.Main$ - Incorrect configuration: KeyNotFound(jdbc,None,Set("jdbc")), KeyNotFound(gcloud,None,Set("gcloud"))

When using HOCON format that matches the example on your README:

[main] ERROR com.powerspace.pg2bq.Main$ - Incorrect configuration: WrongType(STRING,Set(OBJECT),None,jdbc), WrongType(STRING,Set(OBJECT),None,gcloud)

[sderosiaux]

Hi @ZonerDan,

Can you paste the content of your configuration file? It seems you're passing a string to jdbc instead of an object jdbc { ... }, same for gcloud. Or some odd character is present?

[ZonerDan]

JSON Version:

{ "jdbc": { "url": "", "user": "", "password": "", "tables": ["people"] }, "gcloud": { "project": "", "service-account-key-path": "", "bq.dataset": "", "gcs.tmp-bucket": "pg-export" } }

HOCON Version:

jdbc { url = "" user = "" password = "" tables = ["people"] }

gcloud { project = "" service-account-key-path = "" bq.dataset = "" gcs.tmp-bucket = "pg-export" }

[ZonerDan]

Other things I have tried:

• changing gcs.tmp-bucket to gcs.tmpBucket
• changing value of password from """" to nothing
• changing value of password from """" to null

[ZonerDan]

Provided in comments

[sderosiaux]

I just copy/pasted your HOCON (with all the placeholders ), the program starts:

/bin/pg2bq -Dconfig.file=/Users/sderosiaux/pg2bq.conf
2018-02-20 16:34:04,336  [main] ...

[ZonerDan]

:( I'm at a loss. I just tried with all the placeholders as well and still receive the WrongType error.

[ZonerDan]

Ok. I think its because in my original testing I received an error stating that I should change the file extension to .properties instead of .conf. Now I've changed it back and the program is starting.

[sderosiaux]

Yeah, I think when the file ends by .properties, the config expects to find the Java properties format. Happy you got it fixed!

[ZonerDan]

Thanks for your help!