remove-table = true won't work, where's the HS Manager, Plea

[johnraz]

I've done my homework, paid the 10$, read the docs, searched the faq's, but I've spent six hours on this, and ....

I created an entity bean with remove-table = true, but after adding new column, I get :

on startup :

[EjbModule] Deploying FundMixerEJB
[FundMixerEJB] Table 'FUNDMIXEREJB' already exists

trying to access or remove() bean

15:26:35,981 INFO [STDOUT] create RemoteException; EJBException:; nested exception is:
javax.ejb.EJBException: Load failed; CausedByException is:
Column not found: FUNDS in statement [SELECT funds FROM FUNDMIXEREJB WHERE (name='myPortfolio')]

I've tried to configure hsqldb-ds.xml, did a startDatabaseManager(), then what?

Why isn't the table getting removed?

Where is the hs manager where I can enter sql ?

Thanks !

[johnraz]

OK, Found a post describing the HS Manager

Now trying to connect to HS using port 1476 I get refused

Anyone know if jdbc:hsqldb:hsql://localhost:1476 is correct, or where this property is set ?

[johnraz]

For the Benefit on anyone behind me,

you need to not only set the remove-table element in the projects jbosscmp-jdbc.xml, but in the server/default/conf dir also

standardjbosscmp-jdbc.xml
standardjaws.xml

gotta love that JBoss Doc!!