Wiki source code of Use of HiLoGenerator with sql-util DAO classes
Version 1.1 by christoph_lechleitner@iteg_at on 2013-02-02 04.17:14
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | === {{id name="UseofHiLoGeneratorwithsql-utilDAOclasses-AddtableID_GENERATORtoTableDefinitions"/}}Add table ID_GENERATOR to TableDefinitions === | ||
| 2 | |||
| 3 | (% class="syntaxhighlighter nogutter java" %) | ||
| 4 | ((( | ||
| 5 | |((( | ||
| 6 | (% class="container" title="Hint: double-click to select code" %) | ||
| 7 | ((( | ||
| 8 | (% class="line number1 index0 alt2" %) | ||
| 9 | ((( | ||
| 10 | (% class="java plain" %){{code language="none"}}TableInfo idGenerator={{/code}}(% class="java keyword" %){{code language="none"}}new{{/code}}(%%) (% class="java plain" %){{code language="none"}}TableInfo({{/code}}(% class="java string" %){{code language="none"}}"ID_GENERATOR"{{/code}}(% class="java plain" %){{code language="none"}});{{/code}} | ||
| 11 | ))) | ||
| 12 | |||
| 13 | (% class="line number2 index1 alt1" %) | ||
| 14 | ((( | ||
| 15 | (% class="java plain" %){{code language="none"}}idGenerator.setColumns(Arrays.asList({{/code}} | ||
| 16 | ))) | ||
| 17 | |||
| 18 | (% class="line number3 index2 alt2" %) | ||
| 19 | ((( | ||
| 20 | (% class="java spaces" %){{code language="none"}} {{/code}}(% class="java keyword" %){{code language="none"}}new{{/code}}(%%) (% class="java plain" %){{code language="none"}}ColumnInfo({{/code}}(% class="java string" %){{code language="none"}}"NEXT_ID"{{/code}}(% class="java plain" %){{code language="none"}},Types.BIGINT,{{/code}}(% class="java value" %){{code language="none"}}20{{/code}}(% class="java plain" %){{code language="none"}},{{/code}}(% class="java keyword" %){{code language="none"}}null{{/code}}(% class="java plain" %){{code language="none"}},{{/code}}(% class="java keyword" %){{code language="none"}}false{{/code}}(% class="java plain" %){{code language="none"}},{{/code}}(% class="java keyword" %){{code language="none"}}null{{/code}}(% class="java plain" %){{code language="none"}}){{/code}} | ||
| 21 | ))) | ||
| 22 | |||
| 23 | (% class="line number4 index3 alt1" %) | ||
| 24 | ((( | ||
| 25 | (% class="java plain" %){{code language="none"}}));{{/code}} | ||
| 26 | ))) | ||
| 27 | ))) | ||
| 28 | ))) | ||
| 29 | ))) | ||
| 30 | |||
| 31 | === {{id name="UseofHiLoGeneratorwithsql-utilDAOclasses-InstantiateanidGeneratorbean"/}}Instantiate an idGenerator bean === | ||
| 32 | |||
| 33 | (% class="syntaxhighlighter nogutter java" %) | ||
| 34 | ((( | ||
| 35 | |((( | ||
| 36 | (% class="container" title="Hint: double-click to select code" %) | ||
| 37 | ((( | ||
| 38 | (% class="line number1 index0 alt2" %) | ||
| 39 | ((( | ||
| 40 | (% class="java plain" %)##<[[bp:bean>>url:http://bpbean||shape="rect"]] id=##(% class="java string" %){{code language="none"}}"idGenerator"{{/code}}(%%) (% class="java keyword" %){{code language="none"}}class{{/code}}(% class="java plain" %){{code language="none"}}={{/code}}(% class="java string" %){{code language="none"}}"org.clazzes.util.sql.dao.HiLoIdGenerator"{{/code}} | ||
| 41 | ))) | ||
| 42 | |||
| 43 | (% class="line number2 index1 alt1" %) | ||
| 44 | ((( | ||
| 45 | (% class="java spaces" %){{code language="none"}} {{/code}}(% class="java plain" %){{code language="none"}}init-method={{/code}}(% class="java string" %){{code language="none"}}"initialize"{{/code}}(%%) (% class="java plain" %){{code language="none"}}depends-on={{/code}}(% class="java string" %){{code language="none"}}"databaseSetup"{{/code}}(% class="java plain" %){{code language="none"}}>{{/code}} | ||
| 46 | ))) | ||
| 47 | |||
| 48 | (% class="line number3 index2 alt2" %) | ||
| 49 | ((( | ||
| 50 | (% class="java spaces" %){{code language="none"}} {{/code}}(% class="java plain" %)##<[[bp:property>>url:http://bpproperty||shape="rect"]] name=##(% class="java string" %){{code language="none"}}"dataSource"{{/code}}(%%) (% class="java plain" %){{code language="none"}}ref={{/code}}(% class="java string" %){{code language="none"}}"dataSource"{{/code}}(% class="java plain" %){{code language="none"}}/>{{/code}} | ||
| 51 | ))) | ||
| 52 | |||
| 53 | (% class="line number4 index3 alt1" %) | ||
| 54 | ((( | ||
| 55 | (% class="java plain" %)##</[[bp:bean>>url:http://bpbean||shape="rect"]]>## | ||
| 56 | ))) | ||
| 57 | ))) | ||
| 58 | ))) | ||
| 59 | ))) | ||
| 60 | |||
| 61 | databaseSetup is the bean representing the JDBC2XML SchemaManager (see [[this HowTo>>doc:JDBC2XML.Java Library Documentation.How To create and update Databases using SchemaManager and SchemaUpdateSnippets.WebHome]]), depends-on assures, that the ID generator is started after the database tables are set up. | ||
| 62 | |||
| 63 | ==== {{id name="UseofHiLoGeneratorwithsql-utilDAOclasses-Variant:idGeneratorbeanusingapplicationspecifictableandcolumnnames:"/}}Variant: idGenerator bean using application specific table and column names: ==== | ||
| 64 | |||
| 65 | (% class="syntaxhighlighter nogutter java" %) | ||
| 66 | ((( | ||
| 67 | |((( | ||
| 68 | (% class="container" title="Hint: double-click to select code" %) | ||
| 69 | ((( | ||
| 70 | (% class="line number1 index0 alt2" %) | ||
| 71 | ((( | ||
| 72 | (% class="java plain" %)##<[[bp:bean>>url:http://bpbean||shape="rect"]] id=##(% class="java string" %){{code language="none"}}"idGenerator"{{/code}}(%%) (% class="java keyword" %){{code language="none"}}class{{/code}}(% class="java plain" %){{code language="none"}}={{/code}}(% class="java string" %){{code language="none"}}"org.clazzes.util.sql.dao.HiLoIdGenerator"{{/code}} | ||
| 73 | ))) | ||
| 74 | |||
| 75 | (% class="line number2 index1 alt1" %) | ||
| 76 | ((( | ||
| 77 | (% class="java spaces" %){{code language="none"}} {{/code}}(% class="java plain" %){{code language="none"}}init-method={{/code}}(% class="java string" %){{code language="none"}}"initialize"{{/code}}(%%) (% class="java plain" %){{code language="none"}}depends-on={{/code}}(% class="java string" %){{code language="none"}}"databaseSetup"{{/code}}(% class="java plain" %){{code language="none"}}>{{/code}} | ||
| 78 | ))) | ||
| 79 | |||
| 80 | (% class="line number3 index2 alt2" %) | ||
| 81 | ((( | ||
| 82 | (% class="java spaces" %){{code language="none"}} {{/code}}(% class="java plain" %)##<[[bp:property>>url:http://bpproperty||shape="rect"]] name=##(% class="java string" %){{code language="none"}}"dataSource"{{/code}}(%%) (% class="java plain" %){{code language="none"}}ref={{/code}}(% class="java string" %){{code language="none"}}"dataSource"{{/code}}(% class="java plain" %){{code language="none"}}/>{{/code}} | ||
| 83 | ))) | ||
| 84 | |||
| 85 | (% class="line number4 index3 alt1" %) | ||
| 86 | ((( | ||
| 87 | (% class="java spaces" %){{code language="none"}} {{/code}}(% class="java plain" %){{code language="none"}}<!-- idTableName, {{/code}}(% class="java keyword" %){{code language="none"}}default{{/code}}(% class="java plain" %){{code language="none"}}: ID_GENERATOR -->{{/code}} | ||
| 88 | ))) | ||
| 89 | |||
| 90 | (% class="line number5 index4 alt2" %) | ||
| 91 | ((( | ||
| 92 | (% class="java spaces" %){{code language="none"}} {{/code}}(% class="java plain" %)##<[[bp:property>>url:http://bpproperty||shape="rect"]] name=##(% class="java string" %){{code language="none"}}"idTableName"{{/code}}(%%) (% class="java plain" %){{code language="none"}}value={{/code}}(% class="java string" %){{code language="none"}}"MYAPP_ID_GENERATOR"{{/code}}(% class="java plain" %){{code language="none"}}/>{{/code}} | ||
| 93 | ))) | ||
| 94 | |||
| 95 | (% class="line number6 index5 alt1" %) | ||
| 96 | ((( | ||
| 97 | (% class="java spaces" %){{code language="none"}} {{/code}}(% class="java plain" %){{code language="none"}}<!-- nextIdColumnName, {{/code}}(% class="java keyword" %){{code language="none"}}default{{/code}}(% class="java plain" %){{code language="none"}}: NEXT_ID -->{{/code}} | ||
| 98 | ))) | ||
| 99 | |||
| 100 | (% class="line number7 index6 alt2" %) | ||
| 101 | ((( | ||
| 102 | (% class="java spaces" %){{code language="none"}} {{/code}}(% class="java plain" %)##<[[bp:property>>url:http://bpproperty||shape="rect"]] name=##(% class="java string" %){{code language="none"}}"nextIdColumnName"{{/code}}(%%) (% class="java plain" %){{code language="none"}}value={{/code}}(% class="java string" %){{code language="none"}}"NEXT_ID"{{/code}}(% class="java plain" %){{code language="none"}}/>{{/code}} | ||
| 103 | ))) | ||
| 104 | |||
| 105 | (% class="line number8 index7 alt1" %) | ||
| 106 | ((( | ||
| 107 | (% class="java plain" %)##</[[bp:bean>>url:http://bpbean||shape="rect"]]>## | ||
| 108 | ))) | ||
| 109 | ))) | ||
| 110 | ))) | ||
| 111 | ))) | ||
| 112 | |||
| 113 | === {{id name="UseofHiLoGeneratorwithsql-utilDAOclasses-SettheIdGeneratorinyourDAOs"/}}Set the IdGenerator in your DAOs === | ||
| 114 | |||
| 115 | (% class="syntaxhighlighter nogutter java" %) | ||
| 116 | ((( | ||
| 117 | |((( | ||
| 118 | (% class="container" title="Hint: double-click to select code" %) | ||
| 119 | ((( | ||
| 120 | (% class="line number1 index0 alt2" %) | ||
| 121 | ((( | ||
| 122 | (% class="java plain" %)##<[[bp:bean>>url:http://bpbean||shape="rect"]] id=##(% class="java string" %){{code language="none"}}"userDAO"{{/code}}(%%) (% class="java keyword" %){{code language="none"}}class{{/code}}(% class="java plain" %){{code language="none"}}={{/code}}(% class="java string" %){{code language="none"}}"at.egv.drust.impl.dao.jdbc.DsUserJdbcDAO"{{/code}}(% class="java plain" %){{code language="none"}}>{{/code}} | ||
| 123 | ))) | ||
| 124 | |||
| 125 | (% class="line number2 index1 alt1" %) | ||
| 126 | ((( | ||
| 127 | (% class="java spaces" %){{code language="none"}} {{/code}}(% class="java plain" %)##<[[bp:property>>url:http://bpproperty||shape="rect"]] name=##(% class="java string" %){{code language="none"}}"idGenerator"{{/code}}(%%) (% class="java plain" %){{code language="none"}}ref={{/code}}(% class="java string" %){{code language="none"}}"idGenerator"{{/code}}(% class="java plain" %){{code language="none"}}/>{{/code}} | ||
| 128 | ))) | ||
| 129 | |||
| 130 | (% class="line number3 index2 alt2" %) | ||
| 131 | ((( | ||
| 132 | (% class="java spaces" %){{code language="none"}} {{/code}}(% class="java plain" %)##<[[bp:property>>url:http://bpproperty||shape="rect"]] name=##(% class="java string" %){{code language="none"}}"generator"{{/code}}(%%) (% class="java plain" %){{code language="none"}}ref={{/code}}(% class="java string" %){{code language="none"}}"sqlGenerator"{{/code}}(% class="java plain" %){{code language="none"}}/>{{/code}} | ||
| 133 | ))) | ||
| 134 | |||
| 135 | (% class="line number4 index3 alt1" %) | ||
| 136 | ((( | ||
| 137 | (% class="java spaces" %){{code language="none"}} {{/code}}(% class="java plain" %)##<[[bp:property>>url:http://bpproperty||shape="rect"]] name=##(% class="java string" %){{code language="none"}}"threadLocalKey"{{/code}}(%%) (% class="java plain" %){{code language="none"}}ref={{/code}}(% class="java string" %){{code language="none"}}"jdbcUrl"{{/code}}(% class="java plain" %){{code language="none"}}/>{{/code}} | ||
| 138 | ))) | ||
| 139 | |||
| 140 | (% class="line number5 index4 alt2" %) | ||
| 141 | ((( | ||
| 142 | (% class="java plain" %)##</[[bp:bean>>url:http://bpbean||shape="rect"]]>## | ||
| 143 | ))) | ||
| 144 | ))) | ||
| 145 | ))) | ||
| 146 | ))) |