Hi,
Sorry for that long delay, I was out of town. I am using jboss 4.0.2. I managed to make it work. It is fine for HSQLDB but not so with mySql. I cannot use "maven create-schema" I get the following message: java.sql.SQLException: No suitable Driver for jdbc:mysql://localhost:3306 Here is my file mysql-ds.xml <?xml version="1.0" encoding="UTF-8" ?> - <!-- $Id: mysql-ds.xml,v 1.3.2.1 2004/12/01 11:46:00 schrouf Exp $ --> - <!-- Datasource config for MySQL using 3.0.9 available from: http://www.mysql.com/downloads/api-jdbc-stable.html --> - <datasources> - <local-tx-datasource> <jndi-name>MySqlDS</jndi-name> <connection-url>jdbc:mysql://localhost:3306/regieMySql</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>x</user-name> <password>y</password> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name> - <!-- sql to call when connection is created <new-connection-sql>some arbitrary sql</new-connection-sql> --> - <!-- sql to call on an existing pooled connection when it is obtained from pool <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql> --> <min-pool-size>5</min-pool-size> - <!-- Don't set this any higher than max_connections on your MySQL server, usually this should be a 10 or a few 10's of connections, not hundreds or thousands --> <max-pool-size>20</max-pool-size> - <!-- Don't allow connections to hang out idle too long, never longer than what wait_timeout is set to on the server...A few minutes is usually okay here, it depends on your application and how much spikey load it will see --> <idle-timeout-minutes>5</idle-timeout-minutes> - <!-- If you're using Connector/J 3.1.8 or newer, you can use our implementation of these to increase the robustness of the connection pool. --> <exception-sorter-class-name>com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter</exception-sorter-class-name> <valid-connection-checker-class-name>com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker</valid-connection-checker-class-name> - <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --> - <metadata> <type-mapping>mySQL</type-mapping> </metadata> </local-tx-datasource> </datasources> And here is my project.properties: 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 dataSource=java:/MySqlDS dataSource.driver.jar=${env.JBOSS_HOME}/server/default/lib/mysql-connector-java-3.1.10-bin.jar dataSource.driver.class=com.mysql.jdbc.Driver dataSource.url=jdbc:mysql://localhost:3306 dataSource.user=x dataSource.password=y 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 dataSource.sql.onError=continue sql.mappings=MySQL hibernate.db.dialect=net.sf.hibernate.dialect.MySQLDialect It seems ok. Is it possible to execute "create-schema" when mysql is running within jboss(localhost)? Thanks _________________________________________________________ Reply to the post : http://galaxy.andromda.org/forum/viewtopic.php?p=2204#2204 Posting to http://forum.andromda.org/ is preferred over posting to the mailing list! ------------------------------------------------------- This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual core and dual graphics technology at this free one hour event hosted by HP, AMD, and NVIDIA. To register visit http://www.hp.com/go/dualwebinar _______________________________________________ Andromda-user mailing list Andromda-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/andromda-user
