RE: JNDI + dbcp + commons-dbcp-1.2.1.jar

[karthik <ka...@xius.org>]

Hi

  No Reply for the same


With regards
Karthik

-----Original Message-----
From: karthik [mailto:karthikn@xius.org]
Sent: Monday, February 26, 2007 12:15 PM
To: Jakarta Commons Users List
Subject: JNDI + dbcp + commons-dbcp-1.2.1.jar


Hi

  Sorry for delay in answering.

We already have the configurations done as u said
and that application executes vey well in most of the cases Except wher ever
there is this
piece of code

>>ArrayDescriptor adNumb = ArrayDescriptor.createDescriptor("ARR_NUMB",
con); << Line number 423

Still we get the ClassCast Exceptions at those mentioned palces....

java.lang.ClassCastException
         at
oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:108)
         at

com.xius.infinet.ums.UMSBusinessClass.makeNewRolesAdmin(UMSBusinessClass.jav
 a:423)


Somebody people on the Web mentioned to fetche the inner Delegated
Connection from the wrapped ones
to solve the same, but no refrences were made.


Please  We Only have the Exceutable (war file and no source code avaliable
for the same)

My limitation is limited to JNDI connection changes to be made when running
on Apache Tomcat 5 and above


Please help me


with regards
Karthik



-----Original Message-----
From: Henri Yandell [mailto:flamefew@gmail.com]
Sent: Thursday, February 22, 2007 11:10 PM
To: Jakarta Commons Users List
Subject: Re: JNDI + dbcp + commons-dbcp-1.2.1.jar


Did you try what I suggested?

Hen

On 2/20/07, karthik <ka...@xius.org> wrote:
>
> Hi
>
>  Do any body in here have solutions for this form request
>
>
>
>
> with regards
> Karthik
>
>
> -----Original Message-----
> From: karthik [mailto:karthikn@xius.org]
> Sent: Thursday, February 08, 2007 9:57 PM
> To: Jakarta Commons Users List
> Subject: JNDI + dbcp + commons-dbcp-1.2.1.jar
>
>
>
>  Hi
>
>    Currently ,When i wanted to port my application "xyz.war" from  OC4j
> (oracle) to TOMCAT5.5
>    I found some problems regarding JNDI usage in tomcat with Commons DBCP
>
> I have made use of Resource tag as follows
>
> <Resource name="jdbc/tomcattest"
> auth="Container"
> type="javax.sql.DataSource"
> driverClassName="oracle.jdbc.driver.OracleDriver"
> url="jdbc:oracle:thin:@//192.168.150.112:11654/xyz"
> username="voise_20"
> password="voise_20"
> maxActive="100"
> maxIdle="10"
> maxWait="-1"/>
>
>
>    I still get the cast exception as below for Array Discriptor being used
>
>    java.lang.ClassCastException
>         at
oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:108)
>         at
>
com.xius.infinet.ums.UMSBusinessClass.makeNewRolesAdmin(UMSBusinessClass.jav
> a:423)
>
>
>    The Code being used  is as follows
>
> 1>>  con = (DBConnectionManager.getInstance()).getConnection();
> 2>>  htReturnData = new Hashtable();
> 3>>  adTemp = ArrayDescriptor.createDescriptor("ARR_VARCHAR", con);
> 4>>  ar = new ARRAY(adTemp, con, saPrivileges);
> 5>>  OracleCallableStatement cstmt = null;
> 6>>  InfinetUtility.log("UMSBusinessClass.makeNewRolesAdmin " + "{CALL
> UMS_ADMIN.ROLEPROFILE_INSERT(?,?,?,to_number(?),?)}");
> 7>>  cstmt = (OracleCallableStatement) con.prepareCall("{CALL
> UMS_ADMIN.ROLEPROFILE_INSERT(?,?,?,to_number(?),?)}");
> 6>>  cstmt.setString(1, sRoleName);
> 9>>  cstmt.setString(2, sRoleDesc);
> 10>> cstmt.setARRAY(3, ar);
> 11>  cstmt.setString(4, new String("" + iNwId));
> 12>> cstmt.registerOutParameter(5, java.sql.Types.INTEGER);
> 14>  cstmt.execute();
>
>
> The exact nature of problem lies in line number "7" where ever the casting
> happens
>
>
> plz Can somebody explain me why am i getting this error as a result of
using
> "commons-dbcp-1.2.1.jar"
>
>
>
> with regards
> Karthik
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org