> Hi,
>
[Resend - not sure if this is working]
> Sorry if this is vendor specific, but it's an odd one in a not very odd
> combination :
>
> Environment : IAS 4.0, SQL Server 7, NT
>
> I have a legacy DB we're wrapping with EJB's etc - C/S -> n-Tier
>
> The DB has a PK on each table which has the (SQLServer specific?) keyword
> 'IDENTITY' attached to it. My understanding of this is that it creates a
> new PK for every insert - which is actually kinda neat as it circumvents
> the need to generate one ourselves.
>
> The problem I have is that IAS, when using CMP, generates code to insert a
> (null - because it doesn't have a value) value into the PK - but SQL
> Server doesn't like this and throws an Exception. This (sort of) makes
> sense as the CMP will not know about the IDENTITY thing and assume we know
> what we're doing with the PK from within the bean.
>
> I'm currently waiting for Inprise to come back on this, but I wondered if
> anyone had run across this before (or had any suggestions).
>
> I can't turn off the IDENTITY as other apps update the DB, and I really
> don't want to go to BMP as it fits nicely into CMP otherwise. Can I 'hide'
> the field from the CMP somehow?
>
> Thanks in advance
>
> tim
This e-mail, and any attachment, is confidential. If you have received it in error,
please delete it from your system, do not use or disclose the information in any way,
and notify me immediately. The contents of this message may contain personal views
which are not the views of the BBC, unless specifically stated.
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
