jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "dennis@zserve.com" <den...@zserve.com>
Subject Re: JDBC
Date Fri, 22 Jun 2001 20:30:28 GMT
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


Mime
View raw message