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/02/02 23:15:30 UTC
DO NOT REPLY [Bug 46651] New: JDBC sample does not allow empty
string(s) in prepare-SELECT statement - java-exception
https://issues.apache.org/bugzilla/show_bug.cgi?id=46651
Summary: JDBC sample does not allow empty string(s) in prepare-
SELECT statement - java-exception
Product: JMeter
Version: 2.3.2
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: Main
AssignedTo: jmeter-dev@jakarta.apache.org
ReportedBy: slavko_h@yahoo.com
Here is my prepare SELECT statement:
----
[Prepared Select Statement] SELECT ('EmailAddress=' + CAST(EmailAddress AS
VARCHAR)) as a1 from StoreShop.Trainers WHERE EmailAddress=?+'@'+?
----
with:
Parameter values: ${ID},${EMAIL-GROUP}
Parameter types: VARCHAR,VARCHAR
Here is a bulk of data and how JDBC sample is responding for them:
1) {"",""}(two empty strings - not null)
AR: the sample is failing: Response message: java.sql.SQLException: number of
arguments (0) and number of types (2) are not equal
ER: Response data: {"a1"} - data are not found but "a1" is a column name - not
java-exception error;
2) {"aaa6",""} - the second parameter is empty string
AR: the sample is failing: Response message: java.sql.SQLException: number of
arguments (1) and number of types (2) are not equal
ER: Response data: {"a1"} - data are not found but "a1" is a column name - not
java-exception error;
3) {"","bluerealm.com"} - the first parameter is empty string
AR: Response data: {"a1"} as expected - data not found but "a1" in a column
name;
So, JDBC sample is working inconsistency in three similar cases.
My expectation is that in the cases #1 test-results are same as in the #3.
--
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 46651] JDBC sample does not allow empty string(s)
in prepare-SELECT statement - java-exception
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46651
Sebb <se...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |DUPLICATE
--- Comment #1 from Sebb <se...@apache.org> 2009-02-02 15:02:39 PST ---
Same routine is used to parse the parameters as in CSV Dataset when quoted
strings are allowed, thus the last parameter(s) are dropped.
*** This bug has been marked as a duplicate of bug 46491 ***
--
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