You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <de...@db.apache.org> on 2005/11/16 00:58:29 UTC

[jira] Updated: (DERBY-556) NetworkServer does not set thread context classloader

     [ 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