nhibernate-issues Mailing List for NHibernate (Page 371)

Brought to you by: ayenderahien, bahusoid, fabiomaulo, fdelaporte, and 5 others

nhibernate-issues — Updates to JIRA issues are sent to this list

You can subscribe to this list here.

2006	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct (110)	Nov (296)	Dec (107)
2007	Jan (212)	Feb (263)	Mar (161)	Apr (183)	May (183)	Jun (75)	Jul (106)	Aug (88)	Sep (227)	Oct (143)	Nov (154)	Dec (53)
2008	Jan (77)	Feb	Mar	Apr (6)	May (103)	Jun (296)	Jul (54)	Aug	Sep (379)	Oct (283)	Nov (224)	Dec (214)
2009	Jan (129)	Feb (257)	Mar (136)	Apr (12)	May (329)	Jun (434)	Jul (375)	Aug (171)	Sep	Oct	Nov	Dec (54)
2010	Jan (198)	Feb (76)	Mar (3)	Apr (1)	May	Jun (62)	Jul (210)	Aug (447)	Sep (330)	Oct (257)	Nov (133)	Dec (453)
2011	Jan (240)	Feb (128)	Mar (442)	Apr (320)	May (428)	Jun (141)	Jul (13)	Aug	Sep	Oct	Nov	Dec

Flat | Threaded

<< < 1 .. 369 370 371 372 373 .. 390 > >> (Page 371 of 390)

[nhibernate-issues] [JIRA] Commented: (NH-838) nosetter access strategy on <version> tag causes incorrect dirty check result

From: NHibernate J. <mik...@us...> - 2007-01-02 09:30:28

     [ http://jira.nhibernate.org/browse/NH-838?page=comments#action_14700 ]
     
Sergey Koshcheyev commented on NH-838:
--------------------------------------

Please supply a simple test case.

> nosetter access strategy on <version> tag causes incorrect dirty check result
> -----------------------------------------------------------------------------
>
>          Key: NH-838
>          URL: http://jira.nhibernate.org/browse/NH-838
>      Project: NHibernate
>         Type: Bug
>   Components: Core
>     Versions: 1.2.0.Beta2
>     Reporter: Bill Poole
>     Priority: Minor

>
> Applying the "nosetter" property access strategy on the <version> element in a mapping file for an entity type seems to cause NHibernate to falsely detect a dirty condition for any entity instance of that type and issue an UPDATE against the database.
> Changing the access strategy to "field" immediately caused the UPDATEs no longer to be issued against the database.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Created: (NH-850) Non-portable file path for generated source files by hbm2net

From: NHibernate J. <mik...@us...> - 2006-12-31 06:31:29

Non-portable file path for generated source files by hbm2net
------------------------------------------------------------

         Key: NH-850
         URL: http://jira.nhibernate.org/browse/NH-850
     Project: NHibernate
        Type: Bug
  Components: Contrib  
    Versions: 1.0.3    
    Reporter: Sebastian Brady
    Priority: Minor


NHibernate.Tools.hbm2net uses non-portable path names for the files it generates. The hardcoded path separator ("\") won't work on Unix-like systems. 

The System.IO.Path methods should be used to build the path name.

Suggest that in the NHibernate.Tool.hbm2net.Generator.write() method (file: src/NHibernate.Tool.hbm2net/Generator.cs, line 152)

    FileInfo file = new FileInfo(dir.FullName + "\\" + this.getFileName(saveToClassName));

becomes

    FileInfo file = new FileInfo(System.IO.Combine(dir.FullName, this.getFileName(saveToClassName));


And, in NHibernate.Tool.hbm2net.Generator.getDir() method (line 203)

    dir = new FileInfo(baseDir.FullName + "\\" + p.Replace(StringHelper.Dot, Path.DirectorySeparatorChar));

becomes

    dir = new FileInfo(System.IO.Combine(baseDir.FullName,
                                         p.Replace(StringHelper.Dot, Path.DirectorySeparatorChar)));





-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Updated: (NH-826) Using Criteria to query for an item throws on Flush in some situations

From: NHibernate J. <mik...@us...> - 2006-12-29 21:45:31

     [ http://jira.nhibernate.org/browse/NH-826?page=all ]

Aaron Jensen updated NH-826:
----------------------------

    Attachment: NH826.patch

This patch fixes it for me.  It's hacky and doesn't feel right, so I'm sure theres a more top down approach to this.  Here's my side of a conversation I had with Ayende explaining the issue:
(1:30:11 PM) Aaron: it's hacky
(1:30:25 PM) Aaron: and i dont know if its the right solution
(1:31:05 PM) Aaron: the issue is that the loadelementsfromcolleciton gets the collectionpersisters for all possible collections for an entity (including it's subclasses)
(1:31:38 PM) Aaron: so if an entity is of the base class, it creates a collection that belongs to the subclass
(1:31:46 PM) Aaron: and it's automatically unreferenced
(1:31:49 PM) Aaron: because it can't be referenced
(1:32:13 PM) Aaron: ok, let me back up... you have a subclass
(1:32:19 PM) Aaron: and you have a base class
(1:32:26 PM) Aaron: sub has a collection
(1:32:29 PM) Aaron: base does not
(1:32:36 PM) Aaron: then you have a container class, that has a collection of base
(1:32:48 PM) Aaron: you get a row from the resultset
(1:32:56 PM) Aaron: and you've got to hydrate all the collections it contains
(1:33:18 PM) Aaron: so, if you get container fetch base fetch collection
(1:33:30 PM) Aaron: or just container join base fetch collection
(1:34:12 PM) Aaron: so the collection persister for the collection is there, and it's owner is base
(1:34:30 PM) Aaron: even though base does not have that collection
(1:34:53 PM) Aaron: at some point the entity's type is determined.. and it's instantiated
(1:34:59 PM) Aaron: so base is instantiated
(1:35:04 PM) Aaron: because that's what it is, it's NOT sub
(1:35:34 PM) Aaron: but the collectionpersister for the collection still exists because it doesn't know at the time it's created that it's not needed... AND it's needed later if there is a sub in the container
(1:35:55 PM) Aaron: so either the set of collectionpersisters needs to change on each row based on the type
(1:36:08 PM) Aaron: or we need to filter using reflection like my patch does
(1:37:31 PM) Aaron: no idea how it worked in 1.0
(1:37:34 PM) Aaron: didn't look at the code
(1:37:41 PM) Aaron: it may not have
(1:37:49 PM) Aaron: because they changed it to fetch as default
(1:37:55 PM) Aaron: so we may have never seen it

> Using Criteria to query for an item throws on Flush in some situations
> ----------------------------------------------------------------------
>
>          Key: NH-826
>          URL: http://jira.nhibernate.org/browse/NH-826
>      Project: NHibernate
>         Type: Bug
>   Components: Core
>     Versions: 1.2.0.Beta2
>     Reporter: Aaron Jensen
>      Fix For: 1.2.0.Beta3
>  Attachments: NH826.patch, NHibernateTest.zip
>
> The situation is best described by the attached sample project, but I will attempt to explain in words when this problem occurs.
> EntityA has a many-to-many to EntityB
> EntityB has a subclass EntityC
> EntityC has a one-to-many to EntityD
> If you create an EntityB and associate it to EntityA, then query for EntityA via Criteria (but not via HQL) then Session.Flush() will fail with: 
> NHibernate.HibernateException: You may not dereference an collection with cascade="all-delete-orphan"
>    at NHibernate.Impl.SessionImpl.UpdateUnreachableCollection(IPersistentCollection coll) in c:\net\nhibernate\nhibernat
> e\src\NHibernate\Impl\SessionImpl.cs:line 3957
>    at NHibernate.Impl.SessionImpl.FlushCollections() in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:
> line 3802
>    at NHibernate.Impl.SessionImpl.FlushEverything() in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:l
> ine 3090 
> The collection it is complaining about is a collection of EntityD objects which should never have been created in the first place.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Commented: (NH-531) GetSetHelperFactory Unexpected Character Compile Error

From: NHibernate J. <mik...@us...> - 2006-12-29 13:02:31

     [ http://jira.nhibernate.org/browse/NH-531?page=comments#action_14691 ]
     
Sergey Koshcheyev commented on NH-531:
--------------------------------------

Yes, this issue will not be fixed in 1.0.x branch (note it's closed as Won't Fix). Disable the reflection optimizer if you have problems with it.

> GetSetHelperFactory Unexpected Character Compile Error
> ------------------------------------------------------
>
>          Key: NH-531
>          URL: http://jira.nhibernate.org/browse/NH-531
>      Project: NHibernate
>         Type: Bug
>     Versions: 1.0.2
>     Reporter: Kevin Chan
>     Priority: Trivial
>  Attachments: nullable.patch
>
> I get following error from the NHibernate logging output, looks like an invalid character got in there:
> 2006-01-23 11:49:15,044 DEBUG NHibernate.Persister.GetSetHelperFactory - Init compiler for class Com.Klinitek.Census.Model.Census
> 2006-01-23 11:49:15,044 DEBUG NHibernate.Persister.GetSetHelperFactory - Adding referenced assembly C:\Documents and Settings\Kevin Chan\Local Settings\Temp\nunit20\ShadowCopyCache\632736137450288750\Tests\assembly\dl3\1caacf84\0091880d_1f1ac601\NHibernate.DLL
> 2006-01-23 11:49:15,044 DEBUG NHibernate.Persister.GetSetHelperFactory - Adding referenced assembly C:\Documents and Settings\Kevin Chan\Local Settings\Temp\nunit20\ShadowCopyCache\632736137450288750\Tests\assembly\dl3\e3918ff2\e408caf6_5520c601\Com.Klinitek.Census.DLL
> 2006-01-23 11:49:15,044 DEBUG NHibernate.Persister.GetSetHelperFactory - Adding referenced assembly C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\mscorlib.dll
> 2006-01-23 11:49:15,044 DEBUG NHibernate.Persister.GetSetHelperFactory - Adding referenced assembly C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll
> 2006-01-23 11:49:15,044 DEBUG NHibernate.Persister.GetSetHelperFactory - Adding referenced assembly C:\Documents and Settings\Kevin Chan\Local Settings\Temp\nunit20\ShadowCopyCache\632736137450288750\Tests\assembly\dl3\d80864f6\00ddc308_1f1ac601\Iesi.Collections.DLL
> 2006-01-23 11:49:15,044 DEBUG NHibernate.Persister.GetSetHelperFactory - Adding referenced assembly C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll
> 2006-01-23 11:49:15,247 DEBUG NHibernate.Persister.GetSetHelperFactory - Compiled with error:
> using System;
> using NHibernate.Property;
> namespace NHibernate.Persister {
> public class GetSetHelper_Com_Klinitek_Census_Model_Census : IGetSetHelper {
>   ISetter[] setters;
>   IGetter[] getters;
>   public GetSetHelper_Com_Klinitek_Census_Model_Census(ISetter[] setters, IGetter[] getters) {
>     this.setters = setters;
>     this.getters = getters;
>   }
> public void SetPropertyValues(object obj, object[] values) {
>   Com.Klinitek.Census.Model.Census t = (Com.Klinitek.Census.Model.Census)obj;
>   try
>   {
>   t.Name = (System.String)values[0];
>   t.PhysicianGroupRules = (Iesi.Collections.ISet)values[1];
>   t.DateLastModified = values[2] == null ? new System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]() : (System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]])values[2];
>   t.Type = (System.String)values[3];
>   t.Description = (System.String)values[4];
>   t.DateCreated = values[5] == null ? new System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]() : (System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]])values[5];
>   t.DefaultSortColumn = (System.String)values[6];
>   }
>   catch( InvalidCastException ice )
>   {
>     throw new MappingException(
>       "Invalid mapping information specified for type " + obj.GetType() + ", check your mapping file for property type mismatches",
>       ice);
>   }
> }
> public object[] GetPropertyValues(object obj) {
>   Com.Klinitek.Census.Model.Census t = (Com.Klinitek.Census.Model.Census)obj;
>   object[] ret = new object[7];
>   ret[0] = t.Name;
>   ret[1] = t.PhysicianGroupRules;
>   ret[2] = t.DateLastModified;
>   ret[3] = t.Type;
>   ret[4] = t.Description;
>   ret[5] = t.DateCreated;
>   ret[6] = t.DefaultSortColumn;
>   return ret;
> }
> }
> }
> 2006-01-23 11:49:15,247 DEBUG NHibernate.Persister.GetSetHelperFactory - Line:17, Column:63 Message:Unexpected character '`'
> 2006-01-23 11:49:15,263 DEBUG NHibernate.Persister.GetSetHelperFactory - Line:17, Column:182 Message:Unexpected character '`'
> 2006-01-23 11:49:15,263 DEBUG NHibernate.Persister.GetSetHelperFactory - Line:20, Column:58 Message:Unexpected character '`'
> 2006-01-23 11:49:15,263 DEBUG NHibernate.Persister.GetSetHelperFactory - Line:20, Column:177 Message:Unexpected character '`'
> 2006-01-23 11:49:15,263 INFO  NHibernate.Persister.GetSetHelperFactory - Disabling reflection optimizer for class Com.Klinitek.Census.Model.Census
> 2006-01-23 11:49:15,263 DEBUG NHibernate.Persister.GetSetHelperFactory - CodeDOM compilation failed
> System.InvalidOperationException: Unexpected character '`'
>    at NHibernate.Persister.GetSetHelperFactory.Build(String code)
>    at NHibernate.Persister.GetSetHelperFactory.CreateGetSetHelper()

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Commented: (NH-531) GetSetHelperFactory Unexpected Character Compile Error

From: NHibernate J. <mik...@us...> - 2006-12-29 12:54:31

     [ http://jira.nhibernate.org/browse/NH-531?page=comments#action_14690 ]
     
David Bernal commented on NH-531:
---------------------------------

I'm still getting this problem in version 1.0.3.0.

> GetSetHelperFactory Unexpected Character Compile Error
> ------------------------------------------------------
>
>          Key: NH-531
>          URL: http://jira.nhibernate.org/browse/NH-531
>      Project: NHibernate
>         Type: Bug
>     Versions: 1.0.2
>     Reporter: Kevin Chan
>     Priority: Trivial
>  Attachments: nullable.patch
>
> I get following error from the NHibernate logging output, looks like an invalid character got in there:
> 2006-01-23 11:49:15,044 DEBUG NHibernate.Persister.GetSetHelperFactory - Init compiler for class Com.Klinitek.Census.Model.Census
> 2006-01-23 11:49:15,044 DEBUG NHibernate.Persister.GetSetHelperFactory - Adding referenced assembly C:\Documents and Settings\Kevin Chan\Local Settings\Temp\nunit20\ShadowCopyCache\632736137450288750\Tests\assembly\dl3\1caacf84\0091880d_1f1ac601\NHibernate.DLL
> 2006-01-23 11:49:15,044 DEBUG NHibernate.Persister.GetSetHelperFactory - Adding referenced assembly C:\Documents and Settings\Kevin Chan\Local Settings\Temp\nunit20\ShadowCopyCache\632736137450288750\Tests\assembly\dl3\e3918ff2\e408caf6_5520c601\Com.Klinitek.Census.DLL
> 2006-01-23 11:49:15,044 DEBUG NHibernate.Persister.GetSetHelperFactory - Adding referenced assembly C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\mscorlib.dll
> 2006-01-23 11:49:15,044 DEBUG NHibernate.Persister.GetSetHelperFactory - Adding referenced assembly C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll
> 2006-01-23 11:49:15,044 DEBUG NHibernate.Persister.GetSetHelperFactory - Adding referenced assembly C:\Documents and Settings\Kevin Chan\Local Settings\Temp\nunit20\ShadowCopyCache\632736137450288750\Tests\assembly\dl3\d80864f6\00ddc308_1f1ac601\Iesi.Collections.DLL
> 2006-01-23 11:49:15,044 DEBUG NHibernate.Persister.GetSetHelperFactory - Adding referenced assembly C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll
> 2006-01-23 11:49:15,247 DEBUG NHibernate.Persister.GetSetHelperFactory - Compiled with error:
> using System;
> using NHibernate.Property;
> namespace NHibernate.Persister {
> public class GetSetHelper_Com_Klinitek_Census_Model_Census : IGetSetHelper {
>   ISetter[] setters;
>   IGetter[] getters;
>   public GetSetHelper_Com_Klinitek_Census_Model_Census(ISetter[] setters, IGetter[] getters) {
>     this.setters = setters;
>     this.getters = getters;
>   }
> public void SetPropertyValues(object obj, object[] values) {
>   Com.Klinitek.Census.Model.Census t = (Com.Klinitek.Census.Model.Census)obj;
>   try
>   {
>   t.Name = (System.String)values[0];
>   t.PhysicianGroupRules = (Iesi.Collections.ISet)values[1];
>   t.DateLastModified = values[2] == null ? new System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]() : (System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]])values[2];
>   t.Type = (System.String)values[3];
>   t.Description = (System.String)values[4];
>   t.DateCreated = values[5] == null ? new System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]() : (System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]])values[5];
>   t.DefaultSortColumn = (System.String)values[6];
>   }
>   catch( InvalidCastException ice )
>   {
>     throw new MappingException(
>       "Invalid mapping information specified for type " + obj.GetType() + ", check your mapping file for property type mismatches",
>       ice);
>   }
> }
> public object[] GetPropertyValues(object obj) {
>   Com.Klinitek.Census.Model.Census t = (Com.Klinitek.Census.Model.Census)obj;
>   object[] ret = new object[7];
>   ret[0] = t.Name;
>   ret[1] = t.PhysicianGroupRules;
>   ret[2] = t.DateLastModified;
>   ret[3] = t.Type;
>   ret[4] = t.Description;
>   ret[5] = t.DateCreated;
>   ret[6] = t.DefaultSortColumn;
>   return ret;
> }
> }
> }
> 2006-01-23 11:49:15,247 DEBUG NHibernate.Persister.GetSetHelperFactory - Line:17, Column:63 Message:Unexpected character '`'
> 2006-01-23 11:49:15,263 DEBUG NHibernate.Persister.GetSetHelperFactory - Line:17, Column:182 Message:Unexpected character '`'
> 2006-01-23 11:49:15,263 DEBUG NHibernate.Persister.GetSetHelperFactory - Line:20, Column:58 Message:Unexpected character '`'
> 2006-01-23 11:49:15,263 DEBUG NHibernate.Persister.GetSetHelperFactory - Line:20, Column:177 Message:Unexpected character '`'
> 2006-01-23 11:49:15,263 INFO  NHibernate.Persister.GetSetHelperFactory - Disabling reflection optimizer for class Com.Klinitek.Census.Model.Census
> 2006-01-23 11:49:15,263 DEBUG NHibernate.Persister.GetSetHelperFactory - CodeDOM compilation failed
> System.InvalidOperationException: Unexpected character '`'
>    at NHibernate.Persister.GetSetHelperFactory.Build(String code)
>    at NHibernate.Persister.GetSetHelperFactory.CreateGetSetHelper()

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Commented: (NH-849) MIN()- and MAX()-projections

From: NHibernate J. <mik...@us...> - 2006-12-28 17:41:25

     [ http://jira.nhibernate.org/browse/NH-849?page=comments#action_14683 ]
     
Erik Meusel commented on NH-849:
--------------------------------

Oh, well, then NHibernate.Expression.AvgProjection lead me to the wrong place to look for MIN() and MAX().

lg
Erik

> MIN()- and MAX()-projections
> ----------------------------
>
>          Key: NH-849
>          URL: http://jira.nhibernate.org/browse/NH-849
>      Project: NHibernate
>         Type: New Feature
>   Components: Data Providers
>     Versions: 1.2.0.Beta2
>     Reporter: Erik Meusel
>     Priority: Minor
>  Attachments: MinMax.tar.gz
>
> I wrote two small and missing projections for MIN() and MAX() for my NHibernate application and would like to write at least another one for CAST(). I'll attach the first two, just in case you're interested in them (since they are really small and not quite complicated to implement at all).

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Commented: (NH-849) MIN()- and MAX()-projections

From: NHibernate J. <mik...@us...> - 2006-12-28 17:29:27

     [ http://jira.nhibernate.org/browse/NH-849?page=comments#action_14682 ]
     
Ayende Rahien commented on NH-849:
----------------------------------

I may be missing something, but there is Projections.Max(string) and Projectsions.Min(string) on NHibernate already.


> MIN()- and MAX()-projections
> ----------------------------
>
>          Key: NH-849
>          URL: http://jira.nhibernate.org/browse/NH-849
>      Project: NHibernate
>         Type: New Feature
>   Components: Data Providers
>     Versions: 1.2.0.Beta2
>     Reporter: Erik Meusel
>     Priority: Minor
>  Attachments: MinMax.tar.gz
>
> I wrote two small and missing projections for MIN() and MAX() for my NHibernate application and would like to write at least another one for CAST(). I'll attach the first two, just in case you're interested in them (since they are really small and not quite complicated to implement at all).

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Created: (NH-849) MIN()- and MAX()-projections

From: NHibernate J. <mik...@us...> - 2006-12-28 16:02:25

MIN()- and MAX()-projections
----------------------------

         Key: NH-849
         URL: http://jira.nhibernate.org/browse/NH-849
     Project: NHibernate
        Type: New Feature
  Components: Data Providers  
    Versions: 1.2.0.Beta2    
    Reporter: Erik Meusel
    Priority: Minor
 Attachments: MinMax.tar.gz

I wrote two small and missing projections for MIN() and MAX() for my NHibernate application and would like to write at least another one for CAST(). I'll attach the first two, just in case you're interested in them (since they are really small and not quite complicated to implement at all).

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Resolved: (NH-848) only mapped properties should require virtual

From: NHibernate J. <mik...@us...> - 2006-12-28 07:46:27

     [ http://jira.nhibernate.org/browse/NH-848?page=all ]
     
Ayende Rahien resolved NH-848:
------------------------------

    Resolution: Won't Fix

The way NHibernate proxies work, it create another object and forward all calls to it. 
Because of this, _all_ methods/properties must be virtual, since the type of the object may be different, and the methods/properties may depend on the state of the object, and the proxied object state is not really valid

> only mapped properties should require virtual
> ---------------------------------------------
>
>          Key: NH-848
>          URL: http://jira.nhibernate.org/browse/NH-848
>      Project: NHibernate
>         Type: Bug
>   Components: Core
>     Versions: 1.2.0.Beta2
>     Reporter: Jerry Haltom
>     Priority: Trivial

>
> Looks like the validator validates that ALL properties are in fact virtual. Only MAPPED properties are of a concern. Getters the user adds which are not mapped do not matter.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Commented: (NH-11) How to do Sorted Collections

From: NHibernate J. <mik...@us...> - 2006-12-28 05:16:26

     [ http://jira.nhibernate.org/browse/NH-11?page=comments#action_14680 ]
     
Jerry Haltom commented on NH-11:
--------------------------------

Iesi.Collections.Generic.SortedSet appears to exist now. Perhaps this is a better solution now?

> How to do Sorted Collections
> ----------------------------
>
>          Key: NH-11
>          URL: http://jira.nhibernate.org/browse/NH-11
>      Project: NHibernate
>         Type: Task
>     Reporter: Mike Doerfler
>     Assignee: Mike Doerfler
>      Fix For: prealpha

>
> .NET has no interface for a SortedSet (it has no Set interface, but that is a seperate gripe), or a SortedDictionary.
> There is a SortedList, but the definition of a <list> in NHibernate requires an Index column so it defines the order of the items in the List.
> There is a ListDictionary, but that has warnings about performance being better than Dictionary for only up to 10 items.  The order of a ListDictionary is based on order of Add or using the AddAt().  It does not use a Comparer to determine where to Add an element.
> The options I can see us having is to:
> 1 - Use an external library that provides SortedSet/SortedDictionary functionallity similar to Javas.  I want to stay as close to the .NET SDK as possible since that is what we are using :)
> 2 - Change the meaning of <sorted-set> and <sorted-map> to just be sorted by Add order or AddAt.  That would be more consistent with the .NET SDK and that is the way I am leaning.  
> The Comparer provided in the mapping would be used to determine the order to Add items from the DataReader to the collection.  We could store the objects in a temporary ArrayList while we read from the DataReader and instantiate the objects, then use ArrayList.Sort(IComparer) and iterate through the sorted Array List and Add them to the Set/Dictionary.  
> The preferred way would to be to sort them using the order-by mapping attribute because the db would handle the sorting and give us the items in order.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Created: (NH-848) only mapped properties should require virtual

From: NHibernate J. <mik...@us...> - 2006-12-28 04:12:25

only mapped properties should require virtual
---------------------------------------------

         Key: NH-848
         URL: http://jira.nhibernate.org/browse/NH-848
     Project: NHibernate
        Type: Bug
  Components: Core  
    Versions: 1.2.0.Beta2    
    Reporter: Jerry Haltom
    Priority: Trivial


Looks like the validator validates that ALL properties are in fact virtual. Only MAPPED properties are of a concern. Getters the user adds which are not mapped do not matter.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Created: (NH-847) Oracle stored procedure with Ref Cursor out

From: NHibernate J. <mik...@us...> - 2006-12-26 22:19:27

Oracle stored procedure with Ref Cursor out
-------------------------------------------

         Key: NH-847
         URL: http://jira.nhibernate.org/browse/NH-847
     Project: NHibernate
        Type: Bug
  Components: Core  
    Versions: 1.2.0.Beta2    
    Reporter: Brian Choi
    Priority: Critical


http://forum.hibernate.org/viewtopic.php?t=968269


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Commented: (NH-846) Support Sqlite ADO.Net 2.0 DataProvider for Nhibernate 1.0.3

From: NHibernate J. <mik...@us...> - 2006-12-26 16:13:26

     [ http://jira.nhibernate.org/browse/NH-846?page=comments#action_14671 ]
     
Bertrand LEGA commented on NH-846:
----------------------------------

Hello Nhibernate/Sqlite3 users ! 

As you may have heard "SQLite ADO.Net Provider" the initial project providing an ADO.NET driver for Sqlite is discontinued.

Instead, a new project sqlite-dotnet2 have started and keep providing nice ADO.NET driver.

As of today, Nhibernate only provides built-in support for the "SQLite ADO.Net Provider" driver which does not support Sqlite 3 ! Hopefully, "sqlite-dotnet2" does.

The first patch seems to be Nhibernate 1.2 specific and doesn't work for 1.03. So I changed the original code (written by Ioan Bizau).

In the zip, you will find : 
  - the visual studio 2005/2003 project
  - the code (yeah)
  - debug and release dlls for .net 2.0 and .net 1.1

I've tested it with the following feature 
   - autoincrement
   - BOOLEAN and DATE fields.

Bye,
Bertrand.

> Support Sqlite ADO.Net 2.0 DataProvider for Nhibernate 1.0.3
> ------------------------------------------------------------
>
>          Key: NH-846
>          URL: http://jira.nhibernate.org/browse/NH-846
>      Project: NHibernate
>         Type: Patch
>   Components: Data Providers
>     Versions: 1.2.0.Beta1
>     Reporter: Bertrand LEGA
>     Priority: Trivial
>  Attachments: NHibernate.SQLite20.zip
>
> NHibernate ist compiled against the old version of the SQLite ADO.Net Provider. But this Provider isnt updated since Feb. 2005.
> The newer one only supports Ado.Net 2.0. You can find it on http://sourceforge.net/projects/sqlite-dotnet2 . 
> Enclosed a SVN Patch that uses the Ado.Net 2.0 Version if NHibernate isn't compiled with .Net 1.0 1.1 or Mono 1.0.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Updated: (NH-846) Support Sqlite ADO.Net 2.0 DataProvider for Nhibernate 1.0.3

From: NHibernate J. <mik...@us...> - 2006-12-26 16:13:25

     [ http://jira.nhibernate.org/browse/NH-846?page=all ]

Bertrand LEGA updated NH-846:
-----------------------------

    Attachment: NHibernate.SQLite20.zip

> Support Sqlite ADO.Net 2.0 DataProvider for Nhibernate 1.0.3
> ------------------------------------------------------------
>
>          Key: NH-846
>          URL: http://jira.nhibernate.org/browse/NH-846
>      Project: NHibernate
>         Type: Patch
>   Components: Data Providers
>     Versions: 1.2.0.Beta1
>     Reporter: Bertrand LEGA
>     Priority: Trivial
>  Attachments: NHibernate.SQLite20.zip
>
> NHibernate ist compiled against the old version of the SQLite ADO.Net Provider. But this Provider isnt updated since Feb. 2005.
> The newer one only supports Ado.Net 2.0. You can find it on http://sourceforge.net/projects/sqlite-dotnet2 . 
> Enclosed a SVN Patch that uses the Ado.Net 2.0 Version if NHibernate isn't compiled with .Net 1.0 1.1 or Mono 1.0.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Created: (NH-846) Support Sqlite ADO.Net 2.0 DataProvider for Nhibernate 1.0.3

From: NHibernate J. <mik...@us...> - 2006-12-26 16:11:25

Support Sqlite ADO.Net 2.0 DataProvider for Nhibernate 1.0.3
------------------------------------------------------------

         Key: NH-846
         URL: http://jira.nhibernate.org/browse/NH-846
     Project: NHibernate
        Type: Patch
  Components: Data Providers  
    Versions: 1.2.0.Beta1    
    Reporter: Bertrand LEGA
    Priority: Trivial


NHibernate ist compiled against the old version of the SQLite ADO.Net Provider. But this Provider isnt updated since Feb. 2005.

The newer one only supports Ado.Net 2.0. You can find it on http://sourceforge.net/projects/sqlite-dotnet2 . 

Enclosed a SVN Patch that uses the Ado.Net 2.0 Version if NHibernate isn't compiled with .Net 1.0 1.1 or Mono 1.0.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Commented: (NH-668) Support Sqlite ADO.Net 2.0 DataProvider

From: NHibernate J. <mik...@us...> - 2006-12-26 16:06:25

     [ http://jira.nhibernate.org/browse/NH-668?page=comments#action_14670 ]
     
Bertrand LEGA commented on NH-668:
----------------------------------

As you may have heard "SQLite ADO.Net Provider" the initial project providing an ADO.NET driver for Sqlite is discontinued.

Instead, a new project sqlite-dotnet2 have started and keep providing nice ADO.NET driver.

As of today, Nhibernate only provides built-in support for the "SQLite ADO.Net Provider" driver which does not support Sqlite 3 ! Hopefully, "sqlite-dotnet2" does.

The first patch seems to be Nhibernate 1.2 specific and doesn't work for 1.03. So I changed the original code (written by Ioan Bizau).

In the zip, you will find : 
  - the visual studio 2005/2003 project
  - the code (yeah)
  - debug and release dlls for .net 2.0 and .net 1.1

I've tested it with the following feature 
   - autoincrement
   - BOOLEAN and DATE fields.

For more information, see http://forum.hibernate.org/viewtopic.php?p=2335245#2335245
Bye,
Bertrand.

> Support Sqlite ADO.Net 2.0 DataProvider
> ---------------------------------------
>
>          Key: NH-668
>          URL: http://jira.nhibernate.org/browse/NH-668
>      Project: NHibernate
>         Type: Patch
>   Components: Data Providers
>     Versions: 1.2.0.Beta1
>     Reporter: Steve Wagner
>     Priority: Trivial
>      Fix For: 1.2.0.Beta1
>  Attachments: sqlite_driver_patch.patch
>
> NHibernate ist compiled against the old version of the SQLite ADO.Net Provider. But this Provider isnt updated since Feb. 2005.
> The newer one only supports Ado.Net 2.0. You can find it on http://sourceforge.net/projects/sqlite-dotnet2 . 
> Enclosed a SVN Patch that uses the Ado.Net 2.0 Version if NHibernate isn't compiled with .Net 1.0 1.1 or Mono 1.0.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Created: (NH-845) Queries and imports in separate hmb.xml are not parsed (re-opening)

From: NHibernate J. <mik...@us...> - 2006-12-26 07:27:27

Queries and imports in separate hmb.xml are not parsed (re-opening)
-------------------------------------------------------------------

         Key: NH-845
         URL: http://jira.nhibernate.org/browse/NH-845
     Project: NHibernate
        Type: Bug
  Components: Core  
    Versions: 1.0.2    
    Reporter: Jon Resnick
    Priority: Minor


This issue was originally posted as NH-542 and then closed.  However the issue is real, as of 1.0.2.  The problem occurs because the class NHibernate.Cfg.AssemblyHbmOrderer discards any mapping files that do not contain a "class" or "joined-subclass" or "subclass" element.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Commented: (NH-844) Pagination no longer support for a query that doesn't start with SELECT.

From: NHibernate J. <mik...@us...> - 2006-12-26 03:57:25

     [ http://jira.nhibernate.org/browse/NH-844?page=comments#action_14664 ]
     
dB. commented on NH-844:
------------------------

Ayende, this only works for the second part, not for the whole thing. AccountPlaceFavorite doesn't have a Score column - it's the sum of appearances in AccountPlaceFavorite. The query wants the places that are "most favorite", that is only places that appear in AccountPlaceFavorite sorted by how many times they appear. I still don't speak SQL fluently enough to write it as one query :)

> Pagination no longer support for a query that doesn't start with SELECT.
> ------------------------------------------------------------------------
>
>          Key: NH-844
>          URL: http://jira.nhibernate.org/browse/NH-844
>      Project: NHibernate
>         Type: Bug
>   Components: Core
>     Versions: 1.2.0.Beta2
>     Reporter: dB.

>
> Beta2 behavior different from 1.0.3.
> This works fine in both 1.0.2 and 1.2.0 Beta 2:
>             IQuery q = Session.CreateSQLQuery(
>                 "CREATE TABLE #fav (	[Id] [int],	[Score] [int] )\n" +
>                 "INSERT INTO #fav ( [Id], [Score] ) " +
>                 " SELECT Place_Id, 1 FROM AccountPlaceFavorite " +
>                 "CREATE TABLE #pl (	[Id] [int],	[Score] [int] )\n" +
>                 "INSERT INTO #pl ( [Id], [Score] )" +
>                 " SELECT Id, SUM(Score) AS 'Score' FROM #fav " +
>                 " GROUP BY Id\n" +
>                 "SELECT {Place.*} FROM {Place} INNER JOIN #pl" +
>                 " ON #pl.Id = Place.Place_Id" +
>                 " ORDER BY [Score] DESC\n" +
>                 "DROP TABLE #pl\n" +
>                 "DROP TABLE #fav ",
>                 "Place",
>                 typeof(Place));
>             IList<Place> places = q.List<Place>();
> Add 
>             q.SetMaxResults(10);
>             q.SetFirstResult(1);
> Exception
>    at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1761
>    at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1705
>    at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1699
>    at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Custom\CustomLoader.cs:line 290
>    at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 5348
>    at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 5335
>    at NHibernate.Impl.SessionImpl.List[T](NativeSQLQuerySpecification spec, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 5323
>    at NHibernate.Impl.SqlQueryImpl.List[T]() in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SqlQueryImpl.cs:line 161
>    at SnCore.Data.Tests.AccountPlaceFavoriteTest.TestSelectWithTempTable() in C:\source\sncore\SnCore.Data.Tests\AccountPlaceFavoriteTest.cs:line 160
> --ADOException
>    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
>    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
>    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
>    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
>    at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
>    at System.Data.SqlClient.SqlDataReader.get_MetaData()
>    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
>    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
>    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
>    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
>    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
>    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
>    at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
>    at NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\BatcherImpl.cs:line 185
>    at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection selection, ISessionImplementor session) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1366
>    at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 392
>    at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 183
>    at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1751
> the query must start with SELECT

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Commented: (NH-844) Pagination no longer support for a query that doesn't start with SELECT.

From: NHibernate J. <mik...@us...> - 2006-12-25 22:25:27

     [ http://jira.nhibernate.org/browse/NH-844?page=comments#action_14663 ]
     
Ayende Rahien commented on NH-844:
----------------------------------

Also, this is far simpler query that does basically the same thing;

SELECT {Place.*} from {Place} 
inner join (SELECT Id, SUM(Score) AS Score FROM AccountPlaceFavorite  GROUP BY Id) pl
on {Place.Id} = pl.Id 
order by pl.Score



> Pagination no longer support for a query that doesn't start with SELECT.
> ------------------------------------------------------------------------
>
>          Key: NH-844
>          URL: http://jira.nhibernate.org/browse/NH-844
>      Project: NHibernate
>         Type: Bug
>   Components: Core
>     Versions: 1.2.0.Beta2
>     Reporter: dB.

>
> Beta2 behavior different from 1.0.3.
> This works fine in both 1.0.2 and 1.2.0 Beta 2:
>             IQuery q = Session.CreateSQLQuery(
>                 "CREATE TABLE #fav (	[Id] [int],	[Score] [int] )\n" +
>                 "INSERT INTO #fav ( [Id], [Score] ) " +
>                 " SELECT Place_Id, 1 FROM AccountPlaceFavorite " +
>                 "CREATE TABLE #pl (	[Id] [int],	[Score] [int] )\n" +
>                 "INSERT INTO #pl ( [Id], [Score] )" +
>                 " SELECT Id, SUM(Score) AS 'Score' FROM #fav " +
>                 " GROUP BY Id\n" +
>                 "SELECT {Place.*} FROM {Place} INNER JOIN #pl" +
>                 " ON #pl.Id = Place.Place_Id" +
>                 " ORDER BY [Score] DESC\n" +
>                 "DROP TABLE #pl\n" +
>                 "DROP TABLE #fav ",
>                 "Place",
>                 typeof(Place));
>             IList<Place> places = q.List<Place>();
> Add 
>             q.SetMaxResults(10);
>             q.SetFirstResult(1);
> Exception
>    at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1761
>    at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1705
>    at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1699
>    at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Custom\CustomLoader.cs:line 290
>    at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 5348
>    at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 5335
>    at NHibernate.Impl.SessionImpl.List[T](NativeSQLQuerySpecification spec, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 5323
>    at NHibernate.Impl.SqlQueryImpl.List[T]() in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SqlQueryImpl.cs:line 161
>    at SnCore.Data.Tests.AccountPlaceFavoriteTest.TestSelectWithTempTable() in C:\source\sncore\SnCore.Data.Tests\AccountPlaceFavoriteTest.cs:line 160
> --ADOException
>    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
>    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
>    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
>    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
>    at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
>    at System.Data.SqlClient.SqlDataReader.get_MetaData()
>    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
>    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
>    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
>    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
>    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
>    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
>    at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
>    at NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\BatcherImpl.cs:line 185
>    at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection selection, ISessionImplementor session) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1366
>    at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 392
>    at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 183
>    at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1751
> the query must start with SELECT

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Commented: (NH-844) Pagination no longer support for a query that doesn't start with SELECT.

From: NHibernate J. <mik...@us...> - 2006-12-25 21:03:23

     [ http://jira.nhibernate.org/browse/NH-844?page=comments#action_14662 ]
     
Sergey Koshcheyev commented on NH-844:
--------------------------------------

Just to explain - this kind of usage of native queries was never explicitly supported (i.e. it worked in earlier versions by accident). If you need paging for such queries, implement it yourself.

> Pagination no longer support for a query that doesn't start with SELECT.
> ------------------------------------------------------------------------
>
>          Key: NH-844
>          URL: http://jira.nhibernate.org/browse/NH-844
>      Project: NHibernate
>         Type: Bug
>   Components: Core
>     Versions: 1.2.0.Beta2
>     Reporter: dB.

>
> Beta2 behavior different from 1.0.3.
> This works fine in both 1.0.2 and 1.2.0 Beta 2:
>             IQuery q = Session.CreateSQLQuery(
>                 "CREATE TABLE #fav (	[Id] [int],	[Score] [int] )\n" +
>                 "INSERT INTO #fav ( [Id], [Score] ) " +
>                 " SELECT Place_Id, 1 FROM AccountPlaceFavorite " +
>                 "CREATE TABLE #pl (	[Id] [int],	[Score] [int] )\n" +
>                 "INSERT INTO #pl ( [Id], [Score] )" +
>                 " SELECT Id, SUM(Score) AS 'Score' FROM #fav " +
>                 " GROUP BY Id\n" +
>                 "SELECT {Place.*} FROM {Place} INNER JOIN #pl" +
>                 " ON #pl.Id = Place.Place_Id" +
>                 " ORDER BY [Score] DESC\n" +
>                 "DROP TABLE #pl\n" +
>                 "DROP TABLE #fav ",
>                 "Place",
>                 typeof(Place));
>             IList<Place> places = q.List<Place>();
> Add 
>             q.SetMaxResults(10);
>             q.SetFirstResult(1);
> Exception
>    at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1761
>    at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1705
>    at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1699
>    at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Custom\CustomLoader.cs:line 290
>    at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 5348
>    at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 5335
>    at NHibernate.Impl.SessionImpl.List[T](NativeSQLQuerySpecification spec, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 5323
>    at NHibernate.Impl.SqlQueryImpl.List[T]() in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SqlQueryImpl.cs:line 161
>    at SnCore.Data.Tests.AccountPlaceFavoriteTest.TestSelectWithTempTable() in C:\source\sncore\SnCore.Data.Tests\AccountPlaceFavoriteTest.cs:line 160
> --ADOException
>    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
>    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
>    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
>    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
>    at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
>    at System.Data.SqlClient.SqlDataReader.get_MetaData()
>    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
>    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
>    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
>    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
>    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
>    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
>    at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
>    at NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\BatcherImpl.cs:line 185
>    at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection selection, ISessionImplementor session) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1366
>    at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 392
>    at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 183
>    at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1751
> the query must start with SELECT

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Resolved: (NH-843) COUNT(*) returns int while COUNT(DISTINCT class) returns long

From: NHibernate J. <mik...@us...> - 2006-12-25 16:46:29

     [ http://jira.nhibernate.org/browse/NH-843?page=all ]
     
Christian Bauer resolved NH-843:
--------------------------------

    Resolution: Not an Issue

Read the release notes.

> COUNT(*) returns int while COUNT(DISTINCT class) returns long
> -------------------------------------------------------------
>
>          Key: NH-843
>          URL: http://jira.nhibernate.org/browse/NH-843
>      Project: NHibernate
>         Type: Bug
>   Components: Core
>     Versions: 1.2.0.Beta2
>     Reporter: dB.

>
> Different behavior in Beta 2 from 1.0.3.
> SELECT COUNT(*) returns an int, while SELECT COUNT(DISTINCT something) from Something something returns long. 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Resolved: (NH-844) Pagination no longer support for a query that doesn't start with SELECT.

From: NHibernate J. <mik...@us...> - 2006-12-25 16:46:28

     [ http://jira.nhibernate.org/browse/NH-844?page=all ]
     
Christian Bauer resolved NH-844:
--------------------------------

    Resolution: Not an Issue

> Pagination no longer support for a query that doesn't start with SELECT.
> ------------------------------------------------------------------------
>
>          Key: NH-844
>          URL: http://jira.nhibernate.org/browse/NH-844
>      Project: NHibernate
>         Type: Bug
>   Components: Core
>     Versions: 1.2.0.Beta2
>     Reporter: dB.

>
> Beta2 behavior different from 1.0.3.
> This works fine in both 1.0.2 and 1.2.0 Beta 2:
>             IQuery q = Session.CreateSQLQuery(
>                 "CREATE TABLE #fav (	[Id] [int],	[Score] [int] )\n" +
>                 "INSERT INTO #fav ( [Id], [Score] ) " +
>                 " SELECT Place_Id, 1 FROM AccountPlaceFavorite " +
>                 "CREATE TABLE #pl (	[Id] [int],	[Score] [int] )\n" +
>                 "INSERT INTO #pl ( [Id], [Score] )" +
>                 " SELECT Id, SUM(Score) AS 'Score' FROM #fav " +
>                 " GROUP BY Id\n" +
>                 "SELECT {Place.*} FROM {Place} INNER JOIN #pl" +
>                 " ON #pl.Id = Place.Place_Id" +
>                 " ORDER BY [Score] DESC\n" +
>                 "DROP TABLE #pl\n" +
>                 "DROP TABLE #fav ",
>                 "Place",
>                 typeof(Place));
>             IList<Place> places = q.List<Place>();
> Add 
>             q.SetMaxResults(10);
>             q.SetFirstResult(1);
> Exception
>    at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1761
>    at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1705
>    at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1699
>    at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Custom\CustomLoader.cs:line 290
>    at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 5348
>    at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 5335
>    at NHibernate.Impl.SessionImpl.List[T](NativeSQLQuerySpecification spec, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 5323
>    at NHibernate.Impl.SqlQueryImpl.List[T]() in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SqlQueryImpl.cs:line 161
>    at SnCore.Data.Tests.AccountPlaceFavoriteTest.TestSelectWithTempTable() in C:\source\sncore\SnCore.Data.Tests\AccountPlaceFavoriteTest.cs:line 160
> --ADOException
>    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
>    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
>    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
>    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
>    at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
>    at System.Data.SqlClient.SqlDataReader.get_MetaData()
>    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
>    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
>    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
>    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
>    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
>    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
>    at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
>    at NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\BatcherImpl.cs:line 185
>    at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection selection, ISessionImplementor session) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1366
>    at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 392
>    at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 183
>    at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1751
> the query must start with SELECT

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Commented: (NH-844) Pagination no longer support for a query that doesn't start with SELECT.

From: NHibernate J. <mik...@us...> - 2006-12-25 16:46:26

     [ http://jira.nhibernate.org/browse/NH-844?page=comments#action_14660 ]
     
Christian Bauer commented on NH-844:
------------------------------------

Stop opening these nonsense issues.


> Pagination no longer support for a query that doesn't start with SELECT.
> ------------------------------------------------------------------------
>
>          Key: NH-844
>          URL: http://jira.nhibernate.org/browse/NH-844
>      Project: NHibernate
>         Type: Bug
>   Components: Core
>     Versions: 1.2.0.Beta2
>     Reporter: dB.

>
> Beta2 behavior different from 1.0.3.
> This works fine in both 1.0.2 and 1.2.0 Beta 2:
>             IQuery q = Session.CreateSQLQuery(
>                 "CREATE TABLE #fav (	[Id] [int],	[Score] [int] )\n" +
>                 "INSERT INTO #fav ( [Id], [Score] ) " +
>                 " SELECT Place_Id, 1 FROM AccountPlaceFavorite " +
>                 "CREATE TABLE #pl (	[Id] [int],	[Score] [int] )\n" +
>                 "INSERT INTO #pl ( [Id], [Score] )" +
>                 " SELECT Id, SUM(Score) AS 'Score' FROM #fav " +
>                 " GROUP BY Id\n" +
>                 "SELECT {Place.*} FROM {Place} INNER JOIN #pl" +
>                 " ON #pl.Id = Place.Place_Id" +
>                 " ORDER BY [Score] DESC\n" +
>                 "DROP TABLE #pl\n" +
>                 "DROP TABLE #fav ",
>                 "Place",
>                 typeof(Place));
>             IList<Place> places = q.List<Place>();
> Add 
>             q.SetMaxResults(10);
>             q.SetFirstResult(1);
> Exception
>    at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1761
>    at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1705
>    at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1699
>    at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Custom\CustomLoader.cs:line 290
>    at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 5348
>    at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 5335
>    at NHibernate.Impl.SessionImpl.List[T](NativeSQLQuerySpecification spec, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 5323
>    at NHibernate.Impl.SqlQueryImpl.List[T]() in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SqlQueryImpl.cs:line 161
>    at SnCore.Data.Tests.AccountPlaceFavoriteTest.TestSelectWithTempTable() in C:\source\sncore\SnCore.Data.Tests\AccountPlaceFavoriteTest.cs:line 160
> --ADOException
>    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
>    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
>    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
>    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
>    at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
>    at System.Data.SqlClient.SqlDataReader.get_MetaData()
>    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
>    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
>    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
>    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
>    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
>    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
>    at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
>    at NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\BatcherImpl.cs:line 185
>    at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection selection, ISessionImplementor session) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1366
>    at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 392
>    at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 183
>    at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1751
> the query must start with SELECT

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Created: (NH-844) Pagination no longer support for a query that doesn't start with SELECT.

From: NHibernate J. <mik...@us...> - 2006-12-25 15:54:27

Pagination no longer support for a query that doesn't start with SELECT.
------------------------------------------------------------------------

         Key: NH-844
         URL: http://jira.nhibernate.org/browse/NH-844
     Project: NHibernate
        Type: Bug
  Components: Core  
    Versions: 1.2.0.Beta2    
    Reporter: dB.


Beta2 behavior different from 1.0.3.

This works fine in both 1.0.2 and 1.2.0 Beta 2:

            IQuery q = Session.CreateSQLQuery(
                "CREATE TABLE #fav (	[Id] [int],	[Score] [int] )\n" +
                "INSERT INTO #fav ( [Id], [Score] ) " +
                " SELECT Place_Id, 1 FROM AccountPlaceFavorite " +
                "CREATE TABLE #pl (	[Id] [int],	[Score] [int] )\n" +
                "INSERT INTO #pl ( [Id], [Score] )" +
                " SELECT Id, SUM(Score) AS 'Score' FROM #fav " +
                " GROUP BY Id\n" +
                "SELECT {Place.*} FROM {Place} INNER JOIN #pl" +
                " ON #pl.Id = Place.Place_Id" +
                " ORDER BY [Score] DESC\n" +
                "DROP TABLE #pl\n" +
                "DROP TABLE #fav ",
                "Place",
                typeof(Place));

            IList<Place> places = q.List<Place>();

Add 

            q.SetMaxResults(10);
            q.SetFirstResult(1);

Exception

   at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1761
   at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1705
   at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1699
   at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Custom\CustomLoader.cs:line 290
   at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 5348
   at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 5335
   at NHibernate.Impl.SessionImpl.List[T](NativeSQLQuerySpecification spec, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 5323
   at NHibernate.Impl.SqlQueryImpl.List[T]() in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SqlQueryImpl.cs:line 161
   at SnCore.Data.Tests.AccountPlaceFavoriteTest.TestSelectWithTempTable() in C:\source\sncore\SnCore.Data.Tests\AccountPlaceFavoriteTest.cs:line 160
--ADOException
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\BatcherImpl.cs:line 185
   at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection selection, ISessionImplementor session) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1366
   at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 392
   at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 183
   at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) in c:\net\nhibernate\nhibernate\src\NHibernate\Loader\Loader.cs:line 1751

the query must start with SELECT


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Created: (NH-843) COUNT(*) returns int while COUNT(DISTINCT class) returns long

From: NHibernate J. <mik...@us...> - 2006-12-24 22:15:21

COUNT(*) returns int while COUNT(DISTINCT class) returns long
-------------------------------------------------------------

         Key: NH-843
         URL: http://jira.nhibernate.org/browse/NH-843
     Project: NHibernate
        Type: Bug
  Components: Core  
    Versions: 1.2.0.Beta2    
    Reporter: dB.


Different behavior in Beta 2 from 1.0.3.
SELECT COUNT(*) returns an int, while SELECT COUNT(DISTINCT something) from Something something returns long. 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

35 messages has been excluded from this view by a project administrator.

Flat | Threaded

<< < 1 .. 369 370 371 372 373 .. 390 > >> (Page 371 of 390)