>haven't been able to figure out the meaning/behaviour of the SQL Query
Types:
Options probably make sense to some one familiar with Java / JDBC


   - Select Statement -- Any query that returns data
   - Update Statement -- Any insert/update/delete
   - Callable Statement-- Stored Procedure
   - Prepared Select Statement- Use a prepared statement in Java

A normal statement is select * from table where column=value

A prepared statement is select * from table where column = ?

And  ? is bound later with the actual value (and hence can be reused for
multiple invocations , plus some compile benefits)

   - Prepared Update Statement

Same as above , but for inserts,updates,deletes

   - Commit
   - Rollback
   - Autocommit(false)
   - Autocommit(true)

These control transaction behavior- if you set autocommit off then then you
must explicitly commit/rollback.



On Tue, Mar 5, 2013 at 8:16 AM, Jakob van Bethlehem <[email protected]>wrote:

> Dear users,
>
> My JMeter experiments continue. Honestly, I find it hard to find
> documentation quickly or some examples that go beyond the first 'Hello
> world'-ish case (for instance: I haven't been able to figure out the
> meaning/behaviour of the SQL Query Types: an easy explanation of when to
> choose what). I hoped the Wiki would help, but that gives me a 'No search
> results' for about any search term I come up with :(…..
>
> Hence my question: besides the jmeter.apache.org/usermanual and the Wiki,
> are there any other (up-to-date) places to go to?
>
> Sincerely,
> Jakob van Bethlehem
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>

Reply via email to