JDBC from cron 
Author Message
 JDBC from cron

Running DB2 under Linux - at this point in time I just have the default
instance db2inst1 operational.

I have a Java JDBC routine that takes a flat file, parses it and loads it to
a table (production data from a manufacturing line).  I would like to do
this on a timed basis throughout the day - probably using cron.

Right now,  the JDBC routine will only execute from the db2inst1 signon
(other signons can't find the driver).  I'm a little confused on how to set
up the environment to allow other users to execute the process.  I would
assume it is a matter of executing db2profile in the bash_profile for each
user - however it would need to point back at the db2inst1 instance (I
think).

Just need a little guidance.  Thanks,

As an aside, rather than cron, would I be better off periodically just doing
the timing in the Java routine and running it as a background process?  If
so, would that be done starting and stopping a thread or is there a more
elegant solution?

Norm

Norman Plummer
Bigston Information Technologies



Sun, 08 Sep 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Vacuum Analyze - CRON script running correctly?

2. Cron /usr/lib/postgresql/bin/do.maintenance

3. Running vacuum on cron

4. cron do.maintenance: "RegisterSharedInvalid,InvalidateSharedInvalid"

5. how to vacuum from cron?

6. how to vacuum from cron?

7. cron jobs on views

8. how to cron pg_dump and vaccum

9. Automate report2.5 developed on NT to run from cron job on Solaris 2.5

10. shell script with sqlplus call not working in cron

11. cron and ORACLE_HOME env

12. Submitting a cron


 
Powered by phpBB® Forum Software