JAVA Stored Procedures....HELP!!! 
Author Message
 JAVA Stored Procedures....HELP!!!
Every time I change my stored procedures I have to STOP and RESTART the
database before my code change takes effect.  It's like I run REPLACE_JAR
but it doesn't take effect.  I can even see the physical file being updated
in the DB2 JAR folder.  I assume the actual JAR file being used is in memory
and that's why stopping and restarting works.  ...What should I do?  This is
really slowing me down. :|  Is there any way to get my new JAR to kick in
without stopping and restarting?


Mon, 18 Jul 2005 06:16:18 GMT
 JAVA Stored Procedures....HELP!!!

I just read what Michael Bhola wrote... "keepdari = no in the dbm cfg might
help"  I'll post again if that solves my problem.


Quote:
> Every time I change my stored procedures I have to STOP and RESTART the
> database before my code change takes effect.  It's like I run REPLACE_JAR
> but it doesn't take effect.  I can even see the physical file being
updated
> in the DB2 JAR folder.  I assume the actual JAR file being used is in
memory
> and that's why stopping and restarting works.  ...What should I do?  This
is
> really slowing me down. :|  Is there any way to get my new JAR to kick in
> without stopping and restarting?



Mon, 18 Jul 2005 06:17:35 GMT
 JAVA Stored Procedures....HELP!!!
SCORE!  Thanks Michael.  That was my problem.


Quote:
> I just read what Michael Bhola wrote... "keepdari = no in the dbm cfg
might
> help"  I'll post again if that solves my problem.



> > Every time I change my stored procedures I have to STOP and RESTART the
> > database before my code change takes effect.  It's like I run
REPLACE_JAR
> > but it doesn't take effect.  I can even see the physical file being
> updated
> > in the DB2 JAR folder.  I assume the actual JAR file being used is in
> memory
> > and that's why stopping and restarting works.  ...What should I do?
This
> is
> > really slowing me down. :|  Is there any way to get my new JAR to kick
in
> > without stopping and restarting?



Mon, 18 Jul 2005 06:56:56 GMT
 JAVA Stored Procedures....HELP!!!
Brian,

Note that keepdari=no will slow down your sp execution a lot...another
option is to use:

"call sqlj.refresh_classes()"


Quote:
> SCORE!  Thanks Michael.  That was my problem.



> > I just read what Michael Bhola wrote... "keepdari = no in the dbm cfg
> might
> > help"  I'll post again if that solves my problem.



> > > Every time I change my stored procedures I have to STOP and RESTART
the
> > > database before my code change takes effect.  It's like I run
> REPLACE_JAR
> > > but it doesn't take effect.  I can even see the physical file being
> > updated
> > > in the DB2 JAR folder.  I assume the actual JAR file being used is in
> > memory
> > > and that's why stopping and restarting works.  ...What should I do?
> This
> > is
> > > really slowing me down. :|  Is there any way to get my new JAR to kick
> in
> > > without stopping and restarting?



Tue, 19 Jul 2005 02:14:35 GMT
 JAVA Stored Procedures....HELP!!!
Thanks!


Quote:
> Brian,

> Note that keepdari=no will slow down your sp execution a lot...another
> option is to use:

> "call sqlj.refresh_classes()"



> > SCORE!  Thanks Michael.  That was my problem.



> > > I just read what Michael Bhola wrote... "keepdari = no in the dbm cfg
> > might
> > > help"  I'll post again if that solves my problem.



> > > > Every time I change my stored procedures I have to STOP and RESTART
> the
> > > > database before my code change takes effect.  It's like I run
> > REPLACE_JAR
> > > > but it doesn't take effect.  I can even see the physical file being
> > > updated
> > > > in the DB2 JAR folder.  I assume the actual JAR file being used is
in
> > > memory
> > > > and that's why stopping and restarting works.  ...What should I do?
> > This
> > > is
> > > > really slowing me down. :|  Is there any way to get my new JAR to
kick
> > in
> > > > without stopping and restarting?



Sat, 23 Jul 2005 08:39:19 GMT
 JAVA Stored Procedures....HELP!!!
.....Thank you very much.


Quote:
> Brian,

> Note that keepdari=no will slow down your sp execution a lot...another
> option is to use:

> "call sqlj.refresh_classes()"



> > SCORE!  Thanks Michael.  That was my problem.



> > > I just read what Michael Bhola wrote... "keepdari = no in the dbm cfg
> > might
> > > help"  I'll post again if that solves my problem.



> > > > Every time I change my stored procedures I have to STOP and RESTART
> the
> > > > database before my code change takes effect.  It's like I run
> > REPLACE_JAR
> > > > but it doesn't take effect.  I can even see the physical file being
> > > updated
> > > > in the DB2 JAR folder.  I assume the actual JAR file being used is
in
> > > memory
> > > > and that's why stopping and restarting works.  ...What should I do?
> > This
> > > is
> > > > really slowing me down. :|  Is there any way to get my new JAR to
kick
> > in
> > > > without stopping and restarting?



Sat, 23 Jul 2005 08:39:02 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. Java Stored Procedure Help

2. Java Stored Procedures Help!

3. Calling a Java Stored Procedure from another Java Stored Stored Procedure

4. Gettting SQL0751N trying to call java stored procedure from a java stored procedure

5. Calling Java Stored Procedure from SQL Stored Procedure

6. Calling Java code on disc from a Java Stored Procedure

7. help us - java stored procedure

8. Help: File access from Java stored procedure (Oracle)

9. HELP - Stored Procedure(Function) call through java to Informix database

10. Help with Java Stored Procedures in Oracle

11. Accessing Java STored Procedures frm VB HELP!

12. HELP: Scrollable ResultSet, Stored Procedure, JAVA


 
Powered by phpBB® Forum Software