Hi:
I´m working with Tomcat4 and a Connection Pool for accesing MySQL. But,
when I use the following code in a jsp:
<%@ page import ="java.sql.*, javax.sql.*" %>
<%@ page import ="javax.naming.InitialContext, javax.naming.Context" %>
<html><body>
<%
Context mInitCtx = null;
DataSource mDs = null;
Connection mConexion = null;
Statement mStmt = null;
ResultSet mRs = null;
mInitCtx = new InitialContext();
mDs = (DataSource) mInitCtx.lookup("java:comp/env/jdbc/PoolConexiones");
mConexion = mDs.getConnection();
mStmt = mConexion.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
mRs = mStmt.executeQuery("SELECT * FROM PRECIOS");
for(int i=1; i<=10; i++)
{
mRs.moveToInsertRow();
mRs.updateInt("ORDEN",i);
mRs.insertRow();
mRs.moveToInsertRow();
}
%>
OK
</body></html>
I get the error: ResultSet not updatable
Why is it?
Thank you
¿Quieres conocer el futuro inmediato de la radio digital? Reportajes y
noticias del mundo de la Tecnología. ¡Ponte al día!
http://tecnologia.tiscali.es/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
