Or I usually put the oracle drivers in JAVA_HOME/jre/lib/ext
Not sure of the technical differences between the two approaches, though.
-joel
----- Original Message -----
From: "Al Fogleson" <[EMAIL PROTECTED]>
To: "Orion-Interest" <[EMAIL PROTECTED]>
Sent: Thursday, October 19, 1995 2:29 PM
Subject: Re: Help with getting Orion to talke to Oracle.
> You need to copy the oracle drivers into your orion/lib directory I
actually
> unzipped the classes111.zip there myself.
>
> Al
>
> ----- Original Message -----
> From: "J Davis" <[EMAIL PROTECTED]>
> To: "Orion-Interest" <[EMAIL PROTECTED]>
> Sent: Thursday, October 19, 2000 1:43 PM
> Subject: Help with getting Orion to talke to Oracle.
>
>
> > I have been pulling my hair out trying to get oracle and orion to talk
to
> > each other. I am sure it is a simple error, but I can't seem to find
it.
> > Here is my problem:
> >
> > I have installed orion 1.3.8 on a Windows 2000 server with jdk1.2.2,
> > j2ee1.2.1, jre1.2.2 and oracle8idrivers12_01.zip.
> >
> > I copied the tools.jar from the jdk into the c:\orion dir.
> >
> > I have taken the time to set the following ENV variables based off some
> > earlier messages:
> >
> > J2EE_CLASSPATH=c:\orion\lib\oracle8idrivers12_01.zip
> > J2EE_HOME=c:\j2ee
> > JAVA_HOME=c:\jdk
> > PATH=(Original path);c:\jdk
> >
> > I tried exploding the oracle drivers in the orion/lib dir as well as the
> > jre/lib/ext dir.
> >
> > I tried adding the oracle zip file to the library tag in the
> application.xml
> > like so:
> >
> > <library path="../lib/oracle8idrivers12_01.zip;../lib" />
> >
> > I setup the data-source file like so:
> >
> > <data-source
> > class="com.evermind.sql.ConnectionDataSource"
> > name="Oracle VND Driver"
> > location="jdbc/vndCoreDS"
> > pooled-location="jdbc/vndPooledDS"
> > xa-location="jdbc/xa/vndXADS"
> > ejb-location="jdbc/vndDS"
> > connection-driver="oracle.jdbc.driver.OracleDriver"
> > username="login"
> > password="pass"
> > schema="./database-schemas/oracle.xml"
> > url="jdbc:oracle:thin:@machine:1521:sid"
> > inactivity-timeout="120"
> > />
> >
> > I built a simple class that looks like this to run from a remote
machine:
> >
> > import java.sql.*;
> > import javax.ejb.*;
> > import javax.sql.DataSource;
> > import javax.naming.*;
> > import com.micronpc.db.*;
> >
> > public class TestConn
> > {
> > Context jndiContext;
> >
> > public TestConn()
> > {
> > try
> > {
> > jndiContext = new InitialContext();
> > DataSource ds =
(DataSource)jndiContext.lookup("jdbc/vndPooledDS");
> > Connection conn = ds.getConnection();
> > Statement s = conn.createStatement();
> > String sql = "SELECT * from adv_sub_family_type";
> > ResultSet rs = s.executeQuery(sql);
> > while(rs != null && rs.next())
> > {
> > System.out.println("Record:" + rs.getString(1));
> > }
> > }
> > catch(Exception e)
> > {
> > System.out.println("Got this exception:" + e.getMessage());
> > e.printStackTrace();
> > }
> > }
> >
> > public static void main(String[] args)
> > {
> > TestConn testConn1 = new TestConn();
> > }
> > }
> >
> > My application-client.xml in the META-INF looks like this(although I am
> not
> > trying to use any of these objects yet.):
> >
> > <?xml version="1.0"?>
> > <!DOCTYPE application-client PUBLIC "-//Sun Microsystems, Inc.//DTD J2EE
> > Application Client 1.2//EN"
> > "http://java.sun.com/j2ee/dtds/application-client_1_2.dtd">
> > <application-client>
> > <ejb-ref>
> > <ejb-ref-name>QuoteEntity</ejb-ref-name>
> > <ejb-ref-type>Entity</ejb-ref-type>
> > <home>com.micronpc.api.configurator.QuoteEntityHome</home>
> >
> > <remote>com.micronpc.api.configurator.QuoteEntityRemote</remote>
> > </ejb-ref>
> > <ejb-ref>
> > <ejb-ref-name>ModelQuoteEntity</ejb-ref-name>
> > <ejb-ref-type>Entity</ejb-ref-type>
> >
> > <home>com.micronpc.api.configurator.ModelQuoteEntityHome</home>
> >
> > <remote>com.micronpc.api.configurator.ModelQuoteEntityRemote</remote>
> > </ejb-ref>
> > <ejb-ref>
> > <ejb-ref-name>ProfileEntity</ejb-ref-name>
> > <ejb-ref-type>Entity</ejb-ref-type>
> > <home>com.micronpc.api.configurator.ProfileEntityHome</home>
> >
> > <remote>com.micronpc.api.configurator.ProfileEntityRemote</remote>
> > </ejb-ref>
> > </application-client>
> >
> > my jndi.properties looks like this:
> >
> >
>
java.naming.factory.initial=com.evermind.server.ApplicationClientInitialCont
> > extFactory
> > java.naming.provider.url=ormi://ejbtestbox/micron
> > java.naming.security.principal=admin
> > java.naming.security.credentials=123
> >
> > my principales file looke like this:
> >
> > <?xml version="1.0"?>
> > <!DOCTYPE principals PUBLIC "//Evermind - Orion Principals//"
> > "http://www.orionserver.com/dtds/principals.dtd">
> >
> > <principals>
> > <groups>
> > <group name="administrators">
> > <description>administrators</description>
> > <permission name="administration" />
> > <permission
> > name="com.evermind.server.AdministrationPermission" />
> > </group>
> > <group name="guests">
> > <description>guests</description>
> > </group>
> > <group name="users">
> > <description>users</description>
> > <permission name="rmi:login" />
> > <permission
> > name="com.evermind.server.rmi.RMIPermission" />
> > </group>
> > </groups>
> > <users>
> > <user username="admin" password="123">
> > <description>The default administrator</description>
> > <group-membership group="administrators" />
> > <group-membership group="guests" />
> > <group-membership group="users" />
> > </user>
> > <user username="user" password="456">
> > <description>The default user</description>
> > <group-membership group="guests" />
> > <group-membership group="users" />
> > </user>
> > <user username="anonymous" password="">
> > <description>The default guest/anonyomous
> > user</description>
> > <group-membership group="guests" />
> > </user>
> > </users>
> > </principals>
> >
> > if I try to make a connection with a standalone app on the machine it
> works
> > fine. If I try to go through orion I get the following errors.
> >
> > if I try it as vndPooledDS or vndCoreDS I get the following error:
> >
> > Got this exception:No suitable driver java.sql.SQLException: No suitable
> > driver at java.sql.DriverManager.getConnection(DriverManager.java:477)
> > at java.sql.DriverManager.getConnection(DriverManager.java:137) at
> > com.evermind.sql.DriverManagerDataSource.getConnection(JAX) at
> >
>
com.evermind.sql.DriverManagerConnectionPoolDataSource.getPooledConnection(J
> > AX) at com.evermind.sql.OrionPooledDataSource.eh(JAX) at
> > com.evermind.sql.OrionPooledDataSource.d3(JAX, Compiled Code) at
> > com.evermind.sql.OrionPooledDataSource.getConnection(JAX, Compiled Code)
> > at TestConn.<init>(TestConn.java, Compiled Code) at
> > TestConn.main(TestConn.java:44)
> >
> > if I try it as vndDS I get the following error:
> >
> > Got this exception:null java.lang.NullPointerException at
> > com.evermind.sql.OrionPooledDataSource.d2(JAX, Compiled Code) at
> > com.evermind.sql.OrionPooledDataSource.d3(JAX, Compiled Code) at
> > com.evermind.sql.ai.ek(JAX) at com.evermind.sql.ai.em(JAX) at
> > com.evermind.sql.an.createStatement(JAX) at
> > TestConn.<init>(TestConn.java, Compiled Code) at
> > TestConn.main(TestConn.java:44)
> >
> > These exceptions were thrown running the client app from a remote
machine.
> > I also tried the same app on the same machine with a seperate VM.
either
> > way they boh fail the same. I EJBs I have written that worked well in
JRUN
> > now fail when they try to get a connection.
> >
> > I realize it must be something simple but I have run out of ideas. Any
> > clues?
> >
> >
> > Thanx
> >
> > Greg
> >
> >
> >
>
>
>
