7.2 jbosscmp-jdbc.xml appears incomplete

[wpfeiffe]

The 7.2 example/deployment seems to be missing the mapping for the ShipEJB to the Ship table and ALL relationship mappings in the jbosscmp-jdbc.xm file. Am I missing something?

TIA,

Bill Pfeiffer

[bill.burke]

JBoss CMP 2.0 does not need a mapping. By default, it will create all db tables. The default datasource used is defined in jboss-3.0.x/server/default/conf/standardjbosscmp-jdbc.xml

JBoss ships with HypersonicSQL. This is an embedded Java relational DB and the default datasource (java:/DefaultDS)

[wpfeiffe]

I'm using Postgres as the default to do the samples, but otherwise my setup is pretty much like the Hypersonic setup. When reading through the book I was creating the tables as specified by the book.

It occurs to me now, that if I just deployed the sample without creating the tables myself via SQL, they would have worked out of the box. Some of the table names would have been a little different than the book but I guess it would have worked?! Is this correct?

In the very least, I learned how to use the relationship mapping from the JBoss perspective. I assume I will need to know this stuff when using CMR with my legacy Oracle database. Correct?

Thanks for your help with this!

[slaboure]

> I'm using Postgres as the default to do the samples,
> but otherwise my setup is pretty much like the
> Hypersonic setup. When reading through the book I
> was creating the tables as specified by the book.

ok.

> It occurs to me now, that if I just deployed the
> sample without creating the tables myself via SQL,
> they would have worked out of the box. Some of the
> table names would have been a little different than
> the book but I guess it would have worked?! Is this
> correct?

exactly.

> In the very least, I learned how to use the
> relationship mapping from the JBoss perspective. I
> assume I will need to know this stuff when using CMR
> with my legacy Oracle database. Correct?

yes, it will be your job to map the JBoss CMP stuff over your legacy schema. Sometimes, tricky mappings are not possible and may be a problem for your project. JBoss 4.0 will allow for much more flexible mappings though.

Cheers,


sacha

[jdsrinivas]

hi sacha iam from finland , can u give me ur email id so that we discuss abt the things , here is my id:
[e-mail]

cheers

JD

[slaboure]

Hello JD,

I suggest you keep posting to the forums so that our discussion can be shared with other readers.

Cheers,


sacha

[h45678]

"wpfeiffe" wrote:
The 7.2 example/deployment seems to be missing the mapping for the ShipEJB to the Ship table and ALL relationship mappings in the jbosscmp-jdbc.xm file. Am I missing something?

TIA,

Bill Pfeiffer