Vidoll :: Storyboard

Home

Database Configuration

The Storyboard download comes with an SQL script file containing all the SQL commands to create: a User, Tables, Triggers, Sequences and some dummy categories. Because Oracle 9i has been the development database, all scripts are based on that platform and so might have to be altered to fit another RDBMS. [NOTE: The script has not been tested, it was put together after the database had been built. Individual commands should work, but as a whole...]

Additionally, the Entity EJBs use Oracle specific classes for the SQLJ calls used to call Sequences (used as Entity EJB Primary Keys) and also have to handle CLOB datatypes (Chapter and Comments content) directly because of how Oracle CLOB datatypes work. Eventually, Storyboard will be able to be used with a greater range of RDBMS', including commonly available ones and the application will require modification of configuration files to set what database is being used.