Georgi,
congratulations on getting this. If you find the time can you document this
for the ones that will come after you ?
thanks
marc
|-----Original Message-----
|From: [EMAIL PROTECTED]
|[mailto:[EMAIL PROTECTED]]On Behalf Of Georgi Kostadinov
|Sent: Tuesday, November 07, 2000 1:28 AM
|To: [EMAIL PROTECTED]
|Subject: [jBoss-User] Re: weblogic, oci, jDriver, ORA-24327, etc.
|
|
|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;%Sys
|temRoot%\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]
|
|
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
