User Profile

MauBady · Mar 28 '07, 02:58 PM

Thank you
Yes, the problem seem to be this.

i have commented also the line related to the closure of the Statement and now it seem correct.

Code:

  public ResultSet EseguiLettura(String sSqlToExecute) throws SQLException
  {
      Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
      ResultSet rs = stmt.executeQuery(sSqlToExecute);

...

MauBady · Mar 28 '07, 01:30 PM

this is the error

Exception in thread "main" java.lang.NullP ointerException
at oracle.jdbc.dri ver.UpdatableRe sultSet.next(Up datableResultSe t.java:251)
at EseguiProcesso. main(EseguiProc esso.java:72)

and this is the line:

Code:

        
while (rs.next())
        {
          System.out.println("nullo");
        }

MauBady · Mar 28 '07, 01:07 PM

Thanks

This is the code

Code:

import java.util.*;
import java.sql.*;
public class EseguiProcesso 
{
  private static String msgInfo="Inizio EseguiProcesso.";
  private static String strSql=null;
  
 public static void main(String args[]) throws OwnException
    {
      Configurazione config;
      DbConn dbConn;

...

MauBady · Mar 28 '07, 12:25 PM

this is the code:

ResultSet rs = dbConn.EseguiLe ttura(strSql);
dbConn.closeCon n();
while (rs.next())
{
System.out.prin tln("not empty");
}

and the method call is

public ResultSet EseguiLettura(S tring sSqlToExecute) throws SQLException
{
Statement stmt = conn.createStat ement(ResultSet .TYPE_SCROLL_IN SENSITIVE,...

MauBady · Mar 28 '07, 11:25 AM

Thanks
but if i try to iterate i obtain the java.lang.NullP ointerException . It is possible test the resutset if empty or no without throw the exception?

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

empty resultset