You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Mike Stover <ms...@apache.org> on 2001/06/22 16:03:06 UTC
Re: JDBC
My understanding is that JDBC doesn't quite work, currently. However, there
is a flaw in your test case - you've lumped sub-protocol and url together,
when they should be separate. That is why you get "null" for subprotocol in
your connection attempt, and everything appears in your server-name.
Try, entering "oracle:thin" in the protocol field, and the server name and
database name for the url.
JMeter creates the final connection string as follows:
return "jdbc:"+getSubProtocol()+"://"+getUrl()
And, you can see where it does this at line 107 in DbConfig.java - in case
you need to change it.
-Mike
On Friday 22 June 2001 16:41, Houck, James wrote:
> > Has anyone been able to get the jdbc functionality to work.
>
> I have tried several variations and get the following message over and
> over again.
>
> ConnectionObject: e=java.sql.SQLException: No suitable driverurl =
> jdbc:null://jdbc:oracle:thin:@devora:1521:devora ConnectionObject:
> e=java.sql.SQLException: No suitable driverurl =
> jdbc:null://jdbc:oracle:thin:@devora:1521:devora ConnectionObject:
> e=java.sql.SQLException: No suitable driverurl =
> jdbc:null://jdbc:oracle:thin:@devora:1521:devora
>
> Using
> <?xml version="1.0"?>
>
> <TestPlan>
> <threadgroups>
> <ThreadGroup name="ThreadGroup" numThreads="1">
> <controllers>
> <JdbcTestSample
> type="org.apache.jmeter.protocol.jdbc.control.JdbcTestSample"
> name="Database Testing"> <defaultDb>
> <ConfigElement type="org.apache.jmeter.protocol.jdbc.config.DbConfig">
> <property name="url">jdbc:oracle:thin:@devora:1521:devora</property>
> <property name="password">ziabot</property>
> <property name="driver">oracle.jdbc.driver.OracleDriver</property>
> <property name="username">test</property>
> </ConfigElement></defaultDb>
> <defaultPool>
> <ConfigElement type="org.apache.jmeter.protocol.jdbc.config.PoolConfig">
> <property name="use">50</property>
> <property name="num_connections">1</property>
> </ConfigElement></defaultPool>
> <sqlList>
> <ConfigElement type="org.apache.jmeter.protocol.jdbc.config.SqlConfig">
> <property name="name">Sql Query</property>
> <property name="query">Select * from zips_users</property>
> </ConfigElement>
> </sqlList>
> <configElements>
> </configElements>
> <controllers>
> </controllers>
> </JdbcTestSample>
>
> </controllers>
> <configElements>
> </configElements>
> <timers>
> <Timer type="org.apache.jmeter.timers.ConstantTimer" name="Constant Timer">
> <delay>300</delay>
> <range>0.0</range>
> </Timer>
>
> </timers>
> <listeners>
> <JMeterComponent type="org.apache.jmeter.visualizers.GraphModel"
> name="Graph Results"/> </listeners>
> </ThreadGroup>
>
> </threadgroups>
> <configElements>
> </configElements>
> </TestPlan>
>
>
> Thanks,
>
> James R Houck
> Zilliant
> email: houckj@zilliant.com
> 512.531.8514 Wk
> 512.531.8599 Fax
> 512.585.0112 Cell
----------------------------------------
Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description:
----------------------------------------
--
Mike Stover
mstover1@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
Posted by "dennis@zserve.com" <de...@zserve.com>.
I got JDBC to work just fine. Of cource, I'm using a different database
but that shouldn't really make
a difference.
I could not however, use any of the Listeners with JDBC. ( ie, View
Results, Graph Results )
-Dennis
On 22 Jun 2001 14:03:06 +0000, Mike Stover wrote:
> My understanding is that JDBC doesn't quite work, currently. However, there
> is a flaw in your test case - you've lumped sub-protocol and url together,
> when they should be separate. That is why you get "null" for subprotocol in
> your connection attempt, and everything appears in your server-name.
>
> Try, entering "oracle:thin" in the protocol field, and the server name and
> database name for the url.
>
> JMeter creates the final connection string as follows:
> return "jdbc:"+getSubProtocol()+"://"+getUrl()
>
> And, you can see where it does this at line 107 in DbConfig.java - in case
> you need to change it.
>
> -Mike
>
>
> On Friday 22 June 2001 16:41, Houck, James wrote:
>
> > > Has anyone been able to get the jdbc functionality to work.
> >
> > I have tried several variations and get the following message over and
> > over again.
> >
> > ConnectionObject: e=java.sql.SQLException: No suitable driverurl =
> > jdbc:null://jdbc:oracle:thin:@devora:1521:devora ConnectionObject:
> > e=java.sql.SQLException: No suitable driverurl =
> > jdbc:null://jdbc:oracle:thin:@devora:1521:devora ConnectionObject:
> > e=java.sql.SQLException: No suitable driverurl =
> > jdbc:null://jdbc:oracle:thin:@devora:1521:devora
> >
> > Using
> > <?xml version="1.0"?>
> >
> > <TestPlan>
> > <threadgroups>
> > <ThreadGroup name="ThreadGroup" numThreads="1">
> > <controllers>
> > <JdbcTestSample
> > type="org.apache.jmeter.protocol.jdbc.control.JdbcTestSample"
> > name="Database Testing"> <defaultDb>
> > <ConfigElement type="org.apache.jmeter.protocol.jdbc.config.DbConfig">
> > <property name="url">jdbc:oracle:thin:@devora:1521:devora</property>
> > <property name="password">ziabot</property>
> > <property name="driver">oracle.jdbc.driver.OracleDriver</property>
> > <property name="username">test</property>
> > </ConfigElement></defaultDb>
> > <defaultPool>
> > <ConfigElement type="org.apache.jmeter.protocol.jdbc.config.PoolConfig">
> > <property name="use">50</property>
> > <property name="num_connections">1</property>
> > </ConfigElement></defaultPool>
> > <sqlList>
> > <ConfigElement type="org.apache.jmeter.protocol.jdbc.config.SqlConfig">
> > <property name="name">Sql Query</property>
> > <property name="query">Select * from zips_users</property>
> > </ConfigElement>
> > </sqlList>
> > <configElements>
> > </configElements>
> > <controllers>
> > </controllers>
> > </JdbcTestSample>
> >
> > </controllers>
> > <configElements>
> > </configElements>
> > <timers>
> > <Timer type="org.apache.jmeter.timers.ConstantTimer" name="Constant Timer">
> > <delay>300</delay>
> > <range>0.0</range>
> > </Timer>
> >
> > </timers>
> > <listeners>
> > <JMeterComponent type="org.apache.jmeter.visualizers.GraphModel"
> > name="Graph Results"/> </listeners>
> > </ThreadGroup>
> >
> > </threadgroups>
> > <configElements>
> > </configElements>
> > </TestPlan>
> >
> >
> > Thanks,
> >
> > James R Houck
> > Zilliant
> > email: houckj@zilliant.com
> > 512.531.8514 Wk
> > 512.531.8599 Fax
> > 512.585.0112 Cell
>
> ----------------------------------------
> Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
> Content-Transfer-Encoding: quoted-printable
> Content-Description:
> ----------------------------------------
>
> --
> Mike Stover
> mstover1@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