Hi.
I have a question about a following abstract problem.
i have a stateless bean like this:
@Stateless
Public class MyBean implements MyLocalInterface {
....
@PersistenceContext(unitName = "ReadWritePU")
private EntityManager em;
....
@Override
public void execute() {
...
em.find(...) (some finds)
...
em.merge(...) (some merges)
...
em.persist(...) (some persists)
}
but what happens on db is:
BEGIN
some SELECTs(from some finds)
....
COMMIT
so what happens is, entity manager does not flush the objects from merge
and persist methods, no updates or inserts are done to the database.
Also no Runtime Exceptions are thrown.
But if i put an em.flush() at the end of the business method, every
thing is ok and new objects are flushed to the db.
What could be a reason for this behavior?
I tried to change non-transactional-connections from false to true, the
transaction-isolation-level from serializable to read-commited
and is-isolation-level-guaranteed from true to false, but it did not help.
Here is my whole persistence.xml
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0"
xmlns="
http://java.sun.com/xml/ns/persistence"
<
http://java.sun.com/xml/ns/persistence>
xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance"
<
http://www.w3.org/2001/XMLSchema-instance>
xsi:schemaLocation="
http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
<
http://java.sun.com/xml/ns/persistencehttp:/java.sun.com/xml/ns/persistence/persistence_1_0.xsd>>
<persistence-unit name="ReadWritePU" transaction-type="JTA">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>jdbc/Postgres</jta-data-source>
<exclude-unlisted-classes>false</exclude-unlisted-classes>
<properties>
<property name="hibernate.show_sql" value="true"/>
<property name="hibernate.dialect"
value="org.hibernate.dialect.PostgreSQLDialect"/>
<property name="hibernate.order_updates" value="true"/>
<property name="hibernate.transaction.manager_lookup_class"
value="org.hibernate.transaction.SunONETransactionManagerLookup"/>
<property name="hibernate.transaction.factory_class"
value="org.hibernate.transaction.CMTTransactionFactory"/>
</properties>
</persistence-unit>
<persistence-unit name="ReadOnlyPU" transaction-type="JTA">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>jdbc/PostgresReadonly</jta-data-source>
<exclude-unlisted-classes>false</exclude-unlisted-classes>
<properties>
<property name="hibernate.dialect"
value="org.hibernate.dialect.PostgreSQLDialect"/>
<property name="hibernate.show_sql" value="true"/>
<property name="hibernate.transaction.manager_lookup_class"
value="org.hibernate.transaction.SunONETransactionManagerLookup"/>
<property name="hibernate.transaction.factory_class"
value="org.hibernate.transaction.CMTTransactionFactory"/>
</properties>
</persistence-unit>
</persistence>
And here are my connection pool settings from the domain.xml
<jdbc-connection-pool allow-non-component-callers="true"
associate-with-thread="false" connection-creation-retry-attempts="0"
connection-creation-retry-interval-in-seconds="10"
connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0"
connection-validation-method="table"
datasource-classname="org.postgresql.ds.PGConnectionPoolDataSource"
fail-all-connections="false" idle-timeout-in-seconds="300"
is-connection-validation-required="true"
is-isolation-level-guaranteed="true" lazy-connection-association="false"
lazy-connection-enlistment="false" match-connections="false"
max-connection-usage-count="0" max-pool-size="32"
max-wait-time-in-millis="60000" name="PostgresConnectionPool"
non-transactional-connections="false" pool-resize-quantity="2"
res-type="javax.sql.ConnectionPoolDataSource"
statement-timeout-in-seconds="-1" steady-pool-size="8"
transaction-isolation-level="serializable"
validate-atmost-once-period-in-seconds="0"
validation-table-name="pg_type" wrap-jdbc-objects="false">
<property name="Password" value="********"/>
<property name="PrepareThreshold" value="0"/>
<property name="ServerName" value="******"/>
<property name="DatabaseName" value="*****"/>
<property name="LoginTimeout" value="0"/>
<property name="User" value="*********"/>
<property name="PortNumber" value="*******"/>
<property name="Ssl" value="true"/>
<property name="sslfactory"
value="org.postgresql.ssl.NonValidatingFactory"/>
</jdbc-connection-pool>
Thank you very much
Oleg Mayevskiy