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
