Published on WSO2 Oxygen Tank (http://wso2.org)

Error with derby script WSO2 Registry

By netgonzalezs
Created 2008-04-21 09:07

i try to configuring the WSO2 Registry with Apache Derby Database on UBUNTU

so when i run the script to create a tables into "ij  console" only see an errors

"run '/home/SOA/wso2registry/database-scripts/derby-complete.sql"

 

Versión ij 10.3

ij> connect 'jdbc:derby://localhost:1527/db;user=regadmin;password=regadmin;create=true';

ij> run '/home/SOA/wso2registry/database-scripts/derby-complete.sql';

ij> CREATE TABLE ARTIFACTS (AID INTEGER GENERATED ALWAYS AS IDENTITY,

                PATH VARCHAR (500) NOT NULL,

                MEDIA_TYPE VARCHAR (500),

                DIRECTORY INTEGER NOT NULL,

                STATE INTEGER,

                AUTHOR VARCHAR (500),

                CREATED_TIME TIMESTAMP,

                DESCRIPTION VARCHAR (10000),

                PRIMARY KEY (AID),

                UNIQUE(PATH));

t his Now si OK , BUT ON THE NEXT INSTRUCCION

SHOW TABLES;

i have a problem.. .  below  you can read it

 

 


Source URL:
http://wso2.org/forum/thread/3505