Mercurial > dive4elements > river
diff artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/BedHeightFactory.java @ 8582:17a3030bbda2
Update SQL-statements to schema-changes in rev 6d8d7425a6b5.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 16 Mar 2015 16:59:37 +0100 |
| parents | 078b07a94023 |
| children | 5e38e2924c07 |
line wrap: on
line diff
--- a/artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/BedHeightFactory.java Mon Mar 16 15:36:38 2015 +0100 +++ b/artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/BedHeightFactory.java Mon Mar 16 16:59:37 2015 +0100 @@ -32,8 +32,8 @@ public static final String SQL_SELECT_SINGLE = "SELECT bhsv.height, bhsv.station, bhsv.data_gap," + " bhsv.sounding_width, bhs.year" + - " FROM bed_height_single bhs" + - " JOIN bed_height_single_values bhsv on bhsv.bed_height_single_id = bhs.id"; + " FROM bed_height bhs" + + " JOIN bed_height_values bhsv on bhsv.bed_height_id = bhs.id"; public static final String ID_CLAUSE = " WHERE bhs.id = :height_id" + @@ -46,7 +46,7 @@ /** Query to get name (description) for wst_id. */ public static final String SQL_SELECT_DESCR_SINGLE = - "SELECT description FROM bed_height_single "+ + "SELECT description FROM bed_height "+ "WHERE id = :height_id"; private BedHeightFactory() {