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]
