Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <1213480713.1132099109268.JavaMail.jira@ajax.apache.org>
Date: Wed, 16 Nov 2005 00:58:29 +0100 (CET)
From: "Rick Hillegas (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-556) NetworkServer does not set thread context
 classloader
In-Reply-To: <1179238558.1125962135887.JavaMail.jira@ajax.apache.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

     [ http://issues.apache.org/jira/browse/DERBY-556?page=all ]

Rick Hillegas updated DERBY-556:
--------------------------------

    Attachment: MathUtils.jar
                z.sql
                zz.sql

Hi Jeremy,

Can you explain the problem in greater detail? I successfully did the following:

1) I created and executed a procedure using the network server with the dbproc class visible on the server's classpath. I did the following:

a) Put MathUtils.class (included in the attached MathUtils.jar) in a directory wired into $CLASSPATH
b) Brought up the network server like so:

java -cp $CLASSPATH -Dderby.stream.error.logSeverityLevel=0 org.apache.derby.drda.NetworkServerControl start -p 8246

c) Ran the attached z.sql script through ij. The script output claims success for running a function and dbproc declared in MathUtils.class

2) Using the network server, I also successfully created and executed the same procedure from a jar file loaded into the database. I did the following:

a) Put MathUtils.jar in the current directory.
b) Brought up the network server like so:

java -Dderby.database.classpath=APP.MATH_UTILS -Dderby.stream.error.logSeverityLevel=0 org.apache.derby.drda.NetworkServerControl start -p 8246

c) Ran the attached zz.sql script through ij. This script loaded the jar file, defined the dbproc, then ran the dbproc.


> NetworkServer does not set thread context classloader
> -----------------------------------------------------
>
>          Key: DERBY-556
>          URL: http://issues.apache.org/jira/browse/DERBY-556
>      Project: Derby
>         Type: Bug
>   Components: Network Server
>     Versions: 10.1.1.0
>     Reporter: Jeremy Boynes
>     Assignee: Rick Hillegas
>  Attachments: MathUtils.jar, z.sql, zz.sql
>
> The NetworkServer does not set the thread context classloader which is used to load the implementations of stored procedures. As a result, procedure implementations must be present in the classpath of the engine itself; this differs from embedded mode where classes may be located in the application.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira