corda 未能设置 postgreSQL 数据库属性 url

Question

... corda部署节点失败。日志显示：

[错误] 2018-10-04T11:16:05,466Z[主] ) ~[?:-无法在目标类 ) ~[?:{} ) ~[?:： null at0_1810（本机方法）~[？： 1.8.HikariCP-2.5.1.jar]at0_181（0_181HikariCP-2.5.1.jar1.8.com.zaxxer.hikari.pool.PoolBase.]at0_181（0_181com.zaxxer.hikari.pool.PoolBase.initializeDataSource1.8.PoolBase.java:108]atHikariPool.java:99（HikariCP-2.5.1.jarPoolBase.java:3151.8.HikariCP-2.5.1.jar]atcom.zaxxer.hikari.HikariDataSource.（HikariDataSource.java:71）~[HikariCP-2.5.1.jar：？]atcom.zaxxer.hikari.util.PropertyElf.lambda$setTargetFromProperty ties0美元（PropertyElf.java:57）~[HikariCP-2.5.1.jar：？]atjava.util.Hashtable.forEach（Hashtable.java:879）[？： 1.8.com.zaxxer.hikari.pool.HikariPool.]atcom.zaxxer.hikari.util.PropertyElf.setTargetFromProperties（PropertyElf.java:52）[util.PropertyElf.setProperty：？]atorg.postgresql.ds.PGSimpleDataSource（java.lang.reflect.InvocationTargetException）[sun.reflect.NativeMethodAccessorImpl.invoke：？]atsun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:62）[sun.reflect.DelegatingMethodAccessorImpl.invoke：？]atDelegatingMethodAccessorImpl.java:43（java.lang.reflect.Method.invoke）[Method.java:498：？]atcom.zaxxer.hikari.util.PropertyElf.setProperty（PropertyElf.java:146）[HikariCP-2.5.1.jar：？]at net. corda. node.在net. corda. node-3.2-corda. jar：？]在net. corda. node. interal. AbstractNodeKt. configureDatabase（AbstractNode. kt： 910）[corda-node-3.2-corda. jar：？]在net. corda. node. interal. AbstractNode. kt： 910）[corda-node-3.2-corda. jar：？]在net. corda. node.

Answer 1

I tried alot and Finally I got solution. Again solution is based on type of Datasource and its version.
The root cause of this issue is PGSimpleDataSource does not have "url" property but other properties are there to form URL such as serverName, portNumber, DataBaseName. We did not specify those property because we specify URL that is incorrect for PGSimpleDataSource.

Solution:
remove url property of datasource 
// datasource..addDataSourceProperty(("url", databaseProp.getUrl()))

Add following things in place of URL.
    dataSource.addDataSourceProperty("serverName", "HOSTName/IP");
        //dataSource.addDataSourceProperty("serverName", "localhost");
        dataSource.addDataSourceProperty("portNumber", "5432");
        dataSource.addDataSourceProperty("databaseName", "testDB");

its is working fine after struggling a lot. :)

Answer 2

我遇到了同样的问题，解决方案是重写＜code＞节点中的数据库属性。conf使用以下格式：

"dataSourceProperties.dataSourceClassName"=org.postgresql.ds.PGSimpleDataSource

这似乎是一个问题，其中"dataSourceProperties.dataSourceClassName"与dataSourceProperties.dataSourceClassName的处理方式不同（没有引号）。

Answer 3

dataSourceProperties={
“dataSourceClassName”：org.postgresql.ds.PGSimpleDataSource
”dataSource.url:“jdbc:Postgresql://127.0.0.1:5432/postgres“
”数据源。用户“：”用户“
”数据源。密码“：“密码”
}
数据库={
transactionolationlevel=READ_COMMITTED
模式=公证人
}