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: [EMAIL PROTECTED] > > 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 > [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]
