Sure, I've used them. They are just normal INTs or REALs depending on how
you declared them when you created the table. I'b be interested however
with how you get the next id, if you don't mind sharing
Fredrik...
On Thu, 25 May 2000, Brandon Campbell wrote:
> Fredrik,
>
> I have worked around the storage of the uniqueidentifier because I make get the next
>uniqueidentifer and then create the bean using CMP,
> but the exception below is thrown after the bean is stored and the bean is trying to
>retreive the newly stored data.
>
> It apears that the JdbcOdbc bridge may not translate this datatype correctly,
>
> Is anybody out there connecting to a MSSQL7 database that uses these
>uniqueidentifiers?
>
> If so how are you doing it?
>
> thanks in advance
>
> Brandon
>
> >>> Fredrik Borgh <[EMAIL PROTECTED]> 05/25/00 12:36PM >>>
> Hi Brandon!!!
>
> If you only read from the database, unique indentifiers shouldn't be a
> problem. Storage of the beans (using CMP) on the other hand is at the
> moment quite impossible. This is because the database produces the unique
> and there is currently no way that the EJB Server can retrieve that value.
>
> To this problem, there is one solution as I see it, rewrite a persistence
> manager yourself. This, however, takes *some* time. Then you can use the
> system variable @@identity (in MS SQL Server)J as return value of a stored
> procedure (so you would have to use stored procedures).
>
> Regards,
> Fredrik...
>
> On Thu, 25 May 2000, Brandon Campbell wrote:
>
> > I am having problems with a MSSQL datatype called uniqueidentifier. When the
>container-managed bean tries to retreive the bean the following exception is thrown.
> >
> > [JAWS] Load SQL:SELECT cat_master_flag,cat_ct_id,cat_id,cat_display_flag,cat_name
>FROM categories WHERE cat_id=?
> > at java.lang.reflect.Field.set(Native Method)
> > at
>org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.loadEntity(JAWSPersistenceManager.java:692)
> > at
>org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:240)
> > at
>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:82)
> > at
>org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:88)
> > at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:151)
> > at
>org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:129)
> > at java.lang.reflect.Method.invoke(Native Method)
> > at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
> > at sun.rmi.transport.Transport$1.run(Unknown Source)
> > at java.security.AccessController.doPrivileged(Native Method)
> > at sun.rmi.transport.Transport.serviceCall(Unknown Source)
> > at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
> > at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
> > at java.lang.Thread.run(Unknown Source)
> > [Default] java.rmi.ServerException: Load failed; nested exception is:
> >
> >
> > When I use JDBC and do a select statement I have to use the convert() function to
>get a String object.
> >
> > I need to know if I can do any of the following
> >
> > 1. Modify the select statement that JAWS produces?
> > 2. Workaround this weird datatype?
> >
> > Any help would be appreciated.
> >
> > Thanks
> >
> > Brandon Campbell
> >
>
>
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
