I am designing a product for my company which will be sold to multiple clients. The clients may have any database (MYSQL,MS SQL Server , oracle).
Can i design in such a way that the product will work on any database?
This should be pretty much no problem.
I would like to use type4 jdbc driver. Can connection pooling be implemented?
Absolutely! Especially if you use connection pooling, all your configuration for the DB connection is in one place. To switch database drivers, you just change the configuration.
In case the client wants to change the server from Tomcat to JRUN it should be easy to migrate.
You have to look out for doing things that might not work across all database:
For example, MySQL does not support sub-SELECTs, so you might want to avoid those, or at least have some kind of plug-in that you can use for MySQL-using clients.
Stored procedures are a no-no, unless you want to provide a library of stored procedures for each of ther databases your clients might use (also MySQL is a problem, here, due to its lack of stored procedures).
Many databases do not have Oracle-style sequences, so you'll want to avoid those.
Switching drivers is easy... making your application portable across databases is slightly trickier. For small projects, I've used Apache Torque (http://db.apache.org/torque) as an O-R mapper. It's not the greatest tool in the world, but it knows which database you are using (you tell it) and then it can customize some of the queries (especially generating primary key values for you) for the database being used.
Good luck, -chris
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
