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

​You have set the loggerLevel=null​, valid values are OFF, DEBUG, TRACE

On Wed, Feb 28, 2018 at 10:48 PM, cathryn <9333724(at)qq(dot)com> 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&prepareThreshold=5&preparedStatementCacheQueries=256&preparedStatementCacheSizeMiB=5&databaseMetadataCacheFields=65536&databaseMetadataCacheFieldsMiB=5&defaultRowFetchSize=0&binaryTransfer=true&readOnly=false&binaryTransferEnable=&binaryTransferDisable=&unknownLength=2147483647&logUnclosedConnections=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=POSTGRES&allowEncodingChanges=false&targetServerType=any&loadBalanceHosts=false&hostRecheckSeconds=10&preferQueryMode=extended&autosave=never&reWriteBatchedInserts=false: org.postgresql.util.PSQLException: Something unusual has occurred to cause the driver to fail. Please report this exception.
> [junit] Mar 01, 2018 3:42:42 AM org.postgresql.Driver connect
> [junit] SEVERE: Unexpected connection error:
> [junit] java.lang.NullPointerException
> [junit] at java.util.logging.Handler.setLevel(Handler.java:263)
> [junit] at org.postgresql.Driver.setupLoggerFromProperties(Driver.java:342)
> [junit] at org.postgresql.Driver.connect(Driver.java:240)
> [junit] at java.sql.DriverManager.getConnection(DriverManager.java:664)
> [junit] at java.sql.DriverManager.getConnection(DriverManager.java:247)
> [junit] at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:94)
> [junit] at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:79)
> [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.getDataSourceConnection(BaseDataSourceTest.java:76)
> [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.testUseConnection(BaseDataSourceTest.java:125)
> [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.testJndi(BaseDataSourceTest.java:210)
> [junit] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [junit] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> [junit] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> [junit] at java.lang.reflect.Method.invoke(Method.java:498)
> [junit] at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
> [junit] at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
> [junit] at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
> [junit] at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
> [junit] at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
> [junit] at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
> [junit] at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
> [junit] at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
> [junit] at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
> [junit] at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
> [junit] at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
> [junit] at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
> [junit] at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
> [junit] at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
> [junit] at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
> [junit] at org.junit.runners.Suite.runChild(Suite.java:128)
> [junit] at org.junit.runners.Suite.runChild(Suite.java:27)
> [junit] at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
> [junit] at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
> [junit] at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
> [junit] at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
> [junit] at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
> [junit] at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
> [junit] at junit.framework.JUnit4TestAdapter.run(JUnit4TestAdapter.java:38)
> [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:535)
> [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeInVM(JUnitTask.java:1647)
> [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:1047)
> [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeOrQueue(JUnitTask.java:2207)
> [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:858)
> [junit] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:293)
> [junit] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [junit] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> [junit] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> [junit] at java.lang.reflect.Method.invoke(Method.java:498)
> [junit] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
> [junit] at org.apache.tools.ant.Task.perform(Task.java:348)
> [junit] at org.apache.tools.ant.Target.execute(Target.java:435)
> [junit] at org.apache.tools.ant.Target.performTasks(Target.java:456)
> [junit] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1405)
> [junit] at org.apache.tools.ant.Project.executeTarget(Project.java:1376)
> [junit] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
> [junit] at org.apache.tools.ant.Project.executeTargets(Project.java:1260)
> [junit] at org.apache.tools.ant.Main.runBuild(Main.java:857)
> [junit] at org.apache.tools.ant.Main.startAnt(Main.java:236)
> [junit] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:287)
> [junit] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:113)
>
> Below testcases from suite OptionalTestSuite failed or error:
>
> [junit] Testcase: testGetURL took 0.093 sec
> [junit] Caused an ERROR
> [junit] Something unusual has occurred to cause the driver to fail. Please report this exception.
> [junit] org.postgresql.util.PSQLException: Something unusual has occurred to cause the driver to fail. Please report this exception.
> [junit] at org.postgresql.Driver.connect(Driver.java:275)
> [junit] at java.sql.DriverManager.getConnection(DriverManager.java:664)
> [junit] at java.sql.DriverManager.getConnection(DriverManager.java:247)
> [junit] at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:94)
> [junit] at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:79)
> [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.getDataSourceConnection(BaseDataSourceTest.java:76)
> [junit] at org.postgresql.test.jdbc2.optional.SimpleDataSourceWithSetURLTest.testGetURL(SimpleDataSourceWithSetURLTest.java:40)
> [junit] Caused by: java.lang.NullPointerException
> [junit] at java.util.logging.Handler.setLevel(Handler.java:263)
> [junit] at org.postgresql.Driver.setupLoggerFromProperties(Driver.java:342)
> [junit] at org.postgresql.Driver.connect(Driver.java:240)
> [junit]
> [junit] Testcase: testSetURL took 0.041 sec
> [junit] FAILED
> [junit] expected: null<null> but was: java.lang.String<null>
> [junit] junit.framework.AssertionFailedError: expected: null<null> but was: java.lang.String<null>
> [junit] at org.postgresql.test.jdbc2.optional.SimpleDataSourceWithSetURLTest.testSetURL(SimpleDataSourceWithSetURLTest.java:60)
> [junit]
> [junit] Testcase: testJndi took 0.056 sec
> [junit] FAILED
> [junit] Something unusual has occurred to cause the driver to fail. Please report this exception.
> [junit] junit.framework.AssertionFailedError: Something unusual has occurred to cause the driver to fail. Please report this exception.
> [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.testUseConnection(BaseDataSourceTest.java:143)
> [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.testJndi(BaseDataSourceTest.java:210)
> [junit]
> [junit] Testcase: testUseConnection took 0.063 sec
> [junit] FAILED
> [junit] Something unusual has occurred to cause the driver to fail. Please report this exception.
> [junit] junit.framework.AssertionFailedError: Something unusual has occurred to cause the driver to fail. Please report this exception.
> [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.testUseConnection(BaseDataSourceTest.java:143)
> [junit]
> [junit] Testcase: testPGConnection took 0.049 sec
> [junit] FAILED
> [junit] Unable to call PGConnection method on pooled connection due to org.postgresql.util.PSQLException (Something unusual has occurred to cause the driver to fail. Please report this exception.)
> [junit] junit.framework.AssertionFailedError: Unable to call PGConnection method on pooled connection due to org.postgresql.util.PSQLException (Something unusual has occurred to cause the driver to fail. Please report this exception.)
> [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.testPGConnection(BaseDataSourceTest.java:186)
> [junit]
> [junit] Testcase: testGetConnection took 0.054 sec
> [junit] FAILED
> [junit] Something unusual has occurred to cause the driver to fail. Please report this exception.
> [junit] junit.framework.AssertionFailedError: Something unusual has occurred to cause the driver to fail. Please report this exception.
> [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.testGetConnection(BaseDataSourceTest.java:115)
> [junit]
> [junit] Testcase: testNotPooledConnection took 0.063 sec
> [junit] Caused an ERROR
> [junit] Something unusual has occurred to cause the driver to fail. Please report this exception.
> [junit] org.postgresql.util.PSQLException: Something unusual has occurred to cause the driver to fail. Please report this exception.
> [junit] at org.postgresql.Driver.connect(Driver.java:275)
> [junit] at java.sql.DriverManager.getConnection(DriverManager.java:664)
> [junit] at java.sql.DriverManager.getConnection(DriverManager.java:247)
> [junit] at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:94)
> [junit] at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:79)
> [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.getDataSourceConnection(BaseDataSourceTest.java:76)
> [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.testNotPooledConnection(BaseDataSourceTest.java:167)
> [junit] Caused by: java.lang.NullPointerException
> [junit] at java.util.logging.Handler.setLevel(Handler.java:263)
> [junit] at org.postgresql.Driver.setupLoggerFromProperties(Driver.java:342)
> [junit] at org.postgresql.Driver.connect(Driver.java:240)
> [junit]
> [junit] Testcase: testDdlOverConnection took 0.051 sec
> [junit] FAILED
> [junit] Something unusual has occurred to cause the driver to fail. Please report this exception.
> [junit] junit.framework.AssertionFailedError: Something unusual has occurred to cause the driver to fail. Please report this exception.
> [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.testDdlOverConnection(BaseDataSourceTest.java:157)
>
> Could you give me guidence about this error? Thanks in advance.
>
>