Principals population during deployment

[tonno01]

I would like to know, if there is any way to create and populate the tables for the DatabaseLoginModule (Principals, Roles) during CMP EJB deployment on the JBoss server, and not before...

Hope anyone knows an answer.

Thanks,
Martin

[darranl]

The only solution that I can think of is to write an MBean that checks to see if initialisation has been performed after it has been deployed, if your app is not initialised then you can initialise the data in your tables.

[danl_thompson]

Yeah, but isn't there a chicken and egg here? if the CMP is secured, and the user isn't authenticated, how can the system check to see if he's in table, if the table is wrapped in a secure EJB?

dt

[darranl]

Direct JDBC access?

[danl_thompson]

Ah, of course, from the MBean.

[tonno01]

Hi, as i am pretty new to this stuff, can anyone give me some hint how this mbean is coded??

thanks a lot..
martin

[lretief]

To see how to code an MBean read the JBoss Admin and Developers Guide or the JMX Spec.

To get back to the original question, have you considered using your datasource to execute SQL? The datasource could be bundled in your deployment and thus it would be loaded at deploy time and you could piggy-back in the arbitrary sql you could specify to be excuted. Ugly but available...