depends on what version of oracle you are running :)
the directory names are fairly "intuitive" and if you are running Oracle 8i
(any release) use oci815_8
Filip
~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net
> -----Original Message-----
> From: A mailing list for Enterprise JavaBeans development
> [mailto:[EMAIL PROTECTED]]On Behalf Of Ramesh, Kesav
> Sent: Friday, March 30, 2001 3:25 AM
> To: [EMAIL PROTECTED]
> 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".
>
>
===========================================================================
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".
