You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "luoyunpeng (JIRA)" <ji...@apache.org> on 2017/03/23 09:25:41 UTC

[jira] [Updated] (TRAFODION-2551) exception is thrown, when using traT4DataSource in jdbcT4

     [ https://issues.apache.org/jira/browse/TRAFODION-2551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

luoyunpeng updated TRAFODION-2551:
----------------------------------
    Summary: exception is thrown, when using traT4DataSource in jdbcT4  (was: exception is thrown, when using traT4DataSource in jdbcT2)

> exception is thrown, when using traT4DataSource in jdbcT4
> ---------------------------------------------------------
>
>                 Key: TRAFODION-2551
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2551
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: client-jdbc-t4
>         Environment: clien evn: windows
> jdbc4
> centos version: 7.2
>            Reporter: luoyunpeng
>
> when i was running the following test code with jdbcT4 driver
> ####
> @Test
> 	public void testDataSource() throws SQLException, InterruptedException {
> 		dataSource = new TrafT4DataSource();
> 		int MaxPoolSize = 4;
> 		dataSource.setUrl(url);
> 		dataSource.setUser(usr);
> 		dataSource.setPassword(pwd);
> 		dataSource.setMaxPoolSize(MaxPoolSize);
> 		dataSource.setMinPoolSize(1);
> 		dataSource.setInitialPoolSize(1);
> 		System.out.println("start TrafT4DataSource test, the url is : " + url);
> 		for (int i = 0; i < MaxPoolSize + 3; i++) {
> 			System.out.println(i + " times");
> 			getConnection();
> 			connNew.close();
> 			connNew = null;
> 			Thread.currentThread().sleep(1000 * 60 * 20);
> 		}
> 	}
> 	private void getConnection() throws SQLException {
> 		connNew = dataSource.getConnection();
> 	}
> ####
> when about 4800 seconds, there is a exceptoin message as follows:
> ####
> org.trafodion.jdbc.t4.TrafT4Exception: The message id: max_pool_size_reached
>          at org.trafodion.jdbc.t4.TrafT4Messages.createSQLException(TrafT4Messages.java:304)
>          at org.trafodion.jdbc.t4.TrafT4PooledConnectionManager.getConnection(TrafT4PooledConnectionManager.java:136)
>          at org.trafodion.jdbc.t4.TrafT4DataSource.getConnection(TrafT4DataSource.java:135)
>          at org.jdbctest.DataSource.DataSourceTest.getConnection(DataSourceTest.java:37)
>          at org.jdbctest.DataSource.DataSourceTest.testDataSource(DataSourceTest.java:29)
>          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>          at java.lang.reflect.Method.invoke(Method.java:498)
>          at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
>          at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
>          at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
>          at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
>          at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
>          at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
>          at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
>          at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
>          at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
>          at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
>          at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
>          at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
>          at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
>          at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
>          at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
>          at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86)
>          at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
>          at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459)
>          at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:678)
>          at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382)
>          at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)