hibernate - Hyperjaxb3: Create lookup table from enumeration element -

-

i have xsd file includes element enumeration constraint:

<xs:complextype name="request">     <xs:sequence>         <xs:element name="commsaddress" type="xs:string" />         <xs:element name="commsaddresstype">             <xs:simpletype>                 <xs:restriction base="xs:string">                     <xs:enumeration value="email"/>                     <xs:enumeration value="phone"/>                 </xs:restriction>             </xs:simpletype>         </xs:element>         ...

i commsaddresstype field in generated java class generated enum values email , phone. in turn, hibernate automatically generate database schema commsaddresstype table containing 2 rows values email , phone. request table can reference these commsaddresstypeid column.

currently, hyperjaxb3 generates request class commsaddresstype field of type string:

@xmlelement(name="commsaddresstype") protected string commsaddresstype

and schema generated request table has commsaddresstype column of type varchar. result in lot of unnecessary duplicated data.

is there way of achieving described above? also, exposing xsd customer, avoid including jaxb or hyperjaxb tags in schema if possible.

disclaimer: i'm author of hyperjaxb.

if make enumerated types become enums in java, hyperjaxb handle them enums, not strings. can, instance, customize simple type with:

<jaxb:typesafeenumclass/>

see example.

hyperjaxb map corrsponding properties @enumerated.

no, can't generate lookup table can customize how enum mapped in database. instance, can make mapped enumtype.ordinal:

<hj:basic><orm:enumerated>ordinal</orm:enumerated></hj:basic>

example.

actually, enums don't need lookup tables jpa. jpa map enums correctly according speified enumtype mapping.

but may need lookup table own purposes - being able produce human-readable values in joined queries.

in case i'd recommend mapping enum ordinal , adding lookup table plus corresponding foreign keys on own ddl scripts.

and yes, can of described customizations in separate bindings file (normally bindings.xjb), don't have directly in schema. see test projects here, there plenty of examples. *.xjb files in src/main/resources directories.


Comments

Post a Comment

Popular posts from this blog

javascript - Chart.js (Radar Chart) different scaleLineColor for each scaleLine -

-
Image
i try , create radar chart using chart.js has various colours each scaleline, or coloured between scalelines. wondering if possible? from: to: i have working graph, though there doesn't seem method change individual scale lines. kind regards leigh you can extend radar chart type this, so chart.types.radar.extend({ name: "radaralt", initialize: function (data) { chart.types.radar.prototype.initialize.apply(this, arguments); var originalscaledraw = this.scale.draw; var ctx = this.chart.ctx; this.scale.draw = function () { var linewidth = this.linewidth; // bypasses line drawing in originalscaledraw this.linewidth = linewidth; originalscaledraw.apply(this, arguments); ctx.linewidth = this.linewidth; var scale = this; // draw chart.helpers.each(scale.ylabels, function (label, index) { // color of ...
Read more

apache - Error with PHP mail(): Multiple or malformed newlines found in additional_header -

-
suddenly have started receiving above error without changes having been made script. host 1and1 (i know...) the script still works fine on different server, , suspicion there must have been server config change has lead this, although hosts plead ignorance. there's no information on above error @ in google can find - have ideas? server running apache if helps. had similar problem. came out of blue. no php code changed. what changed: php upgraded 5.5.25-1 5.5.26. a security risk in php mail() function has been fixed , newlines in additional_headers allowed no more. because newlines mean: starts email message (and surely don't want inject newlines through headers followed evil message). what have worked fine, e.g. having newlines after headers or passing whole message additional_headers , function no more. solution : sanitize headers. no multiple newlines in additional_headers argument. these count "multiple or malformed newlines":...
Read more

java - Android – MapFragment overlay button shadow, just like MyLocation button -

-
Image
i'm struggling add shadow custom overlay button on google map. goal make custom button google's mylocation button. here's how app looks now: layout.xml <relativelayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" xmlns:map="http://schemas.android.com/apk/res-auto" android:layout_height="match_parent" android:layout_width="match_parent" style="@style/apptheme"> <fragment android:layout_width="match_parent" android:layout_height="match_parent" android:id="@+id/map" tools:context=".mapsactivity" android:name="com.google.android.gms.maps.supportmapfragment" android:layout_alignparentend="true" android:layout_alignparentstart="true" android:layout_alignparentbottom="true" ...
Read more