the problem is that the version of JDBC that iu are using is old one
download the version 2.0 or later and then try
tarun
----- Original Message -----
From: "Javier Alonso" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 1:47 PM
Subject: Problems with Result Set
Hello everybody. I�m having a problem with the Result Set Type that i�m
trying to create.
When i create a Result Set that is scrollabe and updatable i get an error
message when the servlet is called. I�m posting the code i�m using and the
error message. I hope anybody can help me.
Code:
Statement st;
st = null;
ResultSet rs;
rs = null;
ResultSetMetaData rsmeta;
try{
st =
cnx.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDAT
ABLE);
System.out.println("el tipo resultset "+st.getResultSetType());
rs = st.executeQuery("SELECT a.titulo, a.entradilla, a.texto,
a.titulo_cat, a.entradilla_cat, a.texto_cat, a.titulo_eus, a.entradilla_eus,
a.texto_eus, a.titulo_gal, a.entradilla_gal, a.texto_gal, a.titulo_ing,
a.entradilla_ing, a.texto_ing, a.titulo_val, a.entradilla_val, a.texto_val,
b.ruta_foto, b.orden FROM EROSKIES.CONTENIDO a, EROSKIES.CONTENIDO_FOTOS b
WHERE a.id_contenido="+id_contenido+"AND b.id_contenido="+id_contenido+"");
file://Aqui tengo que meter la sql y a�adir datos al vector si voy a usar
vector
rsmeta=rs.getMetaData();
String cursor=rs.getCursorName();
file://rs.first();
System.out.println("cursor: "+cursor);
}
catch(SQLException sql){
System.out.println(" tengo Error SQL: ");
System.out.println(sql.getMessage());
file://sql.printStackTrace();
}
finally
{
if(st != null)
try
{
rs.close();
st.close();
}
catch(SQLException e)
{
System.out.println("Se ha producido un error al cerrar la conexion");
System.out.println(e.getMessage());
}
}
file://Aqui llamada a mostrarContenido;
}
And this is the stack trace:
java.lang.UnsupportedOperationException
at
sun.jdbc.odbc.JdbcOdbcConnection.createStatement(JdbcOdbcConnection.java:101
8)
at
com.attest.eroski.ContenidoServlet.mirarBaseDatos(ContenidoServlet.java:200)
at com.attest.eroski.ContenidoServlet.doGet(ContenidoServlet.java:133)
Anay help will be welcome
___________________________________________________________________________
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
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.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
