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 2006/11/09 10:50:44 UTC
DO NOT REPLY [Bug 40934] New: - Oracle database connection, database parameters read from file by CSV Data Set Config
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=40934>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=40934
Summary: Oracle database connection, database parameters read
from file by CSV Data Set Config
Product: JMeter
Version: 2.2
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P3
Component: Main
AssignedTo: jmeter-dev@jakarta.apache.org
ReportedBy: Michal.Kaczmarzyk@comarch.com
Connection to Oracle database.
All necessary info (host, port, SID) are stored in *.txt file. CSV Data Set Config
gets them from file and assigns to variables.
,Variable Names (comma-delimited), field in CSV Data Set Config is:
host,port,sid
In JDBC Connection Configuration in 'Database URL' field there is:
jdbc:oracle:thin:@${host}:${port}:${sid}
After running the test plan HTTP Response Message is: 'java.sql.SQLException:
Invalid number format for port number', although all the values from file were
read correctly (checked with Java request). When 'Database URL' field is:
jdbc:oracle:thin:@nemo:1523:MY_SID (fixed values), everything is OK.
CSVRead function instead of CSV Data Set Config, makes it also working just fine.
It looks like, after getting the values from file by CSV Data Set Config, the
values are not replaced in ${variable_name} reference, in JDBC Connection
Configuration element.
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org
[Bug 40934] CSV Data Set Config parameters cannot be used in some
Config elements
Posted by bu...@apache.org.
http://issues.apache.org/bugzilla/show_bug.cgi?id=40934
Nikolai Prokoschenko <ni...@prokoschenko.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |nikolai@prokoschenko.de
--- Comment #4 from Nikolai Prokoschenko <ni...@prokoschenko.de> 2008-02-27 04:45:34 ---
So this bug is actually about JDBC sampler, right? Judging from mailing list
traffic and own experience, it's the only sampler that doesn't support
user-defined variables. Considering this bug didn't exist in the "old" JDBC
sampler (e.g. in 2.0.1) it is introduced in 2.3 and is making life difficult
for people like myself who have to migrate from 2.0.1
I'm having the same problems: variables in JDBC configuration field are not
used, i.e. replaced with blanks. Using verbatim configuration in these fields
works, using properties on the command line works too, but not variables with
values calculated at run-time.
If this is really a problem with initialization order (which it seems it is),
could some developers please take a look the JDBC sampler and make it use the
runtime configuration? I tried to, but my experience is limited and JMeter code
is foreign to me.
--
Configure bugmail: http://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 40934] - CSV Data Set Config parameters cannot be used in Config elements
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=40934>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=40934
sebb@apache.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|Oracle database connection, |CSV Data Set Config
|database parameters read |parameters cannot be used in
|from file by CSV Data Set |Config elements
|Config |
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org
[Bug 40934] CSV Data Set Config parameters cannot be used in some
Config elements
Posted by bu...@apache.org.
http://issues.apache.org/bugzilla/show_bug.cgi?id=40934
--- Comment #6 from Nikolai Prokoschenko <ni...@prokoschenko.de> 2008-02-27 08:23:14 ---
(In reply to comment #5)
> (In reply to comment #4)
> > Considering this bug didn't exist in the "old" JDBC
> > sampler (e.g. in 2.0.1) it is introduced in 2.3 and is making life difficult
> > for people like myself who have to migrate from 2.0.1
> CSV Dataset did not exist in 2.0.1.
My problematic case doesn't involve CSV Dataset, but generated variables
instead.
> > I'm having the same problems: variables in JDBC configuration field are not
> > used, i.e. replaced with blanks. Using verbatim configuration in these fields
> > works, using properties on the command line works too, but not variables with
> > values calculated at run-time.
> Exactly what used to work in 2.0.1 and does not work now?
Existing scripts which use the JDBC Sampler with a properties file and
user-defined variables. Pool variable has been set manually for the config
element and the sampler.
> It would help if you could attach a simple test case that works in 2.0.1 and
> fails in the later version of JMeter.
I'll try to do so tomorrow.
--
Configure bugmail: http://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
[Bug 40934] CSV Data Set Config parameters cannot be used in some
Config elements
Posted by bu...@apache.org.
http://issues.apache.org/bugzilla/show_bug.cgi?id=40934
Sebb <se...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #5 from Sebb <se...@apache.org> 2008-02-27 05:58:35 ---
(In reply to comment #4)
> So this bug is actually about JDBC sampler, right? Judging from mailing list
> traffic and own experience, it's the only sampler that doesn't support
> user-defined variables.
Not strictly true, there was another case recently not involving JDBC.
See:
http://www.nabble.com/User-and-Password-Variable-Problem-td15598236.html#a15598236
> Considering this bug didn't exist in the "old" JDBC
> sampler (e.g. in 2.0.1) it is introduced in 2.3 and is making life difficult
> for people like myself who have to migrate from 2.0.1
CSV Dataset did not exist in 2.0.1.
> I'm having the same problems: variables in JDBC configuration field are not
> used, i.e. replaced with blanks. Using verbatim configuration in these fields
> works, using properties on the command line works too, but not variables with
> values calculated at run-time.
Exactly what used to work in 2.0.1 and does not work now?
> If this is really a problem with initialization order (which it seems it is),
> could some developers please take a look the JDBC sampler and make it use the
> runtime configuration? I tried to, but my experience is limited and JMeter code
> is foreign to me.
>
It would help if you could attach a simple test case that works in 2.0.1 and
fails in the later version of JMeter.
--
Configure bugmail: http://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 40934] - Oracle database connection, database parameters read from file by CSV Data Set Config
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=40934>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=40934
------- Additional Comments From sebb@apache.org 2007-01-18 17:18 -------
User Defined Variables also work OK.
The CSV Dataset does not work with JDBC Config because it processes the file
read after the other Config elements have been processed.
Not sure how to fix this yet.
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
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 40934] - CSV Data Set Config parameters cannot be used in some Config elements
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=40934>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=40934
sebb@apache.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|CSV Data Set Config |CSV Data Set Config
|parameters cannot be used in|parameters cannot be used in
|Config elements |some Config elements
------- Additional Comments From sebb@apache.org 2007-09-06 07:17 -------
In fact CSV Dataset works OK in Configuration elements that process their data
at run time - for example HTTP Auth Manager, Header Manager and Cookie Manager
(which now handles variables).
The problem with JDBC Config is that its data items are processed during test
initialisation, which is too early for the CSV variables to be defined.
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
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 40934] - CSV Data Set Config parameters cannot be used in Config elements
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=40934>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=40934
------- Additional Comments From sebb@apache.org 2007-09-01 04:50 -------
Now at least documented in known bugs and component_reference...
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org