Hi,
t_tm |t_scenario
-------|------
tm_id |scenario_id
tm_nom |scenario_label
|scenario_valeur
|scenario_horodate
|scenario_tmid -> refers to t_tm.tm.id as foreign key
Why I can't access to the father id tm_id?
2004-03-29 11:40:54,523 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.ScenarioEJB]
Insert Entity SQL: INSERT INTO t_scenario (scenario_id, scenario_label,
scenario_valeur, scenario_horodate, scenario_tmid) VALUES (?, ?, ?, ?,
?)
2004-03-29 11:40:54,523 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.ScenarioEJB]
Entity Exists SQL: SELECT COUNT(*) FROM t_scenario WHERE scenario_id=?
2004-03-29 11:40:54,523 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.ScenarioEJB]
entity-command: [commandName=default,commandClass=class
org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
2004-03-29 11:40:54,523 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.ScenarioEJB]
Remove SQL: DELETE FROM t_scenario WHERE scenario_id=?
2004-03-29 11:40:54,554 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.ScenarioEJB] Table not
create as requested: t_scenario
2004-03-29 11:40:54,554 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.ScenarioEJB#fi
ndByPrimaryKey] SQL: SELECT scenario_id FROM t_scenario WHERE
scenario_id=?
2004-03-29 11:40:54,554 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.ScenarioEJB] Added
findByPrimaryKey query command for local home interface
2004-03-29 11:40:54,554 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ScenarioEJB#findAll]
EJB-QL: SELECT OBJECT(s) FROM Scenario AS s
2004-03-29 11:40:54,554 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ScenarioEJB#findAll] SQL:
SELECT t0_s.scenario_id FROM t_scenario t0_s
2004-03-29 11:40:54,554 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ScenarioEJB#findByTmIdAnd
Valeur] EJB-QL: SELECT DISTINCT OBJECT(s) FROM Scenario s,
IN(s.scenarioTm) t WHERE t.Id=?1 AND s.Valeur=?2
2004-03-29 11:40:54,569 DEBUG [org.jboss.util.NestedThrowable]
org.jboss.util.NestedThrowable.parentTraceEnabled=true
2004-03-29 11:40:54,569 DEBUG [org.jboss.util.NestedThrowable]
org.jboss.util.NestedThrowable.nestedTraceEnabled=false
2004-03-29 11:40:54,569 DEBUG [org.jboss.util.NestedThrowable]
org.jboss.util.NestedThrowable.detectDuplicateNesting=true
2004-03-29 11:40:54,569 ERROR [org.jboss.ejb.EntityContainer] Starting
failed
org.jboss.deployment.DeploymentException: Error compiling EJB-QL
statement 'SELECT DISTINCT OBJECT(s) FROM Scenario s, IN(s.scenarioTm) t
WHERE t.Id=?1 AND s.Valeur=?2'; - nested throwable:
(org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered
"s.scenarioTm" at line 1, column 49.
Was expecting:
<COLLECTION_VALUED_PATH> ...
)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.<init>(JDBCEJBQLQuery.java
:50)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCC
ommandFactory.java:59)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.j
ava:212)
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
