IBM WebSphere Application Server
Enterprise Edition Version 4.1
Release Notes supplement
If using a database other than DB2 with the BRBeans samples (Movie Sample or Simple Sample), you need to modify the generated Table.ddl file. For example:
CREATE DATABASE BRBGROUP
that is not required for the table creation
and it will outputs anerror regarding the
permission or privilege to create the database.
Workaround for Sybase, Oracle, Informix and
SQL Server: Remove or comment out the statement
CREATE DATABASE BRBGROUP
in the DDL file.
Because the DDL is not generated correctly for the syntax requirement of some databases, you need to modify the file to successfully create the tables.
Note: Informix and Oracle DDLs are not affected.
Workaround for Sybase: Remove the semicolons
and add go
statement, as shown below.
Original statements: | Modified statements: |
create schema authorization EJB; |
create schema authorization EJB |
Workaround for SQL Server: Remove the semicolons
and the alter
statements, and add primary key
to the end of Column name PRIMARYKEY
, as shown below:
Original statements: | Modified statements: |
create schema authorization EJB; |
CREATE SCHEMA AUTHORIZATION EJB |