[jboss-user] [JBoss jBPM] - Re: ERROR JDBCExceptionReporter : Table not found in stateme

2007-07-17 Thread Johan.Parent 
anonymous wrote : Hypersonic can work in multiple modes. TCP Server, 
Standalone, InMemory.
  | As far as I know the InMemory mode stores all your data in memory and
  | flushes them to the disk when you shutdown the server. (not 100% sure)

The in-memory-db is a volatile db. Once closed it disappears. Perfect for unit 
tests so you can start with an untainted db for each test. But nothing ever 
gets flushed to disk as far as I know.

Regards,

Johan

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4064884#4064884

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4064884
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss jBPM] - Re: ERROR JDBCExceptionReporter : Table not found in stateme

2007-07-16 Thread ppetrou 
Hi, I had exactly the same problem,

In my situation the problem was in the hibernate.cfg.xml.

Hypersonic can work in multiple modes. TCP Server, Standalone, InMemory.
As far as I know the InMemory mode stores all your data in memory and
flushes them to the disk when you shutdown the server. (not 100% sure)

Not the best option for production!!

hibernate.cfg.xml defaults to the InMemory mode so even the fact that
you have the tables in the jboss data directory they are not in memory...

Try the following configuration. Mainly you just need to comment out the
jbpm datasource and comment in the inmemory one.




  | 
  | 
  | 
  | http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd";>
  | 
  | 
  |   
  | 
  | 
  | org.hibernate.dialect.HSQLDialect
  | 
  | 
  | 
  | org.hibernate.cache.HashtableCacheProvider
  | 
  | 
  | java:/JbpmDS
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  |   
  | 
  | 
  | 
  | 

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4064582#4064582

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4064582
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss jBPM] - Re: ERROR JDBCExceptionReporter : Table not found in stateme

2007-06-22 Thread javi0704 
Many thanks Cristian, it is a good proposition. I will try your approach and 
tell you what i reach.

Thank you for your response

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4056926#4056926

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4056926
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss jBPM] - Re: ERROR JDBCExceptionReporter : Table not found in stateme

2007-06-22 Thread cristian_e 
Sounds like a confusion about where is the jbpm database you are working with. 
The first exception about the table not found clearly is saying that the 
database you are pointing to didn't have the jbpm schema created in it.

I think you have to start over and check this steps:

- Select the database/schema where you are going to put the jbpm tables into.

- Run the corresponding database creation script that comes within the jbpm 
zip. There are multiple versions for the main database engines.

- Modify the hibernate configuration file of your jbpm installation and tell it 
to connect to the database you previously selected.

I guess now you are saving your process definition to any other db. You maybe 
even added jbpm tables to other db without noticing it.

Hope this helps.

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4056916#4056916

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4056916
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss jBPM] - Re: ERROR JDBCExceptionReporter : Table not found in stateme

2007-06-22 Thread javi0704 
Can nobody help me with this issue? Please give me any kind of idea.

Thanks

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4056911#4056911

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4056911
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss jBPM] - Re: ERROR JDBCExceptionReporter : Table not found in stateme

2007-06-21 Thread javi0704 
Hi again,
i inserted the following statement "JbpmConfiguration.createSchema()" after 
JbpmConfiguration jbpmConfiguration = JbpmConfiguration.getInstance();   in my 
code. I don't see now any kind of exception. So it seems to be ok. Bet 
 in the HSQL_Database is the current processDefinition not there. Please help 
me.

thx again


View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4056426#4056426

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4056426
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user