Re: iBatis.Net future release

2010-05-08 Thread Ron Grabowski
For a project with ~3 commiters, Subversion seems to get the job done just fine. From: tech fan monsterc...@gmail.com To: user-cs@ibatis.apache.org; mich...@mccurrey.com Sent: Sat, May 8, 2010 11:25:59 AM Subject: Re: iBatis.Net future release How about as a

Re: [vote] Promote DataMapper 1.6 to General Availability

2009-08-04 Thread Ron Grabowski
+1 - Original Message From: Clinton Begin clinton.be...@gmail.com To: user-cs@ibatis.apache.org; andrea.tassin...@i-mconsulting.com Sent: Tuesday, August 4, 2009 9:21:31 AM Subject: Re: [vote] Promote DataMapper 1.6 to General Availability +1 On 2009-08-04, Andrea Tassinari

Re: iBATIS.NET Welcomes Michael McCurrey as Committer

2009-07-05 Thread Ron Grabowski
A simple-ish first patch might be to embed a providers.config into the assembly and implement the functionality described in this documentation from DbProviderFactory: /// summary /// Gets the IDbProvider given an identifying name. /// /summary /// remarks /// Familiar names for the .NET 2.0

Re: Next Release

2009-06-24 Thread Ron Grabowski
A very basic QueryForDataTable might look like this: // untested public static DataTable QueryForDataTable(this ISqlMapper sqlMapper, string statement, object parameter) { var dataTableRowDelegate = new QueryWithRowDelegateDataTable(); sqlMapper.QueryWithRowDelegate(statement,

Re: Ibatis.Net - A Call to Arms

2009-05-27 Thread Ron Grabowski
I'm still alive and forcing my team to use IBatis.Net :-) They've commented on the verboseness and requirement of having multiple xml config files...things like not being able to use one of the built-in DbProviderFactorys strings. Perhaps merging providers.config within sqlmap.config so there

QueryWithRowDelegateDictionaryCreator to help with bulk loading one-to-many relationships

2009-02-15 Thread Ron Grabowski
Using the RowDelegate approach avoids having to iterate through the returned IListT a second time to do the grouping: public class QueryWithRowDelegateDictionaryCreatorTKey, T { private readonly FuncT, TKey keySelector; private readonly IDictionaryTKey, IListT dictionary = new

Re: v3 + log4net

2008-12-10 Thread Ron Grabowski
The last time I checked there wasn't a log4net implementation of v3's logging abstraction. You should be able to take the log4net integration project from the v2 code and update that until someone (me) can commit the code. I think you need to implement two small-ish interfaces. - Original

Re: how to get a recent build of ibatis.NET data mapper

2008-10-09 Thread Ron Grabowski
You'll have to get the files from Subversion: https://svn.apache.org/repos/asf/ibatis/trunk/cs/V3/src and open the Visual Studio solution and build it. There's also a nant script. You'll need a Subversion client like TortoiseSVN: http://tortoisesvn.net/downloads If you're smart enough to

Re: How to use ibatis 1.3.0 connect to compact server(.sdf) database

2008-06-25 Thread Ron Grabowski
What are the Types that implement IDbConnection, IDbCommand, etc. for compact server? You'll need to add those entries to your providers.config file. - Original Message From: cindy wangbairan [EMAIL PROTECTED] To: user-cs@ibatis.apache.org Sent: Wednesday, June 25, 2008 4:50:36 AM

Re: Next Release?

2008-06-17 Thread Ron Grabowski
Its mostly the same code-base but in a different namespace with a new configuration engine. - Original Message From: Michael McCurrey (5318) [EMAIL PROTECTED] To: user-cs@ibatis.apache.org Sent: Monday, June 16, 2008 11:49:05 AM Subject: RE: Next Release? So is anybody running their

Re: Multiple ResultMap Support

2008-06-12 Thread Ron Grabowski
Try putting a semi-colon after the first select? - Original Message From: Michael Schall [EMAIL PROTECTED] To: user-cs@ibatis.apache.org Sent: Thursday, June 12, 2008 5:46:34 PM Subject: Multiple ResultMap Support I'm trying to use the multiple resultset support in one of my maps. I

Extending DataMapper from V3 to add support QueryForDataSet

2008-06-07 Thread Ron Grabowski
Here's an example of extending the DataMapper from V3 to add a QueryForDataSet method: http://www.ronosaurus.com/IBatisNet/DataSetDataMapper.cs.txt DataRow doesn't have a public constructor so I used a Hashtable in the resultClass of the resultMap then wrote a small adapter class to redirect

Re: DAO with SQLMAP vs just SQLMAP

2007-05-20 Thread Ron Grabowski
If you need support for managing multiple implmentations (DAOs or other things) of interfaces you're probably better off going with a container from the Castle Project (Windsor Container) or Spring Framework. - Original Message From: Garth Keesler [EMAIL PROTECTED] To:

Re: Statement Batching

2007-04-25 Thread Ron Grabowski
There isn't any prohibiting you from using Ayende's example code with IBatisNet now: // his reflection sample...you could also use the delegate code for (int i = 0; i products.Count; i++) { appendInfo.Invoke(sqlCmdSet, new object[] { SqlMapperAdapter.BuildDbCommand(sqlMapper, Product.Update,

Re: RE : iBatis.Net - Optimistic concurrency control

2007-04-19 Thread Ron Grabowski
You can put the items in an IDictionary and pass that in: ListDictionary parameters = new ListDictionary(); parameters[Employee] = employee; parameters[Timestamp] = timestamp; int rowsUpdated = sqlMapper.Update(Employee.Update, parameters); update id=UpdateEmployee UPDATE dbo.Employee SET

Re: QueryForDataTable()

2007-01-21 Thread Ron Grabowski
I started a branch a long time ago that I eventually deleted. I took another stab at it just now (haven't checked in any code anywhere) and ended up making these changes: - TypeRegistry.cs: add an alias for datatable - DataExchangeFactory.cs: add _dataRowDataExchange - ISqlMapper.cs: add

Re: Batched Statements

2007-01-03 Thread Ron Grabowski
Batching is a new feature of ADO.Net's 2.0 DataAdapter class: http://davidhayden.com/blog/dave/archive/2006/01/05/2665.aspx I believe JDBC natively supports batching. When it makes sense to batch things I usually use a StringBuilder and build the raw sql statements myself. - Original

Re: Cache not working

2006-12-28 Thread Ron Grabowski
CachingStatement should probably have the cache hit, cache miss logging messages. - Original Message From: Ron Grabowski [EMAIL PROTECTED] To: user-cs@ibatis.apache.org Sent: Thursday, December 28, 2006 12:43:31 AM Subject: Re: Cache not working [snip] Another solution may be to add

Re: Cache not working

2006-12-27 Thread Ron Grabowski
Is your ISqlMapper instance configured with caching enabled? MessageBox.Show(Mapper.Instance().IsCacheModelsEnabled); The default value is false. You'll need to enable it via the configuration file: settings setting useStatementNamespaces=true / setting

Re: Logging tip

2006-12-27 Thread Ron Grabowski
Technically you don't need to add it to your project...you just need to make sure that the assembly is in the same directory as your program so it can be loaded at run-time. If that file can't be loaded at run-time then you can't use the log4net bindings. Previous versions of IBatisNet would

Re: Cache not working

2006-12-27 Thread Ron Grabowski
IBatisNet.DataMapper.Test.NUnit.SqlMapTests.CacheController.TestReturnInstanceOfCachedOject looks like it tests the readOnly=true, serialize=false case. When I modified the test to run with readOnly=false, serialize=false the test failed. The last assert was failing:

Re: SQL Fragments in iBATIS.NET / Connection pooling

2006-11-13 Thread Ron Grabowski
We're using the built-in ADO.Net connection pooling (i.e. whatever the IDbConnection supports via its ConnectionString). - Original Message From: Bruno Silva (Cool Advance) [EMAIL PROTECTED] To: user-cs@ibatis.apache.org Sent: Monday, November 13, 2006 11:49:02 AM Subject: Re: SQL

Re: Profiling .Net code

2006-10-26 Thread Ron Grabowski
dotTrace from Jetbrains and ANTS Profiler from Red Gate seem to be resonable priced products. I believe both have trail versions. The IBatisNet.DataMapper.Test.NUnit.SqlMapTests.Perf namespace has tests which compare a SqlMapper to normal ADO.Net. The recent IL enchancements for

Re: RE : Re: distributed cahing/iBATIS.Net

2006-10-26 Thread Ron Grabowski
? Thanks, Tite Ron Grabowski [EMAIL PROTECTED] a écrit : The ICacheController interface only has a few members to it. I didn't see anything in the MemcachedClient about removing multiple keys. I haven't tested the code below but I'm able to run the MemcachedBench program

Re: viewing generated SQL without Log4Net?

2006-10-24 Thread Ron Grabowski
You can setup the LogManager's Adapter without a configuration file: [SetUp] public void Init() { IBatisNet.Common.Logging.LogManager.Adapter = new ConsoleOutLoggerFA(new NameValueCollection()); } - Original Message From: Douglas Smith [EMAIL PROTECTED] To:

Re: viewing generated SQL without Log4Net?

2006-10-23 Thread Ron Grabowski
Logging is currently the most straightforward way of viewing what's being sent to the database. IBatisNet comes with a Console logger so you technically don't need to setup log4net to view the sql inside of nunit-gui. What exactly are you wanting to do? - Original Message From:

Re: can't run iBatis Tutorial

2006-10-17 Thread Ron Grabowski
Are you able to update the wiki with your changes? Thanks, Ron - Original Message From: robsosno [EMAIL PROTECTED] To: user-cs@ibatis.apache.org Sent: Tuesday, October 17, 2006 4:24:56 PM Subject: Re: can't run iBatis Tutorial robsosno wrote: I'm trying to evaluate iBatis to check if

Re: MySql Connection problem

2006-10-16 Thread Ron Grabowski
Have you verified the connetion string works on a normal MySqlConnection (or whatever MySql's IDbConnection is)? using (IDbConnection connection = new MySqlConnection(...)) { Console.Write(connection.ConnectionState); } - Original Message From: Tony Elmore [EMAIL PROTECTED]

Re: Log4net...

2006-10-16 Thread Ron Grabowski
Did Don's post help resolve your problem? - Original Message From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: user-cs@ibatis.apache.org; Ron Grabowski [EMAIL PROTECTED] Sent: Saturday, October 14, 2006 1:56:28 PM Subject: Log4net... I copied and pasted configuration in the ibatis sqlmapper

Re: Writing a custom session store by implementing ISessionStore

2006-10-08 Thread Ron Grabowski
I think the problem he's experiencing is that there's no way to tell IBatisNet to always use CallContextSessionStore even if its running in a web site where HttpContext is available. If we made an ISessionStoreFactory and wrote a CallContextSessionStoreFactory implementation then the user could

Re: Writing a custom session store by implementing ISessionStore

2006-10-07 Thread Ron Grabowski
Write a patch that allows the user to specify an ISessionStoreFactory: public class StaticSessionStoreFactory : ISessionStoreFactory { public ISessionStore GetSessionStore(string sqlMapperId) { return new StaticSessionStore(sqlMapperId); } } settings setting

Re: distributed cahing/iBATIS.Net

2006-10-06 Thread Ron Grabowski
. If no one's done it by the time I get there, then I'll probably do it :) Alex -Original Message- From: Ron Grabowski [mailto:[EMAIL PROTECTED] Sent: Thursday, October 05, 2006 7:22 PM To: user-cs@ibatis.apache.org Subject: Re: distributed cahing/iBATIS.Net Someone needs to write

Re: distributed cahing/iBATIS.Net

2006-10-05 Thread Ron Grabowski
Someone needs to write an IBatisNet cache client for memcached: http://www.danga.com/memcached/ There is a closed source solution called NCache but its probably $$$. - Original Message From: Tite Etoundi [EMAIL PROTECTED] To: user-cs@ibatis.apache.org Sent: Tuesday, October 3,

Re: Log4Net and logging SQL Statements

2006-08-17 Thread Ron Grabowski
With your current configuration, you're telling your application to look for the log4net configuration in the App/Web.config and for IBatisNet to re-configure log4net from the Log4net.config file. I usually configure log4net from my application and tell IBatisNet to attach itself to that

Re: [VOTE] Promote iBATIS DataMapper 1.5.1, DataAccess 18.1 to General Availability

2006-08-10 Thread Ron Grabowski
+1 --- Gilles Bayon [EMAIL PROTECTED] wrote: Hi all, After a cycle of 2 BETA, the iBATIS DataMapper 1.5.1, DataAccess 18.1 can now be considered as General Availability. This release is primarily an enhancement release to support .NET 2.0 and also bug fix, documentation have been

Re: SQL Statement: Console App...works great, Web App...properties not parsed

2006-07-29 Thread Ron Grabowski
Hrmmm, that's very strange. What version of IBatisNet are you using? Are you able to make a very small test application and post a .zip of it somewhere or email it to me directly? --- Support [EMAIL PROTECTED] wrote: Have an SQL statement as follows: insert id=InsertCustomer

RE: iBatis Newbie: Problem with typeAlias

2006-07-19 Thread Ron Grabowski
You need to tell the type loader what assembly the class is coming from. What is the name of your project's .dll? --- Douglas Smith [EMAIL PROTECTED] wrote: Why is this not good enough? typeAlias alias=Forecaster type=com.roanoketimes.forecasters.data.Forecaster /

Re: iBatis Newbie: problem with providers.config

2006-07-17 Thread Ron Grabowski
What does your providers.config file look like? ?xml version=1.0 encoding=utf-8? providers xmlns=http://ibatis.apache.org/providers; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; clear/ provider name=sqlServer1.1 description=Microsoft SQL Server, provider V1.0.5000.0 in framework

Re: ResultMap with constructor injection

2006-07-17 Thread Ron Grabowski
DataMapper 1.5 supports this notation (IBATISNET-155): resultMap id=account-result-constructor class=Account constructor argument argumentName=id column=Account_ID/ argument argumentName=firstName column=Account_FirstName/ argument argumentName=lastName column=Account_LastName/

Re: ResultMap with constructor injection

2006-07-17 Thread Ron Grabowski
ParameterType:Type Position:int --- Clinton Begin [EMAIL PROTECTED] wrote: Wow, I gotta read the docs. :-) BTW: What's the argumentName attribute for? Can C# introspect on the argument names? Cheers, Clinton On 7/17/06, Ron Grabowski [EMAIL PROTECTED] wrote: DataMapper 1.5 supports

Re: Domain classes from multiple assemblies...

2006-07-16 Thread Ron Grabowski
I don't understand...do you mean: typeAlias alias=Book assembly=DomainTwo.Book, DomainTwo / or: typeAlias alias=Book type=DomainTwo.Book assembly=DomainTwo / The first example isn't very .NET-ish. When .NET people talk about dynamically loading a Type, they talk about it in terms of its

Re: Creating a DataTable from an IList returned from the data mapper

2006-07-15 Thread Ron Grabowski
What ASP.Net components only bind to DataTables and DataSets? I think its ineffecient to get an IList back of items then iterate through it a second time to convert it to a DataTable. I'm in favor of an implementation that creates the DataTable from the IDataReader directly. --- Riccardo

Re: Possible Bug: ResultMapping with a resultmap with no direct Properties

2006-07-15 Thread Ron Grabowski
You're using DataMapper 1.5 Beta correct? Is useReflectionOptimizer enabled? --- Peter Mills [EMAIL PROTECTED] wrote: I'm having trouble with a resultmapping, using the latest beta of the mapper. The problem occurs when a resultMapping only contains properties with select attributes

Re: Working with .NET 2.0

2006-07-05 Thread Ron Grabowski
Could you post the xml file that is generating the error? --- Martin Trejo Ch�vez [EMAIL PROTECTED] wrote: Hi everybody, I'm trying to use the original iBATIS assemblies in a project inside VS2005 and I'm getting this error message: IBatisNet.Common.Exceptions.ConfigurationException

Re: Firebird + Framework 2.0

2006-06-26 Thread Ron Grabowski
Does the version of the Firebird driver in your application's /bin directory match the information in the providers.config file? Are you able to dynamically the objects in the Firebird assembly yourself? For example: Type type = Type.GetType(MySql.Data.MySqlClient.MySqlConnection,

Re: Could not load type after worker process idle timeout

2006-05-27 Thread Ron Grabowski
How are you configuring your SqlMapper? Building a SqlMapper object is expensive. Most people create a static instance of SqlMapper. Are you creating a new SqlMapper every time you make a query? --- Jarmo Ollikainen [Entegra Oy] [EMAIL PROTECTED] wrote: Hello fellow iBATIS users, I have an

Re: Could not configure ResultMap

2006-05-05 Thread Ron Grabowski
Since you're building from source, can you provide a Debug trace that shows the line number of where the exception is occuring? --- Alexandre Grenier [EMAIL PROTECTED] wrote: Hello all, I'm considering iBatis to help rewriting a quite large project - terabyte size db. The first step is to

RE: Could not configure ResultMap

2006-05-04 Thread Ron Grabowski
Send the zip file to me or post it online somewhere and I'll take a look at it. --- Alexandre Grenier [EMAIL PROTECTED] wrote: Thanks Luke, I wish to be doing whatever you do that makes it work :) The files are all just sitting in the bin folder. The Domain.dll is there. I tried with

Re: SelectKey with resultmap

2006-04-17 Thread Ron Grabowski
No. The good news is that because of this: http://issues.apache.org/jira/browse/IBATISNET-143 selectKey nodes are processed in the same way all the other statement nodes are processed. I think its just a one line fix: // InsertDeSerializer.cs:84 selectKey.ResultMapName =

Re: .Net 1.1 Null Dates Issue

2006-04-11 Thread Ron Grabowski
Try using this custom type handler that maps NULL columns to DateTime.MinValue and vice-versa: http://www.mail-archive.com/user-cs@ibatis.apache.org/msg00636.html --- James, Justin [EMAIL PROTECTED] wrote: This is my first experience with ibatis and I am stuck on a problem with null dates

RE: MySpace.com

2006-03-30 Thread Ron Grabowski
Either a zip file or open a new issue here: http://issues.apache.org/jira/browse/IBATISNET --- Christopher Bissell [EMAIL PROTECTED] wrote: Thanks very much Gilles, How would you like the files, in a ZIP via email? I'll start looking at the latest revisions concerning the emit call.

Re: MySpace.com

2006-03-29 Thread Ron Grabowski
--- Christopher Bissell [EMAIL PROTECTED] wrote: Hello everyone, I didn't want to talk about it until it was a 'core' piece of our architecture, but MySpace.com is now running IBatis for a good portion of its data access abstraction layer. Neat! Is this article true:

RE: DataAccess problems

2006-03-29 Thread Ron Grabowski
Could you post your dao.config file? Since you're running in Debug mode, can you provide the exact line number that is causing the exception. Or re-paste your stack trace when ran in Debug mode. It should contain line numbers. --- Svancara, Randall - CO 7th [EMAIL PROTECTED] wrote: I rebuilt

Re: Can SelectKey have a parameter

2006-03-28 Thread Ron Grabowski
The InsertDeSerializer class only looks for property, type, and resultClass attributes. I've added an issue along with a patch in Jira for selectKey nodes to allow dynamic sql: http://issues.apache.org/jira/browse/IBATISNET-143 I suppose InsertDeSerializer could be changed to allow a

Re: DataAccess problems

2006-03-28 Thread Ron Grabowski
Can you post the full stack trace please? What method in IBatisNet is throwing the exception? --- Svancara, Randall - CO 7th [EMAIL PROTECTED] wrote: I have implemented IBATIS data access and data mapper. I have been looking at the Subversion repository for examples of how to implement

Re: Problem trying to declare a Sybase provider

2006-03-25 Thread Ron Grabowski
Could you post the Sybase provider entry from your providers.config. IBatisNet is basically doing this: Type sybaseCommandType = Type.GetType(Mono.Data.SybaseCommand, Mono.Data.SybaseClient, Version=2.0.0.0, Culture=neutral,PublicKeyToken=0738eb9f132ed756); IDbCommand command =

Re: smalldatetime to string conversion problem in sql server

2006-03-13 Thread Ron Grabowski
I would expect a database column of type SmallDateTime to be mapped to a DateTime object...not a string. Why not keep it as a DateTime and let your application decide its string representation? --- Zarar Siddiqi [EMAIL PROTECTED] wrote: Ok, for now I've fixed this problem by defining a custom

Re: c# ibatis:procedure

2006-02-19 Thread Ron Grabowski
According to this snippet from SqlMap.xsd: xs:element name=sqlMap xs:complexType xs:sequence xs:element ref=alias minOccurs=0/ xs:element ref=cacheModels minOccurs=0/ xs:element ref=resultMaps minOccurs=0/ xs:element ref=statements minOccurs=0 / xs:element

Re: Getting wrong type back from DaoManager.GetType()

2006-02-07 Thread Ron Grabowski
I've always casted the result from GetDao(): _companyDao = (ICompanyDao)_daoManager.GetDao(typeof(ICompanyDao)); --- Jason Taylor [EMAIL PROTECTED] wrote: Hello all, The DaoFactory portion of my dao.config is configured thus: ... daoFactory dao

Re: Does ibatis support temp tables in sql maps?

2006-01-30 Thread Ron Grabowski
You need to escape the pound sign with another pound sign: ##tmpTopLevelJobKeywords

Re: Using Unary condition elements to add prepended statements without tag text

2006-01-30 Thread Ron Grabowski
I believe Java iBATIS solves this by allowing prepend attributes on all dynamic elements: isNotNull property=PersonName prepend=a INNER JOIN Person p ON a.PersonID = p.PersonID / I think that would solve your problem. Make a feature request in JIRA:

Re: Error configuring DAO. Cause: Ambiguous match found.

2006-01-30 Thread Ron Grabowski
Can we see ICompanyDao and the method signatures from the class that implements ICompanyDao. This looks like a DynamicProxy exception. --- Jason Taylor [EMAIL PROTECTED] wrote: Hello everyone; I'm fairly new to iBATIS and I seem to have hit a wall that I can't get around. I keep getting

Re: New to IBATIS.NET..and have Problems

2006-01-28 Thread Ron Grabowski
Instead of doing this: IDbCommand command = getCommandWithOpenConnection(); int rowsAffected = command.ExecuteNonQuery(@ UPDATE User SET LastLoginDate = ' + DateTime.Now + '); You do this: int rowsAffected = sqlMapper.Update(User.Update, DateTime.Now); You'll need a SqlMap.config and a

Re: Binding datagrid to ArrayList of Hashtables

2005-12-22 Thread Ron Grabowski
asp:Repeater runat=server id=repList ItemTemplate asp:Literal id=litItem runat=server / /ItemTemplate /asp:Repeater private void repList_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item) { IDictionary dict = (IDictionary)e.Item.DataItem;

Re: Using iBatis.NET DataAccess with NHibernate AND SqlMap

2005-11-05 Thread Ron Grabowski
It should be possible. Have you looked at the IBatisNet.DataAccess.Extensions project? http://tinyurl.com/9ldl9 http://svn.apache.org/repos/asf/ibatis/trunk/cs/mapper/IBatisNet.DataAccess.Extensions/DaoSessionHandlers/ --- Andreas Schmidt [EMAIL PROTECTED] wrote: Hello all, First of

Re: ibatis and firebird 1.7

2005-10-21 Thread Ron Grabowski
http://www.connectionstrings.com/ lists this as a sample connection string: User=SYSDBA;Password=masterkey;Database=SampleDatabase.fdb;DataSource=localhost;Port=3050;Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=true;MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0 ---

RE: nullable types when querying the db

2005-10-19 Thread Ron Grabowski
create a package with source and a class library. /Okku -Original Message- From: Ron Grabowski [mailto:[EMAIL PROTECTED] Sent: den 18 oktober 2005 20:15 To: user-cs@ibatis.apache.org Subject: Re: nullable types when querying the db Thanks to some nagging on my part

Re: Attempting to build NPetshop using Visual Studio 2005

2005-10-19 Thread Ron Grabowski
NPetshop is old. NPetshop2 is more up to date. I doubt anyone has tried to compile NPetshop with VS2005. nstruts-config.xml isn't used. This is the exception I get when I launch the NPetshop website: Exception : at NPetshop.Presentation.UserActions.CatalogAction..ctor(HttpContext context) at

Re: GetDao has been changed from string to type?

2005-10-18 Thread Ron Grabowski
Does this work? ICandidateDao _candidateDao = daoManager[typeof(ICandidateDao)] as ICandidateDao; IKeywordDao _keywordDao = daoManager[typeof(IKeywordDao)] as IKeywordDao; ICategoryDao _categoryDao = daoManager[typeof(IUserDao)] as ICategoryDao; --- Brian Kierstead [EMAIL

Re: nullable types when querying the db

2005-10-18 Thread Ron Grabowski
Thanks to some nagging on my part :-) http://www.mail-archive.com/user-cs%40ibatis.apache.org/msg00390.html http://www.mail-archive.com/user-cs%40ibatis.apache.org/msg00405.html http://issues.apache.org/jira/browse/IBATISNET-120 there is code in SVN allows for overriding the global

RE: ConfigureAndWatch Performance Issue

2005-10-17 Thread Ron Grabowski
Are you doing any type of timing tests with the loading or are you just saying things feel slow? My AMD 1.8GHz (Athlon 2500+) machine processes 110 statements, 22 cache models, and 15 result maps spread across 15 files in 0.65 seconds. I built my project in Release mode using this code:

Re: strong name assembly IBatisNet.DataMapper.dll DLL

2005-10-14 Thread Ron Grabowski
Comment out these lines in AssemblyInfo.cs: // [assembly: AssemblyDelaySign(false)] // [assembly: AssemblyKeyName()] // [assembly: AssemblyKeyFile(..\\..\\AssemblyKey.snk)] --- Mariano [EMAIL PROTECTED] wrote: Hello Ive a little problem with IBatisNet.DataMapper.dll, when im building my

RE: ConfigureAndWatch Performance Issue

2005-10-14 Thread Ron Grabowski
- From: Ron Grabowski [mailto:[EMAIL PROTECTED] Sent: Thursday, October 13, 2005 11:06 PM To: user-cs@ibatis.apache.org Subject: Re: ConfigureAndWatch Performance Issue Is it ok if I include your VB.Net code in the IBatisNet DataMapper documentation so other people can use

RE: ConfigureAndWatch Performance Issue

2005-10-14 Thread Ron Grabowski
the files. I could send you if you want screen captures of all the steps I did. Thanks -Original Message- From: Ron Grabowski [mailto:[EMAIL PROTECTED] Sent: Friday, October 14, 2005 11:12 AM To: user-cs@ibatis.apache.org Subject: RE: ConfigureAndWatch Performance Issue SVN

RE: ConfigureAndWatch Performance Issue

2005-10-14 Thread Ron Grabowski
way you have to download the SVN? -Original Message- From: Ron Grabowski [mailto:[EMAIL PROTECTED] Sent: Friday, October 14, 2005 2:16 PM To: user-cs@ibatis.apache.org Subject: RE: ConfigureAndWatch Performance Issue Hmmm, this is what I did (Flash movie): http

Re: ConfigureAndWatch Performance Issue

2005-10-13 Thread Ron Grabowski
Is it ok if I include your VB.Net code in the IBatisNet DataMapper documentation so other people can use it? --- Cynthia Torres [EMAIL PROTECTED] wrote: Hi, I'm newer to iBatis. I'm experiencing some performance issues with the ConfigureAndWatch method, it takes about 6 seconds in

RE: ConfigureAndWatch Performance Issue

2005-10-13 Thread Ron Grabowski
Hmmm, it should be on this page: http://ibatis.apache.org/mailinglists.html but its not. Try emailing this address: [EMAIL PROTECTED] --- paul [EMAIL PROTECTED] wrote: Hi, How do I unsubscribe from the list. Sorry for the trouble but I looked on the website and couldn't see any

Re: Reuse SQL Fragment

2005-10-07 Thread Ron Grabowski
I've added an issue for this. I don't think anyone has started on it yet: http://issues.apache.org/jira/browse/IBATISNET-116 --- Hai Hoang [EMAIL PROTECTED] wrote: Does IBATIS.NET supports reuse SQL-fragment such as this

Re: Custom Data Access Exception

2005-10-05 Thread Ron Grabowski
I think has been resolved in the SVN. The code now looks something like this: try { result = invocation.Method.Invoke( _daoImplementation.DaoInstance, arguments); } catch (Exception e) { throw UnWrapException(e, invocation.Method.Name); } Where UnWrapException removes the proxy

Re: Changing database inside transaction

2005-10-05 Thread Ron Grabowski
That's a strange request...why would you want to do that? Is this possible using normal ADO.Net? --- Choi, W. Byung [EMAIL PROTECTED] wrote: Hi All. Is Changing database inside transaction is possible? Byung Choi

Re: Custom DateTime type handler that overrides IBatisNet's DateTimeTypeHandler

2005-10-04 Thread Ron Grabowski
I think the 01/01/0001 00:00:00 is ugly. Who has the value of double.MinValue memorized? I don't use parameterMaps. I use the standard #Property# syntax: update id=Update parameterClass=User UPDATE [User] SET [Login] = #Login#, [Password] = #Password#, [Name] = #Name#,

Re: Custom DateTime type handler that overrides IBatisNet's DateTimeTypeHandler

2005-10-03 Thread Ron Grabowski
? --- Ron Grabowski [EMAIL PROTECTED] wrote: I want to implement a typeHandler for DateTime objects that overrides the default DateTimeTypeHandler. I've added this text to my sqlMap.config file: typeHandlers typeHandler type=DateTime callback

RE: URGENT - Connecting to both Oracle and SqlServer - PLEASE HELP

2005-09-30 Thread Ron Grabowski
I would make short Console app that uses your existing config file and does simple queries between the database. This test case shows two DaoManagers interacting with each other: http://tinyurl.com/7awxt

RE: Sybase ASE

2005-09-30 Thread Ron Grabowski
the connection string then clone everything is fine. From what I see in the code, I'm stuck, so I'm off to contact Sybase support. We'll see what they say... Thanks for the help... -Original Message- From: Ron Grabowski [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 6:16 PM

RE: Sybase ASE

2005-09-30 Thread Ron Grabowski
then sets the connection string, if I set the connection string then clone everything is fine. From what I see in the code, I'm stuck, so I'm off to contact Sybase support. We'll see what they say... Thanks for the help... -Original Message- From: Ron Grabowski [mailto:[EMAIL

Re: Sybase ASE

2005-09-29 Thread Ron Grabowski
Have you verified that the connection string works using normal ADO.Net: string connectionString = @Provider=Sybase.Ase;Data Source=ASTOR;Port=5004;Database=QUAD0006;Min Pool Size=1; Max Pool Size=2;User Id=xxx;Password=xxx; IDbConnection conn = new

RE: Sybase ASE

2005-09-29 Thread Ron Grabowski
work... -Original Message- From: Ron Grabowski [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 4:22 PM To: user-cs@ibatis.apache.org Subject: Re: Sybase ASE Have you verified that the connection string works using normal ADO.Net: string connectionString

Re: URGENT - Connecting to both Oracle and SqlServer - PLEASE HELP

2005-09-28 Thread Ron Grabowski
Your dao.config file should look more like this: ?xml version=1.0 encoding=utf-8? daoConfig xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xsi:noNamespaceSchemaLocation=DaoConfig.xsd context id=SqlServer daoSessionHandler id=SqlMap property name=sqlMapConfigFile value=SqlMap.config/

Re: Will iBATIS work with Framework 2.0?

2005-09-27 Thread Ron Grabowski
There is no guide to moving towards .Net 2.0 yet. I believe the product is still officially a beta. Its my understanding that .Net 2.0 should run existing 1.1 programs with little or no modification. Did you search the list archives? http://www.mail-archive.com/user-cs%40ibatis.apache.org/

Re: oracle select key doesn't work?

2005-09-27 Thread Ron Grabowski
According to the test cases: http://tinyurl.com/77dbg http://svn.apache.org/repos/asf/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/OracleClient/Category.xml This should be the correct syntax: insert id=InsertCategoryNull parameterMap=insert-null-params selectKey property=Id

Free version of Oracle to run IBatisNet test cases?

2005-09-27 Thread Ron Grabowski
Roberto (or other Oracle people), is there a free version of Oracle that I can install at home to run the test cases on? Thanks, Ron

Re: Will iBATIS work with Framework 2.0?

2005-09-27 Thread Ron Grabowski
entry. --- oleksa borodie [EMAIL PROTECTED] wrote: On 9/27/05, Ron Grabowski [EMAIL PROTECTED] wrote: Did you search the list archives? http://www.mail-archive.com/user-cs%40ibatis.apache.org/ Someone asked a very similiar questions 24 hours ago. You mean logging in ASP.NET 2.0 thread

RE: Will iBATIS work with Framework 2.0?

2005-09-27 Thread Ron Grabowski
Message- From: oleksa borodie [mailto:[EMAIL PROTECTED] Sent: den 27 september 2005 16:24 To: user-cs@ibatis.apache.org; Clinton Begin Subject: Re: Will iBATIS work with Framework 2.0? On 9/27/05, Ron Grabowski [EMAIL PROTECTED] wrote: Did you search the list archives? http://www.mail

RE: Will iBATIS work with Framework 2.0?

2005-09-27 Thread Ron Grabowski
I've been doing a lot of thinking today haven't I ;-) --- Ron Grabowski [EMAIL PROTECTED] wrote: I think Java style complex type mappings would be nice. I think the Java dynamic sql tags have a prePend attribute available. Do you know of any other differences? I think people would

RE: logging in ASP.NET 2.0

2005-09-26 Thread Ron Grabowski
What methods were reported as being depreciated when you compiled in 2.0? BuildDefaultLoggerFactoryAdapter() is in the SVN version of IBatisNet. If you are using the version in SVN, you'll need to add some additional code to your web.config: sectionGroup name=iBATIS section name=logging

RE: logging in ASP.NET 2.0

2005-09-26 Thread Ron Grabowski
Is everything working now? Was the problem the missing elements from the config file? Thanks for the .Net 2.0 warnings. They'll be a good starting point when discussions about .Net 2.0 take place. Does anyone know if IBatisNet works on verison 1.0 of the Framework? I wrote a IDataReaderProxy

Re: DataAccess_ADO_Oracle_Cursor

2005-09-26 Thread Ron Grabowski
This article: http://tinyurl.com/8qvsp http://64.233.187.104/search?q=cache:aYimzXAypr0J:dotnetjunkies.net/WebLog/rtgurskevik/archive/2004/12/03/34843.aspx+DbType+cursor+oracle+ado.nethl=en has this comment: // Need to pass as DbType.Object here since .Cursor type doesn't exist as DbType. //

Re: Result Map nested properties in .NET

2005-09-23 Thread Ron Grabowski
Hrmmm, I thought we had this functionality. I wrote a test case and got the same error you did. I looked through the code and I couldn't find anything that would parse that. I saw that IBatisNet.DataMapper.Test.Domain.LineItem had a Order property but we don't have tests to populate a property

Re: Result Map nested properties in .NET

2005-09-23 Thread Ron Grabowski
I think it would be nice if IBatisNet handled this case like Java. Is there a reason why we don't? If I were using a moderately complex object with other objects as properties: EmailMessage.FromOjbect.Name EmailMessage.ToObject.Name EmailMessage.BccObject.Name I would add 3 type aliases to my

Re: Dynamic SQL in SELECT statements

2005-09-21 Thread Ron Grabowski
http://issues.apache.org/jira/browse/IBATISNET-114 --- Ron Grabowski [EMAIL PROTECTED] wrote: This sounds similiar to ibatis Java's remapResults=true setting. Any chance you could compile in Debug mode so we can get the line number of the exception? I suppose I could write my own test case

  1   2   >