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]
