-
1. Re: Optional OneToOne not honoured on SQL Server 2005
ejb3workshop Apr 27, 2006 9:33 AM (in response to ejb3workshop)The same occurs using the JTDS Driver (jtds-1.2-dist.zip).
-
2. Re: Optional OneToOne not honoured on SQL Server 2005
ejb3workshop Apr 28, 2006 5:41 AM (in response to ejb3workshop)I found this article on the web, which shed some light on the problem. Seems like a bug (aka feature) of SQL Server.
http://www.sqlmag.com/Article/ArticleID/25259/sql_server_25259.html
and
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=48614 -
3. Re: Optional OneToOne not honoured on SQL Server 2005
ejb3workshop Apr 28, 2006 5:49 AM (in response to ejb3workshop)This might also be of interest
http://groups.google.co.uk/group/microsoft.public.sqlserver.server/browse_thread/thread/e4a0d0f81f4ef42/7d9c3c9461435c9e?lnk=st&q=%22SQL+Server%22+Unique+Key+constraint+NULL&rnum=5&hl=en#7d9c3c9461435c9e
It seesm pretty clear to be isolated to SQL Server, so not strickly speaking related to this forum. Yet in the context of EJB3 this poses a (significant) limitation. The freedom achieved with EJB3 entities is restricted and this is a problem which should be relevant to this forum.
Alex
ejb3workshop.com