You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jmeter-dev@jakarta.apache.org by bu...@apache.org on 2009/04/17 16:57:14 UTC
DO NOT REPLY [Bug 47045] New: JDBC Request .sql script file
execution
https://issues.apache.org/bugzilla/show_bug.cgi?id=47045
Summary: JDBC Request .sql script file execution
Product: JMeter
Version: unspecified
Platform: PC
OS/Version: Linux
Status: NEW
Severity: enhancement
Priority: P2
Component: HTTP
AssignedTo: jmeter-dev@jakarta.apache.org
ReportedBy: horatiuvlad@yahoo.com
JDBC Request is supporting only SQL queries and no .sql script files. It would
be helpful to have a new Query Type: Script that would take a .sql script file
path as input.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org
DO NOT REPLY [Bug 47045] JDBC Request .sql script file execution
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47045
--- Comment #3 from Sebb <se...@apache.org> 2009-04-20 08:16:05 PST ---
The script file appears to use
--
as a comment marker, and
;
at the end of a line to delimit statements.
As far as I know, neither of these are standardadised.
Also, using ";" to delimit statements is unlikely to work in all cases.
So whilst it might work for your particular case, it looks like it will not
work for all JBDC implementations.
It's important that JMeter is able to work with all JDBC implementations.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org
DO NOT REPLY [Bug 47045] JDBC Request .sql script file execution
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47045
--- Comment #2 from Horatiu Vlad <ho...@yahoo.com> 2009-04-20 07:46:38 PST ---
Created an attachment (id=23514)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23514)
JDBCSampler with Script Query Type
I'm using the attached JDBC Sample code that allows Script as Query Type. The
for the Query is the script file that was previously created as a DB dump. The
only limitation that I have to cope with in my case is the 'client_encoding'
that can be set only to 'UNICODE' or not specified at all.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org
DO NOT REPLY [Bug 47045] JDBC Request .sql script file execution
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47045
--- Comment #1 from Sebb <se...@apache.org> 2009-04-17 09:19:03 PST ---
What format would the script file take?
How is JMeter to know where the statement boundaries are?
JDBC does not support multiple queries per statement, as far as I know.
A lot of databases support script files, but as far as I know there is no
standard for statement delimiters or indeed for SQL features such as commit,
rollback, and set statements.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org