Sybase ASE + Jboss

pablojavierpy Oct 20, 2004 6:52 AM

Has someone been using JBOSS + Sybase ASE in production environments?

I have searched, but haven't found much information about this combination y JBOSS's forums.

I wanted to use these technologies to deploy an application I am developing, but, I am not sure about it.

-> what about IDENTIY/auto-increment primary keys?
-> what about transactions under heavy loads?

This two issues, apparently are unresolved....

Any ideas from JBOSS developers?

Should I stick to a more open database like PostgreSQL?

Thanks in advance.

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.
Actions
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.
Actions

Go to original post