Re: Errors encountered when running JDBC testcases from OptionalTestSuite against vPG10.2

On Thu, 2018-03-01 at 12:48 +0800, cathryn wrote:
> Dear Sir/Mandam
> I am running JDBC testsuites against vPG10.2, but encounter below
> error:
> test:
> [junit] Testsuite:
> org.postgresql.test.jdbc2.optional.OptionalTestSuite
> [junit] Tests run: 58, Failures: 6, Errors: 2, Skipped: 1, Time
> elapsed: 4.175 sec
> [junit] Mar 01, 2018 3:42:42 AM
> org.postgresql.ds.common.BaseDataSource getConnection
> [junit] SEVERE: Failed to create a Non-Pooling DataSource from
> PostgreSQL JDBC Driver 42.2.1 for test at
> jdbc:postgresql://10.143.17.239:5432/test?loggerLevel=null&prepareThr
> eshold=5&preparedStatementCacheQueries=256&preparedStatementCacheSize
> MiB=5&databaseMetadataCacheFields=65536&databaseMetadataCacheFieldsMi
> B=5&defaultRowFetchSize=0&binaryTransfer=true&readOnly=false&binaryTr
> ansferEnable=&binaryTransferDisable=&unknownLength=2147483647&logUncl
> osedConnections=false&disableColumnSanitiser=false&tcpKeepAlive=false
> &loginTimeout=0&connectTimeout=10&socketTimeout=0&cancelSignalTimeout
> =10&receiveBufferSize=-1&sendBufferSize=-1&ApplicationName=PostgreSQL
> JDBC
> Driver&jaasLogin=true&useSpnego=false&gsslib=auto&sspiServiceClass=PO
> STGRES&allowEncodingChanges=false&targetServerType=any&loadBalanceHos
> ts=false&hostRecheckSeconds=10&preferQueryMode=extended&autosave=neve
> r&reWriteBatchedInserts=false: org.postgresql.util.PSQLException:
> Something unusual has occurred to cause the driver to fail. Please
> report this exception.

There is no &user= nor &password= in your connection URL. Maybe they
are required. Depends upon your pg_hba.conf settings.

Setting &loginTimeout=0 may cause a problem. I've never tried that one.

Most of these settings can be defined in your postgresql.conf file.

HTH

Rob