Two questions...
1) Getting connections from a PersistenceBroker...
In the documentation, it says that you can acquire a connection object
directly from the PB API. By the fact that you can also acquire brokers
from an Implementation instance, can I assume that the following is legal?
Implementation odmg = OJB.getInstance();
Transaction tx = odmg.getTransaction();
tx.beginTransaction();
PersistenceBroker broker = ((HasBroker) tx).getBroker();
Connection connection = broker.serviceConnectionManager().getConnection();
PreparedStatement statement = connection.prepareStatement(sql);
ResultSet resultSet = statement.executeQuery();
//...
tx.commitTransaction();
The docs says to NOT close a connection... but what about Statement and
ResultSet resources?
2) Using PersistenceBroker.getIteratorByQuery...
Is the iterator returned by PersistenceBroker.getIteratorByQuery valid
after the persistence broker has been closed (either explicitly because I'm
using the PB API or implicitly by closing the an ODMG transaction. That
is, is this valid...
Implementation odmg = OJB.getInstance();
Transaction tx = odmg.getTransaction();
tx.beginTransaction();
PersistenceBroker broker = ((HasBroker) tx).getBroker();
Criteria criteria = new Criteria();
criteria.addEqualTo("category.id", category.getId());
criteria.addOrderByAscending("name");
Query query = QueryFactory.newQuery(Product.class, criteria);
Iterator iterator = broker.getIteratoryByQuery(query);
tx.commitTransaction();
while(iterator.hasNext()) {
Product product = (Product) iterator.next();
// blah blah blah
}
Is it valid to use the iterator after the transaction has been committed
(i.e.: broker has been closed)?
Thanks for your time...
--
Sean Dockery
Software Developer
Securac Technologies Inc.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
