I am trying to deploy a simple CMP on Sun App Server 8, and I'm having a few problems with mapping the fields. DB is mySQL 4.0. It is a simple table/bean "room" having only 2 fields, id and description, both varchar/string.
I execute the following command to capture the schema:
capture-schema -username user -password pwd -dburl
jdbc:mysql://localhost/ejb -driver com.mysql.jdbc.Driver -out room.dbschema -schemaname
ejb -table room
The following is printed and the schema file is generated:
using dburl: jdbc:mysql://localhost/ejb
using username: user
using password: pwd
using driver: com.mysql.jdbc.Driver
using schemaname: ejb
using output file: room.dbschema
Capturing schema: ejb
Schema captured
Saving schema ...
However when I load the room.dbschema file in the deployment tool, in Create Database Mappings, no mappings are found.
Any help?