I get a ClassCastException:

java.lang.ClassCastException:
org.apache.commons.dbcp.DelegatingCallableStatement cannot be cast to
oracle.jdbc.OracleCallableStatement

because openejb is not loading the oracle driver as described in
openejb.xml:

<Resource id="JUSERDS" type="DataSource">
  JdbcDriver oracle.jdbc.OracleDriver
  JdbcUrl jdbc:oracle:thin:@naxtest01:1523:SMST
  UserName xxxx
  Password yyyy
  JtaManaged true
</Resource>

java source ----------------------------------

   @Resource(name = "JUSERDS")
   private DataSource _ds;
   ...
   ...
   @PostConstruct
   void init() {
           _logger.debug("init DataSource=" + _ds);
           _dao = new CompanyDao(_ds);
   }

log output on above line:
2009-01-21 14:11:55,095 [http-8080-1] DEBUG com.bmi.sms.ejb.company.Company 
- init datasource=org.apache.openejb.resource.jdbc.basicdatasou...@82f392

I'm fetching an Oracle Cursor, so I need to cast the Statement.  
Thanks.

-Henry Retter
-- 
View this message in context: 
http://www.nabble.com/DataSource-problem-tp21591543p21591543.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Reply via email to