You have to do 2 things with OCI driver : - add the jar in lib/ext of Jmeter - install on Jmeter node the native part of Oracle client Net10g or other, and fill the tnsname file to permit to JDBC Driver 2 to connect to databse.
Cordialement / Best regards Jean-Louis Pasturel -----Message d'origine----- De : Ali Navab [mailto:[email protected]] Envoyé : mardi 8 février 2011 09:27 À : JMeter Users List Objet : Re: JDBC Connection to Oracle through Proxy Dear Pasturel, I tested it using the thin driver of Oracle ( Type 4) successfully for direct mode. if i want to connect to DB via Proxy i must using the oci driver of Oracle. could i add the jar of the oci driver into lib of JMeter like thin mode? how can i using JDBC using oci driver? what about "java request" of JMeter?? is it useful for me? On Sun, Feb 6, 2011 at 8:12 PM, Pasturel <[email protected]>wrote: > Hi, > as i understand you want to use the oci driver of Oracle that *needs* > native oracle library on client side ( JMeter node) with this JDBC of > type > 2 > > Why don't you use the thin driver of Oracle ( Type 4) ? > You have only to put the jar of the thin driver into lib/ext of > JMeter and adpat the URL to the thin driver. > > Le 05/02/2011 13:40, Ali Navab a écrit : > > Hi Pasturel, >> Thanks for speedy reply. I want to connect to oracle via database >> proxy by "jdbc:oracle:*oci*:@" + tns I need to call some routine and >> authenticate myself first for proxy befor connecting to my tables.. >> So i want to know do JMeter have any module or plugin to handle it? >> or i have to using JUnit to handle this request ? >> >> On Sat, Feb 5, 2011 at 2:41 PM, >> Pasturel<[email protected] >> >wrote: >> >> Le 05/02/2011 11:45, Ali Navab a écrit : >>> >>> Dear Reader, >>> >>>> Hi, >>>> I want to test a JDBC connection to Oracle through proxy. I tested >>>> it directly (without a proxy) successfully but i do not know how >>>> can i test it through a proxy .. ??! any references or docs? >>>> It will be really appreciated if someone can help me. >>>> Thanks in advanced >>>> >>>> Regards, >>>> aLi nAvAb >>>> >>>> What kind of proxy ? A proxy is bound to a protocol, http proxy, >>>> tcp >>>> >>> proxy. Perhaps JDBC proxy exists, i don't know >>> >>> -------------------------------------------------------------------- >>> - 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] > > ********************************* This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. Messages are susceptible to alteration. France Telecom Group shall not be liable for the message if altered, changed or falsified. If you are not the intended addressee of this message, please cancel it immediately and inform the sender. ******************************** --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
