Hi Ramesh ,
I chose oci815_8...logically even others should work ...the driver name i
give during configuration is "weblogic.jdbc.oci.Driver" ...i am a beginner
...not aware of things in much detail so conceptually i know little as in
how drivers work ....but just copy the dll from the above mentioned
directory to weblogic\bin so that u dont to have separately configure ur
path ...
regards
Vinodh
"Ramesh, Kesav" <[EMAIL PROTECTED]>@java.sun.com> on 03/30/2001 04:55:17
PM
Please respond to A mailing list for Enterprise JavaBeans development
<[EMAIL PROTECTED]>
Sent by: A mailing list for Enterprise JavaBeans development
<[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: problem connecting oracle with ejb
Hi i have dll in 4 folders under bin
oci734_7
oci805_7
oci805_8
oci815_8
whihc one should i set up in the path
Regards
Ramesh Kesavanarayanan
Electronic Data Systems
Steeple Reach,
25, Cathedral Road,
A SEI-CMM® Level-3 Organization
91-44-811 3801 to 15 ext :2186
91-44-233 0380 (res)
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Don't be too good I will miss you.
Don't be too caring, I might like you.
Don't be too sweet, I might fall
-----Original Message-----
From: Johann Hackl [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 2:39 PM
To: [EMAIL PROTECTED]
Subject: AW: problem connecting oracle with ejb
Hi,
<Vendor>
you have additionally to set your path and include the directory where the
weblogicoci36.dll
is stored ( usually in %WL_HOME%\bin\%oracle_version% ) before starting
WebLogic.
e.g. set PATH=%PATH%;c:\bea\wlserver6.0\bin\oci816_7
</Vendor>
Because library - path means on Windows - Machines "PATH" and on unix -
machines
"LD_LIBRARY_PATH", but not classpath.
Regards,
Johann
> -----Ursprüngliche Nachricht-----
> Von: Ramesh, Kesav [SMTP:[EMAIL PROTECTED]]
> Gesendet am: Freitag, 30. März 2001 10:31
> An: [EMAIL PROTECTED]
> Betreff: problem connecting oracle with ejb
>
> here is what the error i get when i try to connect to a oracle database
> with
> my ejb. can any one let me know what might be the problem .
>
> FYI i have set up the classpath in setenv.bat to the path of my oracle
> driver
>
>
> Thu Mar 30 14:03:16 GMT+05:30 2000:<I> <JDBC Pool> Creating connection
> pool
> demo
> Pool with:
> {refreshMinutes=10, poolName=demoPool, loginDelaySecs=1, testTable=dual,
> maxCapacity=10, props=user=etcd;password=etcd;server=INFOREP,
> allowShrinking=true, driver=weblogic.jdbc.oci.Driver,
> aclName=weblogic.jdbc.connectionPool.demoPool, capacityIncrement=2,
> initialCapacity=4, url=jdbc:weblogic:oracle, shrinkPeriodMins=15}
> Delaying 1 seconds before making a demoPool pool connection.
> 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(Connecti
> on
> EnvFactory.java:149)
> at
>
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connecti
> on
> EnvFactory.java:109)
> at
>
weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator
> .j
> ava, Compiled Code)
> at
> weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java,
> Compiled Code)
> at
>
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:3
> 30
> )
> at
weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java,
> Compiled Code)
> at
> weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:200)
> 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 Code)
> at
> weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
> Thu Mar 30 14:03:17 GMT+05:30 2000:<I> <JDBC Pool> Sleeping in
> createResource()
> Thu Mar 30 14:03:18 GMT+05:30 2000:<E> <JDBC Pool> Failed to create
> connection pool "demoPool"
> 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 java.sql.DriverManager.getConnection(DriverManager.java:457)
> at java.sql.DriverManager.getConnection(DriverManager.java:137)
> at
>
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(Connecti
> on
> EnvFactory.java:172)
> at
>
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connecti
> on
> EnvFactory.java:109)
> at
>
weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator
> .j
> ava, Compiled Code)
> at
> weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java,
> Compiled Code)
> at
>
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:3
> 30
> )
> at
weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java,
> Compiled Code)
> at
> weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:200)
> 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 Code)
> at
> weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
> at
>
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(Connecti
> on
> EnvFactory.java:182)
> at
>
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connecti
> on
> EnvFactory.java:109)
> at
>
weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator
> .j
> ava, Compiled Code)
> at
> weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java,
> Compiled Code)
> at
>
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:3
> 30
> )
> at
weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java,
> Compiled Code)
> at
> weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:200)
> 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 Code)
> at
> weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
> at
>
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connecti
> on
> EnvFactory.java:125)
> at
>
weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator
> .j
> ava, Compiled Code)
> at
> weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java,
> Compiled Code)
> at
>
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:3
> 30
> )
> at
weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java,
> Compiled Code)
> at
> weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:200)
> 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 Code)
> at
> weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
>
> Thu Mar 30 14:03:18 GMT+05:30 2000:<I> <JMS> Beginning startup process
> Thu Mar 30 14:03:18 GMT+05:30 2000:<I> <JMS> Init JMS Security
> Thu Mar 30 14:03:18 GMT+05:30 2000:<I> <JMS> Initializing from
> weblogic.properties
> Thu Mar 30 14:03:19 GMT+05:30 2000:<I> <JMS> Startup process complete.
JMS
> is active
> Thu Mar 30 14:03:19 GMT+05:30 2000:<I> <JMS> Bound SessionPoolManager as
> weblogic.jms.SessionPoolManager
> Thu Mar 30 14:03:19 GMT+05:30 2000:<I> <JMS> Bound
> ConnectionConsumerManager
> as weblogic.jms.ConnectionConsumerManager
> Thu Mar 30 14:03:19 GMT+05:30 2000:<I> <WebLogicServer> Invoking
> main-style
> startup RMI Registry weblogic.rmi.internal.RegistryImpl
> Thu Mar 30 14:03:19 GMT+05:30 2000:<I> <RMI> Registry started
> Thu Mar 30 14:03:19 GMT+05:30 2000:<I> <EJB> Enterprise JavaBeans
> initializing
> -----------------found
> Thu Mar 30 14:03:22 GMT+05:30 2000:<E> <EJB> Could not deploy:
> 'e:/weblogic/myserver/shipdemo.jar'
> Possible reasons include:
> 1. The bean or an interface class has been modified but
> the deployment descriptor has not been updated
> 2. The database mappings in the deployment descriptor do not
> match the database definition
> 3. The jar file is not a valid jar file
> 4. The jar file does not contain a valid bean
> weblogic.ejb.common.DeploymentException: Could not setup the persistence
> store for this bean.; nested exception is:
> weblogic.cmp.rdbms.ConnectionPoolException: Could not open
> connection pool named 'demoPool'. Cannot deploy CMP Entity Bean.
> weblogic.cmp.rdbms.ConnectionPoolException: Could not open connection
pool
> named 'demoPool'. Cannot deploy CMP Entity Bean.
> at
> weblogic.cmp.rdbms.PSRdbms_Base.columnIsInTable(PSRdbms_Base.java:260)
> at
>
weblogic.cmp.rdbms.PSRdbms_Base.columnsAreInTable(PSRdbms_Base.java,Compil
> ed
> Code)
> at
> weblogic.cmp.rdbms.PSRdbms_Base.baseSetup(PSRdbms_Base.java:112)
> at
>
com.titan.ship.ShipPSWebLogic_CMP_RDBMS.setup(ShipPSWebLogic_CMP_RDBMS.jav
> a:
> 117)
> at
>
com.titan.ship.ShipPSWebLogic_CMP_RDBMS.setup(ShipPSWebLogic_CMP_RDBMS.jav
> a:
> 104)
> at
>
weblogic.ejb.internal.StatefulEJBHome.initializeEntityEjbStore(StatefulEJB
> Ho
> me.java:456)
> at
> weblogic.ejb.internal.StatefulEJBHome.setup(StatefulEJBHome.java:290)
>
> at weblogic.ejb.internal.EJBHomeImpl.setup(EJBHomeImpl.java:600)
> at
>
weblogic.ejb.internal.EJBDeploymentImpl.setupBeanHome(EJBDeploymentImpl.ja
> va
> :576)
> at
>
weblogic.ejb.internal.EJBDeploymentImpl.deployBeans(EJBDeploymentImpl.java
> ,
> Compiled Code)
> at
>
weblogic.ejb.internal.EJBDeploymentImpl.deploy(EJBDeploymentImpl.java:335)
> at
> weblogic.ejb.internal.EJBJarDeployment.deploy(EJBJarDeployment.java:231)
> at
> weblogic.ejb.internal.EJBManagerImpl.deploy(EJBManagerImpl.java,
> Compiled Code)
> at
> weblogic.ejb.internal.EJBManagerImpl.deployNew(EJBManagerImpl.java:352)
> at
> weblogic.ejb.internal.EJBManagerImpl.deploy(EJBManagerImpl.java:319)
> at
> weblogic.ejb.internal.EJBManagerImpl.deployBeans(EJBManagerImpl.java,
> Compiled Code)
> at
> weblogic.ejb.internal.EJBManagerImpl.<init>(EJBManagerImpl.java:242)
> at weblogic.t3.srvr.T3Srvr.start(T3Srvr.java, Compiled Code)
> at weblogic.t3.srvr.T3Srvr.main(T3Srvr.java:825)
> at java.lang.reflect.Method.invoke(Native Method)
> at weblogic.Server.startServerDynamically(Server.java:99)
> at weblogic.Server.main(Server.java:65)
> at weblogic.Server.main(Server.java:55)
> at weblogic.NTServiceHelper.run(NTServiceHelper.java:19)
> at java.lang.Thread.run(Thread.java:479)
>
> Thu Mar 30 14:03:22 GMT+05:30 2000:<I> <EJB> 0 EJB jar files loaded,
> containing
> 0 EJBs
> Thu Mar 30 14:03:22 GMT+05:30 2000:<I> <EJB> 0 deployed, 0 failed to
> deploy.
> Thu Mar 30 14:03:23 GMT+05:30 2000:<I> <ZAC> ZAC ACLs initialized
> Thu Mar 30 14:03:23 GMT+05:30 2000:<I> <ZAC> ZAC packages stored in local
> direct
> ory exports
> Thu Mar 30 14:03:23 GMT+05:30 2000:<I> <ListenThread> Listening on port:
> 7001
>
> <NT Performance Pack> NATIVE: created IoCompletionPort successfully.
> IoPort=0x00
> 0001c0
> Thu Mar 30 14:03:24 GMT+05:30 2000:<I> <WebLogicServer> WebLogic Server
> started
> Regards
>
> Ramesh Kesavanarayanan
>
> Electronic Data Systems
> Steeple Reach,
> 25, Cathedral Road,
> A SEI-CMM® Level-3 Organization
> 91-44-811 3801 to 15 ext :2186
> 91-44-233 0380 (res)
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> Don't be too good I will miss you.Don't be too caring, I might like you.
> Don't be too sweet, I might fall
>
>
==========================================================================
> =
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
----------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
