protected TableStandardName lookupTableStandardName(String standardName) {
TableStandardName name = super.lookupTableStandardName(standardName);
if (name == null) {
SessionHelper helper = new SessionHelper(mSessions);
try {
Session session = helper.beginTransaction();
List results =
session.find(
"SELECT name" + " FROM TableStandardName name" + " WHERE name.name = ?",
standardName,
Hibernate.STRING);
if (results.size() == 1) {
name = (TableStandardName) results.get(1);
}
} catch (HibernateException e) {
helper.rollback(System.err);
} finally {
helper.close(System.err);
}
if (name != null) {
mTableStandardNames.put(standardName, name);
}
}
return name;
}
private void logDatabaseInfo() throws ServletException {
SessionHelper helper = RetsServer.createHelper();
try {
Session session = helper.beginSession();
Connection connection = session.connection();
DatabaseMetaData metaData = connection.getMetaData();
LOGGER.info(
"JDBC Driver info: "
+ metaData.getDriverName()
+ " version "
+ metaData.getDriverVersion());
LOGGER.info(
"JDBC DB info: "
+ metaData.getDatabaseProductName()
+ " version "
+ metaData.getDatabaseProductVersion());
} catch (SQLException e) {
throw new ServletException("Caught", e);
} catch (HibernateException e) {
throw new ServletException("Caught", e);
} finally {
try {
helper.close();
} catch (HibernateException e) {
throw new ServletException(e);
}
}
}
private MSystem findSystemFromHibernate() {
SessionHelper helper = new SessionHelper(mSessions);
MSystem system = null;
try {
Session session = helper.beginTransaction();
List results = new ArrayList();
Iterator iterator = session.iterate("from MSystem");
while (iterator.hasNext()) {
results.add(iterator.next());
}
if (results.size() == 1) {
system = (MSystem) results.get(0);
}
} catch (HibernateException e) {
LOG.warn("Caught", e);
helper.rollback(LOG);
} finally {
helper.close(LOG);
}
return system;
}