How can Get a bit Text Field Data of Database in java

Question

i am using following code for get data from database but data is in big quantity so string is not hold all data so what is the process to get all data from database

     spst=scon.prepareStatement("SELECT dbQuery FROM alyss where license=?");
     spst.setString(1, key);
     ResultSet rs = spst.executeQuery();
     while(rs.next()){
     DBQuery = rs.getNString("dbQuery");
     }

yes i have more than 2 billion character.

Lokesh Kumar
– Lokesh Kumar

2014-11-20 11:13:54 +00:00
Commented Nov 20, 2014 at 11:13 — Lokesh Kumar
– Lokesh Kumar, Commented Nov 20, 2014 at 11:13
Which DBMS are you using?

user330315
– user330315

2014-11-20 12:20:43 +00:00
Commented Nov 20, 2014 at 12:20 — user330315
– user330315, Commented Nov 20, 2014 at 12:20

Vishvesh Phadnis · Accepted Answer · 2014-11-20 12:17:51Z

2

Use

Reader reader=rs.getNCharacterStream(columnIndex) ;

It is intended for use when accessing NCHAR,NVARCHAR and LONGNVARCHAR columns

Code

   java.sql.Statement st=connection.createStatement();
   ResultSet rs=st.executeQuery("SELECT ApplicationId FROM application");

    while(rs.next())
    {
        FileOutputStream fileOutputStream=null;
        Reader reader=null;
        try {
            fileOutputStream =   new FileOutputStream("output.txt");
            reader=rs.getNCharacterStream(1 /*you can use here column name also*/);
            int c;
            while( (c=reader.read())!=-1)
            {
                fileOutputStream.write(c) ;
            }

        }           
        catch(Exception e){}
        finally {
            if (reader != null) {
                reader.close();
            }
            if (fileOutputStream != null) {
                fileOutputStream.close();
            }
        }
    }

edited Nov 20, 2014 at 12:17

answered Nov 20, 2014 at 11:10

Vishvesh Phadnis

2,6385 gold badges22 silver badges36 bronze badges

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

2 Comments

Lokesh Kumar Over a year ago

how can save these data in a file

Lokesh Kumar Over a year ago

Vishvesh this code is not working properly this code give java.lang.NullPointerException Execption

Collectives™ on Stack Overflow

How can Get a bit Text Field Data of Database in java

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related