[JUDDI-184] Derby db is not created correctly on initialization

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0rc6
• Fix Version/s: 2.0rc6
• Assignee: Thomas Cunningham
• Reporter: Kurt T Stam
• Created: 05/Feb/09 15:29
• Updated: 06/Feb/09 05:10
• Resolved: 06/Feb/09 05:10

Description

When running juddi-tomcat out-of-the-box the derby database

1. is called juddi-derby-test-db; which we should probably change to juddi-db

2. when the first statement is executed in the RegistryEngine on line 302

CREATE TABLE BUSINESS_ENTITY
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
AUTHORIZED_NAME VARCHAR(255) NOT NULL,
PUBLISHER_ID VARCHAR(20) NULL,
OPERATOR VARCHAR(255) NOT NULL,
LAST_UPDATE TIMESTAMP NOT NULL,
PRIMARY KEY (BUSINESS_KEY)
)

it throws the following exception:

SQL Exception: Syntax error: Encountered "NULL" at line 5, column 28.

So something is wrong when it goes to create the derby database.