Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id EFFF6DCA5 for ; Fri, 28 Dec 2012 04:38:31 +0000 (UTC) Received: (qmail 77747 invoked by uid 500); 28 Dec 2012 04:38:31 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 77605 invoked by uid 500); 28 Dec 2012 04:38:30 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 77535 invoked by uid 99); 28 Dec 2012 04:38:27 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 28 Dec 2012 04:38:27 +0000 X-ASF-Spam-Status: No, hits=2.9 required=5.0 tests=HTML_MESSAGE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: 216.139.250.139 is neither permitted nor denied by domain of kosurusekhar@gmail.com) Received: from [216.139.250.139] (HELO joe.nabble.com) (216.139.250.139) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 28 Dec 2012 04:38:22 +0000 Received: from tom.nabble.com ([192.168.236.105]) by joe.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1ToRhp-0002aO-Ju for derby-user@db.apache.org; Thu, 27 Dec 2012 20:38:01 -0800 Date: Thu, 27 Dec 2012 20:38:01 -0800 (PST) From: kosurusekhar To: derby-user@db.apache.org Message-ID: In-Reply-To: <50DC7D0B.1030306@oracle.com> References: <1356584652035-126086.post@n7.nabble.com> <50DC7D0B.1030306@oracle.com> Subject: Re: Problem with User Defined Type - External Java Class MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2598_17400964.1356669481607" X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_2598_17400964.1356669481607 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi Rick, The jar is included in classpath, but while mapping the Store proc parameters it is throwing error, in another store proc i created object for my UDT class, there it created an object. I am suspecting that mapping the variables done by another ClassLoader. Regards Sekhar. On Thu, Dec 27, 2012 at 10:24 PM, Rick Hillegas-3 [via Apache Database] < ml-node+s10148n126105h28@n7.nabble.com> wrote: > On 12/26/12 9:04 PM, kosurusekhar wrote: > > > I created an User Defined Type as per derby docs and i am using it in > Store > > Proc IN Parameter. Both UDT& Store Proc Java Classes packed into a > single > > jar and uploaded to Derby Database using IJ client. > > When i am trying to accecss the Store Proc with JDBC code i could see > > ClassNotFoundException in Derby console and in log file. > > > > For the same class i created object in another Store Proc. (Not as Store > > Proc Method Parameter, in side the method implementation) There it is > able > > to create the object. How Derby is trying to load the method parameters > > external java classes ? > > > > I created another test store proc with UDT as java.util.List. it is > working > > fine. > Hi Sekhar, > > It sounds as though your classpath does not include the jar file which > contains the UDT class. > > Hope this helps, > -Rick > > > Please help me to register my UDT external java class into Derby > Classpath ? > > > > I am sure it is there in derby classpath but while mapping the Store > proc > > method paratemeters it is not able to find the particular class. is > there > > multiple class loaders are working so that it is not able to identify my > UDT > > java class, please help me to solve this issue. > > > > Thanks in Advance. > > > > > > > > Regards, > > Sekhar > > > > > > > > > > > > > > > > -- > > View this message in context: > http://apache-database.10148.n7.nabble.com/Problem-with-User-Defined-Type-External-Java-Class-tp126086.html > > Sent from the Apache Derby Users mailing list archive at Nabble.com. > > > > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://apache-database.10148.n7.nabble.com/Problem-with-User-Defined-Type-External-Java-Class-tp126086p126105.html > To unsubscribe from Problem with User Defined Type - External Java Class, click > here > . > NAML > -- View this message in context: http://apache-database.10148.n7.nabble.com/Problem-with-User-Defined-Type-External-Java-Class-tp126086p126112.html Sent from the Apache Derby Users mailing list archive at Nabble.com. ------=_Part_2598_17400964.1356669481607 Content-Type: text/html; charset=UTF8 Content-Transfer-Encoding: quoted-printable
Hi Rick,
=C2=A0
The jar is included in classpath, = but while mapping the Store proc parameters it is throwing error, in anothe= r store proc i created object for my UDT class, there it created an object.= I am suspecting that mapping the variables done by another ClassLoader.
=C2=A0
=C2=A0
Regards
Sekhar.

On Thu, Dec 27, 2012 at 10:24 PM, Rick Hilleg= as-3 [via Apache Database] <[hidden email]> wrote:
=09On 12/26/12 9:04 PM, kosurusekhar wrote:

> I created an User Defined Typ= e as per derby docs and i am using it in Store
> Proc IN Parameter. Both UDT& =C2=A0Store Proc Java Classes pac= ked into a single
> jar and uploaded to Derby Database using IJ client.
> When i am trying to accecss the Store Proc with JDBC code i could = see
> ClassNotFoundException in Derby console and in log file.
>
> For the same class i created object in another Store Proc. (Not as= Store
> Proc Method Parameter, in side the method implementation) There it= is able
> to create the object. How Derby is trying to load the method param= eters
> external java classes ?
>
> I created another test store proc with UDT as java.util.List. it i= s working
> fine.
Hi Sekhar,

It sounds as though your classpath does not include the jar file = which=20
contains the UDT class.

Hope this helps,
-Rick

> Please help me to register my= UDT external java class into Derby Classpath ?
>
> I am sure it is there in derby classpath but while mapping the Sto= re proc
> method paratemeters it is not able to find the particular class. i= s there
> multiple class loaders are working so that it is not able to ident= ify my UDT
> java class, please help me to solve this issue.
>
> Thanks in Advance.
>
>
>
> Regards,
> Sekhar
>
>
>
>
>
>
>
> --
> View this message in context: http://apache= -database.10148.n7.nabble.com/Problem-with-User-Defined-Type-External-Java-= Class-tp126086.html
> Sent from the Apache Derby Users mailing list archive at Nabble.com.
>

=09 =09 =09 =09
=09
=09
=09
=09=09
If you reply to this email, your mess= age will be added to the discussion below:
=09=09http://apache-database.10148.n7.nabble.= com/Problem-with-User-Defined-Type-External-Java-Class-tp126086p126105.html= =09
=09
=09=09 =09=09To unsubscribe from Problem with User Defined Type - External Java Cl= ass, clic= k here.
=09=09NAML =09

=09 =09 =09
View this message in context: Re: Problem with User Defined Type - External Java Class
Sent from the Apache Derby Users mailing list archive at Nab= ble.com.
------=_Part_2598_17400964.1356669481607--