Re: Errors encountered when running JDBC testcases fromOptionalTestSuite against vPG10.2 - Mailing list pgsql-jdbc
From | Jorge Solórzano |
---|---|
Subject | Re: Errors encountered when running JDBC testcases fromOptionalTestSuite against vPG10.2 |
Date | |
Msg-id | CA+cVU8PjwzuwAUHnP+1ig4DP1pyKF53EWmBhMnQk3zqrmAr=zg@mail.gmail.com Whole thread Raw |
List | pgsql-jdbc |
You have set the loggerLevel=null, valid values are OFF, DEBUG, TRACE
On Wed, Feb 28, 2018 at 10:48 PM, cathryn <9333724@qq.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.
pgsql-jdbc by date: