[nhusers] Re: Oracle 12c Dialect

2013-08-06 Thread David Zwingelberg
Hi Alex, I would prefer the fallback option. An option that has been explicit declared cannot be ignored. This would cause misunderstandings. And the second will cause loss of functionality, so that the ROWNUM can not be used anymore? If I understand correctly. Good work! Best regards, David Am

[nhusers] Re: Oracle and cursors

2012-11-18 Thread guilemsola
I have post the same twice but I believe that second one is more accurate https://groups.google.com/forum/?fromgroups=#!topic/nhusers/j1N1IY5PBBc Regards On Sunday, November 18, 2012 3:30:14 AM UTC+1, guilemsola wrote: > > Hi All, > > I'm suffering an issue with NH and oracle running out of cur

[nhusers] Re: Oracle 11g and NHibernate DateTime to Date mapping

2012-09-12 Thread cremor
Why should the fix from stackoverflow remove any behaviour? It overrides OracleDataClientDriver, so the NHibernate code you posted is still executed. As far as I can say this is a perfect solution. At least if you only use DATE columns, I don't know how it would affect queries on TIMESTAMP column

[nhusers] Re: Oracle 11g and NHibernate DateTime to Date mapping

2012-08-31 Thread Stig Christensen
The fix on stackoverflow removes the default behavior, which is not recommended. This is the from the NHibernate source. /// /// This adds logic to ensure that a DbType.Boolean parameter is not created since /// ODP.NET doesn't support it.

[nhusers] Re: Oracle 11g and NHibernate DateTime to Date mapping

2012-08-31 Thread Stig Christensen
Also you can fix it by using a custom type See https://groups.google.com/group/nhusers/browse_thread/thread/1e68220bcafcf28c On 30 Aug., 14:45, Dries Verbeke wrote: > Check out this > postfor > the answer > > > > > > >

[nhusers] Re: Oracle 11g and NHibernate DateTime to Date mapping

2012-08-30 Thread Dries Verbeke
Check out this postfor the answer On Friday, August 17, 2012 5:15:54 AM UTC+2, Milind wrote: > > did you found the solution as I have similar issue. > > please let me know > -- You received this message

[nhusers] Re: Oracle 11g and NHibernate DateTime to Date mapping

2012-08-17 Thread Milind
did you found the solution as I have similar issue. please let me know -- You received this message because you are subscribed to the Google Groups "nhusers" group. To view this discussion on the web visit https://groups.google.com/d/msg/nhusers/-/PMeW8QBMqcgJ. To post to this group, send emai

[nhusers] Re: Oracle 11g and NHibernate DateTime to Date mapping

2011-09-20 Thread djn
Oh! I forgot to mention our environment: .net (C#) 4.0 NHibernate 3.1.0, used primarily via Linq ODP.Net 11.2.2.0 Regards, ./Daniel On Sep 20, 9:22 am, djn wrote: > Hi. > > I'm having trouble with a query where I select records within a given > timespan. > > The column I'm selecting from is of

[nhusers] Re: Oracle blob comare

2011-06-02 Thread srf
I noticed this is also an issue with clob fields which is more of an issue since you can use a clob field to store really large text inforation and you can only do a compare using the dbms_lob package. Is there no other way to query a clob field other than doing a raw query? On Jun 2, 8:24 am, srf

Re: [nhusers] Re: Oracle Driver issue with Win 2008 64 bit

2011-02-24 Thread Ying Guo
Hi Finally got it resolved by install the Oracle client with 32bit onto the server. I am running IIS in 32 mode. Oracle client with 64 bit installed. (the client package actually have all the driver included) The misleading part is the Exception says is looking for 64 driver , it is actually looki

[nhusers] Re: Oracle Driver issue with Win 2008 64 bit

2011-02-24 Thread turibbio
Hi Ying Guo, Actually you've to check in the folder "C:\Windows\Microsoft.NET \assembly", both in GAC_32 & GAC_34 folders. If you cannot find oracledataaccess.dll (or oracleclient.dll for old .net provider) in 2.x or in 4 folders, you need to install providers. In my app, I use Oracle 11g, then I'

Re: [nhusers] Re: Oracle Driver issue with Win 2008 64 bit

2011-02-23 Thread Ying Guo
Thanks for the reply, Turibbio. I understand this is a platform related issue. However still having trouble to find a solution. I've check the C:\windows\Assembly for 2008 R2 The two oracle entry in there are Oracle.dataaccess AMD64 oracle.web AMD64 I dont see another location for the 2003 server

[nhusers] Re: Oracle Driver issue with Win 2008 64 bit

2011-02-23 Thread turibbio
Hi Ying Guo, I've faced the same problem few days ago. First of all, I've to clearify one thing, it is not an NHibernate related problem! Here is what worked for me: if you don't know, Win Server 2008 R2 has 2 different folder for GAC (GAC_32 & GAC_64). You have to check if, in the right folder bas

Re: [nhusers] Re: Oracle Dialect not working properly with Linq Single function

2010-07-06 Thread Fabio Maulo
Steve, the exception was about missed parameters values (pagination parameters missed). I'll re-install oracle and check it. -- Fabio Maulo El 06/07/2010, a las 05:29, Steve Strong escribió: I think there are actually two separate issues here. Single() & SingleOrDefault() work correctly if th

Re: [nhusers] Re: Oracle Dialect not working properly with Linq Single function

2010-07-06 Thread Steve Strong
I think there are actually two separate issues here. Single() & SingleOrDefault() work correctly if there are zero or one results; they are incorrect if there is more than one result (due to a buggy use of SetMaxResults(1), which I'll fix). But that's not the bug that's being seen here. What And

Re: [nhusers] Re: Oracle Dialect not working properly with Linq Single function

2010-07-05 Thread Fabio Maulo
Sir Steve Strong knows it, don't worry. On Mon, Jul 5, 2010 at 3:39 PM, Diego Mijelshon wrote: > It's not necessarily a bug in the code. > An exception is just that: a state that deviates from the rule. > While the code shouldn't be designed around exceptions, it can happen that, > given a spec o

Re: [nhusers] Re: Oracle Dialect not working properly with Linq Single function

2010-07-05 Thread Diego Mijelshon
It's not necessarily a bug in the code. An exception is just that: a state that deviates from the rule. While the code shouldn't be designed around exceptions, it can happen that, given a spec of "there can be one and only one X where Y=Z" you try to retrieve it using Single and, somehow (say, beca

Re: [nhusers] Re: Oracle Dialect not working properly with Linq Single function

2010-07-05 Thread Fabio Maulo
If you write a query that may return 10 records and there you put "Single" you are foo or you have a bug. That is what "Single" mean and for that reason it throw exception when more than one instance are selected. In NH we don't have to change its meaning putting an unnecessary pagination (SetMaxR

Re: [nhusers] Re: Oracle Dialect not working properly with Linq Single function

2010-07-05 Thread Diego Mijelshon
I can't think of a better way to do it. For Single, this is the behavior: - Request at most 2 records from the server (to avoid doing extra work) - If no records returned, exception - If one record returned, map it and we're done - If more than one record returned, exception For SingleOrDefault i

Re: [nhusers] Re: Oracle Dialect not working properly with Linq Single function

2010-07-05 Thread Fabio Maulo
There is no need to complicate the query for "Single" -- Fabio Maulo El 05/07/2010, a las 12:16, Diego Mijelshon escribió: IIRC, Single/SingleOrDefault use SetMaxResults(2), and then checks that a single record is returned... Diego On Mon, Jul 5, 2010 at 10:19, Fabio Maulo wrote: > For

Re: [nhusers] Re: Oracle Dialect not working properly with Linq Single function

2010-07-05 Thread Fabio Maulo
It happenin provider. You can execute the linq first and then apply Single > var query = (from a in session.Query() > where a.Username == username > select a).ToList(); > var user = query.Single(); -- Fabio Maulo El 05/07/2010, a las 12:

[nhusers] Re: Oracle Dialect not working properly with Linq Single function

2010-07-05 Thread andrew6072
How do I use the SetMaxResults in the case ? Or is that something the happens somewhere in the linq provider ? public OlaUser GetByUsername(string username) { var session = GetSession(); var query = (from a in session.Query() w

Re: [nhusers] Re: Oracle Dialect not working properly with Linq Single function

2010-07-05 Thread Diego Mijelshon
IIRC, Single/SingleOrDefault use SetMaxResults(2), and then checks that a single record is returned... Diego On Mon, Jul 5, 2010 at 10:19, Fabio Maulo wrote: > For "First" and "FirstOrDefault" we can apply SetMaxResults(1) ... and fix > the bug (please check last JIRAs and add a new one if

Re: [nhusers] Re: Oracle Dialect not working properly with Linq Single function

2010-07-05 Thread Fabio Maulo
about the different behavior of each NH's query system well... it is normal... Different systems, different implementations, different results On Mon, Jul 5, 2010 at 10:19 AM, Fabio Maulo wrote: > For "First" and "FirstOrDefault" we can apply SetMaxResults(1) ... and fix > the bug (please ch

Re: [nhusers] Re: Oracle Dialect not working properly with Linq Single function

2010-07-05 Thread Fabio Maulo
For "First" and "FirstOrDefault" we can apply SetMaxResults(1) ... and fix the bug (please check last JIRAs and add a new one if you can't find an existing) For "Single" and "SingleOrDefault" we *shouldn't* apply SetMaxResults(1) because doing so we will change the "Single" behavior (it should thr

[nhusers] Re: Oracle Dialect not working properly with Linq Single function

2010-07-05 Thread andrew6072
Hi Fabio, What do you mean by changing the meaning of Single ? Oh and It also happens with First(), and SingleOrDefault() as well It seems to be something to do with this call bool useLimit = UseLimit(selection, dialect); when I use Query<> it returns true, and if I use QueryOver<> it return fa

Re: [nhusers] Re: Oracle Dialect not working properly with Linq Single function

2010-07-05 Thread Fabio Maulo
Confirmed, we have a bug. We are changing the meaning of Single. On Mon, Jul 5, 2010 at 8:35 AM, Fabio Maulo wrote: > If our provider creates a paginated query for the method "Single" we have a > bug. > > > On Mon, Jul 5, 2010 at 8:06 AM, andrew6072 > wrote: > >> Hi Fabio, >> >> I think the exc

Re: [nhusers] Re: Oracle Dialect not working properly with Linq Single function

2010-07-05 Thread Fabio Maulo
If our provider creates a paginated query for the method "Single" we have a bug. On Mon, Jul 5, 2010 at 8:06 AM, andrew6072 wrote: > Hi Fabio, > > I think the exception got chopped off, this is the full exception. > > [SQL: select * from ( select olauser0_.USER_ID as USER1_57_, > olauser0_.USERNA

[nhusers] Re: Oracle Dialect not working properly with Linq Single function

2010-07-05 Thread andrew6072
Hi Fabio, I think the exception got chopped off, this is the full exception. [SQL: select * from ( select olauser0_.USER_ID as USER1_57_, olauser0_.USERNAME as USERNAME57_, olauser0_.EMAIL_ADDRESS as EMAIL3_57_, olauser0_.COMMENTS as COMMENTS57_, olauser0_.PASSWORD as PASSWORD57_, olauser0_.PASSW

[nhusers] Re: Oracle Sequences and SQLite

2010-05-17 Thread Corey Coogan
I like the idea of using GUIDs, however, the DB is quite legacy and it was enough teeth pulling to get folks to agree to a surrogate key as it is. The key has to be a sequence, so my hands are tied there. Thanks for the suggestion, cc On May 17, 10:35 am, Jason Dentler wrote: > Your best option

[nhusers] Re: Oracle Configuration

2009-10-16 Thread Fabio Maulo
Could not load type NHibernate.Dialect.Oracle10gDialect. Possible cause: *no assembly name specified* NHibernate.Dialect.Oracle10gDialect, NHibernate For NH2.1.0 2009/10/16 nhib newbie > > Hi all, > > Could anyone please provide me a working Oracle 9i/10g nhibernate > configuration to put on ap

[nhusers] Re: Oracle Configuration

2009-10-16 Thread Carlos cubas
NHibernate 2.0 or 2.1? -Carlos Practice makes perfect, but if no one is perfect, why practice? > Date: Fri, 16 Oct 2009 05:43:44 -0700 > Subject: [nhusers] Oracle Configuration > From: selcuk.ozdo...@gmail.com > To: nhusers@googlegroups.com > > > Hi all, > > Could anyone please provide

[nhusers] Re: Oracle Generated SQL

2009-09-30 Thread Igor
> So, my questions are: > 1) Why did the style of sql change? I'm also interested in this question! > 2) Can I force NH to generate the ANSI compliant style? Use Oracle10gDialect. As I can see, the only difference between them is ANSI syntax for joins. > 3) How do I specify <> in a mapping fil

[nhusers] Re: Oracle + NHibernate

2009-06-09 Thread Craig van Nieuwkerk
Possibly try to explain what you are trying to do. You shouldn't really need to use DUAL with nHibernate unless you are trying to run some Oracle specific command in which case you can write custom SQL. Craig. On Wed, Jun 10, 2009 at 11:43 AM, Plácido Bisneto wrote: > Hello, > What's the best ap

[nhusers] Re: Oracle + NHibernate

2009-06-09 Thread Fabio Maulo
Custom SQL where needed... I would know where. 2009/6/9 Plácido Bisneto > Hello, > What's the best approach when I need to use the DUAL table from oracle in > my HQL? > It's not something that I'm developing now, but in the past, I really used > the DUAL table for a lot of things. > So, how shou

[nhusers] Re: ORACLE supports

2009-03-04 Thread Fabio Maulo
Ah... I, who is not using Oracle in any project, was the only one who tried to provide a failing test for NH-847... As I said some weeks ago... the NH+Oracle community should be a little be more reactive... Wake up guys. 2009/3/4 Fabio Maulo > The issue NH-847 has a question as last comment.That

[nhusers] Re: ORACLE supports

2009-03-04 Thread Fabio Maulo
The issue NH-847 has a question as last comment.That issue has 15 watchers, 19 votes, some requests in this mailing-list and now your re-fresh of the same request. Perhaps some one of you guys can answer that question. I'm waiting an answer since 2009/02/09. 2009/3/4 Brendan Kowitz > > Built

[nhusers] Re: ORACLE supports

2009-03-04 Thread Brendan Kowitz
Built-in support, so without the need to subclass and hack in some changes. Eg. http://groups.google.com/group/nhusers/browse_thread/thread/1e5c71502dd547f0/d3bc917ad7c9ca32?hl=en#d3bc917ad7c9ca32 I'm not reliant on this, just curious. Brendan. On Mar 4, 10:45 pm, Fabio Maulo wrote: > what me

[nhusers] Re: ORACLE supports

2009-03-04 Thread Fabio Maulo
what mean "real" ? 2009/3/4 Brendan Kowitz > > Thanks for the good news. +1 to continued Oracle support :) > > On a side note, is there any 'real' support for oracle stored procs > with these new dialects? > > Brendan. > > On Mar 4, 12:06 pm, Fabio Maulo wrote: > > Hi Mike. > > I'm happy becaus

[nhusers] Re: ORACLE supports

2009-03-04 Thread Brendan Kowitz
Thanks for the good news. +1 to continued Oracle support :) On a side note, is there any 'real' support for oracle stored procs with these new dialects? Brendan. On Mar 4, 12:06 pm, Fabio Maulo wrote: > Hi Mike. > I'm happy because you can work with new ORACLE dialects... > 3 lines talking abo

[nhusers] Re: ORACLE supports

2009-03-03 Thread Fabio Maulo
Hi Mike. I'm happy because you can work with new ORACLE dialects... 3 lines talking about your success story would be very appreciates http://nhforge.org/wikis/successstories/success-stories.aspx 2009/3/3 mhanney > > I also switched to the trunk recently to try the new 10g dialect with > 10g Rel

[nhusers] Re: ORACLE supports

2009-03-03 Thread Fabio Maulo
2009/3/3 Nicolai Sørensen > > Just switched our project to the trunk to try the new Oracle dialect > and I must say, it works like a charm with 11g. Very nice job Fabio =) Hi Nicolai. I'm happy because you can work with new dialects... 3 lines talking about your success story would be very appr

[nhusers] Re: ORACLE supports

2009-03-03 Thread Fabio Maulo
BTW all these things mean that we will remove old ORACLE's dialects before release NH2.1.0Alpha2. 2009/3/3 Fabio Maulo > 62 failed ? I have one. > > 2009/3/3 mhanney > > >> I also switched to the trunk recently to try the new 10g dialect with >> 10g Release 2 and I am very happy to report the f

[nhusers] Re: ORACLE supports

2009-03-03 Thread Fabio Maulo
62 failed ? I have one. 2009/3/3 mhanney > > I also switched to the trunk recently to try the new 10g dialect with > 10g Release 2 and I am very happy to report the following test > results: > > 1513 passed, 62 failed, 127 skipped, took 305.27 seconds. > > I am particularly happy to see all Guid

[nhusers] Re: ORACLE supports

2009-03-03 Thread mhanney
I also switched to the trunk recently to try the new 10g dialect with 10g Release 2 and I am very happy to report the following test results: 1513 passed, 62 failed, 127 skipped, took 305.27 seconds. I am particularly happy to see all Guid Type tests passing. Awesome. Here is my config...

[nhusers] Re: ORACLE supports

2009-03-03 Thread Nicolai Sørensen
Just switched our project to the trunk to try the new Oracle dialect and I must say, it works like a charm with 11g. Very nice job Fabio =) On 5 Feb., 04:19, Fabio Maulo wrote: > 2009/2/4 mhanney > > > > > More is the pity. Unfortunately for some - Oracle is still around. > > Not only still aro

[nhusers] Re: ORACLE supports

2009-02-04 Thread Fabio Maulo
2009/2/4 mhanney > > More is the pity. Unfortunately for some - Oracle is still around. Not only still around... only for information using Oracle10g Express NH run in 47% of the time needed with MsSQL2005 Express. NHibernate has many features not supported or at least not used by MsSQL users.

[nhusers] Re: ORACLE supports

2009-02-04 Thread mhanney
More is the pity. Unfortunately for some - Oracle is still around. The other Oralce/NHibernate user and I are very pleased with this news. Thanks Fabio. On Feb 4, 1:15 pm, Robin Nadeau wrote: > I had no idea that Oracle was still around. > > > > On Wed, Feb 4, 2009 at 4:13 PM, Fabio Maulo wrot

[nhusers] Re: ORACLE supports

2009-02-04 Thread Dario Quintana
No, my bad, I was looking in a old working copy. Conclusion: the trunk doesn't support vs2005, and you should have installed .net2.0 with the service pack. On Wed, Feb 4, 2009 at 8:49 PM, Oscar Orduz Acosta wrote: > Thanks Dario: > I can't find NHibernate-2.0.sln, and the trunk does not compile

[nhusers] Re: ORACLE supports

2009-02-04 Thread Oscar Orduz Acosta
Thanks Dario: I can't find NHibernate-2.0.sln, and the trunk does not compile with vs2005... I am doing something wrong? 2009/2/4 Dario Quintana > Oh, I didnt' try it, but the NHibernate-2.0.sln is there > > On Wed, Feb 4, 2009 at 7:59 PM, Oscar Orduz Acosta wrote: > >> Fabio: >> This trunk doe

[nhusers] Re: ORACLE supports

2009-02-04 Thread Dario Quintana
Oh, I didnt' try it, but the NHibernate-2.0.sln is there On Wed, Feb 4, 2009 at 7:59 PM, Oscar Orduz Acosta wrote: > Fabio: > This trunk does not support vs2005? right? > -- Dario Quintana http://darioquintana.com.ar --~--~-~--~~~---~--~~ You received this me

[nhusers] Re: ORACLE supports

2009-02-04 Thread Dario Quintana
Actually, i'm working right now, follow the log of the trunk. http://nhjira.koah.net/browse/NH-1571 On Wed, Feb 4, 2009 at 7:03 PM, Robin Nadeau wrote: > Is there any plans for sql server 2008? > -- Dario Quintana http://darioquintana.com.ar --~--~-~--~~~---~--~-

[nhusers] Re: ORACLE supports

2009-02-04 Thread Dario Quintana
Actually the trunk requires .Net2.0 with service pack. On Wed, Feb 4, 2009 at 7:59 PM, Oscar Orduz Acosta wrote: > Fabio: > This trunk does not support vs2005? right? > -- Dario Quintana http://darioquintana.com.ar --~--~-~--~~~---~--~~ You received this messa

[nhusers] Re: ORACLE supports

2009-02-04 Thread Fabio Maulo
Oscar.If you need Guid as POID and your DBA not trust to .NET you can use the new "guid.native" generator. NHibernate.Id.NativeGuidGenerator 2009/2/4 Oscar Orduz Acosta > Thanks a lot Fabio, > I've just downloaded the trunk and I will try with this new dialects. We > have installations with both

[nhusers] Re: ORACLE supports

2009-02-04 Thread Oscar Orduz Acosta
Ok, I've not done the migration to 2008 yet, so I have to wait until that to make the tests. thanks Oscar 2009/2/4 Fabio Maulo > 2009/2/4 Oscar Orduz Acosta > >> Fabio: >> This trunk does not support vs2005? right? >> > > Correct, and the trunk will be the last version target to .NET2.0. > >

[nhusers] Re: ORACLE supports

2009-02-04 Thread Fabio Maulo
2009/2/4 Oscar Orduz Acosta > Fabio: > This trunk does not support vs2005? right? > Correct, and the trunk will be the last version target to .NET2.0. -- Fabio Maulo --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups

[nhusers] Re: ORACLE supports

2009-02-04 Thread Oscar Orduz Acosta
Fabio: This trunk does not support vs2005? right? 2009/2/4 Oscar Orduz Acosta > Thanks a lot Fabio, > I've just downloaded the trunk and I will try with this new dialects. We > have installations with both MsSqlServer and Oracle databases. The Oracle > installations is mainly in government inst

[nhusers] Re: ORACLE supports

2009-02-04 Thread Oscar Orduz Acosta
Thanks a lot Fabio, I've just downloaded the trunk and I will try with this new dialects. We have installations with both MsSqlServer and Oracle databases. The Oracle installations is mainly in government institutions with Oracle 9i and 10g, so I will test with them. Oscar 2009/2/4 Fabio Maulo

[nhusers] Re: ORACLE supports

2009-02-04 Thread Fabio Maulo
Probably done after a clean installation of MSSQL2008 (stay alone without previous versions) 2009/2/4 Tuna Toksoz > Dario is working on that, and there is a dialect that has 2 mssql 2008 > datatypes namely DateTime2 and DATETIMEOFFSET. > > FileStream is on the way! > > Tuna Toksöz > http://tunat

[nhusers] Re: ORACLE supports

2009-02-04 Thread Robin Nadeau
I had no idea that Oracle was still around. On Wed, Feb 4, 2009 at 4:13 PM, Fabio Maulo wrote: > sorry for the "hahahaha"but is strange that the only user responding my > post about Oracle is one MsSQL user > > 2009/2/4 Fabio Maulo > > hahaha...Is available on trunk. >> >> 2009/2/4 Robin Nadeau

[nhusers] Re: ORACLE supports

2009-02-04 Thread Fabio Maulo
sorry for the "hahahaha"but is strange that the only user responding my post about Oracle is one MsSQL user 2009/2/4 Fabio Maulo > hahaha...Is available on trunk. > > 2009/2/4 Robin Nadeau > > Is there any plans for sql server 2008? >> >> >> On Wed, Feb 4, 2009 at 3:43 PM, Fabio Maulo wrote: >

[nhusers] Re: ORACLE supports

2009-02-04 Thread Tuna Toksoz
Dario is working on that, and there is a dialect that has 2 mssql 2008 datatypes namely DateTime2 and DATETIMEOFFSET. FileStream is on the way! Tuna Toksöz http://tunatoksoz.com http://twitter.com/tehlike Typos included to enhance the readers attention! On Wed, Feb 4, 2009 at 11:03 PM, Robin

[nhusers] Re: ORACLE supports

2009-02-04 Thread Fabio Maulo
hahaha...Is available on trunk. 2009/2/4 Robin Nadeau > Is there any plans for sql server 2008? > > > On Wed, Feb 4, 2009 at 3:43 PM, Fabio Maulo wrote: > >> People, I'm proud to announce that NH2.1.0 (trunk) has 3 new dialects: >> Oracle8iDialect, Oracle9iDialect, Oracle10gDialect >> Using Ora

[nhusers] Re: ORACLE supports

2009-02-04 Thread Robin Nadeau
Is there any plans for sql server 2008? On Wed, Feb 4, 2009 at 3:43 PM, Fabio Maulo wrote: > People, I'm proud to announce that NH2.1.0 (trunk) has 3 new dialects: > Oracle8iDialect, Oracle9iDialect, Oracle10gDialect > Using OracleClientDriver, Oracle10gDialect and Oracle10g Express we are > pa

[nhusers] Re: ORACLE

2009-02-03 Thread Fabio Maulo
Oscar.I hope that today I can close the new Oracle dialects series: Oracle8iDialect, Oracle9iDialect, Oracle10gDialect I'm going to work in pagination using variable limits (instead fixed limits in SqlCommand text) and than in GUID support. When, and if, you can, please try new dialects in a real-

[nhusers] Re: ORACLE

2009-02-03 Thread Oscar Orduz Acosta
Hi Fabio Glad to know this information helped you, and yes I can to write that wiki, I hesitate to write this issue in nh becouse it's externally to it, but by my own experience (3 days tracking the problem) and yours become this very necessary to the community. Oscar 2009/2/3 Fabio Maulo > Co

[nhusers] Re: ORACLE

2009-02-03 Thread Fabio Maulo
Configuration of for Oracle to run NH-test NHibernate.Driver.OracleClientDriver User ID=NH;Password=nh;Data Source=localhost Unspecified false NHibernate.Dialect.Oracle10gDialect true 1, false 0, yes 'Y', no 'N' NHibernate.ByteCode.LinFu.ProxyFactoryFactory, NHibernate.ByteCode.LinFu Now the

[nhusers] Re: ORACLE

2009-02-03 Thread Sidar Ok
may be we can "call for" them with a blog post in nh-forge ? (so we can drive relevant people to there) On Tue, Feb 3, 2009 at 4:46 PM, Fabio Maulo wrote: > 2009/2/3 Sidar Ok > >> wow, that's spooky > > > What is important is to have some response from Oracle community because I > don't have an

[nhusers] Re: ORACLE

2009-02-03 Thread Fabio Maulo
2009/2/3 Sidar Ok > wow, that's spooky What is important is to have some response from Oracle community because I don't have any customer using it so I don't have a real project to work with Oracle. I'm checking each NH's failing test one-by-one "for the glory" and an help from NH+Oracle commun

[nhusers] Re: ORACLE

2009-02-03 Thread Fabio Maulo
Alleluya Thanks Oscar. 2009/2/3 Oscar Orduz Acosta > Hello Fabio: > I don't know if this relevant, but recently I have to deal with some issue > of OracleDriver from Microsoft, if this has isolation=ReadCommitted the > Rollback not working as expected becouse some modifications in the same

[nhusers] Re: ORACLE

2009-02-03 Thread Sidar Ok
wow, that's spooky On Tue, Feb 3, 2009 at 4:27 PM, Oscar Orduz Acosta wrote: > Hello Fabio: > I don't know if this relevant, but recently I have to deal with some issue > of OracleDriver from Microsoft, if this has isolation=ReadCommitted the > Rollback not working as expected becouse some modif

[nhusers] Re: ORACLE

2009-02-03 Thread Oscar Orduz Acosta
Hello Fabio: I don't know if this relevant, but recently I have to deal with some issue of OracleDriver from Microsoft, if this has isolation=ReadCommitted the Rollback not working as expected becouse some modifications in the same transaction seems to be commited. If I used the driver from Oracl

[nhusers] Re: ORACLE

2009-02-03 Thread Fabio Maulo
:(( no a solution when you run all tests together. :(( What happen ? nobody are working with ORACLE here ? 2009/2/3 Fabio Maulo > Apparently solved disabling the connection pooling trough connectionstring > .;Pooling=False > > 2009/2/3 Fabio Maulo > > Hi.I have a problem with some test and

[nhusers] Re: ORACLE

2009-02-03 Thread Fabio Maulo
Apparently solved disabling the connection pooling trough connectionstring .;Pooling=False 2009/2/3 Fabio Maulo > Hi.I have a problem with some test and I would like to know if it is a > know issue. > > As you probably know in each test we are checking the DB emptiness. > In presence of tran

[nhusers] Re: ORACLE

2009-02-02 Thread Fabio Maulo
Hi.I have a problem with some test and I would like to know if it is a know issue. As you probably know in each test we are checking the DB emptiness. In presence of transaction.Rollback the emptiness-check fail in my PC... if I run the test introducing a delay between Rollback and emptiness-check

[nhusers] Re: Oracle varchar2(4000)

2008-12-17 Thread Fabio Maulo
1, if I well remember, is the value to have NTEXT, TEXT, BLOB2, STRINGCLOB and so on in various RDBMS 2008/12/17 Ricardo Borges > > I had a problem with varchar2(4000) column for Oracle... > > I tried many types in the mapping and the only way I found was mapping > as "AnsiString" > The "Str

[nhusers] Re: Oracle in mono under linux

2008-11-04 Thread Ayende Rahien
*ORA-24806:*LOB form mismatch*Cause:*When reading from or writing into LOBs, the character set form of the user buffer should be same as that of the LOB. *Action:*Make sure that the buffer you are using to read or write has the same form as that of the LOB. On Tue, Nov 4, 2008 at 9:40 PM, Bruno Mat

[nhusers] Re: Oracle connection string in mono

2008-10-31 Thread Ayende Rahien
Start by doing new OracleConnection("...") until it works. On Fri, Oct 31, 2008 at 10:35 PM, Bruno Matos <[EMAIL PROTECTED]> wrote: > > Ayende Rahien wrote: > > What is the error? > 2008-10-31 20:24:35,095 [2] ERROR NHibernate.Util.ADOExceptionReporter:0 > - Connection parameter not supported: 'G

[nhusers] Re: Oracle connection string in mono

2008-10-31 Thread Bruno Matos
Ayende Rahien wrote: > What is the error? 2008-10-31 20:24:35,095 [2] ERROR NHibernate.Util.ADOExceptionReporter:0 - Connection parameter not supported: 'GISA) (SERVER' Thank you. > > On Fri, Oct 31, 2008 at 10:30 PM, Bruno Matos <[EMAIL PROTECTED] > > wrote: > > >

[nhusers] Re: Oracle connection string in mono

2008-10-31 Thread Ayende Rahien
What is the error? On Fri, Oct 31, 2008 at 10:30 PM, Bruno Matos <[EMAIL PROTECTED]> wrote: > > Hello! > > I'm trying to run an application under linux with mono 1.9, but the > connection string that works with .NET doesn't work with mono. here is > the configuration: > > > > > > >