Connecting to Oracle from weblogic6.1
843829Apr 18 2002 — edited Apr 30 2002Hi there!
I am trying to connect to Oracle database (Oracle 8i DB enterprise edition) from my CONSOLE. When I configure my JDBC connection pool and apply the target(weblogic server name - in my case it is "myserver") to it, it's giving me oracle.net.TNSAddress.SOException.
Configuration:
----------------------
URL: jdbc:oracle:thin:@sweetcorn:1521:okidev
Driver: oracle.jdbc.driver.OracleDriver
user=scorm (This is the userID I used for Oracle)
server=myserver (My target server in weblogic)
Password=********* (PW used in oracle)
If I change the configuration such that user=none & server=none, then I am getting the following error:
Cannot startup connection pool -ejbpool. Weblogic.common.ResourceException.
Any idea where I am going wrong??? Can any body suggest me the proper configuration and anything I should do with my classpath (I already have classes12.zip in my CP), etc.
Thanks in advance
-Manasvi