From: Max R. A. <ma...@eo...> - 2002-11-02 14:55:32
|
As seen in http://sourceforge.net/forum/message.php?msg_id=1718579 it is actually possible to have MSSQL support that a has only a single identity column which is the case in many of the JUnit tests, but.... I've looked into the query generation and I don't see any calls to the Dialect for generating the sql insert string, thus I don't now exactly where to detect and then modify the sql string accordingly when it is needed to do a "insert into foo default values;" instead of "insert into foo values ();" (which is the sql currently generated) Can someone? ;) /max |
From: Gavin K. <ga...@ap...> - 2002-11-02 15:07:13
|
I wanna leave this 'til after we have a proper SQL statement hierarchy; which I would like to get done ASAP and am considering spinning off as a new project. ----- Original Message ----- From: "Max Rydahl Andersen" <ma...@eo...> To: <hib...@li...> Sent: Sunday, November 03, 2002 1:55 AM Subject: [Hibernate] Single Identity column support for MSSQL ? > As seen in http://sourceforge.net/forum/message.php?msg_id=1718579 it is > actually possible to have MSSQL support that a has only a single identity > column which is the > case in many of the JUnit tests, but.... > > I've looked into the query generation and I don't see any calls to the > Dialect for generating the sql insert string, thus > I don't now exactly where to detect and then modify the sql string > accordingly when it is needed to do a "insert into foo default values;" > instead of "insert into foo values ();" (which is the sql currently > generated) > > Can someone? ;) > > /max > > > > > ------------------------------------------------------- > This sf.net email is sponsored by: See the NEW Palm > Tungsten T handheld. Power & Color in a compact size! > http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en > _______________________________________________ > hibernate-devel mailing list > hib...@li... > https://lists.sourceforge.net/lists/listinfo/hibernate-devel |
From: Gavin K. <ga...@ap...> - 2002-11-02 15:17:09
|
Yep, you got it. But if you are going to do it anyway, I suppose you might as well submit a patch.... ----- Original Message ----- From: "Max Rydahl Andersen" <ma...@eo...> To: "Gavin King" <ga...@ap...> Sent: Sunday, November 03, 2002 2:13 AM Subject: Re: [Hibernate] Single Identity column support for MSSQL ? > - bummer :( > > It would just make my testing much easier if I could run (almost) all tests > on my mssql server. > > Well - i'll try to live without... > > IF I try to make my own local copy of hibernate generate "good" mssql sql > have I understood it correctly that it > is only in the generateInsertString of EntityPersister that there need to be > some changes ? > > AND the specific mssql stuff should only be activated when identiyString == > true && propertyColumns == false , or ? > > /max > > ----- Original Message ----- > From: "Gavin King" <ga...@ap...> > To: "Max Rydahl Andersen" <ma...@eo...> > Cc: "hibernate list" <hib...@li...> > Sent: Saturday, November 02, 2002 4:06 PM > Subject: Re: [Hibernate] Single Identity column support for MSSQL ? > > > > I wanna leave this 'til after we have a proper SQL statement hierarchy; > > which I would like to get done ASAP and am considering spinning off as a > new > > project. > > > > ----- Original Message ----- > > From: "Max Rydahl Andersen" <ma...@eo...> > > To: <hib...@li...> > > Sent: Sunday, November 03, 2002 1:55 AM > > Subject: [Hibernate] Single Identity column support for MSSQL ? > > > > > > > As seen in http://sourceforge.net/forum/message.php?msg_id=1718579 it is > > > actually possible to have MSSQL support that a has only a single > identity > > > column which is the > > > case in many of the JUnit tests, but.... > > > > > > I've looked into the query generation and I don't see any calls to the > > > Dialect for generating the sql insert string, thus > > > I don't now exactly where to detect and then modify the sql string > > > accordingly when it is needed to do a "insert into foo default values;" > > > instead of "insert into foo values ();" (which is the sql currently > > > generated) > > > > > > Can someone? ;) > > > > > > /max > > > > > > > > > > > > > > > ------------------------------------------------------- > > > This sf.net email is sponsored by: See the NEW Palm > > > Tungsten T handheld. Power & Color in a compact size! > > > http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en > > > _______________________________________________ > > > hibernate-devel mailing list > > > hib...@li... > > > https://lists.sourceforge.net/lists/listinfo/hibernate-devel > > > > |
From: Max R. A. <ma...@eo...> - 2002-11-02 16:27:05
|
> Yep, you got it. But if you are going to do it anyway, I suppose you might > as well submit a patch.... Yeah - I guess I could - so I did :) Now I can almost run all junit-tests on MSSQl. /max > ----- Original Message ----- > From: "Max Rydahl Andersen" <ma...@eo...> > To: "Gavin King" <ga...@ap...> > Sent: Sunday, November 03, 2002 2:13 AM > Subject: Re: [Hibernate] Single Identity column support for MSSQL ? > > > > - bummer :( > > > > It would just make my testing much easier if I could run (almost) all > tests > > on my mssql server. > > > > Well - i'll try to live without... > > > > IF I try to make my own local copy of hibernate generate "good" mssql sql > > have I understood it correctly that it > > is only in the generateInsertString of EntityPersister that there need to > be > > some changes ? > > > > AND the specific mssql stuff should only be activated when identiyString > == > > true && propertyColumns == false , or ? > > > > /max > > > > ----- Original Message ----- > > From: "Gavin King" <ga...@ap...> > > To: "Max Rydahl Andersen" <ma...@eo...> > > Cc: "hibernate list" <hib...@li...> > > Sent: Saturday, November 02, 2002 4:06 PM > > Subject: Re: [Hibernate] Single Identity column support for MSSQL ? > > > > > > > I wanna leave this 'til after we have a proper SQL statement hierarchy; > > > which I would like to get done ASAP and am considering spinning off as a > > new > > > project. > > > > > > ----- Original Message ----- > > > From: "Max Rydahl Andersen" <ma...@eo...> > > > To: <hib...@li...> > > > Sent: Sunday, November 03, 2002 1:55 AM > > > Subject: [Hibernate] Single Identity column support for MSSQL ? > > > > > > > > > > As seen in http://sourceforge.net/forum/message.php?msg_id=1718579 it > is > > > > actually possible to have MSSQL support that a has only a single > > identity > > > > column which is the > > > > case in many of the JUnit tests, but.... > > > > > > > > I've looked into the query generation and I don't see any calls to the > > > > Dialect for generating the sql insert string, thus > > > > I don't now exactly where to detect and then modify the sql string > > > > accordingly when it is needed to do a "insert into foo default > values;" > > > > instead of "insert into foo values ();" (which is the sql currently > > > > generated) > > > > > > > > Can someone? ;) > > > > > > > > /max > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > This sf.net email is sponsored by: See the NEW Palm > > > > Tungsten T handheld. Power & Color in a compact size! > > > > http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en > > > > _______________________________________________ > > > > hibernate-devel mailing list > > > > hib...@li... > > > > https://lists.sourceforge.net/lists/listinfo/hibernate-devel > > > > > > > > > > ------------------------------------------------------- > This sf.net email is sponsored by: See the NEW Palm > Tungsten T handheld. Power & Color in a compact size! > http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en > _______________________________________________ > hibernate-devel mailing list > hib...@li... > https://lists.sourceforge.net/lists/listinfo/hibernate-devel > |