OK, thanks Dave. I have carboned Dan O'Conner in case he cares to comment.
He knows the specs quite well and yes, its MVC Soft generated code. I was
under the impression that the EJB container should throw that exception,
but prehaps that only applies to CMP.
For now, I am just calling findByPrimaryKey() before I call create. Its
some extra overhead, but whatever keeps me moving at this point is
acceptable, if not optimal.
As for the list, no, I have not received anything either. Also, my mail to
the list is still sitting in my mail servers outbound queue. It is
definately down. :-(
Thanks again!
Jim
--On Sunday, March 04, 2001 4:51 PM -0600 David Castro Diephouse
<[EMAIL PROTECTED]> wrote:
> jim- Looks like this is a problem in your BMP code (or is it generated
> code?). If you were using jaws, it would do a query to find out if the PK
> exists, and throw a DKE. I assume that you are not really doing BMP
> yourself, but that you are using mvcsoft. Whoever is writing the BMP code
> should be throwing the DKE, and obviously is not. I dont really see how
> it could happen without an explicit check: it would be ugly to try to
> tell from the text of the SQLException what the error was.
>
> BTW - have you been getting msgs from the mailing list? I havent seen
> anything since friday night.
>
> Jim Archer wrote:
>
>> Hi Dave...
>>
>> Thats what I thought. When I try that, I don't ever seem to catch a
>> DuplicateKeyException. Rather, I catch a CreateException. Here is the
>> code I wrote and the log excerpt. You can se the exception thrown by
>> Hypersonic when the key is a dupe and then you can see the
>> CreateException caught by my code. There is no evidence that I ever
>> caught the DuplicateKeyException.
>>
>> Am I doing somethign wrong?
>>
>> Thanks again... Your a fountain of information and a huge help!
>>
>> Jim
>>
>> try
>> {
>> uar = home.create(regUar, lidr, cr);
>> }
>> catch(DuplicateKeyException e)
>> {
>> tr.print("DuplicateKeyException while creating UAR record: " +
>> e.getMessage());
>> throw new RnDuplicateUarException("The UAR ID " +
>> regUar.getTag().toString() + " already
>> exists"); }
>> catch(CreateException e)
>> {
>> tr.print("Create Exception while creating UAR record: " +
>> e.getMessage()); return null;
>> }
>> catch(RemoteException e)
>> {
>> tr.print("RE:System/communication error: " + e.getMessage());
>> return null;
>> }
>>
>> [CreateNewUARSlsb] CreateNewUarBean Sat Mar 03 19:33:25 EST 2001 Calling
>> createUarEb()
>> [CreateNewUARSlsb] CreateNewUarBean Sat Mar 03 19:33:25 EST 2001 method
>> createUarEb() entered
>> [UarEntity] UarEJB Sat Mar 03 19:33:26 EST 2001 ejbCreate() entered
>> [UarEntity] UarEJB Sat Mar 03 19:33:26 EST 2001 Primary key set to:
>> UAR:JARCHER:S
>> [UarEntity] UarEJB Sat Mar 03 19:33:26 EST 2001 ejbCreate() exited
>> [UarEntity] java.sql.SQLException: Violation of unique index in statement
>> [insert into UarEntity (uarTagName, personal, endUser, entityName,
>> accountName, addr1, addr2, addr3, city, state, postalCode, countryCode,
>> phone, fax, dateAdded, dateLastMod) values ('UAR:JARCHER:S', TRUE, TRUE,
>> 'Processing Innovations, LLC', 'JARCHER', '10 Crestview Drive', 'Address
>> Line 2', 'Address Line 3', 'Greenville', 'RI', '02828', 'USA',
>> '401-949-4768', '401-949-5814', '2001-03-03', '2001-03-03')]
>> [UarEntity] at org.hsql.Trace.getError(Trace.java:124)
>> [UarEntity] at org.hsql.Result.<init>(Result.java:70)
>> [UarEntity] at
>> org.hsql.jdbcConnection.executeHSQL(jdbcConnection.java:644) [UarEntity]
>> at org.hsql.jdbcConnection.execute(jdbcConnection.java:540) [UarEntity]
>> at org.hsql.jdbcStatement.fetchResult(jdbcStatement.java:499)
>> [UarEntity] at
>> org.hsql.jdbcStatement.executeUpdate(jdbcStatement.java:52) [UarEntity]
>> at
>> org.hsql.jdbcPreparedStatement.executeUpdate(jdbcPreparedStatement.java:
>> 114) [UarEntity] at
>> org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(Prepare
>> dSt atementInPool.java:82)
>> [UarEntity] at com.regtek.eb20.ImplUarEJB.insert(ImplUarEJB.java:803)
>> [UarEntity] at
>> com.regtek.eb20.ImplUarEJB.ejbCreate(ImplUarEJB.java:217) [UarEntity]
>> at java.lang.reflect.Method.invoke(Native Method) [UarEntity] at
>> org.jboss.ejb.plugins.BMPPersistenceManager.createEntity(BMPPersistenceM
>> ana ger.java:121)
>> [UarEntity] at
>> org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:441)
>> [UarEntity] at java.lang.reflect.Method.invoke(Native Method)
>> [UarEntity] at
>> org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityCont
>> ain er.java:639)
>> [UarEntity] at
>> org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(Entity
>> Syn chronizationInterceptor.java:160)
>> [UarEntity] at
>> org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanc
>> eIn terceptor.java:87)
>> [UarEntity] at
>> org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:
>> 135) [UarEntity] at
>> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor
>> CMT .java:264)
>> [UarEntity] at
>> org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:
>> 86) [UarEntity] at
>> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor
>> .ja va:119)
>> [UarEntity] at
>> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
>> [UarEntity] at
>> org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316)
>> [UarEntity] at
>> org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPCo
>> nta inerInvoker.java:421)
>> [UarEntity] at
>> org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:19
>> 8) [UarEntity] at $Proxy21.create(Unknown Source)
>> [UarEntity] at
>> com.regtek.slsb.CreateNewUARBean.createUarEb(CreateNewUARBean.java:285)
>> [UarEntity] at
>> com.regtek.slsb.CreateNewUARBean.makeNew(CreateNewUARBean.java:86)
>> [UarEntity] at java.lang.reflect.Method.invoke(Native Method)
>> [UarEntity] at
>> org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Stat
>> ele ssSessionContainer.java:472)
>> [UarEntity] at
>> org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(Statele
>> ssS essionInstanceInterceptor.java:87)
>> [UarEntity] at
>> org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:
>> 133) [UarEntity] at
>> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor
>> CMT .java:459)
>> [UarEntity] at
>> org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
>> [UarEntity] at
>> org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav
>> a:1 37)
>> [UarEntity] at
>> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
>> [UarEntity] at
>> org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer
>> .ja va:271)
>> [UarEntity] at
>> org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContai
>> ner Invoker.java:381)
>> [UarEntity] at
>> org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContai
>> ner Invoker.java:452)
>> [UarEntity] at
>> org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.invoke(State
>> les sSessionProxy.java:152)
>> [UarEntity] at $Proxy18.makeNew(Unknown Source)
>> [UarEntity] at
>> com.regtek.protocol_servlets.MakeUAR.doPost(MakeUAR.java:137)
>> [UarEntity] at
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:760) [UarEntity]
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>> [UarEntity] at
>> org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
>> [UarEntity] at
>> org.apache.tomcat.core.Handler.service(Handler.java:286) [UarEntity]
>> at
>> org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
>> [UarEntity] at
>> org.apache.tomcat.core.ContextManager.internalService(ContextManager.jav
>> a:7 97)
>> [UarEntity] at
>> org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
>> [UarEntity] at
>> org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(H
>> ttp ConnectionHandler.java:210)
>> [UarEntity] at
>> org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
>> [UarEntity] at
>> org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:49
>> 8) [UarEntity] at java.lang.Thread.run(Unknown Source)
>> [CreateNewUARSlsb] CreateNewUarBean Sat Mar 03 19:33:26 EST 2001 Create
>> Exception while creating UAR record: null
>> [CreateNewUARSlsb] CreateNewUarBean Sat Mar 03 19:33:26 EST 2001 Back
>> from createUarEb()
>>
>> --On Saturday, March 03, 2001 8:16 AM -0600 David Castro Diephouse
>> <[EMAIL PROTECTED]> wrote:
>>
>> > Jim - javax.ejb.DuplicateKeyException is defined by spec, just create
>> > and check for that
>> >
>> > Jim Archer wrote:
>> >
>> >> Hi All...
>> >>
>> >> I have what must be a fairly common problem and I was wondering if
>> >> someone could suggest what they think the preferred solution might be.
>> >>
>> >> I need to create an EB for a user and I have set the userid up as a
>> >> primary jey. Of course, the user ID must be unique. I'm wondering what
>> >> the best way to detect that a new user has picked an unavailable user
>> >> ID.
>> >>
>> >> First, I could just try to create the EB and catch a create exception.
>> >> The downside to this seems to be that if I get a create exception I
>> >> don't know for sure it was created sue to a non-unique key field
>> >> without looking at the message text that might vary accross servers.
>> >> So it seems that I can only know that there was some problem.
>> >>
>> >> The next option is to use the finder for primary key and see if I get
>> >> a record back. This would answer the question but seems like extra
>> >> overhead to introduce. Also, it would result in a FinderException
>> >> when the userID is unique and I don't know if that will roll back the
>> >> transaction I'm in or not. Of course, I have to check for existance
>> >> and add the new one in the same transaction.
>> >>
>> >> Is there a third option? I would appreciate any suggestions!
>> >>
>> >> Thanks lots!
>> >>
>> >> Jim
>> >>
>> >> ********************************************
>> >> I shall be telling this with a sigh
>> >> Somewhere ages and ages hence:
>> >> Two roads diverged in a wood, and I -
>> >> I took the one less traveled by,
>> >> And that has made all the difference.
>> >>
>> >> - Robert Frost, 1916
>> >>
>> >> --
>> >> --------------------------------------------------------------
>> >> To subscribe: [EMAIL PROTECTED]
>> >> To unsubscribe: [EMAIL PROTECTED]
>>
>> ********************************************
>> I shall be telling this with a sigh
>> Somewhere ages and ages hence:
>> Two roads diverged in a wood, and I -
>> I took the one less traveled by,
>> And that has made all the difference.
>>
>> - Robert Frost, 1916
********************************************
I shall be telling this with a sigh
Somewhere ages and ages hence:
Two roads diverged in a wood, and I -
I took the one less traveled by,
And that has made all the difference.
- Robert Frost, 1916
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
