String length issue in java -

I am getting data from a DB process that gives XML an output to the ultimate, when I execute this process in DB I am a full XML, but when I execute it using Java, it only prints 4000 characters. Here is my code:

  call string sql = "{SP_NAME (?)}"; Try {callable location stmt = DataAccess.databaseConnection .prepareCall (SQL); Stmt.registerOutParameter (1, java.sql.Types.VARCHAR); Stmt.execute (); String result = (string) stmt.getNString (1); SOP (result); // printing result} hold (exception e) {System.out.println (e); }  

What's the reason? Can anyone help me find out this problem?

How is your return value defined in your stored procedure? Chances are it is defined as a varchar (4000). If that's the case, then your problem is there.

If it is not, please see the limitations of your data structure.

If this is not a problem, have you tried debugging? Does your SQL Server driver return?