Senhores :D
Estou com um sistema razoavelmente grande em produção a 4 dias e hoje recebi um e-mail do pessoal que cuida do banco falando que o sistema está dando lock nas tabela que ele usa.
Não tenho idéia do que possa ser, aparentemente fiz tudo correto.
No Hibernate, o que pode causar esse tipo de problema?
<hibernate-configuration>
<session-factory>
<property name="connection.username">username</property>
<property name="connection.url">jdbc:oracle:thin:@127.0.01:1521/base</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="myeclipse.connection.profile">Oracle</property>
<property name="connection.password">123</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="show_sql">false</property>
<property name="default_catalog">catalog</property>
<property name="c3p0.min_size">2</property>
<property name="c3p0.max_size">20</property>
<property name="c3p0.timeout">600</property>
<property name="c3p0.max_statements">50</property>
<property name="c3p0.idle_test_period">3000</property>
<!-- mapeamento dos hbm.xml -->
</session-factory>
</hibernate-configuration>
private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";
private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();
private static Configuration configuration = new Configuration();
private static org.hibernate.SessionFactory sessionFactory;
private static String configFile = CONFIG_FILE_LOCATION;
private HibernateSessionFactory() {
}
public static Session getSession() throws HibernateException {
Session session = (Session) threadLocal.get();
if (session == null || !session.isOpen()) {
if (sessionFactory == null) {
rebuildSessionFactory();
}
session = (sessionFactory != null) ? sessionFactory.openSession() : null;
threadLocal.set(session);
}
return session;
}
public static void rebuildSessionFactory() {
try {
configuration.configure(configFile);
sessionFactory = configuration.buildSessionFactory();
} catch (Exception e) {
System.err
.println("%%%% Error Creating SessionFactory %%%%");
e.printStackTrace();
}
}
public static void closeSession() throws HibernateException {
Session session = (Session) threadLocal.get();
threadLocal.set(null);
if (session != null) {
session.flush();session.close();
}
}
public static org.hibernate.SessionFactory getSessionFactory() {
return sessionFactory;
}
public static void setConfigFile(String configFile) {
HibernateSessionFactory.configFile = configFile;
sessionFactory = null;
}
public static Configuration getConfiguration() {
return configuration;
}