Hi Deepak ,

Nice and Good Explanation . Thanking you a lot .

With warm regards,
Vijay


----- Original Message ----- From: "Deepak Shetty" <[email protected]>
To: "JMeter Users List" <[email protected]>
Sent: Monday, October 12, 2009 10:41 PM
Subject: Re: Oracle JDBC Connection - Response was NULL


1. If you want to display larger results returned then check
jmeter.properties
There is a property view.results.tree.max_size where you can specify the max
size (or disable)
# Maximum size of HTML page that can be displayed; default=200 * 1024
# Set to 0 to disable the size check
#view.results.tree.max_size=0


2. you have run out of java Heap. Running a test with View results tree
listener will cause that(you are storing all responses in memory so you will
run out of memory at some point in time( . Only use listeners like view
result tree if you are debugging something , dont use it for long running
tests (either run in command line mode or use listeners like summary report
which dont have a big footprint). You can increase the Java heap (Xmx) but
that will only postpone the appearance of the problem.





On Sun, Oct 11, 2009 at 9:52 PM, vijayakumar
<[email protected]>wrote:

Dear Sebb , Manjula and All ,

Thanks for all your guidance .,

As said earlier , The test plan was working fine , But the results in '
View results in Tree ' and ' Assertion Result ' were stopped after a
particular time . i.e., I have run the test plan for 50 concurrent users ,
But it was displaying the result for 13 users only after that there was
nothing displayed in these two listeners .

When I was looking on to Jmeter.log file , I got the following messages .

i. WARN - jmeter.visualizers.ViewResultsFullVisualizer: Response too large
to be displayed. Size: 6970261 > Max: 204800
2009/10/09 19:24:16

ii. ERROR - jmeter.threads.JMeterThread: Test failed!
java.lang.OutOfMemoryError: Java heap space

and my JMeter heap size setting are as follows ,  [ I have 2G RAM in my
machine ]

set HEAP=-Xms512m -Xmx1024m
set NEW=-XX:NewSize=128m -XX:MaxNewSize=128m
set SURVIVOR=-XX:SurvivorRatio=8 -XX:TargetSurvivorRatio=50%
set TENURING=-XX:MaxTenuringThreshold=2
set EVACUATION=-XX:MaxLiveObjectEvacuationRatio=20%
set RMIGC=-Dsun.rmi.dgc.client.gcInterval=600000
-Dsun.rmi.dgc.server.gcInterval=600000
set PERM=-XX:PermSize=64m -XX:MaxPermSize=64m
set DEBUG=-verbose:gc -XX:+PrintTenuringDistribution

What I have to do to solve this problem ? Please help me

Thanking You
With warm regards,
Vijayakumar.C
----- Original Message -----
From: "sebb" <[email protected]>
To: "JMeter Users List" <[email protected]>
Sent: Friday, October 09, 2009 4:12 PM
Subject: Re: Oracle JDBC Connection - Response was NULL


 Also, add a View Results Tree Listener so you can see what the response
is.

On 09/10/2009, Manjula Priyantha <[email protected]> wrote:

Hi Vijaya,

 Try as follows in JDBC Connection Configuration;

 Database URL    :       jdbc:oracle:thin:@host:port:service
 JDBC Driver class       :       oracle.jdbc.driver.OracleDriver
 Username                :       username
 Password                :       password

 BR,
 Manjula
 -----Original Message-----
 From: vijayakumar [mailto:[email protected]]
 Sent: Friday, October 09, 2009 12:33 PM
 To: JMeter Users List
 Subject: Oracle JDBC Connection - Response was NULL

 Dear All ,

 Greetings ,

We are executing a test plan with JDBC Connection Configuration . We are
 using Oracle Database and Java Application .

I have used the Database URL in JDBC Connection Configuration panel with
 following all possible syntax

 i. jdbc:oracle:thin:user/pass@//host:port/service  OR
 ii. jdbc:oracle:thin:@//host:port/service   OR
 iii.

jdbc:oracle:thin:@
(description=(address=(host={mc-name})(protocol=tcp)(port=
 {port-no}))(connect_data=(sid={sid})))

 and I have placed  " ojdbc14.jar " in JMeter lib folder already .

But , While am running my test plan , The query is not executed and the
 error thrown ar Assertion result as " JDBC Request
 Response Assertion : Response was null " .

 Can anyone please explain what I need to do to sort out the problem ?

 Thanking You
 With warm regards,
 Vijayakumar.C



---------------------------------------------------------------------
 To unsubscribe, e-mail: [email protected]
 For additional commands, e-mail: [email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]




---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]





---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to