The driver is the same as far as I remember , the connection string for java is something like jdbc:oracle:oci:@AA (AA is what you defined in TNSNames.ora). look up the documentation in oracle
On Tue, Feb 8, 2011 at 1:33 AM, Ali Navab <[email protected]> wrote: > Great .. > I added the jar file and installed the Oracle client 11g. > I could not understand how to fill the tnsname file of Oracle Client to > permit to JDBC Driver 2. > I added the tns of my database to the "TNSNAMES.ORA" file in my Oracle > Client like this: > AA = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST =X)(PORT =Y)) > ) > (CONNECT_DATA = > (SID = ORA8) > (SERVER = DEDICATED) > ) > ) > > How can i say to JMeter to connect to database or Oracle Cilent ?? JMeter > has problem with this Database URL : jdbc:oracle:oci:@ > > (description=(address=(host=X)(protocol=tcp)(port=Y))(connect_data=(SERVER=DEDICATED)(sid=ORA8))) > > Is the JDBC Driver Class of oci is the same as thin ? > Can i use JDBC Request to connect to DataBase without using connection > pool? > > > > > On Tue, Feb 8, 2011 at 12:14 PM, <[email protected] > >wrote: > > > > > 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] > > > > >
