find « Record « Java Database Q&A





1. how to find out how many records returned in recordSet    coderanch.com

Kola wrote : "Do i have to loop through the recordset to find out how many results were returned?" yes, this is the only way i know to get this information. I'm not a SQL expert and dont know if there's a SQL statement to bring this kind of information into the resultset, but it's a interesting subject of study.

4. Can't find record in 'tablename' on select in MqSql    coderanch.com

i am getting Can't find record in 'tablename' error. I am using MySql. What is cause for this error? As I know if we insert and delete from a table while selecting from the same table, We can get this error. but what is my doubt is we also get 'lock wait time out exception'. Can any one clarify this. In ...

5. Can't find record in 'tablename    coderanch.com

i am getting Can't find record in 'tablename' error. I am using MySql. What is cause for this error? As I know if we insert and delete from a table while selecting from the same table, We can get this error. but what is my doubt is we also get 'lock wait time out exception'. Can any one clarify this. In ...

7. Find geographical records based on zip code and radius    coderanch.com

I want to find geo records based on zip code and a radius. It does not have to be very accurate, so curvature of the earth based on lat and long are not necessary. But I do need some general calculation to do this. Also, I am using Hibernate, so it would be nice to shoehorn the calculation into HSQL Here ...