• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Mapping Oracle

 
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
Any one tried mapping oracle with Weblogic server. I tried to change this way in the weblogic.properties file.
weblogic.jdbc.connectionPool.oraclePool=\
url=jdbc:weblogic racle,\
driver=weblogic.jdbc.oci.Driver,\
loginDelaySecs=1,\
initialCapacity=4,\
maxCapacity=10,\
capacityIncrement=2,\
allowShrinking=true,\
shrinkPeriodMins=15,\
refreshMinutes=10,\
testTable=dual,\
props=user=weblogic;password=weblogic;server=bhavani

Am using oracle8i Release 2. and weblogic 5.1
when i start the server it throws,
weblogic.common.ResourceException: weblogic.common.ResourceException:
Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: System.loadLibrary threw java.lang.UnsatisfiedLinkError
with the message 'no weblogicoci36 in java.library.path'.
at weblogic.jdbcbase.oci.Driver.connect(Driver.java:116)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(Con
nectionEnvFactory.java:146)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Con
nectionEnvFactory.java:108)
at weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllo
cator.java, Compiled Code)
at weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.j
ava, Compiled Code)
at weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.j
ava:330)
at weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java, Compi
led Code)
at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:220)
at weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
at weblogic.t3.srvr.StartupThread.doWork(StartupThread.java, Compiled Co
de)
at weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java
:62)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(Con
nectionEnvFactory.java:154)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Con
nectionEnvFactory.java:108)
at weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllo
cator.java, Compiled Code)
at weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.j
ava, Compiled Code)
at weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.j
ava:330)
at weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java, Compi
led Code)
at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:220)
at weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
at weblogic.t3.srvr.StartupThread.doWork(StartupThread.java, Compiled Co
de)
at weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java
:62)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Con
nectionEnvFactory.java:124)
at weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllo
cator.java, Compiled Code)
at weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.j
ava, Compiled Code)
at weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.j
ava:330)
at weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java, Compi
led Code)
at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:220)
at weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
at weblogic.t3.srvr.StartupThread.doWork(StartupThread.java, Compiled Co
de)
at weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java
:62)

plzz help. It is very basic problem, but struck with classpath stuff.

Bhavani
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hope this helps.In the WEBLOGCI|BIN folder you have 4 other folders which could be mapped to diffrent Oracle versions.
in that select the OCI version you have copy the DLL to the relevent database bin foldr.
 
Ranch Hand
Posts: 1871
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Indika_Maligaspe,
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please log in with a new name which meets the requirements.
In the simplest of terms you may have to remove the underscore in the present name.
Thanks.
 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi ,
if u r trying to map bea weblogic with oracle , u need to append the follwing to ur PATH .
c:\bea\wlserver6.0\bin\oci816_8;
c:\ORANT816\bin
also in the url u need to mention the oracle service name i.e
URL=jdbc:weblogic racle:bhavani(in ur case)
where bhavani is the service name of the oracle 8i server.
 
It wasn't my idea to go to some crazy nightclub in the middle of nowhere. I just wanted to stay home and cuddle with this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic