Very Computer

Hello,

I'm having a problem wherein I cannot retrieve String data out of an ntext
field greater than 5120 in length [data.length()].  It would appear that a
10k limit has been imposed on retrieving data from this field.  Does anyone
have any solutions?

The exception I'm getting follows.  Note that the unknown token is the hex
code for whatever the 5121st character is - in this case a 't'.

java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Unexpected token
type: Unknown token: 0x74
 at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
 at com.microsoft.jdbc.sqlserver.tds.TDSRequest.getRow(Unknown Source)
 at
com.microsoft.jdbc.sqlserver.SQLServerImplResultSet.positionCursor(Unknown
Source)
 at com.microsoft.jdbc.base.BaseResultSet.next(Unknown Source)
 at com.zinio.service.db.DBUtils.executeQuery(DBUtils.java:450)
 at
com.zinio.service.db.DBNotificationQueue.retrieve(DBNotificationQueue.java:5
8)
 at
com.zinio.service.db.DBNotificationQueueTester.testPayloadSize(DBNotificatio
nQueueTester.java:169)
 at java.lang.reflect.Method.invoke(Native Method)
 at junit.framework.TestCase.runTest(TestCase.java:166)
 at junit.framework.TestCase.runBare(TestCase.java:140)
 at junit.framework.TestResult$1.protect(TestResult.java:106)
 at junit.framework.TestResult.runProtected(TestResult.java:124)
 at junit.framework.TestResult.run(TestResult.java:109)
 at junit.framework.TestCase.run(TestCase.java:131)
 at junit.framework.TestSuite.runTest(TestSuite.java:173)
 at junit.framework.TestSuite.run(TestSuite.java:168)
 at junit.textui.TestRunner.doRun(TestRunner.java:74)
 at junit.textui.TestRunner.run(TestRunner.java:200)
 at
com.zinio.service.db.DBNotificationQueueTester.main(DBNotificationQueueTeste
r.java:198)

Thanks for any help,

Troy Molander

I'm having the exact same problem, but with a "text" field.  I've no
solutions, I'm afraid...