My validation Query was "Select 1" (likely a default). I removed it and
I no longer get the warning message.
Thank you.
Jerry
On 9/5/2013 2:52 PM, Deepak Shetty wrote:
two things to check
a. What is the validation statement in the JDBC connection config element?
is it valid?
b. Did you put a debug sampler and check that your file is being read
correctly and the statements are being read correctly
On Thu, Sep 5, 2013 at 12:28 PM, Jerry Lampi <[email protected]> wrote:
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.**DelegatingConstructorAccessorI**mpl.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.**
ResourceLimitingJdbcConnection**Pool.newPoolable(**
ResourceLimitingJdbcConnection**Pool.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:
user-unsubscribe@jmeter.**apache.org<[email protected]>
For additional commands, e-mail: [email protected]
---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 130905-0, 09/05/2013
Tested on: 9/5/2013 2:59:05 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]
