Hi Vikram, Oracle connections through Weblogic does not support ArrayDescriptor.
Hence we created our own Oracle Connection pool and based on the need we either get Weblogic (Oracle) Connection (mentioned in weblogic.properties) or Oracle Connection. 'based on need' means get Oracle connection if we are trying to store or retrieve a Array and for other purposes use Weblogic connection. We have a separate Oracle connection pool for oracle for this reason. May be this would help you. When you are using Array, try to use to this connection. WE have the same problem and we solved it by the following code. Class.forName(oracle.jdbc.driver.OracleDriver); Connection connection = DriverManager.getConnection( "jdbc:oracle:thin:@111.111.111.111:port:XYZ", USR, PWD); Now use this connection to retrieve or save the records. Though this the same as weblogic.properties, this connection will work. Hope this solves your problem. Regards, Prasad. -----Original Message----- From: vikram.naik [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 8:10 PM To: EJB-INTEREST Cc: vikram.naik Subject: Re: Passing Varray in stored procedures using JDBC Hello, I am trying to pass Arrays to Oracle Store procedures using weblogic datasource. But I am getting class cast exception while creating ArrayDescription. As it expects oracleConnection... Do we have some work around for this problem. Regards, Vikram Naik -----Original Message----- From: ********** [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 7:30 PM To: [EMAIL PROTECTED] Subject: Re: Passing Varray in stored procedures using JDBC Sorry, would you like to tell me what is UDT? UDT-User Define Type? >Hello All, > >I want to pass an array UDT using weblogic connection to a stored >procedure. Can any point some resource where I can find some hints On how to >do this. > >Regards, >Vikram Naik > >=========================================================================== >To unsubscribe, send email to [EMAIL PROTECTED] and include in the body >of the message "signoff EJB-INTEREST". For general help, send email to >[EMAIL PROTECTED] and include in the body of the message "help". David Chen [EMAIL PROTECTED] [EMAIL PROTECTED] Chen in the body of the message "help". toboTo unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help". =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
