Connecting to Oracle from weblogic6.1

Hi 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

[986 byte] By [nmhb23] at [2007-9-19]

«« !!!Pl. Help Me!!! illegal Operation when trying 2 compile
»» jaxp fails to unmarshall xml document if it contaions the "&" character

# 1

u have to set the path of ur oracle driver in the claspath variable.Hope u r doin that.RegardsChatni

Chatni at 2007-7-5 >

top of java,Enterprise & Remote Computing,Enterprise Technologies...

# 2

I haven't used WebLogic but isn't the server name supposed to be in the folloing form?jdbc:oracle:thin:@youroraclesvr:1521:youroracleSIDI assume you are using the thin driver.

sunil_patel at 2007-7-5 >

# 3

Thanks for UR replies!I got it working now...after removing the server value from my configuration.-Manasvi

nmhb23 at 2007-7-5 >

# 4

I think , you need to use valid driver of Oracle at directory "/Oracle home/Jdbc" .

truongktsn at 2007-7-5 >

# 5

If you are using THIN driver ,specify server name or ip address in the URL. If you are using NATIVE driver specify "TNS Name"

satishpatil at 2007-7-5 >

# 6

Hello

You specified server=myserver . I think here you have to give ur oracle server name. That's why that error comes. When u r using thin clients then you have to specified ur oracle server name as well as database name also in URL .

I also got the similar problem.

If you got the solution then pls mail me back.

anirudhkumar at 2007-7-5 >

# 7

Try this, this should workDriver - oracle.jdbc.driver.OracleDriverURL- jdbc:oracle:thin:@IP Address:ORACLE_SID

vinoth at 2007-7-5 >

Codefund.Com Java Programmer Resources including(FAQ) Tutorial based around objectives, Mock Exam, Demo Applets illustrating language points, created by a Sun Certified Java Programmer.

Connecting to Oracle from weblogic6.1

Enterprise & Remote Computing Hot Topic

Enterprise & Remote Computing

Site Classified