Problem:

Product: BES5.x and JBuilder8.
Platform: Win 2000 Pro
JDK: JDK shipped with BES5.x

BES5.x cannot find the JDatastore tables some times

When JBuilder creates different deployable units in different projects, in which each of the projects has its own database named by JBuilder, each database will have the same jndi name. If many containers are started, the last container deploys his database and registers it in the naming service overwriting the previously registered database. When the client tries to attach to the first container the following error will be thrown:

ejbcontainer: >>>> EJB LOG >>>>ejbcontainer: java.lang.Error: User requested that table not be created

This problem may occur for those having more then one database connection and multiple deployable units.

Resolution:

Modify the jndi-definitions file with the unique JNDI name (there are two JNDI names in the jndi-definitions element) for each deployable unit.
serial://datasources/DataSource serial://datasources/driverDataSource in the same element and also in the corresponding serial://datasources/driverDataSource