websphere - How do I write a JPA primary key generator that will work for several databases and several app servers? -


i'm on project (java/ejb/jpa swing client) deployed several different app servers , supports several different databases. application required run on combination of following servers , databases:

servers: - glassfish - jboss - websphere (was)  databases: - oracle - mysql - microsoft sql server

is there 1 way generate primary key using jpa work in of these environments. have tried number of different strategies , have gotten farthest using annotation in jpa entity class:

@id @column( name = "id" ) @tablegenerator(          name = "appseqstore",          table = "app_seq_store",          pkcolumnname = "app_seq_name",          pkcolumnvalue = "listener_pk",          valuecolumnname = "app_seq_value",          initialvalue = 1,          allocationsize = 1 ) @generatedvalue( strategy = generationtype.table, generator = "appseqstore" )

and table in database:

create table app_seq_store (     app_seq_name varchar(255) not null,     app_seq_value number(10) not null,     primary key(app_seq_name) )  insert app_seq_store values ('listener_pk', 0)

this works in oracle, , ms sql server, , mysql using jboss app server. in other words works of databases i've tried using jboss.

this not work in webspehere (was 8.5.5.2) , gives following exception (oracle database in case):

[4/24/15 22:29:17:339 edt] 00000079 businessexcep e   cntr0020e: ejb threw unexpected (non-declared) exception during invocation of method "addnewlistenertarget" on bean "beanid(myappwas#myappserverejb.jar#listenerdaoejb, null)". exception data: java.lang.unsupportedoperationexception            @ org.hibernate.service.jta.platform.internal.websphereextendedjtaplatform$transactionmanageradapter.setrollbackonly(websphereextendedjtaplatform.java:139)            @ org.hibernate.ejb.abstractentitymanagerimpl.markasrollback(abstractentitymanagerimpl.java:1169)            @ org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1319)            @ org.hibernate.ejb.abstractentitymanagerimpl.persist(abstractentitymanagerimpl.java:881)            @ com.ibm.ws.jpa.management.jpaexeminvocation.persist(jpaexeminvocation.java:317)            @ com.ibm.ws.jpa.management.jpaentitymanager.persist(jpaentitymanager.java:143)            @ com.apelon.server.ejb.listenerdaobean.addnewlistenertarget(listenerdaobean.java:243)            @ com.apelon.server.dao.remote.ejsremote0sllistenerdaoejb_446f2106.addnewlistenertarget(ejsremote0sllistenerdaoejb_446f2106.java)            @ com.apelon.server.dao.remote._ejsremote0sllistenerdaoejb_446f2106_tie.addnewlistenertarget(_ejsremote0sllistenerdaoejb_446f2106_tie.java:1)            @ com.apelon.server.dao.remote._ejsremote0sllistenerdaoejb_446f2106_tie._invoke(_ejsremote0sllistenerdaoejb_446f2106_tie.java)            @ com.ibm.corba.iiop.serverdelegate.dispatchinvokehandler(serverdelegate.java:678)            @ com.ibm.corba.iiop.serverdelegate.dispatch(serverdelegate.java:525)            @ com.ibm.rmi.iiop.orb.process(orb.java:616)            @ com.ibm.corba.iiop.orb.process(orb.java:1581)            @ com.ibm.rmi.iiop.connection.dorequestwork(connection.java:3160)            @ com.ibm.rmi.iiop.connection.dowork(connection.java:3030)            @ com.ibm.rmi.iiop.workunitimpl.dowork(workunitimpl.java:64)            @ com.ibm.ejs.oa.pool.pooledthread.run(threadpool.java:118)            @ com.ibm.ws.util.threadpool$worker.run(threadpool.java:1864)


Comments

Post a Comment

Popular posts from this blog

asp.net mvc - SSO between MVCForum and Umbraco7 -

i need integrate sso between mvcforum (forum of company) , umbraco7 (manages cms company). however struggling shared authentication work. tried several ways suggested on other threads still not running expected. here did: 1. in mvcforum (forum.mywebsite.com) 1.1. machine key in web.xml: <machinekey validationkey="the same key umbraco7" decryptionkey="the same key umbraco7" validation="sha1" decryption="aes" /> 1.2. authenticate forms in web.xml <forms name="my-sso-auth" protection="all" path="/" timeout="43200" domain="forum.mywebsite.com" loginurl="/members/logon" enablecrossappredirects="true" /> 2. in umbraco7 (news.mywebsite.com) 2.1. machine key in web.xml: <machinekey validationkey="the same key mvcforum" decryptionkey="the same key mvcforum" validation="sha1" decryption="aes" /> 2.2. a
Read more

Python Tkinter keyboard using bind -

i have problem using bind option can click button in keyboard, , call function once key pressed. tried taking other codes have similar purpose , saw i'm doing pretty same, though still have problem must've missed. thankful if me this. here's code: # -*- coding: utf-8 -*- #imports tkinter import * pil import imagetk, image import time import tkmessagebox #===========================================================================================================================================# #tkinter class class app(frame): def __init__(self, master=none): frame.__init__(self, master) self.pack() #===========================================================================================================================================# #game pieces classes class board: def __init__(self, rows = 7, columns = 6, picture_height = none, picture_width = none): self.rows = rows self.columns = columns self.picture
Read more

ubuntu - Selenium Node Not Connecting to Hub, Not Opening Port -

i'm trying set demo selenium grid. have digital ocean ubuntu 14.02 droplet. (i have 2 , tried set using 2 different machines got nowhere.) i'm trying run hub , node both locally. here input both hub, node, , nmap results. https://gist.github.com/mekhami/d5bbecca5ff0de9d2dc9 so, node starting tcp connection reset , port it's supposed operate on closed. i have had no luck in number of different options , configurations work. but... of course, worked randomly once. don't know why, don't know did, know 1 brief moment, node connected , saw on grid console. tried run test , went down again , i've never seen come up. please let me know more information can provide. update: randomly came online again. don't know happened, might related timeout or time_wait or going on. this because vm/server not have enough entropy available. to resolve problem, install haveged (or other similar things). the instructions of how install haveged on ubu
Read more