Hi, Thanks a lot for all. Now my JBoss server is working together with MySQL. However I still have a question. When I deploy Entity Beans, I though it should create tables automatically. But it doesn't, although I specify that <create-table>=true in the jaws.xml is as following. Could anymore help? Thanks
<?xml version="1.0" encoding="UTF-8"?> <jaws> <datasource>java:/DefaultDS</datasource> <type-mapping>mySQL</type-mapping> <debug>false</debug> <default-entity> <create-table>true</create-table> <remove-table>true</remove-table> <tuned-updates>true</tuned-updates> <read-only>false</read-only> <time-out>300</time-out> <select-for-update>false</select-for-update> </default-entity> <enterprise-beans> <entity> <ejb-name>Car</ejb-name> <table-name>Car</table-name> <create-table>true</create-table> <cmp-field> <field-name>make</field-name> <column-name>make</column-name> </cmp-field> <cmp-field> <field-name>model</field-name> <column-name>model</column-name> </cmp-field> <cmp-field> <field-name>year</field-name> <column-name>year</column-name> </cmp-field> <cmp-field> <field-name>id</field-name> <column-name>carID</column-name> </cmp-field> <cmp-field> <field-name>ownerid</field-name> <column-name>ownerID</column-name> </cmp-field> <finder> <name>findAllCars</name> <query>1=1</query> <order/> <read-ahead>true</read-ahead> </finder> <finder> <name>findByPrimaryKey</name> <query>id = {0}</query> <order/> <read-ahead>true</read-ahead> </finder> </entity> <entity> <ejb-name>Owner</ejb-name> <table-name>Owner</table-name> <create-table>true</create-table> <cmp-field> <field-name>name</field-name> <column-name>name</column-name> </cmp-field> <cmp-field> <field-name>id</field-name> <column-name>ID</column-name> </cmp-field> <cmp-field> <field-name>dateBought</field-name> <column-name>dateBought</column-name> </cmp-field> <finder> <name>findByPrimaryKey</name> <query>id = {0}</query> <order/> <read-ahead>true</read-ahead> </finder> </entity> </enterprise-beans> </jaws> -- Jia (Christine) Li 524N ICT Building Department of Computer Science University of Calgary _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user