I decided that Turbine seemed quite interesting, so last night I checked it
out. As I quite like Interbase and I had it all nice and setup , I decided
to try creating newapp using interbase. I checked out the news groups and
found an article by Jon Stevens dated 01/05/2001 commenting that it worked
with Interbase.
At the begginning , I tried building with ant and jdk1.3.1 but it came
up with segmentation errors (That's an issue with this jdk...) so I switched
back to jdk1.3. Everything seemed to go well..Most of the targets were
executed..the sql files were created succesfully, but when it tried to
execute the sql interbase bombed out. Looking at the errors, it seemed that
it didn't like the comments present int the genereated sql files. But, what
i also noticed which may or may not be strange is that final compilation
also bombed out, complaining about 'invalid flag: -sourcepath'.
The first time I tried it, I set the properties file to allow automatic
creation of the database. The second time, I activated the manual database
creation option and created it myself...
Any suggestions....
I'm including my console output and the newapp.properties file.
Saimon...
saimon@linux:/opt/tdk/webapps/newapp/WEB-INF/build > ant init
Buildfile: build.xml
init:
init-tasks:
turbine-sql:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating SQL for Turbine base system! |
[echo] | |
[echo] +------------------------------------------+
/opt/tdk/webapps/newapp/WEB-INF/src/sql/turbine-schema.sql
init-tasks:
turbine-id-table-sql:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating SQL for YOUR Turbine project! |
[echo] | Woo hoo! |
[echo] | |
[echo] +------------------------------------------+
/opt/tdk/webapps/newapp/WEB-INF/src/sql/id-table-schema.sql
init-tasks:
turbine-id-table-init-sql:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating TURBINE initialization SQL |
[echo] | for ID Broker system! |
[echo] | |
[echo] +------------------------------------------+
/opt/tdk/webapps/newapp/WEB-INF/src/sql/turbine-id-table-init.sql
init-tasks:
turbine-security-sql:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating Turbine security system SQL! |
[echo] | |
[echo] +------------------------------------------+
/opt/tdk/webapps/newapp/WEB-INF/src/sql/turbine-security.sql
init-tasks:
project-sql:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating SQL for YOUR Turbine project! |
[echo] | Woo hoo! |
[echo] | |
[echo] +------------------------------------------+
/opt/tdk/webapps/newapp/WEB-INF/src/sql/report.newapp.sql.generation
init-tasks:
project-id-table-init-sql:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating PROJECT initialization SQL |
[echo] | for ID Broker system! |
[echo] | |
[echo] +------------------------------------------+
/opt/tdk/webapps/newapp/WEB-INF/src/sql/newapp-id-table-init.sql
init-tasks:
create-database:
insert-sql:
insert-sql-file:
[sql] Executing file: /opt/tdk/webapps/newapp/WEB-INF/src/sql/turbine-schema.sql
[sql] Failed to execute: /*
--------------------------------------------------------------------------
TURBINE_PERMISSION CREATE TABLE TURBINE_PERMISSION ( "PERMISSION_ID" INTEGER NOT
NULL, "PERMISSION_NAME" VARCHAR (99) NOT NULL, "OBJECTDATA" BLOB, PRIMARY
KEY(PERMISSION_ID), UNIQUE (PERMISSION_NAME) )
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -104
Unexpected end of command
[sql] Failed to execute: /*
--------------------------------------------------------------------------
TURBINE_ROLE CREATE TABLE TURBINE_ROLE ( "ROLE_ID" INTEGER NOT NULL,
"ROLE_NAME" VARCHAR (99) NOT NULL, "OBJECTDATA" BLOB, PRIMARY KEY(ROLE_ID),
UNIQUE (ROLE_NAME) )
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -104
Unexpected end of command
[sql] Failed to execute: /*
--------------------------------------------------------------------------
TURBINE_GROUP CREATE TABLE TURBINE_GROUP ( "GROUP_ID" INTEGER NOT NULL,
"GROUP_NAME" VARCHAR (99) NOT NULL, "OBJECTDATA" BLOB, PRIMARY KEY(GROUP_ID),
UNIQUE (GROUP_NAME) )
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -104
Unexpected end of command
[sql] Failed to execute: /*
--------------------------------------------------------------------------
TURBINE_ROLE_PERMISSION CREATE TABLE TURBINE_ROLE_PERMISSION ( "ROLE_ID" INTEGER
NOT NULL, "PERMISSION_ID" INTEGER NOT NULL, PRIMARY KEY(ROLE_ID,PERMISSION_ID)
)
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -104
Unexpected end of command
[sql] Failed to execute: /*
--------------------------------------------------------------------------
TURBINE_USER CREATE TABLE TURBINE_USER ( "USER_ID" INTEGER NOT NULL,
"LOGIN_NAME" VARCHAR (32) NOT NULL, "PASSWORD_VALUE" VARCHAR (32) NOT NULL,
"FIRST_NAME" VARCHAR (99) NOT NULL, "LAST_NAME" VARCHAR (99) NOT NULL,
"EMAIL" VARCHAR (99), "CONFIRM_VALUE" VARCHAR (99), "MODIFIED" timestamp,
"CREATED" timestamp, "LAST_LOGIN" timestamp, "OBJECTDATA" BLOB,
PRIMARY KEY(USER_ID), UNIQUE (LOGIN_NAME) )
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -104
Unexpected end of command
[sql] Failed to execute: /*
--------------------------------------------------------------------------
TURBINE_USER_GROUP_ROLE CREATE TABLE TURBINE_USER_GROUP_ROLE ( "USER_ID" INTEGER
NOT NULL, "GROUP_ID" INTEGER NOT NULL, "ROLE_ID" INTEGER NOT NULL, PRIMARY
KEY(USER_ID,GROUP_ID,ROLE_ID) )
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -104
Unexpected end of command
[sql] Failed to execute: /*
--------------------------------------------------------------------------
TURBINE_SCHEDULED_JOB CREATE TABLE TURBINE_SCHEDULED_JOB ( "JOB_ID" INTEGER NOT
NULL, "SECOND" INTEGER default -1 NOT NULL, "MINUTE" INTEGER default -1 NOT
NULL, "HOUR" INTEGER default -1 NOT NULL, "WEEK_DAY" INTEGER default -1 NOT
NULL, "DAY_OF_MONTH" INTEGER default -1 NOT NULL, "TASK" VARCHAR (99) NOT
NULL, "EMAIL" VARCHAR (99), "PROPERTY" BLOB, PRIMARY KEY(JOB_ID) )
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -104
Unexpected end of command
[sql] 0 of 7 SQL statements executed successfully
insert-sql-file:
[sql] Executing file:
/opt/tdk/webapps/newapp/WEB-INF/src/sql/turbine-security.sql
[sql] Failed to execute: /* Script to fill the tables with default roles and
permissions */ /* Currently tested with MySQL, Oracle, Postgres and Hypersonic only.
*/ /* Create the global group */ /* this group is used to assign system-wide roles to
users */ INSERT INTO TURBINE_GROUP (GROUP_ID, GROUP_NAME) VALUES (1,'global')
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -204
Table unknown
TURBINE_GROUP
[sql] Failed to execute: /* Create the root role */ INSERT INTO TURBINE_ROLE
(ROLE_ID, ROLE_NAME) VALUES (1, 'turbine_root')
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -204
Table unknown
TURBINE_ROLE
[sql] Failed to execute: /* Create an account, turbine, for system administartor
*/ /* Remember to set a good password for this user in a production system! */ INSERT
INTO TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME)
VALUES (0, 'turbine', 'turbine', 'turbine', 'turbine')
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -204
Table unknown
TURBINE_USER
[sql] Failed to execute: /* Assign the user, turbine, a system-wide role,
turbine_root */ INSERT INTO TURBINE_USER_GROUP_ROLE ( USER_ID, GROUP_ID, ROLE_ID )
SELECT TURBINE_USER.USER_ID, TURBINE_GROUP.GROUP_ID, TURBINE_ROLE.ROLE_ID from
TURBINE_USER, TURBINE_GROUP, TURBINE_ROLE WHERE TURBINE_USER.LOGIN_NAME = 'turbine'
AND TURBINE_GROUP.GROUP_NAME = 'global' AND TURBINE_ROLE.ROLE_NAME = 'turbine_root'
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -204
Table unknown
TURBINE_USER
[sql] Failed to execute: /* Add some default permissions */ INSERT INTO
TURBINE_PERMISSION (PERMISSION_ID, PERMISSION_NAME) VALUES (1,
'admin_users')
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -204
Table unknown
TURBINE_PERMISSION
[sql] Failed to execute: /* Add some permissions for the root role */ INSERT
INTO TURBINE_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID) SELECT TURBINE_ROLE.ROLE_ID,
TURBINE_PERMISSION.PERMISSION_ID FROM TURBINE_ROLE, TURBINE_PERMISSION WHERE
TURBINE_PERMISSION.PERMISSION_NAME = 'admin_users' AND TURBINE_ROLE.ROLE_NAME =
'turbine_root'
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -204
Table unknown
TURBINE_ROLE
[sql] 0 of 6 SQL statements executed successfully
insert-sql-file:
[sql] Executing file: /opt/tdk/webapps/newapp/WEB-INF/src/sql/id-table-schema.sql
[sql] Failed to execute: /*
--------------------------------------------------------------------------
ID_TABLE CREATE TABLE ID_TABLE ( "ID_TABLE_ID" INTEGER NOT NULL IDENTITY,
"TABLE_NAME" VARCHAR (255) NOT NULL, "NEXT_ID" INTEGER, "QUANTITY" INTEGER,
PRIMARY KEY(ID_TABLE_ID), UNIQUE (TABLE_NAME) )
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -104
Unexpected end of command
[sql] 0 of 1 SQL statements executed successfully
insert-sql-file:
[sql] Executing file: /opt/tdk/webapps/newapp/WEB-INF/src/sql/newapp-schema.sql
[sql] Failed to execute: /*
--------------------------------------------------------------------------
RDF CREATE TABLE RDF ( "RDF_ID" INTEGER NOT NULL IDENTITY, "TITLE" VARCHAR
(255), "BODY" VARCHAR (255), "URL" VARCHAR (255), "AUTHOR" VARCHAR (255),
"DEPT" VARCHAR (255), PRIMARY KEY(RDF_ID) )
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -104
Unexpected end of command
[sql] 0 of 1 SQL statements executed successfully
insert-sql-file:
[sql] Executing file:
/opt/tdk/webapps/newapp/WEB-INF/src/sql/turbine-id-table-init.sql
[sql] Failed to execute: delete from ID_TABLE where id_table_id >= 1
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -204
Table unknown
ID_TABLE
[sql] Failed to execute: insert into ID_TABLE (id_table_id, table_name, next_id,
quantity) VALUES (1, 'TURBINE_PERMISSION', 100, 10)
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -204
Table unknown
ID_TABLE
[sql] Failed to execute: insert into ID_TABLE (id_table_id, table_name, next_id,
quantity) VALUES (2, 'TURBINE_ROLE', 100, 10)
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -204
Table unknown
ID_TABLE
[sql] Failed to execute: insert into ID_TABLE (id_table_id, table_name, next_id,
quantity) VALUES (3, 'TURBINE_GROUP', 100, 10)
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -204
Table unknown
ID_TABLE
[sql] Failed to execute: insert into ID_TABLE (id_table_id, table_name, next_id,
quantity) VALUES (4, 'TURBINE_ROLE_PERMISSION', 100, 10)
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -204
Table unknown
ID_TABLE
[sql] Failed to execute: insert into ID_TABLE (id_table_id, table_name, next_id,
quantity) VALUES (5, 'TURBINE_USER', 100, 10)
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -204
Table unknown
ID_TABLE
[sql] Failed to execute: insert into ID_TABLE (id_table_id, table_name, next_id,
quantity) VALUES (6, 'TURBINE_USER_GROUP_ROLE', 100, 10)
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -204
Table unknown
ID_TABLE
[sql] Failed to execute: insert into ID_TABLE (id_table_id, table_name, next_id,
quantity) VALUES (7, 'TURBINE_SCHEDULED_JOB', 100, 10)
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -204
Table unknown
ID_TABLE
[sql] 0 of 8 SQL statements executed successfully
insert-sql-file:
[sql] Executing file:
/opt/tdk/webapps/newapp/WEB-INF/src/sql/newapp-id-table-init.sql
[sql] Failed to execute: delete from ID_TABLE where id_table_id >= 101
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -204
Table unknown
ID_TABLE
[sql] Failed to execute: insert into ID_TABLE (id_table_id, table_name, next_id,
quantity) VALUES (101, 'RDF', 100, 10)
[sql] interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -204
Table unknown
ID_TABLE
[sql] 0 of 2 SQL statements executed successfully
init-tasks:
project-om:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating Peer-based Object Model for |
[echo] | YOUR Turbine project! Woo hoo! |
[echo] | |
[echo] +------------------------------------------+
/opt/tdk/webapps/newapp/WEB-INF/src/java/report.newapp.om.generation
compile:
[javac] Compiling 31 source files to /opt/tdk/webapps/newapp/WEB-INF/classes
[javac] javac: invalid flag: -sourcepath
[javac] use: javac [-g][-O][-debug][-depend][-nowarn][-verbose][-classpath
path][-nowrite][-deprecation][-d dir][-J<runtime flag>] file.java...
BUILD FAILED
/opt/tdk/webapps/newapp/WEB-INF/build/build.xml:76: Compile failed, messages should
have been provided.
Total time: 1 minute 40 seconds
newapp.properties
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
