[JBoss-user] [Persistence CMP/JBoss] - Re: Sybase ASE + Jboss

[kabkhan]

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):
anonymous wrote : 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.


View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3852038#3852038

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3852038


---
This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
Use IT products in your business? Tell us what you think of them. Give us
Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

[JBoss-user] [Persistence CMP/JBoss] - Re: Sybase ASE + Jboss

[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=bbop=viewtopict=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=bbop=viewtopict=55410
http://www.jboss.org/index.html?module=bbop=viewtopict=54569
http://www.jboss.org/index.html?module=bbop=viewtopict=27937


Thanks again

Cheers.



View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=3852046#3852046

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3852046


---
This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
Use IT products in your business? Tell us what you think of them. Give us
Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user