Writing SQL Maps that support both SQL Server and Oracle

2005-01-21 Thread Barnett, Brian W.
We have a web app that runs against SQL Server. All of our SQL maps are SQL Server compliant. We now have to be able to support Oracle as well. (We never thought it would happen... a mistake.) Anyway, we are wondering if anyone has some general guidelines for writing SQL Maps so that they run

Re: Writing SQL Maps that support both SQL Server and Oracle

2005-01-21 Thread Ron Grabowski
You could use stored procedures. I'm starting to port statements originally written for SQL Server over to Access (with the .Net version of iBatis) and I think I can get away with defining database specific functions in the properties file that I define my database information: settings