I'll definitely give it a go when it's ready and available.
2009/8/14 David R. Longnecker <tiredstud...@gmail.com> > Glad you got it working! If I may ask, when the changes hit the master > branch, please give the Fluently method another shot... I'd be interested to > see how things work out with the updates. > > Thanks for the response! :) > > -dl > > > On Thu, Aug 13, 2009 at 4:57 PM, Froggymeister <froggymeis...@gmail.com>wrote: > >> So I got it working. Yea! >> I ended up using the connection below. >> >> It turns out that the reason I wasn't getting the expected results was >> because there weren't any results in the table to return. How could that be? >> Simple; when I first ran the application, it proceeded to create tables in >> my schema with names identical to the class names. So while I still had the >> "CATEGORY" table in the schema, a new table with the name "Category" was >> created. It did that for all classes except where in the HasManyToMany >> relationships I had specified the "WithTableName" method. >> >> I had to go back and remove all the new tables and reset the constraints >> back as it was. With the mapping classes I specified the table names with >> the "WithTable" method. It all worked after that. >> >> I am a newbie when it comes to NHibernate and Fluent NHibernate, so I will >> have to do some more reading to figure out why the new tables were created. >> How would I stop this from happening in cases where I already have a >> database with tables? I'd also have to learn about Oracle's case-sensitve >> object naming bit. Why and Why? I will also try and figure out the statement >> cache size setting for the Oracle DB. >> >> =========================================== >> var cfg = OracleClientConfiguration.Oracle9 >> .ConnectionString( c => c >> .Is( "DATA >> SOURCE=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.112)(PORT=1521))(CONNECT_DATA=(SERVER >> = DEDICATED)(SERVICE_NAME=XXX)));PERSIST SECURITY INFO=True;USER >> ID=XXXUser;Password=XXXUser" ) ); >> >> return Fluently.Configure() >> .Database( cfg ) >> >> .Mappings( m => m >> .FluentMappings.AddFromAssemblyOf<Category>() ) >> .BuildSessionFactory(); >> =========================================== >> >> >> >> 2009/8/14 David R. Longnecker <tiredstud...@gmail.com> >> >> Using the connection string below (and with working server, instance, >>> user, pass, and a mapping object), I connected to an Oracle i9 v9.2.0.8 >>> database without any errors. Unfortunately, not being the "DBA dude" I >>> don't have access to the dba schema to see if, perhaps, statement cache size >>> is a setting or something that we have turned on--knowing Oracle, it might >>> be a setting. >>> >>> As far as the updates, I haven't checked the git logs, but once James >>> looks over and blesses the changes, it will allow StatementCacheSize(int) to >>> be optional. >>> >>> In the mean time, if your string version of your connection string isn't >>> returning what you expect, perhaps there's an additional underlying >>> problem? I'm assuming, since you have ShowSql() turned on, that you can see >>> the SQL in your unit tests/debug and those statements work as expected if >>> you copy them into SQL Developer or SQL*Plus? >>> >>> -dl >>> >>> On Wed, Aug 12, 2009 at 5:19 PM, Froggymeister >>> <froggymeis...@gmail.com>wrote: >>> >>>> return Fluently.Configure() >>>> .Database( OracleClientConfiguration.Oracle9 >>>> .ConnectionString( c => c >>>> .Server( "XXX" ) >>>> .Instance( "XXXUser" ) >>>> .Username( "XXXUser" ) >>>> .Password( "XXXUser" ) >>>> *.StatementCacheSize( 100 ) *) >>>> .Cache( c => c >>>> .UseQueryCache() >>>> >>>> .ProviderClass<NHibernate.Cache.HashtableCacheProvider>() ) >>>> .ShowSql() ) >>>> .Mappings( m => >>>> m.FluentMappings.AddFromAssemblyOf<Category>() ) >>>> .BuildSessionFactory(); >>>> >>> >>> >>> >>> >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Fluent NHibernate" group. To post to this group, send email to fluent-nhibernate@googlegroups.com To unsubscribe from this group, send email to fluent-nhibernate+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/fluent-nhibernate?hl=en -~----------~----~----~----~------~----~------~--~---
