Wiki source code of Use of HiLoGenerator with sql-util DAO classes
Last modified by christoph_lechleitner@iteg_at on 2013-02-02 07.58:44
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 | |||
| 7 | |((( | ||
| 8 | (% class="container" title="Hint: double-click to select code" %) | ||
| 9 | ((( | ||
| 10 | (% class="line number1 index0 alt2" %) | ||
| 11 | ((( | ||
| 12 | (% 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}} | ||
| 13 | ))) | ||
| 14 | |||
| 15 | (% class="line number2 index1 alt1" %) | ||
| 16 | ((( | ||
| 17 | (% class="java plain" %){{code language="none"}}idGenerator.setColumns(Arrays.asList({{/code}} | ||
| 18 | ))) | ||
| 19 | |||
| 20 | (% class="line number3 index2 alt2" %) | ||
| 21 | ((( | ||
| 22 | (% 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}} | ||
| 23 | ))) | ||
| 24 | |||
| 25 | (% class="line number4 index3 alt1" %) | ||
| 26 | ((( | ||
| 27 | (% class="java plain" %){{code language="none"}}));{{/code}} | ||
| 28 | ))) | ||
| 29 | ))) | ||
| 30 | ))) | ||
| 31 | |||
| 32 | Future versions should use the constants {{code language="none"}}HiLoIdGenerator.DEFAULT_ID_TABLE_NAME{{/code}}, {{code language="none"}}HiLoIdGenerator.DEFAULT_NEXT_ID_COL_NAME{{/code}} which are part of sql-util as of the yet unreleased version 1.2.1. | ||
| 33 | ))) | ||
| 34 | |||
| 35 | === {{id name="UseofHiLoGeneratorwithsql-utilDAOclasses-InstantiateanidGeneratorbean"/}}Instantiate an idGenerator bean === | ||
| 36 | |||
| 37 | (% class="syntaxhighlighter nogutter java" %) | ||
| 38 | ((( | ||
| 39 | |((( | ||
| 40 | (% class="container" title="Hint: double-click to select code" %) | ||
| 41 | ((( | ||
| 42 | (% class="line number1 index0 alt2" %) | ||
| 43 | ((( | ||
| 44 | (% 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}} | ||
| 45 | ))) | ||
| 46 | |||
| 47 | (% class="line number2 index1 alt1" %) | ||
| 48 | ((( | ||
| 49 | (% 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}} | ||
| 50 | ))) | ||
| 51 | |||
| 52 | (% class="line number3 index2 alt2" %) | ||
| 53 | ((( | ||
| 54 | (% 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}} | ||
| 55 | ))) | ||
| 56 | |||
| 57 | (% class="line number4 index3 alt1" %) | ||
| 58 | ((( | ||
| 59 | (% class="java plain" %)##</[[bp:bean>>url:http://bpbean||shape="rect"]]>## | ||
| 60 | ))) | ||
| 61 | ))) | ||
| 62 | ))) | ||
| 63 | |||
| 64 | |||
| 65 | ))) | ||
| 66 | |||
| 67 | 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. | ||
| 68 | |||
| 69 | ==== {{id name="UseofHiLoGeneratorwithsql-utilDAOclasses-Variant:idGeneratorbeanusingapplicationspecifictableandcolumnnames:"/}}Variant: idGeneratorbean using application specific table and column names: ==== | ||
| 70 | |||
| 71 | (% class="syntaxhighlighter nogutter java" %) | ||
| 72 | ((( | ||
| 73 | |||
| 74 | |||
| 75 | |((( | ||
| 76 | (% class="container" title="Hint: double-click to select code" %) | ||
| 77 | ((( | ||
| 78 | (% class="line number1 index0 alt2" %) | ||
| 79 | ((( | ||
| 80 | (% 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}} | ||
| 81 | ))) | ||
| 82 | |||
| 83 | (% class="line number2 index1 alt1" %) | ||
| 84 | ((( | ||
| 85 | (% 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}} | ||
| 86 | ))) | ||
| 87 | |||
| 88 | (% class="line number3 index2 alt2" %) | ||
| 89 | ((( | ||
| 90 | (% 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}} | ||
| 91 | ))) | ||
| 92 | |||
| 93 | (% class="line number4 index3 alt1" %) | ||
| 94 | ((( | ||
| 95 | (% 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}} | ||
| 96 | ))) | ||
| 97 | |||
| 98 | (% class="line number5 index4 alt2" %) | ||
| 99 | ((( | ||
| 100 | (% 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}} | ||
| 101 | ))) | ||
| 102 | |||
| 103 | (% class="line number6 index5 alt1" %) | ||
| 104 | ((( | ||
| 105 | (% 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}} | ||
| 106 | ))) | ||
| 107 | |||
| 108 | (% class="line number7 index6 alt2" %) | ||
| 109 | ((( | ||
| 110 | (% 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}} | ||
| 111 | ))) | ||
| 112 | |||
| 113 | (% class="line number8 index7 alt1" %) | ||
| 114 | ((( | ||
| 115 | (% class="java plain" %)##</[[bp:bean>>url:http://bpbean||shape="rect"]]>## | ||
| 116 | ))) | ||
| 117 | ))) | ||
| 118 | ))) | ||
| 119 | |||
| 120 | |||
| 121 | ))) | ||
| 122 | |||
| 123 | === {{id name="UseofHiLoGeneratorwithsql-utilDAOclasses-SetthesqlGeneratorinyourDAOs"/}}Set the sqlGenerator in your DAOs === | ||
| 124 | |||
| 125 | (% class="syntaxhighlighter nogutter java" %) | ||
| 126 | ((( | ||
| 127 | |||
| 128 | |||
| 129 | |((( | ||
| 130 | (% class="container" title="Hint: double-click to select code" %) | ||
| 131 | ((( | ||
| 132 | (% class="line number1 index0 alt2" %) | ||
| 133 | ((( | ||
| 134 | (% 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}} | ||
| 135 | ))) | ||
| 136 | |||
| 137 | (% class="line number2 index1 alt1" %) | ||
| 138 | ((( | ||
| 139 | (% 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}} | ||
| 140 | ))) | ||
| 141 | |||
| 142 | (% class="line number3 index2 alt2" %) | ||
| 143 | ((( | ||
| 144 | (% class="java spaces" style="font-size: 10.0pt;line-height: 13.0pt;" %){{code language="none"}} {{/code}}(% class="java plain" style="font-size: 10.0pt;line-height: 13.0pt;" %)##<[[bp:property>>url:http://bpproperty||shape="rect"]] name=##(% class="java string" style="font-size: 10.0pt;line-height: 13.0pt;" %){{code language="none"}}"threadLocalKey"{{/code}}(% style="font-size: 10.0pt;line-height: 13.0pt;" %) (% class="java plain" style="font-size: 10.0pt;line-height: 13.0pt;" %){{code language="none"}}ref={{/code}}(% class="java string" style="font-size: 10.0pt;line-height: 13.0pt;" %){{code language="none"}}"jdbcUrl"{{/code}}(% class="java plain" style="font-size: 10.0pt;line-height: 13.0pt;" %){{code language="none"}}/>{{/code}} | ||
| 145 | ))) | ||
| 146 | |||
| 147 | (% class="line number5 index4 alt2" %) | ||
| 148 | ((( | ||
| 149 | (% class="java plain" %)##</[[bp:bean>>url:http://bpbean||shape="rect"]]>## | ||
| 150 | ))) | ||
| 151 | ))) | ||
| 152 | ))) | ||
| 153 | ))) |