Database Connection Drivers
Hi guys,
I've been working with a couple of database applications and I'm currently using the Sun JDBC driver for all my connections -
Code:
"sun.jdbc.odbc.JdbcOdbcDriver"
My question is basically what other kinds of driver are available and what are the advantages and disadvantages of each one? Are there any that you would prefer to use or does it depend on the kind of database you're connecting to?
Thanks
Re: Database Connection Drivers
Well, where do I start!
Your question requires a long research and I don't think you can find an easy answer to it.
The JDBC driver is general and works for most DB connections. But as far as I know each of the well known DB servers provide it's own JDBC compatible driver for easier usage.
I haven't tried many but the component for the MySql db works much faster than just using the simple JDBC connection. and comes with great tools and classes for us developers (to make out lives easier). but that doesn't mean that the JDBC driver is not as good -it was even better than the driver the community made for the MS-SQL Server 2000 until Microsoft released their version.
So as far as I know it's just about easiness and performance (not in many cases)
Re: Database Connection Drivers
We always use MERLIA as jdbc driver for the SQL Server,which supports ResultSetMetaData,XAConnection and SQLXML.