-
1. Re: Sybase ASE + Jboss
kabirkhan Oct 20, 2004 7:29 AM (in response to pablojavierpy)You can use any database you like...
Jboss comes with an example datasource config for sybase, in sybase-ds.xml the docs/examples/jca folder.
For primary key generation, from the documentation (see free docs, chapter 11.19):sybase-fetch-key: (org.jboss.ejb.plugins.cmp.jdbc.sybase.JDBCSybaseCreateCommand) The JDBCSybaseCreateCommand
executes an INSERT INTO query after executing a SELECT @@IDENTITY statement to
fetch the generated key. -
2. Re: Sybase ASE + Jboss
pablojavierpy Oct 20, 2004 8:36 AM (in response to pablojavierpy)Hi Kabkhan.
First of all, thanks for the quick reply.
Two things:
1) I have read, that if you use JBOSS+Sybase, you might experience transaction logs and sutff. So I don't think "any database you like" applies here.
Please refer the following posts:
http://www.jboss.org/index.html?module=bb&op=viewtopic&t=54135
2) "sybase-fetch-key" is for retrieve the generated key. But, since there is no auto-increment template in Sybase datasource mapping configuration in standardjbosscmp-jdbc.xml, I don't know how to tell container to create table with IDENTITY column needed by "sybase-fetch-key" entity command.
Please refer the following posts:
http://www.jboss.org/index.html?module=bb&op=viewtopic&t=55410
http://www.jboss.org/index.html?module=bb&op=viewtopic&t=54569
http://www.jboss.org/index.html?module=bb&op=viewtopic&t=27937
Thanks again!!!!
Cheers.