https://issues.apache.org/bugzilla/show_bug.cgi?id=46522
Summary: JDBC and MSSQL - incorrect "Response data" in JDBC
sample
Product: JMeter
Version: 2.3.2
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: Main
AssignedTo: [email protected]
ReportedBy: [email protected]
My DB is "MSSQL Server 2005"
I'm using "sqljdbs4.jar" as ODBC driver.
My table has a few field and a few data lines.
When I am using a simple select - ResponseData are shown correctly in a JDBC
sample, for instance,
#1>SELECT visittypeid, visitname, version from storeshop.visittypes;
"Response data" tab is showing correct data as expected:
visittypeid typename version
1 Secret Shop 1
2 Blitz (Jun-Nov) 1
3 Training 1
4 Casual Visit 1
5 Blitz (2008 Holiday) 1
When I'm using little bit "fancy" SELECT, the ResponseData are incorrect, for
instance,
#2>SELECT 'visittypeid=' + CAST(visittypeid AS VARCHAR), 'typename=' +
typename, 'version=' + CAST(version AS VARCHAR) from storeshop.visittypes;
version=1 version=1 version=1
version=1 version=1 version=1
version=1 version=1 version=1
version=1 version=1 version=1
version=1 version=1 version=1
ER(ExpectedResult):
visittypeid=1 typename=Secret Shop version=1
visittypeid=2 typename=Blitz (Jun-Nov) version=1
...
I used to use a similar "technique" with MySql - I didn't have any problem
there.
The #2 SELECT inside MSSQL is working fine, as expected.
So, I do not exactly, is it Jmeter "display" issue or "sqljdbs4.jar" issue.
Would you provide me "mssql" ODBC driver which you are using to verify the
"issue" again.
You can attach the jar-file to this report - I guess it is ~0.5MB, if it is OK
for you Or send directly to my email Or let me know when I can get "correct"
one.
--
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: [email protected]
For additional commands, e-mail: [email protected]
