cmp entity bean, does adding <cmp-field> require deleting ta

johnraz Dec 26, 2003 12:58 PM

I've bean able to create my entity bean, and now i want to add a new field, in this case an arraryList.

So, I added the ejb-jar

<cmp-field><field-name>fundArray</field-name></cmp-field>

the jboss-cmp

<cmp-field><field-name>fundArray</field-name><column-name>fundArray</column-name></cmp-field>

And modified my create method to pass and do a getFundArray, but I get this error

13:47:40,613 INFO [STDOUT] create RemoteException;EJBException:; nested exception is:
javax.ejb.EJBException: Load failed; CausedByException is:
Column not found: FUNDARRAY in statement [SELECT fundArray FROM FUNDMIXEREJB WHERE (name='myPortfolio')]
13:47:40,613 INFO [STDOUT] fundList size = 1

It appears to me that the previous generation which did not hava an "fundArray" column, needs to be deleted.

I tried removing all deployment files, jars wars.

How do I delete the table from CMP java:/DefaultDS DB.

THANKS!

1. Re: cmp entity bean, does adding <cmp-field> require deletin

adrian.brock Dec 29, 2003 4:16 AM (in response to johnraz)

If you have an older version jboss that allows tcp/ip connections to hsqldb
you can goto http://localhost:8080/jmx-console find the hypersonic mbean
the click startDatabaseManager.

Otherwise you have to re-instate remote access for hsqldb.

NOTE: it is bad to put hsqldb on an open port with the default user/password
for the system admin.
http://sourceforge.net/docman/display_doc.php?docid=19314&group_id=22866

Alternatively, write some simple code that connects java:/DefaultDS
and does "drop table whatever"

Regards,
Adrian
Actions