need your opinion : what is the best JDBC driver ?

tyris · Apr 10, 2001

hi all,

i've found so much company selling jdbc driver ...

i'd like your opinion about the best JDBC driver for MS SQL server 7 that could support SQL server and NT authentication.

tell me what's your favorite and why please, that could help me to find the best one. Best regards X-),
Elise

tiz · Apr 10, 2001

The Sun ODBC driver will do the trick for you and it should already be installed either with your servlet engine or in the JDK (I think - otherwise check

http://java.sun.com/products/jdbc/).

Some code like this is what you need.

Code:

...
try
{
	Class.forName(&quot;sun.jdbc.odbc.JdbcOdbcDriver&quot;);
	con = DriverManager.getConnection(&quot;jdbc:odbc:msdb&quot;,&quot;sa&quot;,&quot;&quot;);

	stmt = con.createStatement();
	rs = stmt.executeQuery(&quot;SELECT name FROM employees&quot;);

	out.println(&quot;<html><head><title>DB Example</title></head>&quot;);
	out.println(&quot;<body>&quot;);
	out.println(&quot;<UL>&quot;);
	while(rs.next())
	{
		out.println(&quot;<LI>&quot; + rs.getString(&quot;name&quot;));
	}
	out.println(&quot;</UL>&quot;);
	out.println(&quot;</BODY></HTML>&quot;);

}
        catch(Exception e)
{
	out.println(&quot;SQLException caught: &quot; + e.getMessage());
	if (e instanceof SQLException)
	{
		out.println(&quot;SQL Exception&quot;);
	}
	else
	{

	}
}

Hope this helps! --
Tim <tim@planetedge.co.uk>

tyris · Apr 11, 2001

thanks for the code, i even found a good site explaining this for the begining :

http://www.jspinsider.com/tutorials/jsp/Ray/jspb_ext_1_1.html

for the driver, well i have begun my search from the sun site, and they gave me so much results... what would like ùe company is the most common and used driver. so hard to choose among all those one...

Best regards X-),
Elise

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

need your opinion : what is the best JDBC driver ?

tyris

Programmer

tiz

Programmer

tyris

Programmer

Similar threads

Part and Inventory Search

Sponsor