Geek asks and answers

Follow db instructions from file

I am using the Apache built-in derby for my application. I have an SQL script called createdb.sql that creates all the tables in the database and populates it with the source data, for example:

SET SCHEMA APP;


CREATE TABLE study (
    study_id    bigint  not null GENERATED ALWAYS AS IDENTITY  (START WITH 1, INCREMENT BY 1),
    name        varchar(50) not null,
    note         varchar(1000) DEFAULT '',      
    created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    deleted boolean DEFAULT false,
    UNIQUE(name),
    CONSTRAINT primary_key PRIMARY KEY (study_id)

);

INSERT INTO "APP"."STUDY" (NAME) VALUES ('default');



CREATE TABLE img (
    img_id bigint not null GENERATED ALWAYS AS IDENTITY  (START WITH 1, INCREMENT BY 1),
    filename varchar(200) not null,
    path        varchar(300) not null,
    flipped boolean DEFAULT false,
    type      smallint not null, 
    note varchar(1000) DEFAULT '',
    created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (img_id)    
);

ALTER TABLE img ADD COLUMN dpix integer DEFAULT -1;
ALTER TABLE img ADD COLUMN dpiy integer DEFAULT -1;

The question is how to download this file and follow all the instructions using java? I try to execute another function, but all of them do not work. For instance,

Statement s = conn.createStatement();
s.execute(sqlStr);

or

Statement s = conn.createStatement();
s.executeUpdate(sqlStr);

sqlStr - , createdb.sql. SQL, script, ? Btw, SQL script , SQuirreL SQL Client . .

+5

More articles:


All Articles