You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Jae Joo <jj...@ECNext.com> on 2007/09/13 22:17:40 UTC

JDBC Request 

Hi,

 

I am new in jmeter and I am trying to some JDBC Request testing with
Oracle.

 

Here is the jdbc definition.

 

oracle.jdbc.driver.OracleDriver

dbc:oracle:thin:@hostname:port:dbname

username/password

 

And I added 

 

Select * from table_1;

 

Then, click start, it did not do anything. I have check the oracle side,
there is connection established, but no sql statement was sent.

Also, I ran this test plan in NON-GUI command with -l logfile option, it
shows no error messages.

 

 

Anything I missed?

 

Thanks,

 

 

Jae Joo

Application Architect

 

ECNext, Inc.

614-682-5134 (office)

614-682-5104 (fax)

www.ecnext.com <blocked::http://www.ecnext.com/> 

 

Making e-Content Work for You(tm)

RE: JDBC Request

Posted by Jae Joo <jj...@ECNext.com>.
Nothing.



-----Original Message-----
From: sebb [mailto:sebbaz@gmail.com] 
Sent: Friday, September 14, 2007 9:47 AM
To: JMeter Users List
Subject: Re: JDBC Request

On 14/09/2007, Jae Joo <jj...@ecnext.com> wrote:
> There are 3 warnings in jmeter log file. I am wondering it causes the
> problem.
>
> 2007/09/14 08:17:35 WARN  - jmeter.save.SaveService: Could not set up
> alias JMSSampler java.lang.NoClassDefFoundError: javax/jms/Message
> 2007/09/14 08:17:35 WARN  - jmeter.save.SaveService: Could not set up
> alias SubscriberSampler java.lang.NoClassDefFoundError:
> javax/jms/MessageListener
> 2007/09/14 08:17:35 WARN  - jmeter.save.SaveService: Could not set up
> alias MailerVisualizer java.lang.NoClassDefFoundError:
> javax/mail/MessagingException

No, these are not relevant to JDBC.

> Still not sending sql query...

What does the Tree Listener show in the different panels?

> Jae
>
> -----Original Message-----
> From: sebb [mailto:sebbaz@gmail.com]
> Sent: Thursday, September 13, 2007 7:32 PM
> To: JMeter Users List
> Subject: Re: JDBC Request
>
> Check the jmeter.log file
>
> On 13/09/2007, Jae Joo <jj...@ecnext.com> wrote:
> > Hi,
> >
> >
> >
> > I am new in jmeter and I am trying to some JDBC Request testing with
> > Oracle.
> >
> >
> >
> > Here is the jdbc definition.
> >
> >
> >
> > oracle.jdbc.driver.OracleDriver
> >
> > dbc:oracle:thin:@hostname:port:dbname
> >
> > username/password
> >
> >
> >
> > And I added
> >
> >
> >
> > Select * from table_1;
> >
> >
> >
> > Then, click start, it did not do anything. I have check the oracle
> side,
> > there is connection established, but no sql statement was sent.
> >
> > Also, I ran this test plan in NON-GUI command with -l logfile
option,
> it
> > shows no error messages.
> >
> >
> >
> >
> >
> > Anything I missed?
> >
> >
> >
> > Thanks,
> >
> >
> >
> >
> >
> > Jae Joo
> >
> > Application Architect
> >
> >
> >
> > ECNext, Inc.
> >
> > 614-682-5134 (office)
> >
> > 614-682-5104 (fax)
> >
> > www.ecnext.com <blocked::http://www.ecnext.com/>
> >
> >
> >
> > Making e-Content Work for You(tm)
> >
> >
> >
> >
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org

Re: JDBC Request

Posted by sebb <se...@gmail.com>.
On 14/09/2007, Jae Joo <jj...@ecnext.com> wrote:
> There are 3 warnings in jmeter log file. I am wondering it causes the
> problem.
>
> 2007/09/14 08:17:35 WARN  - jmeter.save.SaveService: Could not set up
> alias JMSSampler java.lang.NoClassDefFoundError: javax/jms/Message
> 2007/09/14 08:17:35 WARN  - jmeter.save.SaveService: Could not set up
> alias SubscriberSampler java.lang.NoClassDefFoundError:
> javax/jms/MessageListener
> 2007/09/14 08:17:35 WARN  - jmeter.save.SaveService: Could not set up
> alias MailerVisualizer java.lang.NoClassDefFoundError:
> javax/mail/MessagingException

No, these are not relevant to JDBC.

> Still not sending sql query...

What does the Tree Listener show in the different panels?

> Jae
>
> -----Original Message-----
> From: sebb [mailto:sebbaz@gmail.com]
> Sent: Thursday, September 13, 2007 7:32 PM
> To: JMeter Users List
> Subject: Re: JDBC Request
>
> Check the jmeter.log file
>
> On 13/09/2007, Jae Joo <jj...@ecnext.com> wrote:
> > Hi,
> >
> >
> >
> > I am new in jmeter and I am trying to some JDBC Request testing with
> > Oracle.
> >
> >
> >
> > Here is the jdbc definition.
> >
> >
> >
> > oracle.jdbc.driver.OracleDriver
> >
> > dbc:oracle:thin:@hostname:port:dbname
> >
> > username/password
> >
> >
> >
> > And I added
> >
> >
> >
> > Select * from table_1;
> >
> >
> >
> > Then, click start, it did not do anything. I have check the oracle
> side,
> > there is connection established, but no sql statement was sent.
> >
> > Also, I ran this test plan in NON-GUI command with -l logfile option,
> it
> > shows no error messages.
> >
> >
> >
> >
> >
> > Anything I missed?
> >
> >
> >
> > Thanks,
> >
> >
> >
> >
> >
> > Jae Joo
> >
> > Application Architect
> >
> >
> >
> > ECNext, Inc.
> >
> > 614-682-5134 (office)
> >
> > 614-682-5104 (fax)
> >
> > www.ecnext.com <blocked::http://www.ecnext.com/>
> >
> >
> >
> > Making e-Content Work for You(tm)
> >
> >
> >
> >
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org

RE: JDBC Request

Posted by Jae Joo <jj...@ECNext.com>.
There are 3 warnings in jmeter log file. I am wondering it causes the
problem.

2007/09/14 08:17:35 WARN  - jmeter.save.SaveService: Could not set up
alias JMSSampler java.lang.NoClassDefFoundError: javax/jms/Message 
2007/09/14 08:17:35 WARN  - jmeter.save.SaveService: Could not set up
alias SubscriberSampler java.lang.NoClassDefFoundError:
javax/jms/MessageListener 
2007/09/14 08:17:35 WARN  - jmeter.save.SaveService: Could not set up
alias MailerVisualizer java.lang.NoClassDefFoundError:
javax/mail/MessagingException

Still not sending sql query...

Jae

-----Original Message-----
From: sebb [mailto:sebbaz@gmail.com] 
Sent: Thursday, September 13, 2007 7:32 PM
To: JMeter Users List
Subject: Re: JDBC Request

Check the jmeter.log file

On 13/09/2007, Jae Joo <jj...@ecnext.com> wrote:
> Hi,
>
>
>
> I am new in jmeter and I am trying to some JDBC Request testing with
> Oracle.
>
>
>
> Here is the jdbc definition.
>
>
>
> oracle.jdbc.driver.OracleDriver
>
> dbc:oracle:thin:@hostname:port:dbname
>
> username/password
>
>
>
> And I added
>
>
>
> Select * from table_1;
>
>
>
> Then, click start, it did not do anything. I have check the oracle
side,
> there is connection established, but no sql statement was sent.
>
> Also, I ran this test plan in NON-GUI command with -l logfile option,
it
> shows no error messages.
>
>
>
>
>
> Anything I missed?
>
>
>
> Thanks,
>
>
>
>
>
> Jae Joo
>
> Application Architect
>
>
>
> ECNext, Inc.
>
> 614-682-5134 (office)
>
> 614-682-5104 (fax)
>
> www.ecnext.com <blocked::http://www.ecnext.com/>
>
>
>
> Making e-Content Work for You(tm)
>
>
>
>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org

Re: JDBC Request

Posted by sebb <se...@gmail.com>.
Check the jmeter.log file

On 13/09/2007, Jae Joo <jj...@ecnext.com> wrote:
> Hi,
>
>
>
> I am new in jmeter and I am trying to some JDBC Request testing with
> Oracle.
>
>
>
> Here is the jdbc definition.
>
>
>
> oracle.jdbc.driver.OracleDriver
>
> dbc:oracle:thin:@hostname:port:dbname
>
> username/password
>
>
>
> And I added
>
>
>
> Select * from table_1;
>
>
>
> Then, click start, it did not do anything. I have check the oracle side,
> there is connection established, but no sql statement was sent.
>
> Also, I ran this test plan in NON-GUI command with -l logfile option, it
> shows no error messages.
>
>
>
>
>
> Anything I missed?
>
>
>
> Thanks,
>
>
>
>
>
> Jae Joo
>
> Application Architect
>
>
>
> ECNext, Inc.
>
> 614-682-5134 (office)
>
> 614-682-5104 (fax)
>
> www.ecnext.com <blocked::http://www.ecnext.com/>
>
>
>
> Making e-Content Work for You(tm)
>
>
>
>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org