Hi Sudhir,
Can't help you with this-this is security stuff with orion.
You can create a JSP using
your connection to Oracle to see if it is working. Add the following to your JSP.
<%
javax.naming.Context context = new javax.naming.InitialContext();
javax.sql.DataSource dataSource =
(javax.sql.DataSource) context.lookup("jdbc/OracleDS");
java.sql.Connection conn = dataSource.getConnection();
java.sql.Statement stmt = conn.createStatement();
java.sql.ResultSet rs = stmt.executeQuery("select table_name from user_tables");
while(rs.next()) {
out.println(rs.getString(1));
}
%>
Eric
"Sudhir A." wrote:
> Hi Thanks for your mail,
>
> I am bit new to EJB and trying my level best to run the sample applicaion. But
>i am geeting this error. Can you please help me with this one. Thanks in advance for
>your help.
>
> I am not getting the Driver exception any more. I am trying to run the examples. I
>have made changes to all the necessary changes. Even the table "myproduct" got
>correctly initialised in the database when i started the server. But when i am trying
>to run the
> application i am getting the following error.
>
> E:\ORION\demo\EJB\CART>java -classpath %Classpath%;../../../orion.jar;../../../e
> jb.jar;../../jndi.jar;e:/orion/demo/ejb/product ProductClient
>
> Communication error: Lookup error: java.lang.SecurityException: Invalid
> username/password
>
> ******************
> Just for reference, here is my "data-sources.xml" reference.
>
> <data-source
> name="Oracle Datasource"
> class="com.evermind.sql.ConnectionDataSource"
> location="jdbc/OracleDS"
> pooled-location="jdbc/DefaultPooledDS"
> xa-location="jdbc/xa/DefaultXADS"
> ejb-location="jdbc/DefaultEJBDS"
> url="jdbc:oracle:thin:@surya:1521:sid"
> connection-driver="oracle.jdbc.driver.OracleDriver"
> username="scott"
> password="tiger"
> schema="database-schemas/oracle.xml"
> />
> *******************
>
> Also i made changes server.xml and added these lines.
>
> <application name="ejbsamples" path="../demo/ejb" />
>
> Do i need to make any more changes or is there any other place i need to specify
>User Name and Password.
>
> Thanks
> sudhir
>
> --- Eric Richardson <[EMAIL PROTECTED]>
> > wrote:
> >Here you are!
> >Eric :-)
> >
> ><data-source
> > name="Oracle Datasource"
> > class="com.evermind.sql.ConnectionDataSource"
> > location="jdbc/OracleDS"
> > pooled-location="jdbc/DefaultPooledDS"
> > xa-location="jdbc/xa/DefaultXADS"
> > ejb-location="jdbc/DefaultEJBDS"
> > url="jdbc:oracle:thin:@host:1521:sid"
> > connection-driver="oracle.jdbc.driver.OracleDriver"
> > username="user"
> > password="pass"
> > />
> >"Sudhir A." wrote:
> >
> >> Hi,
> >> Is there any one who could successfully setup the data source using oracle 8.1
> >>
> >> with the latest version of Orion?
> >>
> >> Please post the Data Source String if possible?
> >>
> >> Thanks
> >> Sudhir
> >>
> >> _____________________________________________________________
> >> Get email for your site ---> http://webmail.bharathexpress.com
>
> _____________________________________________________________
> Get email for your site ---> http://webmail.bharathexpress.com