[
https://issues.jboss.org/browse/RF-12340?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12718747#comment-12718747
]
Brian Leathem commented on RF-12340:
------------------------------------
>From [~marius.bogoevici]:
{quote}
Just take the configuration from TicketMonster. We've had this problem on
Openshift for a long time. H2 will shut down the DB when the last connection is
closed. And after a long time of inactivity the pool empties. I suppose that it
can be also fixed by making sure that there's always at least one connection in
the pool, but this way is far simpler.
{quote}
>From [~sgilda]:
{quote}
So we just need to modify all the connection urls to contain both parameters
like this
<connection-url>jdbc:h2:mem:kitchensink-quickstart;DB_CLOSE_ON_EXIT=FALSE;DB_CLOSE_DELAY=-1</connection-url>
{quote}
> RichFaces kitchensink-rf quickstart fails after running for a period of time
> ----------------------------------------------------------------------------
>
> Key: RF-12340
> URL: https://issues.jboss.org/browse/RF-12340
> Project: RichFaces
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: examples
> Reporter: Brian Leathem
> Assignee: Brian Leathem
> Fix For: 4.3.0.Milestone2
>
>
> After the application has been running for a while (possibly involving a
> database restart), database operations fail with the error:
> {code}
> Caused by: org.h2.jdbc.JdbcSQLException: Table "MEMBER" not found; SQL
> statement:
> select member0_.id as id0_, member0_.email as email0_, member0_.name as
> name0_, member0_.phone_number as phone4_0_ from Member member0_ order by
> member0_.name asc [42102-161]
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
> at org.h2.message.DbException.get(DbException.java:169)
> at org.h2.message.DbException.get(DbException.java:146)
> at org.h2.command.Parser.readTableOrView(Parser.java:4749)
> at org.h2.command.Parser.readTableFilter(Parser.java:1075)
> at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1681)
> at org.h2.command.Parser.parseSelectSimple(Parser.java:1788)
> at org.h2.command.Parser.parseSelectSub(Parser.java:1675)
> at org.h2.command.Parser.parseSelectUnion(Parser.java:1518)
> at org.h2.command.Parser.parseSelect(Parser.java:1506)
> at org.h2.command.Parser.parsePrepared(Parser.java:405)
> at org.h2.command.Parser.parse(Parser.java:279)
> at org.h2.command.Parser.parse(Parser.java:251)
> at org.h2.command.Parser.prepareCommand(Parser.java:217)
> at org.h2.engine.Session.prepareLocal(Session.java:415)
> at org.h2.engine.Session.prepareCommand(Session.java:364)
> at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1119)
> at
> org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71)
> at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:635)
> at
> org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:677)
> at
> org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:663)
> at
> org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:404)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [rt.jar:1.6.0_30]
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> [rt.jar:1.6.0_30]
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> [rt.jar:1.6.0_30]
> at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_30]
> at
> org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:138)
> [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
> ... 101 more
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
richfaces-issues mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/richfaces-issues
