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:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> wrote: > > Hi > > Do any body in here have solutions for this form request > > > > > with regards > Karthik > > > -----Original Message----- > From: karthik [mailto:[EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]