[JBoss-user] [Persistence CMP/JBoss] - Re: Auto-increment Pickle
are you by chance using postgres as your database? View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3839728#3839728 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3839728 --- This SF.Net email sponsored by Black Hat Briefings Training. Attend Black Hat Briefings Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Re: Auto-increment Pickle
jae77 wrote : are you by chance using postgres as your database? No, my testbed is MySQL, but I want to make this app database independent. Well, any database that supports auto-increment that is. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3839730#3839730 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3839730 --- This SF.Net email sponsored by Black Hat Briefings Training. Attend Black Hat Briefings Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Re: Auto-increment Pickle
You need to add somehting similiar to this to the bean level xdoclet tag, these are the settings for postgres, I do not think there is an entirely database independent way to do this: @jboss.unknown-pk class=java.lang.Integer auto-increment=true jdbc-type=INTEGER sql-type=SERIAL @jboss.entity-command name=postgresql-fetch-seq Hope this helps, Mark View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3839733#3839733 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3839733 --- This SF.Net email sponsored by Black Hat Briefings Training. Attend Black Hat Briefings Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Re: Auto-increment Pickle
i see what the problem is now, you're missing the @jboss.entity-command tag that will be used to generate the primary key. millerm1 is also correct w/ the settings for postgres. you're best bet is going to be to define the jdbc-type, sql-type, and entity-command as ant properties ${xxx} and then let the build process substitute them based upon the database you are using. also, if you plan to have foreign key relationships in the database (and you are using postgres) there are some other little nasties you have to deal w/ as well. check out this wiki page http://www.jboss.org/wiki/Wiki.jsp?page=NukesPureCMP it's primarily nukes specific, but does cover the postgres problems that you will encounter should be helpful in that reguard. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3839737#3839737 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3839737 --- This SF.Net email sponsored by Black Hat Briefings Training. Attend Black Hat Briefings Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Re: Auto-increment Pickle
Thank you both. I will definately look into this possible fix as well. I may end up just coding some session beans and taking all of this pk generation away from the RDBMS. This will allow me to both control the recylcling of these primary keys when records are purged off, as well as allow me to distribute a single .ear file with several -ds.xml files as a binary distro, instead of using the ant props. Allowing people a drop-in installation. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3839745#3839745 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3839745 --- This SF.Net email sponsored by Black Hat Briefings Training. Attend Black Hat Briefings Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user