Ok, that is what I thought.  I created a new project and then added a class 
with <<Entity> and <<Manageable>>.  (I added all of the other modeling elements 
as well use case, activity diagram, controller, etc).  I mapped this entity 
(manually) to an existing table (EMP).



When I try to pull up the page I get:



Problem managing Emp: Bad SQL grammar [] in task 'Hibernate operation'; nested 
exception is java.sql.SQLException: Table not found: EMP in statement [select 
this.ID as ID0_, this.EMPNO as EMPNO0_, this.ENAME as ENAME0_ from EMP this 
where 1=1]



Following is what I updated my project.properties to:





maven.multiproject.includes=**/*project.xml

maven.multiproject.excludes=project.xml



maven.idea.project.version=4

maven.idea.project.multiproject.basedir=.



# Change this to the host on which your webservice will be deploy

service.host=localhost

# Change this the port on which your webservice will be deploy

service.port=8080



# setting this to true will deploy the ear exploded

deployExploded=false



# The datasource for the application

dataSource=java&#58;/DefaultDS



# Properties for management of the database schema, 

# ignore if you setup/drop your schema manually

dataSource.driver.jar=$&#123;env.JBOSS_HOME&#125;/server/default/lib/classes12.jar

dataSource.driver.class=oracle.jdbc.driver.OracleDriver

dataSource.url=jdbc&#58;oracle&#58;thin&#58;homer&#58;1521&#58;dbdev

dataSource.user=scott

dataSource.password=tiger

dataSource.sql.init=core/target/schema-create.sql

dataSource.sql.drop=core/target/schema-drop.sql

dataSource.sql.load=core/target/db/create-dummy-load.sql

# What schema related goals should do when an error occurs.

dataSource.sql.onError=continue



# Change this to generate to the correct MDA database mappings

# For MySql use&#58; MySQL

# For Hypersonic use&#58; HypersonicSql

# For Oracle9i use&#58; Oracle9i

sql.mappings=Oracle9i



# For MySql use&#58; net.sf.hibernate.dialect.MySQLDialect

# For Hypersonic use&#58; net.sf.hibernate.dialect.HSQLDialect

# For Oracle9i use&#58; net.sf.hibernate.dialect.Oracle9Dialect

hibernate.db.dialect=net.sf.hibernate.dialect.Oracle9ialect





I then executed install and deploy.  I open up the app and then query the db 
and see no db sessions created.



Thanks,

Steve
_________________________________________________________
Reply to the post : http://galaxy.andromda.org/forum/viewtopic.php?p=1088#1088
Posting to http://forum.andromda.org/ is preferred over posting to the mailing 
list!


-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you shotput
a projector? How fast can you ride your desk chair down the office luge track?
If you want to score the big prize, get to know the little guy.  
Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
_______________________________________________
Andromda-user mailing list
Andromda-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/andromda-user

Reply via email to