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] > >
