Converting nvarchar(max) data type to string in Java

Question

I am executing following sql query on SQL Server 2008 using jTDS API:

SELECT  a , b , c FROM [db].[dbo].[table] where d = 1;

And data type for these three fields are as follows:

a  -- nvarchar(255)
b  -- nvarchar(255)
c  -- nvarchar(max)

When I execute query using Java, the string values for a and b are plain text, but for c I am getting following value:

net.sourceforge.jtds.jdbc.ClobImpl@2b34fb

It seems it is stored as object, how can I convert it to normal string ?

What is the type in Java? DBVT_STRING? DBVT_ASTRING? Something else? — Aaron Bertrand
– Aaron Bertrand, Commented Aug 13, 2012 at 20:52
When you are getting the values off the ResultSet, I take you've already tried getString(column) and getCharacterStream(column)? — Dilum Ranatunga
– Dilum Ranatunga, Commented Aug 13, 2012 at 20:53
DBVT_STRING ? , even i tried , toString on it, it's still same — Pradeep
– Pradeep, Commented Aug 13, 2012 at 20:59
Might want to have a look at this link: sourceforge.net/projects/jtds/forums/forum/104389/topic/4623409 — Eric Petroelje
– Eric Petroelje, Commented Aug 13, 2012 at 21:02
Found this, take a look: stackoverflow.com/questions/2169732/… — Roberto Navarro
– Roberto Navarro, Commented Aug 13, 2012 at 23:35

Pradeep · Accepted Answer · 2012-08-14 07:57:29Z

7

Tried the Link Sent by @Roberto Navaron , It worked, just passed object to this method, type cast it to clob and it returns string

private String clobToString(Clob data) {
    StringBuilder sb = new StringBuilder();
    try {
        Reader reader = data.getCharacterStream();
        BufferedReader br = new BufferedReader(reader);

        String line;
        while(null != (line = br.readLine())) {
            sb.append(line);
        }
        br.close();
    } catch (SQLException e) {
        // handle this exception
    } catch (IOException e) {
        // handle this exception
    }
    return sb.toString();
}

answered Aug 14, 2012 at 7:57

Pradeep

6,6539 gold badges39 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ravindra · Accepted Answer · 2016-12-21 05:29:26Z

1

Or we can use this -

String getNString(int columnIndex)
String getNString(String columnLabel)

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html

answered Dec 21, 2016 at 5:29

Ravindra

1431 silver badge9 bronze badges

Collectives™ on Stack Overflow

Converting nvarchar(max) data type to string in Java

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related