sometimes, jdbc Resultset not getting all 3000 records, showing only 100 records.

Hi,

Few times, jdbc Resultset not getting all 3000 records, showing only 100 records.
It is happening only in Prod environment. Pleaes help me on this.

Thanks,
Naveen

Are the production and dev databases both the same server tech/version? i.e. mysql 5.1.x and 5.1.x?

Hi,
Both dev & prod are same versions. Issue is not there in my local, I pointed my local to prod database but I'm able to see all the records. we're using sybase database.

Are you running jboss locally too or from something else like eclipse?

I'm running eclipse with Websphere application server 7.5.

That's weird - I'm not familiar with an application server configuration putting constraints on queries. Is it acting as though you set the max record count on a query to 100 or is it more random than that?

We have next to no information here.
Suffice to say that the same query against the same database using the same user will produce the same set of results, presuming no one else has changed the data in between.

So, there's something about your set up that is different between A and B.
Only you can find that out.

For example, we have no idea how you are displaying this.
We have no idea what pooling strategy you have.
Are you using JDBC, Hibernate, something else.
How are you counting the results.
Etc etc.

This is, in short, a ridiculously open question.

I'm using JDBC code to fetch data from datbase, I put sysouts in PROD and found like most of the times resultset is getting all 3000+ results from database but it is getting exactly 100 records few times. I'm not able to trace the issue as it is happening only in PROD but not in lower environments.
I'm using RAD with websphere app server, database is sybase.
Could someone please help me on this. Thanks in advace.

Thanks,
Naveen

I have merged your new post with your earlier, seemingly identical question from a week ago. I suggest reading post #7, which is quite explicit with regards to the information (or lack thereof) you have provided. Posting the same question again will not change this.

I'm using JDBC code to fetch data from datbase, I put sysouts in PROD and found like most of the times resultset is getting all 3000+ results from database but it is getting exactly 100 records few times. I'm not able to trace the issue as it is happening only in PROD but not in lower environments. I'm using RAD with websphere app server, database is sybase. Please find my code below:
view plaincopy to clipboardprint?
String sqlStatement = "{ call STOREDPROCEDURE_ITEMS(?,?) }";
try {
databaseAccess = DatabaseManager.GetDatabaseAccess(true);
callableStatement = databaseAccess.prepareCall(sqlStatement);
callableStatement.registerOutParameter(1, Types.INTEGER);
callableStatement.registerOutParameter(2, Types.VARCHAR);
try {
resultset = callableStatement.executeQuery();
if (resultset != null) {
while (resultset.next()) {
item= BuildBasicItem(resultset);
items.add(item);
cache.addItemToCache(item);
}
}
System.out.println("items size"+ items.szie());
} catch (SQLException sqlException) { }
finally(){
databaseAccess.close();
} }

Could someone please help me on this.

Thanks, Naveen

http://www.java-forums.org/forum-gui...w-members.html
BB Code List - Java Programming Forum

db

Cross posted
java - JDBC resultset is retreiving only 100 records sometimes from DB, but it has 3000+ records - Stack Overflow
JDBC resultset is retreiving only 100 records sometimes from DB, but it has 3000+ records (JDBC forum at JavaRanch)

db

Hi Robin - I didn't get you.