i too have the same error. i am executing a query which generates 13,000 rows it gives tthe following excepotion
Exception in thread "main" java.lang.RuntimeException: SQLException Bigger type length than Maximum at com.edmunds.xmlSearch.databaseLoader.VehicleProcessor.processDocuments(VehicleProcessor.java:125) at com.edmunds.xmlSearch.databaseLoader.VehicleProcessor.main(VehicleProcessor.java:55)
Any idea , is it a driver problem or somethign i have to do at the database level
Rashid, Are any of those fields large? Maybe you are trying to put a really large number into an integer (or something like that) ?
There isn't an inherent limitation on the number of rows you can retrieve. You can prove this by picking a simple column and doing "select id, id, id, id, id, id, id from table". Just substitue the number of "id"s with the number of columns you have in your real query.