db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-556) NetworkServer does not set thread context classloader
Date Tue, 15 Nov 2005 23:58:29 GMT
     [ 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


Mime
View raw message