Re: Connecting db through odbc bridge in tomcat 5.5
David Segall wrote:
TwelveEighty <twelve.eighty@gmail.com> wrote:
On Dec 22, 2:26 am, ruds <rudra...@gmail.com> wrote:
Let me start by saying that building enterprise software on top of MS
Access is a BAD idea, it's better to use a "grown up" database such as
MS SQL, Oracle, MySQL. These databases all have native JDBC drivers,
instead of using the ODBC bridge. MySQL is a free database and MS SQL
2005 Express as well, so costs should not be a factor.
I'm sorry to be obsessive about this but I can't help correcting the
claim that MySQL is free. If you mean it is open source then you are
correct. However, unlike SQL Server Express, there are severe
restrictions on who can deploy a MySQL database without paying for it.
I have provided some more details and a comprehensive list of quality
databases that can be freely deployed at
<http://database.profectus.com.au>.
Besides, MySQL is not very good. Use Postgres or one of the other big
players. All the other databases mentioned in the reference (excellent site,
btw) are much better.
However, just because MySQL AB considers your product to be "linked" to their
GPL database just because you use it, doesn't make it so. IANAL, but I would
flout that phoney-baloney "restriction" in a heartbeat if I didn't think that
their product sucks in the first place. I wouldn't worry too hard that "just
*using* the database makes your application a derived work". OTOH, that the
vendor wants to take such a position also puts them on my list of Bad People,
and I certainly wouldn't want to divert my business's attention to defending
against such a patently specious claim.
As far as I'm concerned, MySQL AB can go suck eggs. Guun dun, MySQL AB.
--
Lew