compare a long datatype to a string in select statement

[Srikrishna DhumalRao]

Hi,
I need to fetch records from the database(oracle) where long data type column is like a string in a java file.when i tried with column like 'string'it gives amessage " inconsistent datatypes".
can any one throw some light on this.
Thanks in advance.

[Anandh Ramesh]

hi,

try typecasting the variable to a string and then you can compare them.
eg. String.valueOf(<long variable> will convert it to a string.

if you're not going to perform any computation on this, you can also get the data as a string using rs.getString() where rs is the resultset object.

tell me which one is suitable for you...

[Avi Abrami]

Srikrishna,
The following works for me using JDK 1.4.2, Oracle 9.2.0.4 (on SUN [sparc] Solaris 9) and Oracle's "thin" JDBC driver.

First, I create a database table with a LONG column:

create table MY_TABLE (
  MY_TEXT  LONG
)

Then I insert some data into that table:

insert into MY_TABLE values ('This is some text.');

Note that these first two steps are done using SQL*Plus (not java).

Now I write some java code to fetch the data from MY_TABLE:
[Note that this is pseudo-code -- it is uncompiled and untested!]

import java.sql.*;
 
public class JdbcLong {
  public static void main(String[] args) {
    Connection conn = //However you obtain a connection
    Statement stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery("select MY_TEXT from MY_TABLE");
    if (rs.next()) {
      String myText = rs.getString(1);
    }
  }
}

Hope it helps.

Good Luck,
Avi.

[Srikrishna DhumalRao]

Thanks,
I got it