Thanks everybody for helping me with this problems. It works now! However, I
could not have the jsp example code work! Could someone send me a jsp code
just for the purpose of testing the connection between Orion and Oracle?
Thanks!
Roland
-Original Message-
From: [EMAIL PROTECTED
Try following code in your .jsp file:
InitialContext ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("jdbc/Oracle");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM dual");
while( rs.next() ){
Hi,
Just copy classes12.zip (Oracle jdbc driver) in your
orion/lib directory - just alongside HypersonicSQL
driver hsql.jar...
In Orion/config/data-sources.xml u can setup the
DataSource lookup along with the url,database name usr
and pwd and instance of the database u ref etc...
Post if u
Add the jar/zip to the orion lib folder.
On Fri, 23 Mar 2001, Roland Dong wrote:
I tried to run oracl with orion. When I started orion I got the following
error message:
Error initializing server: DriverManagerDataSource driver
'oracle.jdbc.driver.OracleDriver' not found. Where is
I tried to run oracl with orion. When I started orion I got the following
error message:
Error initializing server: DriverManagerDataSource driver
'oracle.jdbc.driver.OracleDriver' not found. Where is driver supposed to
be located? I have set the environment so that the class12.zip is
Of Roland Dong
Sent: Friday, March 23, 2001 10:10 PM
To: Orion-Interest
Subject: problem running oracle with orion:
'oracle.jdbc.driver.OracleDriver' not found!
I tried to run oracl with orion. When I started orion I got the following
error message:
Error initializing server
the file is classes12.zip and should be in the orion/lib
SnowWolf
-Original Message-
From: Roland Dong [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 24, 2001 1:10 AM
To: Orion-Interest
Subject: problem running oracle with orion:
'oracle.jdbc.driver.OracleDriver' not found!
I
, 2000 7:15 PMTo:
Orion-InterestSubject: Oracle on OrionHey,
Has anybody been successful in deploying EJBs on Orion to an Oracle
database? I'm having trouble getting Orion to auto create tables in
Oracle. It seems to skip certain table names in the ejb-jar.xml file I
use. The tables
Hi!
Is there any error message during deploy? Orion stops the
auto-creation process if there is any SQLException.
I also found that Orion don't create tables for beans that where
already deployed, even if you drop them.
--
Best regards,
Rafaelmailto:[EMAIL
Thanks for the reply,
We figured out the problem. What was wrong was this:
1) It initially created the all tables(only a few were in the XML file)
a week or so ago under a test
username/password we were using
2) We then created our own username/password and granted it certain
privileges(we
Hello Eric,
1 . Somewhere in the past some man wrote to remove deactivated="true"
from from config/principals.xml:
...
user username="xxx" password="yyy" deactivated="true"
...
2. Next check in jndi.properties to user and password are the same are in
principals.xml
run the PruductClient
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 =
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"
13 matches
Mail list logo