I am running a JDBC Request test against Derby 10.10.1.1 and am getting
an <EOF> warning.
The statement I am running is:
select * from SDS_SFM.REQUEST where REQ_TYPE='LOGON' and REQ_STATUS='O'
The statement works, both in JMeter and SQuirrel SQL Client. It is a
valid statement for my DB.
All lines in my defined log file as similar to this:
1378409161962,124,JDBC Select,200,OK,JDBC Users 1-6,text,true,126,120
Here is the JMeter warning:
2013/09/05 14:20:38 WARN -
jmeter.protocol.jdbc.config.DataSourceElement: Could not prepare test
statement, connection recycled on basis of time.
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "<EOF>" at
line 1, column 8.
at
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown
Source)
at org.apache.derby.client.am.Connection.prepareStatement(Unknown
Source)
at
org.apache.avalon.excalibur.datasource.AbstractJdbcConnection.<init>(AbstractJdbcConnection.java:150)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.getProxy(JdbcConnectionFactory.java:265)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:211)
at
org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(ResourceLimitingPool.java:672)
at
org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(ValidatedResourceLimitingPool.java:178)
at
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable(ResourceLimitingJdbcConnectionPool.java:123)
at
org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(ResourceLimitingPool.java:402)
at
org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:130)
at
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:222)
at
org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceComponentImpl.getConnection(DataSourceElement.java:286)
at
org.apache.jmeter.protocol.jdbc.config.DataSourceElement.getConnection(DataSourceElement.java:146)
at
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:85)
at
org.apache.jmeter.threads.JMeterThread.process_sampler(JMeterThread.java:428)
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:256)
at java.lang.Thread.run(Unknown Source)
It is just a warning, but I get a lot of them because I have multiple
threads with loop counts defined.
Any ideas to prevent this warning?
Thanks,
Jerry
---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 130905-0, 09/05/2013
Tested on: 9/5/2013 2:28:22 PM
avast! - copyright (c) 1988-2013 AVAST Software.
http://www.avast.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
