[JBoss jBPM] - Re: JBPM_PROCESSDEFINITION table not found
by abdielj
hi,
First of all thanks for your help.
The schema was automatically created. I used the JBPM Starter's Kit. I checked the DB Administrator and there are no typos in the table name. I'm also using the Eclipse JBPM IDE Bundle which has a plug-in that automatically creates a JBPM Project, but i noticed that the generated folder with the needed dependencies is missing the hibernate3.jar so I added manually to the project in another folder. I don't know if that may be the problem.
Another thing is that the problem is with all accesses to the database, because i tried to obtain the list of tasks for a user with
| List taskList = jbpmContext.getTaskList("ernie");
|
and got the same error for the JBPM_TASKINSTANCE table.
Also when I try to run the project I get the following warning
| WARN EhCacheProvider : Could not find configuration
|
Thanks
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3958263#3958263
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3958263
19 years, 9 months
[EJB 3.0] - EJB 30 - SOME KIND OF LEFT JOIN HELP
by stephan.opitz
i have two tables
CREATE TABLE categories (
categories_id BIGINT(20) NOT NULL,
image VARCHAR(45) NOT NULL,
parent_categories_id BIGINT(20) NOT NULL,
sort_order INTEGER(3) NOT NULL,
last_modified DATETIME NOT NULL,
timestamp DATETIME NOT NULL,
PRIMARY KEY(categories_id)
);
CREATE TABLE categories_lang (
categories_id BIGINT(20) NOT NULL,
languages_id BIGINT(20) NOT NULL,
name VARCHAR(45) NOT NULL,
description TEXT NOT NULL,
PRIMARY KEY(categories_id, languages_id)
);
i created the ejb 3.0 -> all fine
but i don't know how i make i set or sth like this to get an specific categorieslang set when i ask for a special categorie?
what i have to add to categories ejb?
the categories lang should depend on the categories_id and the language id, which i have before ask for categories. actual i make another query to get the categories lang, but i want only one query where i get a categorie with a specific lang :-/
a have no solution found yet, because it is not an classic one...., connection...
thx stephan
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3958261#3958261
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3958261
19 years, 9 months
[Persistence, JBoss/CMP, Hibernate, Database] - Urgent help please!
by ihunter
[Using JBoss 4.0.3, EJB2, MySQL]
Hi Folks,
I have an EJB 2.0 app. and I need to effect the following (psudo) query for an entity...
SELECT obj FROM Obj WHERE (obj.x IN {0}) LIMIT {1}
Using dynamicQL does it, but the LIMIT doesn't go into the actual SQL for MySQL and blows the transaction timeout.
OK, so I use declared-sql, but I NEED to parameterise the IN list from the application - how can do I do this?
Anybody got any ideas, or alternative approaches.
Many many thanks for any help
[Hope this is clear enough]
Ian Hunter
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3958256#3958256
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3958256
19 years, 9 months