.dbschema/sum mapping file problem

Hi,

I have inherited a cmp based app here where I work and am having some

problems modifing the database tables. (I'm relatively new to all of this)

When I try and add a colum to the table (in the bean), when I deploy the app

I get the following error:

Exception while deploying : Fatal Error from EJB Compiler -- JDO74035:

JDOCodeGenerator: Problem while creating database model for application

'transmgr' module 'transmgr-ejb': cannot access or read schema file 'transmgr'.

From reading the sun doc, in summary, it looks like I have (2) options....

capture the new schema automatically by leaving the <schema> entry in the

sun-cmp-mappings.xml file empty

or

I can run the capture-schema utility to manually (after manually altering that table)

generate a .dbschema file, which I then specify in the sun-cmp-mappings.xml file

In both cases I always get the same error. I am assuming that the error

refers to the fact that the app server can not find/open my .dbschema file.

Does any one know why the app server would be looking for this file in the

'automatic capture case'?

For the manual case, the sun doc says that the <schema> entry in the sun mapping

file should only be the basename portion of the filename with a path relative

to the location of the sun mappoing file. Seems simole enough, but I can't get

it to work?

Any insite into this would be appreciated.

Tony

[1543 byte] By [tdaffy] at [2007-11-26 6:41:29]
# 1

1. The problem you have for auto capture schema is possible caused by the fact:

You don't have write access to the schema file which is tried to be created. Make sure that you have write access to $APPSERV_INSTALL/domain/domain1/applications/j2ee-apps

$APPSERV_INSTALL/domain/domain1/generated

2. If you use capture-schema to capture the ${schema_name}.dbschema, then put it in the same place that sun-cmp-mappings.xml resides and change sun-cmp-mappings.xml <schema> to ${schema_name} and repackage them.

jieleng@suncom at 2007-7-6 14:56:01 > top of Java-index,Application & Integration Servers,Application Servers...