I have a JDBC driver which connects to MSSQL server 2005. I have
workforceID as the primary key. There are scenarios where the
workforceID of the user changes. I would like to handle it as follows:

When a workforceID is changed, I wanted it to get updated and
also the association of the User should be updated with the current
workforceID. But the latter does not happen. The driver by default
allows the primary key to be changed only once (Because the association
does not get updated with the new workforceID). Can someone suggest ways
to handle this? I think this should be one of the typical scenarios that
many should have faced.

Thanks in Advance.

GopinathRao's Profile: http://forums.novell.com/member.php?userid=62050
View this thread: http://forums.novell.com/showthread.php?t=451431