DatabaseMetaData md = connection.getMetaData ();
if (!md.supportsANSI92FullSQL()) {
System.out.println("Sorry no transactions for this driver");
}
You can check capability of your JDBC driver to figure out what you can
expect.
Regards,
Dmitry.
----- Original Message -----
From: Ing. Rolando Romero Acosta <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 27, 1999 5:41 AM
Subject: Re: Transactions and Ms Access
> Have you installed Access 97 drivers for ODBC?
>
> ----- Mensaje original -----
> De: Rafał Knopa <[EMAIL PROTECTED]>
> Para: <[EMAIL PROTECTED]>
> Enviado: Sunday, May 23, 1999 7:08 PM
> Asunto: Transactions and Ms Access
>
>
> > I am working currently with Ms Access 97 database via JDBC:ODBC on
> Win95/NT.
> > I tried to use transaction in my servlet by setting
> Connection.setAutoCommit(false) but on this statement I caught an
> SQLException:
> >
> > java.sql.SQLException: [Microsoft][ODBC Microsoft Access 97
> Driver]Operation invalid at this time
> >
> > Additional info: ErrorCode is 59, SQL State is S1011.
> > I am not able to find any information about this exception. What have I
to
> do to use transactions with this database?
> >
> > Rafal
> >
> >
>
___________________________________________________________________________
> > 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
>
>
> ---
> Empresa Productora y Comercializadora de Software.
> Telef: (537) 33-3785
> Fax: (537) 33-6123
> WWW: http://www.softel.caribbeansources.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
