[JBoss-user] problem calling stored procs using pooled connection in oracle

chandra poluru Wed, 28 Mar 2001 03:54:26 -0800

iam using oracle8i as backend database.

i created pooled connection "OracleDb" in jboss2.1

changes in jcml:

<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=OracleDb">
   <attribute name="PoolName">OracleDb</attribute>
   <attribute name="DataSourceClass">oracle.jdbc.xa.client.OracleXADataSource</attribute>
   <attribute name="Properties"></attribute>
   <attribute name="URL">jdbc:oracle:thin:@b2bdevlop:1521:b2b</attribute>
   <attribute name="GCMinIdleTime">1200000</attribute>
   <attribute name="JDBCUser">temp</attribute>
   <attribute name="Password">temp</attribute>
   <attribute name="MaxSize">10</attribute>
   <attribute name="GCEnabled">false</attribute>
   <attribute name="InvalidateOnError">false</attribute>
   <attribute name="TimestampUsed">false</attribute>
   <attribute name="Blocking">true</attribute>
   <attribute name="GCInterval">120000</attribute>
   <attribute name="IdleTimeout">1800000</attribute>
   <attribute name="IdleTimeoutEnabled">false</attribute>
   <attribute name="LoggingEnabled">false</attribute>
   <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
   <attribute name="MinSize">0</attribute>
</mbean>

changes in conf:

got the OracleDb started line at the console while starting the jboss.

but iam trying to access the pooled connection in an entity bean by using the following code:

InitialContext ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup(dbname);
Connection con=ds.getConnection();

iam able to get the connection.

after that iam trying to call one stored procedure in oracle8i which is in a package called Barter as

CallableStatement cst=con.prepareCall("{call Barter.checkloginidsp(?,?)}");
     cst.setString(1,loginid);
     cst.registerOutParameter(2,OracleTypes.CURSOR);
     cst.execute();
                 rs=(ResultSet )cst.getObject(2);

there iam getting SQLException:

java.sql.SQLException: This function is not supported .

how to solve this problem.i think iam not getting the OracleConnection

pl. suggest any solution.

----chandra

[JBoss-user] problem calling stored procs using pooled connection in oracle

Reply via email to