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]
