Menu
▾
▴
nhibernate-issues
|
From: David P. (JIRA) <nh...@gm...> - 2011-04-12 22:07:04
|
Forward mapping and db types
----------------------------
Key: NH-2647
URL: http://216.121.112.228/browse/NH-2647
Project: NHibernate
Issue Type: Bug
Components: Core
Affects Versions: 3.0.0.GA
Reporter: David Popiashvili
Priority: Major
When we create database from our *.hbm mapping files, some of the data types are not mapped correctly to the db. For example, NHibernate ignores Precision and Scale properties for decimal type. Also there's strange behavior with AnsiString, for example this property
<property name="Username" length="15" type="AnsiString" /> is mapped as nvarchar(1) on the database, shouldn't it be varchar(15)?
We are using .NET 4, NHibernate 3.0 and SQL Server 2008
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Fabio M. (JIRA) <nh...@gm...> - 2011-04-12 22:24:07
|
[ http://216.121.112.228/browse/NH-2647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fabio Maulo updated NH-2647:
----------------------------
Priority: Minor (was: Major)
We need your mappings and classes, since we have various tests to cover this situation.
> Forward mapping and db types
> ----------------------------
>
> Key: NH-2647
> URL: http://216.121.112.228/browse/NH-2647
> Project: NHibernate
> Issue Type: Bug
> Components: Core
> Affects Versions: 3.0.0.GA
> Reporter: David Popiashvili
> Priority: Minor
>
> When we create database from our *.hbm mapping files, some of the data types are not mapped correctly to the db. For example, NHibernate ignores Precision and Scale properties for decimal type. Also there's strange behavior with AnsiString, for example this property
> <property name="Username" length="15" type="AnsiString" /> is mapped as nvarchar(1) on the database, shouldn't it be varchar(15)?
> We are using .NET 4, NHibernate 3.0 and SQL Server 2008
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: David P. (JIRA) <nh...@gm...> - 2011-04-12 22:48:04
|
[ http://216.121.112.228/browse/NH-2647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Popiashvili updated NH-2647:
----------------------------------
Attachment: NHibernateTest.rar
Sample to demonstrate the buggy behavior of SchemaExport
> Forward mapping and db types
> ----------------------------
>
> Key: NH-2647
> URL: http://216.121.112.228/browse/NH-2647
> Project: NHibernate
> Issue Type: Bug
> Components: Core
> Affects Versions: 3.0.0.GA
> Reporter: David Popiashvili
> Priority: Minor
> Attachments: NHibernateTest.rar
>
>
> When we create database from our *.hbm mapping files, some of the data types are not mapped correctly to the db. For example, NHibernate ignores Precision and Scale properties for decimal type. Also there's strange behavior with AnsiString, for example this property
> <property name="Username" length="15" type="AnsiString" /> is mapped as nvarchar(1) on the database, shouldn't it be varchar(15)?
> We are using .NET 4, NHibernate 3.0 and SQL Server 2008
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: David P. (JIRA) <nh...@gm...> - 2011-04-12 22:50:12
|
[ http://216.121.112.228/browse/NH-2647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=20901#action_20901 ]
David Popiashvili commented on NH-2647:
---------------------------------------
I reproduced same issue with NHibernate 3.1.0 (Latest build)
> Forward mapping and db types
> ----------------------------
>
> Key: NH-2647
> URL: http://216.121.112.228/browse/NH-2647
> Project: NHibernate
> Issue Type: Bug
> Components: Core
> Affects Versions: 3.0.0.GA
> Reporter: David Popiashvili
> Priority: Minor
> Attachments: NHibernateTest.rar
>
>
> When we create database from our *.hbm mapping files, some of the data types are not mapped correctly to the db. For example, NHibernate ignores Precision and Scale properties for decimal type. Also there's strange behavior with AnsiString, for example this property
> <property name="Username" length="15" type="AnsiString" /> is mapped as nvarchar(1) on the database, shouldn't it be varchar(15)?
> We are using .NET 4, NHibernate 3.0 and SQL Server 2008
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Julian M. (JIRA) <nh...@gm...> - 2011-04-18 09:28:33
|
[ http://216.121.112.228/browse/NH-2647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=20912#action_20912 ]
Julian Maughan commented on NH-2647:
------------------------------------
In your test you are using the MsSqlCeDialect dialect?
> Forward mapping and db types
> ----------------------------
>
> Key: NH-2647
> URL: http://216.121.112.228/browse/NH-2647
> Project: NHibernate
> Issue Type: Bug
> Components: Core
> Affects Versions: 3.0.0.GA
> Reporter: David Popiashvili
> Priority: Minor
> Attachments: NHibernateTest.rar
>
>
> When we create database from our *.hbm mapping files, some of the data types are not mapped correctly to the db. For example, NHibernate ignores Precision and Scale properties for decimal type. Also there's strange behavior with AnsiString, for example this property
> <property name="Username" length="15" type="AnsiString" /> is mapped as nvarchar(1) on the database, shouldn't it be varchar(15)?
> We are using .NET 4, NHibernate 3.0 and SQL Server 2008
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: David P. (JIRA) <nh...@gm...> - 2011-04-18 14:26:32
|
[ http://216.121.112.228/browse/NH-2647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=20913#action_20913 ]
David Popiashvili commented on NH-2647:
---------------------------------------
Yes, it's shown in hibernate.cfg.xml file.
> Forward mapping and db types
> ----------------------------
>
> Key: NH-2647
> URL: http://216.121.112.228/browse/NH-2647
> Project: NHibernate
> Issue Type: Bug
> Components: Core
> Affects Versions: 3.0.0.GA
> Reporter: David Popiashvili
> Priority: Minor
> Attachments: NHibernateTest.rar
>
>
> When we create database from our *.hbm mapping files, some of the data types are not mapped correctly to the db. For example, NHibernate ignores Precision and Scale properties for decimal type. Also there's strange behavior with AnsiString, for example this property
> <property name="Username" length="15" type="AnsiString" /> is mapped as nvarchar(1) on the database, shouldn't it be varchar(15)?
> We are using .NET 4, NHibernate 3.0 and SQL Server 2008
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Julian M. (JIRA) <nh...@gm...> - 2011-04-19 00:07:31
|
[ http://216.121.112.228/browse/NH-2647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=20915#action_20915 ]
Julian Maughan commented on NH-2647:
------------------------------------
...but in the description you say you are using SQL Server 2008. So it occurs in CE as well?
> Forward mapping and db types
> ----------------------------
>
> Key: NH-2647
> URL: http://216.121.112.228/browse/NH-2647
> Project: NHibernate
> Issue Type: Bug
> Components: Core
> Affects Versions: 3.0.0.GA
> Reporter: David Popiashvili
> Priority: Minor
> Attachments: NHibernateTest.rar
>
>
> When we create database from our *.hbm mapping files, some of the data types are not mapped correctly to the db. For example, NHibernate ignores Precision and Scale properties for decimal type. Also there's strange behavior with AnsiString, for example this property
> <property name="Username" length="15" type="AnsiString" /> is mapped as nvarchar(1) on the database, shouldn't it be varchar(15)?
> We are using .NET 4, NHibernate 3.0 and SQL Server 2008
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: David P. (JIRA) <nh...@gm...> - 2011-04-19 00:26:28
|
[ http://216.121.112.228/browse/NH-2647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=20916#action_20916 ]
David Popiashvili commented on NH-2647:
---------------------------------------
o god, I'm sorry, I didn't pay attention to that. Sorry again :(
> Forward mapping and db types
> ----------------------------
>
> Key: NH-2647
> URL: http://216.121.112.228/browse/NH-2647
> Project: NHibernate
> Issue Type: Bug
> Components: Core
> Affects Versions: 3.0.0.GA
> Reporter: David Popiashvili
> Priority: Minor
> Attachments: NHibernateTest.rar
>
>
> When we create database from our *.hbm mapping files, some of the data types are not mapped correctly to the db. For example, NHibernate ignores Precision and Scale properties for decimal type. Also there's strange behavior with AnsiString, for example this property
> <property name="Username" length="15" type="AnsiString" /> is mapped as nvarchar(1) on the database, shouldn't it be varchar(15)?
> We are using .NET 4, NHibernate 3.0 and SQL Server 2008
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Fabio M. (JIRA) <nh...@gm...> - 2011-04-19 11:30:32
|
[ http://216.121.112.228/browse/NH-2647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=20919#action_20919 ]
Fabio Maulo commented on NH-2647:
---------------------------------
David,
For which dialect you are experimenting this problem ?
> Forward mapping and db types
> ----------------------------
>
> Key: NH-2647
> URL: http://216.121.112.228/browse/NH-2647
> Project: NHibernate
> Issue Type: Bug
> Components: Core
> Affects Versions: 3.0.0.GA
> Reporter: David Popiashvili
> Priority: Minor
> Attachments: NHibernateTest.rar
>
>
> When we create database from our *.hbm mapping files, some of the data types are not mapped correctly to the db. For example, NHibernate ignores Precision and Scale properties for decimal type. Also there's strange behavior with AnsiString, for example this property
> <property name="Username" length="15" type="AnsiString" /> is mapped as nvarchar(1) on the database, shouldn't it be varchar(15)?
> We are using .NET 4, NHibernate 3.0 and SQL Server 2008
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: David P. (JIRA) <nh...@gm...> - 2011-04-19 11:49:31
|
[ http://216.121.112.228/browse/NH-2647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=20920#action_20920 ]
David Popiashvili commented on NH-2647:
---------------------------------------
Fabio, I had the problem because I didn't pay attention that I was using MsSqlCeDialect with SQL Server 2008. I changed the dialect to MsSql2008Dialect and the problem is gone. So this is not your bug guys, just my stupid error. Please close this issue.
Thanks and sorry for false alarm :)
> Forward mapping and db types
> ----------------------------
>
> Key: NH-2647
> URL: http://216.121.112.228/browse/NH-2647
> Project: NHibernate
> Issue Type: Bug
> Components: Core
> Affects Versions: 3.0.0.GA
> Reporter: David Popiashvili
> Priority: Minor
> Attachments: NHibernateTest.rar
>
>
> When we create database from our *.hbm mapping files, some of the data types are not mapped correctly to the db. For example, NHibernate ignores Precision and Scale properties for decimal type. Also there's strange behavior with AnsiString, for example this property
> <property name="Username" length="15" type="AnsiString" /> is mapped as nvarchar(1) on the database, shouldn't it be varchar(15)?
> We are using .NET 4, NHibernate 3.0 and SQL Server 2008
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Fabio M. (JIRA) <nh...@gm...> - 2011-04-19 13:57:27
|
[ http://216.121.112.228/browse/NH-2647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fabio Maulo closed NH-2647.
---------------------------
Resolution: Not an Issue
> Forward mapping and db types
> ----------------------------
>
> Key: NH-2647
> URL: http://216.121.112.228/browse/NH-2647
> Project: NHibernate
> Issue Type: Bug
> Components: Core
> Affects Versions: 3.0.0.GA
> Reporter: David Popiashvili
> Priority: Minor
> Attachments: NHibernateTest.rar
>
>
> When we create database from our *.hbm mapping files, some of the data types are not mapped correctly to the db. For example, NHibernate ignores Precision and Scale properties for decimal type. Also there's strange behavior with AnsiString, for example this property
> <property name="Username" length="15" type="AnsiString" /> is mapped as nvarchar(1) on the database, shouldn't it be varchar(15)?
> We are using .NET 4, NHibernate 3.0 and SQL Server 2008
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X