I'm using wls 6.1 and trying to create an connection pool to an oracle 8i
database using weblogic.jdbc.oci.Driver. I've read over the document and I
think that my classpath and path are fine in the startup script. Does
anyone know how to resolve this problem. Below are parts of my startup
script and error.
Here what i'm entering for my connetion pool.
url: jdbc:weblogic:oracle:@****:****:dev1
Driver class weblogic.jdbc.oci.Driver
Properties user=****
password=****
dll=weblogicoci37
Start Script
set PATH=%ORACLE_HOME%\bin;%WL_HOME%\bin\oci817_8\;.\bin;%PATH%
set
CLASSPATH=.;.\lib\weblogic_sp.jar;.\lib\weblogic.jar;%WL_HOME%\oracle\classe
s;.\lib\ejb20_DemoADLSCEntities.jar;%TL40CLASSES%
Error
Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: ORA-24327: need explicit attach before authenticating
a user - (******/********@@******:*****:dev1)
at weblogic.db.oci.OciConnection.getLDAException(OciConnection.java:164)
at weblogic.jdbc.oci.Driver.connect(Driver.java:112)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(Connection
EnvFactory.java:193)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connection
EnvFactory.java:134)
at
weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.j
ava:698)
at weblogic.common.internal.ResourceAllocator.(ResourceAllocator.java:282)
at
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:623
)
at weblogic.jdbc.common.JDBCService.addDeployment(JDBCService.java:107)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
arget.java:329)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
arget.java:144)
at java.lang.reflect.Method.invoke(Native Method)
at
weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
.java:636)
at
weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:6
21)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
nImpl.java:359)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1555)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at
weblogic.management.internal.ConfigurationMBeanImpl.updateConfigMBeans(Confi
gurationMBeanImpl.java:491)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
nImpl.java:361)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1555)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:468)
thanks
Mike
DEV1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = conradb)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dev1)
)
)
Here's my connection pool info
url jdbc:weblogic:oracle:@conradb:1521:dev1
driver weblogic.jdbc.oci.Driver
properties user=*****
password=*****
dll=weblogicoci37
I checked the ORACLE_HOME and its set correctly. Here's the rest of my
startweblogic.cmd
set JAVA_HOME=d:\jdk1.3.1
set ORACLE_HOME=d:\oracle\ora81
set WL_HOME=D:\bea\wlserver6.1
set
PATH=%ORACLE_HOME%\bin;%WL_HOME%\bin\oci817_8\weblogicoci37.dll;.\bin;%PATH%
set
TL40CLASSES=D:\WebGain\TopLink4.0\WDI_J\Classes\wdiall.jar;D:\WebGain\TopLin
k4.0\WDI_J\Classes\xerces.jar;D:\WebGain\TopLink4.0\WDI_J\Classes\wdisdkxerc
es.jar;D:\WebGain\TopLink4.0\WDI_WLS\Classes\wdiwlsx.jar
set
CLASSPATH=.;.\lib\weblogic_sp.jar;.\lib\weblogic.jar;%WL_HOME%\oracle\classe
s;..\lib\ejb20_DemoADLSCEntities.jar;%TL40CLASSES%
set CLASSPATH=%CLASSPATH%;.\lib\jaxm-api.jar
set CLASSPATH=%CLASSPATH%;.\lib\jaxm-client.jar
set CLASSPATH=%CLASSPATH%;.\lib\log4j.jar
set CLASSPATH=%CLASSPATH%;.\lib\commons-logging.jar
I can create a pool fine with oracle thin and weblogic thin
thanks for the help
"Joseph Weinstein" <j...@bea.com> wrote in message
news:3CFF99A8...@bea.com...
Mike wrote:
> Here is my tsnnams
>
> DEV1 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = conradb)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = dev1)
> )
> )
>
Sure, Ok. Try this:
URL: jdbc:weblogic:oracle
driver: weblogic.jdbc.oci.Driver
properties: user=*****
password=*****
server=DEV1
dll isn't a used property with our driver, and we find the machine and port via the tnsnames
file (OCI does), so that stuff in your original URL doesn't help our driver.
Let me know,
Joe
weblogic.common.ResourceException: weblogic.common.ResourceException:
Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: System.loadLibrary(weblogicoci37) threw
java.lang.UnsatisfiedLinkError: no weblogicoci37 in java.library.path
at weblogic.jdbc.oci.Driver.loadLibraryIfNeeded(Driver.java:226)
at weblogic.jdbc.oci.Driver.connect(Driver.java:76)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(Connection
EnvFactory.java:193)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connection
EnvFactory.java:134)
So I knew that it wasn't finding the dll. I looked in my startweblogic.cmd
and changed
PATH=%ORACLE_HOME%\bin;%WL_HOME%\bin\oci817_8\weblogicoci37.dll;.\bin;%PATH%
to
PATH=%ORACLE_HOME%\bin;%WL_HOME%\bin\;.\bin;%PATH%
and it works fine now. I also had a problem with my system path and that
caused weblogic to look in oracle\jdbc\lib for the dll, but that was easly
fixed.
Thanks you really helped me out
Mike
)"Joseph Weinstein" <j...@bea.com> wrote in message
news:3CFFCDAC...@bea.com...
> Tried what you suggested and got the following error.
>
> weblogic.common.ResourceException: weblogic.common.ResourceException:
> Could not create pool connection. The DBMS driver exception was:
> java.lang.UnsatisfiedLinkError: no weblogicoci37 in java.library.path
>
> So I knew that it wasn't finding the dll. I looked in my startweblogic.cmd
> and changed
>
> PATH=%ORACLE_HOME%\bin;%WL_HOME%\bin\oci817_8\weblogicoci37.dll;.\bin;%PATH%
> to
> PATH=%ORACLE_HOME%\bin;%WL_HOME%\bin\;.\bin;%PATH%
>
> and it works fine now. I also had a problem with my system path and that
> caused weblogic to look in oracle\jdbc\lib for the dll, but that was easly
> fixed. Thanks you really helped me out
> Mike
:-)
Joe