Greetings!
I have a functional web application using hibernate and running on JBOSS. Hibernate is pointing to a remote database.
Everything seems to work great until the remote DB is deleted and rebuilt. Once that happens we start getting hibernate errors until we reboot JBOSS, then everything works as expected.
Here is the generated error message:
Code:
--------------------------------------------------------------------------------------------------------------------------------------------------------
11:31:50,323 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http--0.0.0.0-8282-7) An I/O error occured while sending to the backend.
11:31:50,339 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http--0.0.0.0-8282-8) An I/O error occured while sending to the backend.
11:31:50,323 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http--0.0.0.0-8282-6) An I/O error occured while sending to the backend.
11:31:50,323 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http--0.0.0.0-8282-9) An I/O error occured while sending to the backend.
11:31:50,854 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http--0.0.0.0-8282-7) ERROR: column assignedta0_.actionrequested does not exist
Position: 43
-----------------------------------------------------------------------------------------------------------------------------------------------------
Wondering what could be causing this problem and if there is a way around so we don't need to reboot the server every time.
The persistence file looks like this:
Code:
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
version="2.0">
<persistence-unit name="org.hibernate.events.jpa" transaction-type="RESOURCE_LOCAL">
<class>mil.navy.spawar.service.db.object.AssignedTasks</class>
<properties>
<property name="hibernate.dialect" value="org.hibernate.spatial.dialect.postgis.PostgisDialect"/>
<property name="hibernate.connection.driver_class" value="org.postgresql.Driver"/>
<property name="hibernate.connection.url" value="${jdbc.connection.url}"/>
<property name="hibernate.connection.username" value="username"/>
<property name="hibernate.connection.password" value="password"/>
<property name="hibernate.connection.pool_size" value="5"/>
<property name="hibernate.show_sql" value="false"/>
<property name="hibernate.format_sql" value="true"/>
<property name="hibernate.max_fetch_depth" value="5"/>
<property name="hibernate.hbm2ddl.auto" value="update"/>
<!-- Scan for annotated classes and Hibernate mapping XML files -->
<property name="hibernate.archive.autodetection" value="class, hbm"/>
</properties>
</persistence-unit>
</persistence>