RE: Error getting pooled Oracle connection

[Kemp Randy-W18971]

You can create War files with Ant (jakarta.apache.org) and example Ant scripts are in 
the Orion CMP and Orion primers at www.jollem.com. 

-Original Message-
From: waheed_rahuman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 2:00 AM
To: Orion-Interest
Subject: Re: Error getting pooled Oracle connection


can any one please in creating war file please help for  creating a war file
regards
waheed


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

SV: Error getting pooled Oracle connection

[Magnus Rydin]

Title: SV: Error getting pooled Oracle connection





Check the docs or the spec or examples or this list.
It has been answered so many times you should get about 20 hits if you only looked it up in this list. :)
WR


> -Ursprungligt meddelande-
> Från: waheed_rahuman [mailto:[EMAIL PROTECTED]]
> Skickat: den 7 februari 2001 00:00
> Till: Orion-Interest
> Ämne: Re: Error getting pooled Oracle connection
> 
> 
> can any one please in creating war file please help for  
> creating a war file
> regards
> waheed
> 
> 
> _
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
> 
> 

Re: Error getting pooled Oracle connection

[waheed_rahuman]

can any one please in creating war file please help for  creating a war file
regards
waheed


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Re: Error getting pooled Oracle connection

[Robert Krueger]

At 22:36 06.02.2001 , you wrote:
>I would really appreciate it if someone could tell me where I am going 
>wrong here.  It is probably something very simple.  I'm just trying to get 
>a pooled Oracle connection.

there is some shared library missing for your OCI driver. if you're on a 
unix system check if your $ORACLE_HOME/lib is in the LD_LIBRARY_PATH your 
orion instance is using.

if this doesn't make sense to you, use the thin driver and you will be OK.

no orion problem just your local oracle client setup.

HTH

robert

>This is in my data-sources.xml:
>
>class="com.evermind.sql.DriverManagerDataSource"
>name="Oracle"
>location="jdbc/OracleCoreDS"
>xa-location="jdbc/xa/OracleXADS"
>ejb-location="jdbc/OracleDS"
>pooled-location="jdbc/OraclePooledDS"
>connection-driver="oracle.jdbc.driver.OracleDriver"
>username="store"
>password="store"
>url="jdbc:oracle:oci8:@jjh"
>inactivity-timeout="30"
>/>
>
>This is in my EJB:
>
>Context ctx = new InitialContext();
>DataSource dataSource = (DataSource)ctx.lookup("jdbc/OraclePooledDS");
>Connection con = dataSource.getConnection();
>Statement st = con.createStatement();
>ResultSet rs = st.executeQuery("select description from attribute_type");
>if (rs.next())
>  blah = rs.getString("description");
>st.close();
>con.close();
>
>
>And this is my error message, which occurs on the getConnection() call:
>
>javax.transaction.TransactionRolledbackException: 
>java.lang.UnsatisfiedLinkError
>: make_c_state
>at com.evermind.server.ejb.EJBUtils.getUserException(JAX)
>at 
> Customer_StatelessSessionBeanWrapper0.newCustomer(Customer_StatelessS
>essionBeanWrapper0.java:45)
>at __jspPage1_index_jsp._jspService(__jspPage1_index_jsp.java:54)
>at com.orionserver.http.OrionHttpJspPage.service(JAX)
>at com.evermind.server.http.HttpApplication.xj(JAX)
>at com.evermind.server.http.JSPServlet.service(JAX)
>at com.evermind.server.http.d3.sw(JAX)
>at com.evermind.server.http.d3.su(JAX)
>at com.evermind.server.http.ef.s1(JAX)
>at com.evermind.server.http.ef.do(JAX)
>at com.evermind.util.f.run(JAX)
>
>
>Please help! =)
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>

(-) Robert Krüger
(-) SIGNAL 7 Gesellschaft für Informationstechnologie mbH
(-) Brüder-Knauß-Str. 79 - 64285 Darmstadt,
(-) Tel: 06151 665401, Fax: 06151 665373
(-) [EMAIL PROTECTED], www.signal7.de

Error getting pooled Oracle connection

[James Halloran]

I would really appreciate it if someone could tell me where I am going wrong 
here.  It is probably something very simple.  I'm just trying to get a 
pooled Oracle connection.

This is in my data-sources.xml:



This is in my EJB:

Context ctx = new InitialContext();
DataSource dataSource = (DataSource)ctx.lookup("jdbc/OraclePooledDS");
Connection con = dataSource.getConnection();
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select description from attribute_type");
if (rs.next())
  blah = rs.getString("description");
st.close();
con.close();


And this is my error message, which occurs on the getConnection() call:

javax.transaction.TransactionRolledbackException: 
java.lang.UnsatisfiedLinkError
: make_c_state
at com.evermind.server.ejb.EJBUtils.getUserException(JAX)
at 
Customer_StatelessSessionBeanWrapper0.newCustomer(Customer_StatelessS
essionBeanWrapper0.java:45)
at __jspPage1_index_jsp._jspService(__jspPage1_index_jsp.java:54)
at com.orionserver.http.OrionHttpJspPage.service(JAX)
at com.evermind.server.http.HttpApplication.xj(JAX)
at com.evermind.server.http.JSPServlet.service(JAX)
at com.evermind.server.http.d3.sw(JAX)
at com.evermind.server.http.d3.su(JAX)
at com.evermind.server.http.ef.s1(JAX)
at com.evermind.server.http.ef.do(JAX)
at com.evermind.util.f.run(JAX)


Please help! =)
_
Get your FREE download of MSN Explorer at http://explorer.msn.com