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]
>
>
