I get the following error when trying to perform ./build/nodes/runnodes for my cordapp. The party (Mint) which I want to connect to a standalone Postgresql database is giving this error:
[ERROR] 01:07:58-0400 [main] subcommands.ValidateConfigurationCli. - Error(s) while parsing node configuration:
- for path: "database.schema": Unknown property 'schema'.
In my node.conf file for a party (Mint) is
dataSourceProperties = {
dataSourceClassName = "org.postgresql.ds.PGSimpleDataSource"
dataSource.url = "jdbc:postgresql://localhost:5432/sample_db"
dataSource.user = mint
dataSource.password = my_password
}
database = {
transactionIsolationLevel = READ_COMMITTED
schema = mint
}
# When JDBC driver is not placed into node's 'drivers' directory then add absolute path:
jarDirs = ['/Users/sayefiqbal/Documents/Corda/Metals-cordapp/build/nodes/Mint/drivers/postgresql-42.2.12.jar']
Note sure what is the issue. Followed documentation from Corda but no resolution so far.
I suppose you are using the Community edition of Corda, It doesn't have the schema property available. However, you could specify the schema in the JDBC URL as below:
jdbc:postgresql://localhost:5432/sample_db?currentSchema=mint
Refer documentation for details: https://docs.corda.net/docs/corda-os/4.4/node-database.html#postgresql.