Hi,
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".
