resultset
In Java, is better maintain data in the ResultSet or transform to array?
I have two classes, a server and some clients. The server class make a query to database and retrieve a certain number of rows. The clients request a part of these rows, each one a different part.[详细]
2023-03-06 17:26 分类:问答Check for unique row existence via jdbc
I\'m using resultSet.next() to check whether a unique row exist in the database or not. But it is returning false even when the row exists in the database.[详细]
2023-03-06 06:12 分类:问答jdbc empty resultset check not working
In the following java class i\'m having a method authenticate, in which i\'m using resultSet.next() method to check that whether the given userName and password exist in the database or not, but it is[详细]
2023-03-06 05:28 分类:问答How to split a resultset in Java into chunks (500 rows each) without looping?
I have a query which returns millions of records which are held in a result set. I have to process (insert/update) these records.Instead of inserting all the record at once I would like to split the t[详细]
2023-03-05 12:31 分类:问答How can I make each row in the resultset returns multiple times?
I\'m writing an application that uses Mysql and for now my tables don\'t have many data in it. I want to test how my application handles a larger amount of data. In order to d开发者_如何学运维o that I[详细]
2023-03-04 09:03 分类:问答Serializable issues about resultset objects
I want to implement a CS application using Sockets. Th开发者_如何学Pythone db query result are of different classes and I don\'t mean to put those methods handling the result in the server end, I just[详细]
2023-03-04 05:06 分类:问答Java ResultSet, SetObject vs SetString/SetDate/etc
I\'d like to know whether any开发者_开发技巧one considers using PreparedStatement.setObject for all data types as bad practice when preparing a statement. A use case for this would be a DAO with a gen[详细]
2023-03-03 13:51 分类:问答Effective resultset structure in case of Inner Join on more than two tables
I was going through this link to see how the effective resultset looks like if we join (Inner/Outer) two tables.[详细]
2023-03-02 21:26 分类:问答Getting java.sql.SQLException: Operation not allowed after ResultSet closed
When I execute the following code, I get an exception开发者_如何学编程. I think it is because I\'m preparing in new statement with he same connection object. How should I rewrite this so that I can cr[详细]
2023-03-02 09:31 分类:问答Does streaming large result sets with NHibernate actually work?
I\'m using the method that ayende proposed here: http://ayende.com/Blog/archive/2010/06/27/nhibernate-streaming-large-result-sets.aspx[详细]
2023-03-02 05:12 分类:问答