From: Norman R. <nor...@jb...> - 2005-09-28 23:37:22
|
User: nrichards Date: 05/09/28 19:37:17 Modified: examples/dvdstore/dd/ejb3 import.sql persistence.xml Added: examples/dvdstore/dd/ejb3 hibernate.cfg.xml Log: move jbpm into build, start integrating new theme Revision Changes Path 1.7 +31 -31 jboss-seam/examples/dvdstore/dd/ejb3/import.sql (In the diff below, changes in quantity of whitespace are not shown.) Index: import.sql =================================================================== RCS file: /cvsroot/jboss/jboss-seam/examples/dvdstore/dd/ejb3/import.sql,v retrieving revision 1.6 retrieving revision 1.7 diff -u -b -r1.6 -r1.7 --- import.sql 26 Sep 2005 04:41:32 -0000 1.6 +++ import.sql 28 Sep 2005 23:37:17 -0000 1.7 @@ -6,33 +6,33 @@ insert into CATEGORIES (CATEGORY, CATEGORYNAME) values (6, 'Classics'); insert into CATEGORIES (CATEGORY, CATEGORYNAME) values (7, 'Drama'); -insert into products (prod_id, category, title, actor, price) values (1, 2, 'Indahouse', 'Ali G', 12.0); -insert into products (prod_id, category, title, actor, price) values (2, 3, 'The Lion King', '', 12.50); -insert into products (prod_id, category, title, actor, price, common_prod_id) values (3, 5, 'March of the Penguins', '', 19.99, 2); -insert into products (prod_id, category, title, actor, price) values (4, 1, 'Indiana Jones and the Temple of Doom', 'Harisson Ford', 19.99); -insert into products (prod_id, category, title, actor, price) values (5, 1, 'Clear and Present Danger', 'Harisson Ford', 19.99); -insert into products (prod_id, category, title, actor, price) values (6, 6, 'Roman Holiday', 'Audrey Hepburn', 12.99); -insert into products (prod_id, category, title, actor, price) values (7, 6, 'Breakfast at Tiffany''s', 'Audrey Hepburn', 12.99); -insert into products (prod_id, category, title, actor, price) values (8, 6, 'Sabrina', 'Audrey Hepburn', 12.99); -insert into products (prod_id, category, title, actor, price) values (9, 4, 'Sabrina', 'Harrison Ford', 19.99); -insert into products (prod_id, category, title, actor, price) values (10, 1, 'Kill Bill Vol. 1', 'Uma Thurman', 19.99); -insert into products (prod_id, category, title, actor, price) values (11, 1, 'Kill Bill Vol. 2', 'Uma Thurman', 19.99); -insert into products (prod_id, category, title, actor, price) values (12, 7, 'Lost in Translation', 'Bill Murray', 19.99); -insert into products (prod_id, category, title, actor, price) values (13, 7, 'Broken Flowers', 'Bill Murray', 19.99); +insert into PRODUCTS (PROD_ID, CATEGORY, TITLE, ACTOR, PRICE) values (1, 2, 'Indahouse', 'Ali G', 12.0); +insert into PRODUCTS (PROD_ID, CATEGORY, TITLE, ACTOR, PRICE) values (2, 3, 'The Lion King', '', 12.50); +insert into PRODUCTS (PROD_ID, CATEGORY, TITLE, ACTOR, PRICE, COMMON_PROD_ID) values (3, 5, 'March of the Penguins', '', 19.99, 2); +insert into PRODUCTS (PROD_ID, CATEGORY, TITLE, ACTOR, PRICE) values (4, 1, 'Indiana Jones and the Temple of Doom', 'Harisson Ford', 19.99); +insert into PRODUCTS (PROD_ID, CATEGORY, TITLE, ACTOR, PRICE) values (5, 1, 'Clear and Present Danger', 'Harisson Ford', 19.99); +insert into PRODUCTS (PROD_ID, CATEGORY, TITLE, ACTOR, PRICE) values (6, 6, 'Roman Holiday', 'Audrey Hepburn', 12.99); +insert into PRODUCTS (PROD_ID, CATEGORY, TITLE, ACTOR, PRICE) values (7, 6, 'Breakfast at Tiffany''s', 'Audrey Hepburn', 12.99); +insert into PRODUCTS (PROD_ID, CATEGORY, TITLE, ACTOR, PRICE) values (8, 6, 'Sabrina', 'Audrey Hepburn', 12.99); +insert into PRODUCTS (PROD_ID, CATEGORY, TITLE, ACTOR, PRICE) values (9, 4, 'Sabrina', 'Harrison Ford', 19.99); +insert into PRODUCTS (PROD_ID, CATEGORY, TITLE, ACTOR, PRICE) values (10, 1, 'Kill Bill Vol. 1', 'Uma Thurman', 19.99); +insert into PRODUCTS (PROD_ID, CATEGORY, TITLE, ACTOR, PRICE) values (11, 1, 'Kill Bill Vol. 2', 'Uma Thurman', 19.99); +insert into PRODUCTS (PROD_ID, CATEGORY, TITLE, ACTOR, PRICE) values (12, 7, 'Lost in Translation', 'Bill Murray', 19.99); +insert into PRODUCTS (PROD_ID, CATEGORY, TITLE, ACTOR, PRICE) values (13, 7, 'Broken Flowers', 'Bill Murray', 19.99); -insert into inventory (inv_id, prod_id, quan_in_stock, sales) values (1, 1, 10, 0); -insert into inventory (inv_id, prod_id, quan_in_stock, sales) values (2, 2, 15, 5); -insert into inventory (inv_id, prod_id, quan_in_stock, sales) values (3, 3, 77, 2); -insert into inventory (inv_id, prod_id, quan_in_stock, sales) values (4, 4, 67, 2); -insert into inventory (inv_id, prod_id, quan_in_stock, sales) values (5, 5, 57, 9); -insert into inventory (inv_id, prod_id, quan_in_stock, sales) values (6, 6, 44, 7); -insert into inventory (inv_id, prod_id, quan_in_stock, sales) values (7, 7, 88, 2); -insert into inventory (inv_id, prod_id, quan_in_stock, sales) values (8, 8, 99, 8); -insert into inventory (inv_id, prod_id, quan_in_stock, sales) values (9, 9, 56, 2); -insert into inventory (inv_id, prod_id, quan_in_stock, sales) values (10, 10, 102, 2); -insert into inventory (inv_id, prod_id, quan_in_stock, sales) values (11, 11, 994, 2); -insert into inventory (inv_id, prod_id, quan_in_stock, sales) values (12, 12, 12, 2); -insert into inventory (inv_id, prod_id, quan_in_stock, sales) values (13, 13, 77, 7); +insert into INVENTORY (INV_ID, PROD_ID, QUAN_IN_STOCK, SALES) values (1, 1, 10, 0); +insert into INVENTORY (INV_ID, PROD_ID, QUAN_IN_STOCK, SALES) values (2, 2, 15, 5); +insert into INVENTORY (INV_ID, PROD_ID, QUAN_IN_STOCK, SALES) values (3, 3, 77, 2); +insert into INVENTORY (INV_ID, PROD_ID, QUAN_IN_STOCK, SALES) values (4, 4, 67, 2); +insert into INVENTORY (INV_ID, PROD_ID, QUAN_IN_STOCK, SALES) values (5, 5, 57, 9); +insert into INVENTORY (INV_ID, PROD_ID, QUAN_IN_STOCK, SALES) values (6, 6, 44, 7); +insert into INVENTORY (INV_ID, PROD_ID, QUAN_IN_STOCK, SALES) values (7, 7, 88, 2); +insert into INVENTORY (INV_ID, PROD_ID, QUAN_IN_STOCK, SALES) values (8, 8, 99, 8); +insert into INVENTORY (INV_ID, PROD_ID, QUAN_IN_STOCK, SALES) values (9, 9, 56, 2); +insert into INVENTORY (INV_ID, PROD_ID, QUAN_IN_STOCK, SALES) values (10, 10, 102, 2); +insert into INVENTORY (INV_ID, PROD_ID, QUAN_IN_STOCK, SALES) values (11, 11, 994, 2); +insert into INVENTORY (INV_ID, PROD_ID, QUAN_IN_STOCK, SALES) values (12, 12, 12, 2); +insert into INVENTORY (INV_ID, PROD_ID, QUAN_IN_STOCK, SALES) values (13, 13, 77, 7); INSERT INTO USERS (USERID,TYPE,USERNAME,PASSWORD) VALUES (1,'admin','manager','password') @@ -45,8 +45,8 @@ insert into ORDERS (ORDERID,ORDERDATE,USERID,NETAMOUNT,TAX,TOTALAMOUNT,TRACKING,STATUS) VALUES (1,now(),2,14,3,17,'TR7901' ,0) insert into ORDERS (ORDERID,ORDERDATE,USERID,NETAMOUNT,TAX,TOTALAMOUNT,TRACKING,STATUS) VALUES (2,now(),2,24,5,29,'TR8331' ,0) -insert into ORDERLINES (ORDERLINEID,POSITION,ORDERID,PROD_ID,QUANTITY) VALUES (1,1,1,1,1) -insert into ORDERLINES (ORDERLINEID,POSITION,ORDERID,PROD_ID,QUANTITY) VALUES (2,2,1,2,1) -insert into ORDERLINES (ORDERLINEID,POSITION,ORDERID,PROD_ID,QUANTITY) VALUES (3,1,2,3,2) -insert into ORDERLINES (ORDERLINEID,POSITION,ORDERID,PROD_ID,QUANTITY) VALUES (4,2,2,4,1) -insert into ORDERLINES (ORDERLINEID,POSITION,ORDERID,PROD_ID,QUANTITY) VALUES (5,3,2,5,1) +insert into ORDERLINES (ORDERLINEID,POS,ORDERID,PROD_ID,QUANTITY) VALUES (1,1,1,1,1) +insert into ORDERLINES (ORDERLINEID,POS,ORDERID,PROD_ID,QUANTITY) VALUES (2,2,1,2,1) +insert into ORDERLINES (ORDERLINEID,POS,ORDERID,PROD_ID,QUANTITY) VALUES (3,1,2,3,2) +insert into ORDERLINES (ORDERLINEID,POS,ORDERID,PROD_ID,QUANTITY) VALUES (4,2,2,4,1) +insert into ORDERLINES (ORDERLINEID,POS,ORDERID,PROD_ID,QUANTITY) VALUES (5,3,2,5,1) 1.9 +2 -2 jboss-seam/examples/dvdstore/dd/ejb3/persistence.xml (In the diff below, changes in quantity of whitespace are not shown.) Index: persistence.xml =================================================================== RCS file: /cvsroot/jboss/jboss-seam/examples/dvdstore/dd/ejb3/persistence.xml,v retrieving revision 1.8 retrieving revision 1.9 diff -u -b -r1.8 -r1.9 --- persistence.xml 26 Sep 2005 04:41:32 -0000 1.8 +++ persistence.xml 28 Sep 2005 23:37:17 -0000 1.9 @@ -3,8 +3,8 @@ <!--<jta-data-source>java:/DVDStoreDS</jta-data-source>--> <jta-data-source>java:/DefaultDS</jta-data-source> <properties> - <property name="hibernate.hbm2ddl.auto" value="update"/> + <property name="hibernate.hbm2ddl.auto" value="create-drop" /> <property name="hibernate.show_sql" value="true" /> - <property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect"/> + <property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect" /> </properties> </entity-manager> 1.1 date: 2005/09/28 23:37:17; author: nrichards; state: Exp;jboss-seam/examples/dvdstore/dd/ejb3/hibernate.cfg.xml Index: hibernate.cfg.xml =================================================================== <?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <!-- jdbc connection properties --> <property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property> <property name="connection.datasource">java:DefaultDS</property> <!-- <property name="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</property> <property name="hibernate.connection.url">jdbc:hsqldb:.;sql.enforce_strict_size=true</property> <property name="hibernate.connection.username">sa</property> <property name="hibernate.connection.password"></property> --> <!-- c3p0 connection pooling properties <property name="hibernate.c3p0.min_size">1</property> <property name="hibernate.c3p0.max_size">3</property> --> <!-- other hibernate properties --> <property name="hibernate.show_sql">true</property> <!--identity mapping files --> <!-- uncomment if you don't want to use the default jBPM identity mgmgt component --> <!-- <mapping resource="org/jbpm/identity/User.hbm.xml"/> <mapping resource="org/jbpm/identity/Group.hbm.xml"/> <mapping resource="org/jbpm/identity/Membership.hbm.xml"/> --> <!-- graph.def mapping files --> <mapping resource="org/jbpm/graph/def/ProcessDefinition.hbm.xml"/> <mapping resource="org/jbpm/graph/def/Node.hbm.xml"/> <mapping resource="org/jbpm/graph/def/Transition.hbm.xml"/> <mapping resource="org/jbpm/graph/def/Event.hbm.xml"/> <mapping resource="org/jbpm/graph/def/Action.hbm.xml"/> <mapping resource="org/jbpm/graph/def/SuperState.hbm.xml"/> <mapping resource="org/jbpm/graph/def/ExceptionHandler.hbm.xml"/> <mapping resource="org/jbpm/instantiation/Delegation.hbm.xml"/> <!-- graph.node mapping files --> <mapping resource="org/jbpm/graph/node/StartState.hbm.xml"/> <mapping resource="org/jbpm/graph/node/EndState.hbm.xml"/> <mapping resource="org/jbpm/graph/node/ProcessState.hbm.xml"/> <mapping resource="org/jbpm/graph/node/Decision.hbm.xml"/> <mapping resource="org/jbpm/graph/node/Fork.hbm.xml"/> <mapping resource="org/jbpm/graph/node/Join.hbm.xml"/> <mapping resource="org/jbpm/graph/node/State.hbm.xml"/> <mapping resource="org/jbpm/graph/node/TaskNode.hbm.xml"/> <!-- graph.action mapping files --> <mapping resource="org/jbpm/graph/action/Script.hbm.xml"/> <!-- context.def mapping files --> <mapping resource="org/jbpm/context/def/ContextDefinition.hbm.xml"/> <mapping resource="org/jbpm/context/def/VariableAccess.hbm.xml"/> <!-- taskmgmt.def mapping files --> <mapping resource="org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml"/> <mapping resource="org/jbpm/taskmgmt/def/Swimlane.hbm.xml"/> <mapping resource="org/jbpm/taskmgmt/def/Task.hbm.xml"/> <mapping resource="org/jbpm/taskmgmt/def/TaskController.hbm.xml"/> <!-- module.def mapping files --> <mapping resource="org/jbpm/module/def/ModuleDefinition.hbm.xml"/> <!-- bytes mapping files --> <mapping resource="org/jbpm/bytes/ByteArray.hbm.xml"/> <!-- file.def mapping files --> <mapping resource="org/jbpm/file/def/FileDefinition.hbm.xml"/> <!-- scheduler.def mapping files --> <mapping resource="org/jbpm/scheduler/def/CreateTimerAction.hbm.xml"/> <mapping resource="org/jbpm/scheduler/def/CancelTimerAction.hbm.xml"/> <!-- graph.exe mapping files --> <mapping resource="org/jbpm/graph/exe/Comment.hbm.xml"/> <mapping resource="org/jbpm/graph/exe/ProcessInstance.hbm.xml"/> <mapping resource="org/jbpm/graph/exe/Token.hbm.xml"/> <mapping resource="org/jbpm/graph/exe/RuntimeAction.hbm.xml"/> <!-- module.exe mapping files --> <mapping resource="org/jbpm/module/exe/ModuleInstance.hbm.xml"/> <!-- context.exe mapping files --> <mapping resource="org/jbpm/context/exe/ContextInstance.hbm.xml"/> <mapping resource="org/jbpm/context/exe/TokenVariableMap.hbm.xml"/> <mapping resource="org/jbpm/context/exe/VariableInstance.hbm.xml"/> <mapping resource="org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml"/> <mapping resource="org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml"/> <mapping resource="org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml"/> <mapping resource="org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml"/> <mapping resource="org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml"/> <mapping resource="org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml"/> <mapping resource="org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml"/> <!-- taskmgmt.exe mapping files --> <mapping resource="org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xml"/> <mapping resource="org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml"/> <mapping resource="org/jbpm/taskmgmt/exe/PooledActor.hbm.xml"/> <mapping resource="org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xml"/> <!-- scheduler.exe mapping files --> <mapping resource="org/jbpm/scheduler/exe/Timer.hbm.xml"/> <!-- logging mapping files --> <mapping resource="org/jbpm/logging/log/ProcessLog.hbm.xml"/> <mapping resource="org/jbpm/logging/log/MessageLog.hbm.xml"/> <mapping resource="org/jbpm/logging/log/CompositeLog.hbm.xml"/> <mapping resource="org/jbpm/graph/log/ActionLog.hbm.xml"/> <mapping resource="org/jbpm/graph/log/NodeLog.hbm.xml"/> <mapping resource="org/jbpm/graph/log/ProcessInstanceCreateLog.hbm.xml"/> <mapping resource="org/jbpm/graph/log/ProcessInstanceEndLog.hbm.xml"/> <mapping resource="org/jbpm/graph/log/SignalLog.hbm.xml"/> <mapping resource="org/jbpm/graph/log/TokenCreateLog.hbm.xml"/> <mapping resource="org/jbpm/graph/log/TokenEndLog.hbm.xml"/> <mapping resource="org/jbpm/graph/log/TransitionLog.hbm.xml"/> <mapping resource="org/jbpm/context/log/VariableLog.hbm.xml"/> <mapping resource="org/jbpm/context/log/VariableCreateLog.hbm.xml"/> <mapping resource="org/jbpm/context/log/VariableDeleteLog.hbm.xml"/> <mapping resource="org/jbpm/context/log/VariableUpdateLog.hbm.xml"/> <mapping resource="org/jbpm/context/log/variableinstance/ByteArrayUpdateLog.hbm.xml"/> <mapping resource="org/jbpm/context/log/variableinstance/DateUpdateLog.hbm.xml"/> <mapping resource="org/jbpm/context/log/variableinstance/DoubleUpdateLog.hbm.xml"/> <mapping resource="org/jbpm/context/log/variableinstance/HibernateLongUpdateLog.hbm.xml"/> <mapping resource="org/jbpm/context/log/variableinstance/HibernateStringUpdateLog.hbm.xml"/> <mapping resource="org/jbpm/context/log/variableinstance/LongUpdateLog.hbm.xml"/> <mapping resource="org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml"/> <mapping resource="org/jbpm/taskmgmt/log/TaskLog.hbm.xml"/> <mapping resource="org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml"/> <mapping resource="org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml"/> <mapping resource="org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml"/> <mapping resource="org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml"/> <mapping resource="org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.xml"/> <mapping resource="org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.xml"/> </session-factory> </hibernate-configuration> |