Oracle JDBC Connection - Response was NULL
Locked
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 |
RE: Oracle JDBC Connection - Response was NULL
|
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:[hidden email]] 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: [hidden email] For additional commands, e-mail: [hidden email] |
|
Also, add a View Results Tree Listener so you can see what the response is.
On 09/10/2009, Manjula Priyantha <[hidden email]> 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:[hidden email]] > 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: [hidden email] > For additional commands, e-mail: [hidden email] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [hidden email] For additional commands, e-mail: [hidden email] |
Re: Oracle JDBC Connection - Response was NULL
|
|
Hi Sebb / Manjula
I have added the listner ' View Results in Tree ' and found what was happening in Database . Manjula , I have used the Database URL as you have specified . Now it is working fine . Thank you to both of you . With warm regards, Vijay . C ----- Original Message ----- From: "sebb" <[hidden email]> To: "JMeter Users List" <[hidden email]> 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 <[hidden email]> 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:[hidden email]] >> 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: [hidden email] >> For additional commands, e-mail: [hidden email] >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [hidden email] > For additional commands, e-mail: [hidden email] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [hidden email] For additional commands, e-mail: [hidden email] |
|
In reply to this post by Manjula Priyantha
Hi
oracle.jdbc.OracleDriver should be used. The oracle.jdbc.driver.OracleDriver is deprecated Also please check jmeter.log regards deepak On Fri, Oct 9, 2009 at 3:39 AM, Manjula Priyantha < [hidden email]> 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:[hidden email]] > 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: [hidden email] > For additional commands, e-mail: [hidden email] > > |
Re: Oracle JDBC Connection - Response was NULL
|
|
In reply to this post by sebb-2-2
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" <[hidden email]> To: "JMeter Users List" <[hidden email]> 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 <[hidden email]> 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:[hidden email]] >> 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: [hidden email] >> For additional commands, e-mail: [hidden email] >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [hidden email] > For additional commands, e-mail: [hidden email] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [hidden email] For additional commands, e-mail: [hidden email] |
|
|
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 <[hidden email]>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" <[hidden email]> > To: "JMeter Users List" <[hidden email]> > 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 <[hidden email]> 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:[hidden email]] >>> 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: [hidden email] >>> For additional commands, e-mail: [hidden email] >>> >>> >>> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [hidden email] >> For additional commands, e-mail: [hidden email] >> >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [hidden email] > For additional commands, e-mail: [hidden email] > > |
Re: Oracle JDBC Connection - Response was NULL
|
|
Hi Deepak ,
Nice and Good Explanation . Thanking you a lot . With warm regards, Vijay ----- Original Message ----- From: "Deepak Shetty" <[hidden email]> To: "JMeter Users List" <[hidden email]> 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 > <[hidden email]>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" <[hidden email]> >> To: "JMeter Users List" <[hidden email]> >> 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 <[hidden email]> 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:[hidden email]] >>>> 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: [hidden email] >>>> For additional commands, e-mail: [hidden email] >>>> >>>> >>>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: [hidden email] >>> For additional commands, e-mail: [hidden email] >>> >>> >>> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [hidden email] >> For additional commands, e-mail: [hidden email] >> >> > --------------------------------------------------------------------- To unsubscribe, e-mail: [hidden email] For additional commands, e-mail: [hidden email] |
«
Return to JMeter - User
|
1 view|%1 views
Loading...
| Powered by Nabble | Edit this page |