Re: JDBC: select statements causing errros when using classes12.zip but not when using classess111.zip

From: Josh Gough <exv_at_randomc.com>
Date: Wed, 04 Aug 1999 01:34:35 -0400
Message-ID: <37A7D0EA.25251CB3@randomc.com>

Cindy,

    Thank you for responding. The code I used is below. I just ran it again, and sure enough it runs great with 111.zip, but gives me:

"ORA-03120: two-task conversion routine: integer overflow"

With 12.zip

Oddly, if i pass "select some_single_col_name from node" that works in either...weird.

Any suggestions?

Thanks!

-Josh Gough

---

import java.sql.*;

public class SampleQuery {

    public static void main(String args[]) {

        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            String url = "jdbc:oracle:thin:@(description=(address=(host=
localhost)(protocol=tcp)(port=1521))(connect_data=(sid=hrd)))";
            Connection con = DriverManager.getConnection(url, "blah",


"blahxxxxxx");


            Statement stmt = con.createStatement();
        String sql;
      if (args.length > 0)
       sql = args[0];
      else
       sql = "SELECT * from node";
      String result="";
      System.out.println("The query: " + sql + "\n");
            // run query
            ResultSet rs = stmt.executeQuery(sql);
            ResultSetMetaData rsmd = rs.getMetaData();
            int col_count = rsmd.getColumnCount();
            System.out.println("Columns: " + String.valueOf(col_count));
            while(rs.next()) {
                for (int i=1; i <= col_count; i++) {
                    result += rs.getString(i) + " ";
                }
                System.out.println(result + "\n");
      result = "";
            }
            rs.close();
            stmt.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }

    }
}

---

"C. Ferguson" wrote:

> Hi Josh,
>   Could you post your code snippet?  I've used both the classes111 and
> classes12 files, with no code modifications and they work fine.  I do lots
> of multi column selects...
> Cindy
>

Received on Wed Aug 04 1999 - 00:34:35 CDT