How to execute an SQL script for Derby DB from a ksh script

Question

I am trying to write a small program that utilizes a sql script I wrote, to access data within a Derby DB (let's call it "myscript.sql") from within a ksh script.

I seem to be running into problems however since my ksh script can only launch the "ij" tool, and is not able to input any further commands in the ij shell once opened (thus, can not connect to the DB).

Is there any way that the ksh script can echo commands to the ij shell, so I can connect/execute my query as needed ?

Community · Accepted Answer · 2020-06-20 09:12:55Z

3

You can accomplish this by redirecting stdin to the ij tool and running it using java:

Name an input file as a command-line argument. For example:

java org.apache.derby.tools.ij myscript.sql

Redirect standard input to come from a file. For example:

java org.apache.derby.tools.ij < myscript.sql

Source: Derby documentation

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Dec 16, 2015 at 16:44

Andy Guibert

43.2k8 gold badges46 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to execute an SQL script for Derby DB from a ksh script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related