Hey!
>I believe that all of them are Type 4, though. However, being third-party
drivers
This is not true. There are is a company that sells a Type-3 driver, Merant
at $US 5000. A tough bullet to bite, since you can buy one of the
well known DBs for less than that and get the JDBC Type-3 driver
included.
You are correct Robert. The only people using
SQLServer are the ones that are stuck with it. It's not well supported,
and given the break up of Microsoft, SQLServer could eventually be
an orphaned product.
I hope everyone knows the disadvantages of using a Type-4 driver. In
a nutshell, you don't for a commercial production system. You can find out
more about JDBC Types at the Sun website.
Sorry about the off-topic reply to the post.
Sans adieu,
Danny Rubis
Robert Claeson wrote:
> I-Net Software sells several JDBC drivers for SQL Server. I believe that
> all of them are Type 4, though. However, being third-party drivers, they
> add significantly to the cost of the SQL Server license, and is only an
> optimimal solution if there's already an SQL Server database in place that
> can't easily be replaced.
>
> /Robert
>
> Danny Rubis <[EMAIL PROTECTED]>
> Sent by: "A mailing list for discussion about Sun Microsystem's Java
> Servlet API Technology." <[EMAIL PROTECTED]>
> 2000-05-14 15:00
> Please respond to "A mailing list for discussion about Sun Microsystem's
> Java Servlet API Technology."
>
> To: [EMAIL PROTECTED]
> cc:
> Subject: Re: Scrollable resultset
>
> Hey!
>
> I would not consider a DB any good unless it supplied a
> good Type 3 JDBC driver. That leaves out SQLServer.
>
> DB2 UDB version 6.01 supports JDBC 2.0 API .
>
> I can't comment on other DBs.
>
> BTW the JDBC ODBC bridge from sun is not considered a production
> driver. You might check with Sun about them ever supporting the new
> API.
>
> Sans adieu,
> Danny Rubis
>
> Kiran Badhe wrote:
>
> > Hi,
> >
> > May I know which drivers support this and where to get them?
> >
> > Thanks.
> > Kiran
> >
> > >From: harjit singh <[EMAIL PROTECTED]>
> > >Reply-To: "A mailing list for discussion about Sun Microsystem's Java
> > > Servlet API Technology." <[EMAIL PROTECTED]>
> > >To: [EMAIL PROTECTED]
> > >Subject: Re: Scrollable resultset
> > >Date: Fri, 12 May 2000 11:17:47 -0600
> > >
> > >You have to use an Driver which supports the scrollable Result sets and
> the
> > >jdbc odbc bridge doesnot do that
> > >
> > >- Harjit
> > >
> > >-----Original Message-----
> > >From: Jiger Patel [mailto:[EMAIL PROTECTED]]
> > >Sent: Friday, May 12, 2000 4:33 PM
> > >To: [EMAIL PROTECTED]
> > >Subject: Re: Scrollable resultset
> > >
> > >
> > >Hi kiran,
> > > U have to use JDBC 2.0 a seperate ext, from sun to do this.
> the
> > >JDBC that comes with Java does not support it & so this exception.
> > >
> > >bye,
> > >Jiger
> > >
> > >
> > > >From: Kiran Badhe <[EMAIL PROTECTED]>
> > > >Reply-To: "A mailing list for discussion about Sun Microsystem's Java
> > > > Servlet API Technology." <[EMAIL PROTECTED]>
> > > >To: [EMAIL PROTECTED]
> > > >Subject: Scrollable resultset
> > > >Date: Thu, 11 May 2000 02:45:15 PDT
> > > >
> > > >Hi,
> > > >
> > > >I am a newbie in Java. I have written following code to use the
> > >scrollable
> > > >resultset.When I run the compiled class file it gives me following
> error.
> > > >
> > > >Exception in thread "main" java.lang.UnsupportedOperationException at
> > >
> >sun.jdbc.odbc.JdbcOdbcConnection.createStatement(JdbcOdbcConnection.java.10
> > >18)
> > > >
> > > >
> > > >Does any body know how to make this feature work?
> > > >
> > > >Thanks.
> > > >Kiran
> > > >
> > > >- My Code---
> > > >
> > > >import java.sql.*;
> > > >import java.io.*;
> > > >public class T1
> > > >{
> > > >public static void main(String[] args)
> > > >throws SQLException,IOException,ClassNotFoundException
> > > >{
> > > >Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> > > >Connection conn =
> > > >DriverManager.getConnection("jdbc:odbc:uat","works","works");
> > > >
> > > >Statement stmt;
> > > >System.err.println("Connected.");
> > > >//Statement stmt =
> > >
> >conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_
> > >ONLY);
> > > >stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
> > > >ResultSet.CONCUR_READ_ONLY);
> > > >ResultSet rs = stmt.executeQuery("SELECT * FROM TAB");
> > > >System.err.println("Created");
> > > >//PreparedStatement stmt = conn.prepareStatement("SELECT * FROM
> TAB");
> > > >//ResultSet rs = stmt.executeQuery();
> > > >
> > > >rs.afterLast();
> > > >while (rs.previous())
> > > >{
> > > >System.err.println("The Table name is " + rs.getString("TNAME"));
> > > >}
> > > >
> > > >}
> > > >}
> > > >
> > > >
> > > >
> > >
> >________________________________________________________________________
> > > >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> > > >
> > >
> >___________________________________________________________________________
> > > >To unsubscribe, send email to [EMAIL PROTECTED] and include in
> the
> > >body
> > > >of the message "signoff SERVLET-INTEREST".
> > > >
> > > >Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > > >Resources: http://java.sun.com/products/servlet/external-resources.html
> > > >LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> > >
> >
> >________________________________________________________________________
> > >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> > >
> >
> >___________________________________________________________________________
> > >To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> > >of the message "signoff SERVLET-INTEREST".
> > >
> > >Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > >Resources: http://java.sun.com/products/servlet/external-resources.html
> > >LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> > >
> >
> >___________________________________________________________________________
> > >To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> > >of the message "signoff SERVLET-INTEREST".
> > >
> > >Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > >Resources: http://java.sun.com/products/servlet/external-resources.html
> > >LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
> > ________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> >
> ___________________________________________________________________________
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > Resources: http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
