Hi!
One thing that i'm curious about is whether you are getting any affect
on performance when using Oracle oci driver instead of a type 4 driver?
Anyone that has an idea of that? I was about to give it a try some time
ago but couldn't connect using the oci driver but know you have found a
solution on that problem.
/Lennart
Georgi Kostadinov skrev:
>
> Hi Krishna,
>
> Thanks for your help! I've managed to solve the problem.
> Here's details about what I did:
>
> 1) I made sure I have Oracle RDBMS lib and bin in as well as WebLogic's
> path
> to Oci8 native libs my PATH (As you suggested):
>
>
>f:\weblogic\bin;f:\weblogic\bin\oci815_8;F:\Oracle\Ora81\orb\bin;F:\Oracle\Ora81\bin;F:\Oracle\Ora81\lib;f:\Inprise\AppServer\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;f:\jdk1.3\bin;f:\jdk1.2.2\bin;f:\programs\jakarta-tomcat\bin;f:\programs\dbXML\bin;
>
> 2) I ran the dbping utility from WebLogic and I got:
>
> F:\programs\jboss\bin>java -classpath
> f:\weblogic\oci\classes;f:\weblogic\license utils.dbping ORACLE SCOTT
> TIGER ORCL
> +++ WebLogic Native Layer for OCI 8.x (BETA-2)
>
> **** Success!!! ****
>
> You can connect to the database in your app using:
>
> Class.forName("weblogic.jdbc.oci.Driver").newInstance();
> java.sql.Connection conn =
> DriverManager.getConnection("jdbc:weblogic:oracle:ORCL", "SCOTT",
> "TIGER");
>
> **** or ****
>
> java.util.Properties props = new java.util.Properties();
> props.put("user", "SCOTT");
> props.put("password", "TIGER");
> props.put("server", "ORCL");
> Class.forName("weblogic.jdbc.oci.Driver").newInstance();
> java.sql.Connection conn =
> DriverManager.getConnection("jdbc:weblogic:oracle", props);
>
> 3) I noticed that I was using
> "jdbc20:weblogic:oracle:@asparuh:1521:ORCL"
> and the utility returned "jdbc:weblogic:oracle:ORCL"! So I got rid of
> the
> "@asparuh:1521:" bit and it all worked!
>
> Useful links (for solving this problem):
> http://www.weblogic.com/docs51/install/install_jdbc.html
> http://www.weblogic.com/docs51/techstart/dbping.html
>
> Cheers,
>
> Georgi
>
> > Subject: Re: [jBoss-User] weblogic, oci, jDriver, ORA-24327 (need
>explicitattach...)
> > From: "Krishna Kumar" <[EMAIL PROTECTED]>
> > Date: Tue, 7 Nov 2000 00:19:10 -0800
> >
> > Hi Georgi,
> > wonder if u had u'r problem fixed here is some additional info ....
> >
> > 1) Type 3/4 drivers is a good choice but they don't support long-raw and
> > blob columns...particularly if u are running them on a unice!!!
> >
> > 2) The explicit attach problem is well documented on weblogic & i presume it
> > must be similar on jboss as well the solutions is the follow
> >
> > Ensure the following are there in your LD_LIBRARY_PATH
> > $ORACLE_HOME/lib & $weblogic_home/lib/solaris/oci815_8
> > Also make sure u have set $ORACLE_HOME.
> >
> > This should surely fix the problem,
> >
> >
> > cheers
> > krishna kumar
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
--
mailto:[EMAIL PROTECTED]
http://www.benefit.se/english
Or try Yahoo! Messenger, my nickname is: en_grillad_special
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
