I have set the project.properties as per your instructions. Here is a snapshot
of the same.
# Properties for management of the database schema,
# ignore if you setup/drop your schema manually
dataSource.driver.jar=${env.JBOSS_HOME}/server/default/lib/mysql-connector-java-3.0.16-ga-bin.jar
dataSource.driver.class=org.gjt.mm.mysql.Driver
dataSource.url=jdbc:mysql://localhost:3306/partdatabase
dataSource.user=testspring
dataSource.password=testspring
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: MySQL
# For Hypersonic use: HypersonicSql
# For Oracle9i use: Oracle9i
#sql.mappings=HypersonicSql
sql.mappings=MySQL
# For MySql use: org.hibernate.dialect.MySQLDialect
# For Hypersonic use: org.hibernate.dialect.HSQLDialect
# For Oracle9i use: org.hibernate.dialect.Oracle9Dialect
#hibernate.db.dialect=org.hibernate.dialect.HSQLDialect
hibernate.db.dialect=org.hibernate.dialect.MySQLDialect
I get the following error message:
Problem managing Part: Hibernate operation: could not execute query; bad SQL
grammar [select this_.ID as ID0_, this_.NAME as NAME0_0_ from PART this_];
nested exception is java.sql.SQLException: Table not found: PART in statement
[select this_.ID as ID0_, this_.NAME as NAME0_0_ from PART this_ limit ?] when
I deployed the ear file on JBOSS.
There is some default datasource that is used by JBOSS. Do your settings
override those or should I duplicate the datasource information twice?
_________________________________________________________
Reply to the post : http://galaxy.andromda.org/forum/viewtopic.php?p=2961#2961
Posting to http://forum.andromda.org/ is preferred over posting to the mailing
list!
-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
Andromda-user mailing list
Andromda-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/andromda-user
