![]() ![]() JDBC Driver class: Fully qualified name of driver class.Database URL: JDBC Connection string for the database.However some may require a different query for example, Oracle something like ' SELECT 1 FROM DUAL ' could be used. This defaults to the ' isValid() ' method of the JDBC driver, which is suitable for many databases. Validation Query: A simple query used to determine if the database is still responding.Soft Min Evictable Idle Time(ms): Minimum amount of time a connection may sit idle in the pool before it is eligible for eviction by the idle object evictor, with the extra condition that at least minIdle connections remain in the pool.Test While Idle: Test idle connections of the pool.Auto Commit: Turn auto-commit on or off for the connections.When non-positive, no idle object evictor thread will be run. Time Between Eviction Runs (ms): The number of milliseconds to sleep between runs of the idle object evictor thread.Max Wait (ms): Pool throws an error if the timeout period is exceeded in the process of trying to retrieve a connection.If you really want to use shared pooling, then set the max count to the same as the number of threads to ensure threads don't wait on each other. the connections are not shared between threads. This means that each thread will get its own pool with a single connection in it, i.e. Max Number of Connections: Maximum number of connections allowed in the pool.Multiple connections can be used, each tied to a different variable, allowing JDBC Samplers to select the appropriate connection. Variable Name : The name of the variable the connection is tied to. ![]() Comments : To provide arbitrary comments (if any). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |