mark smith

hi

i use spring boot 2.3.2 with spring data and hibernate.

I have a Enum

public enum CharacterType{    TROLL(1),    MAGICIAN(2);        private final int id;        CharacterType(int id){    this.id=id;        public int getId(){        return id;    }     }

I have an enitty
public class Enemy{    int id;    int characterType; }

In my repository i tried theses solutions without success

@Query(value="select e from Enemy e where e.characterType=com.oryx.constant.CharacterType.TROLL.id" public List<Enemy> getEnemy(); @Query(value="select e from Enemy e where e.characterType=com.oryx.constant.CharacterType.TROLL.getId()" public List<Enemy> getEnemy(); @Query(value="select e from Enemy e where e.characterType=:#{T(com.oryx.constant.CharacterType).TROLL.getId()}" public List<Enemy> getEnemy(); @Query(value="select e from Enemy e where e.characterType=:#{T(com.oryx.constant.CharacterType).TROLL.id}" public List<Enemy> getEnemy();

If I do like that that working

@Query(value="select e from Enemy e where e.characterType=1" public List<Enemy> getEnemy();

I see some thread like this one: https://stackoverflow.com/questions/63060484/enum-in-query-get-invalid-expression who have similar issue.


thanks

Hi

I use jpa with hibernate

I use IdCass for a composite key.

public class SamplingsPK implements Serializable {    private Integer id;    private int year;   ... } @Entity @IdClass(SamplingsPK.class) @Inheritance(strategy = InheritanceType.SINGLE_TABLE) public class Samplings {    @Id    @GeneratedValue    private Integer id;    @Id    private int year;    ...     @OneToMany(mappedBy = "sampling", cascade = CascadeType.PERSIST, orphanRemoval = true)     private List<Samples> samples = new ArrayList<>(); } @Entity public class Samples extends BaseEntity {     @Id    @SequenceGenerator(name = "samples_id_seq", sequenceName = "samples_id_seq", allocationSize = 1)    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "samples_id_seq")    private Integer id;    private String sampleLetter;        @ManyToOne    @JoinColumns({        @JoinColumn(name = "sampling_id", referencedColumnName = "id"),        @JoinColumn(name = "sampling_year", referencedColumnName = "year")})    private Samplings sampling;    .... }


Save code


Samplings samplings = new TraditionalSamplings(); .. Samples sample = new Samples(); sample.setSampleLetter("A"); samplings.addSample(sample); samplingsRepository.save(samplings);

When Samplings is saved, samples is saved but sampling_id  and sampling_year are empty


any idea?

I use spring boot with spring-data-jpa and hibernate implementation

I have a many to many relations


@Entity public class Address{    ...    @ManyToMany(cascade = {CascadeType.MERGE, CascadeType.PERSIST}, mappedBy = "addresses")    private List<Person> persons = new ArrayList<>();    public void addPerson(Person person) {        persons.add(person);        person.getAddresses().add(this);    }    public void removePerson(Person person) {        persons.remove(person);        person.getAddresses().remove(this);    } } @Entity public class Person{    ...    @ManyToMany(cascade = {CascadeType.MERGE, CascadeType.PERSIST})    @JoinColumn(name = "address_id")    private List<Address> addresses = new ArrayList<>();    public void addAddress(Address address) {        addresses.add(address);        address.getPerson().add(this);    }    public void removeAddress(Address address) {        addresses.remove(address);        address.getPerson().remove(this);    } }


Actually if I take a person, add some address and save... person and address are saved.

I would like to be able to do also from the other side: address, add person and save

tried to put on both cascade = {CascadeType.MERGE, CascadeType.PERSIST} on both side, but it don't work

hi

i have an application with rest architecture in spring boot.
i have an other application  in spring boot who use spring mvc (thymeleaf)

mvc will call rest service with resttemplate

we would like to add security to spring rest and spring mvc.

what could be solution to add security?

thanks

hi

I use spring boot in a rest architecture and i would like to allow only some user to access some function.

@Configuration @EnableWebSecurity public class ApplicationSecurity extends WebSecurityConfigurerAdapter { @Override protected void configure(HttpSecurity http) throws Exception {    http.authorizeRequests()            .antMatchers("/login").permitAll()            .antMatchers("/rest/**").authenticated();    http.csrf().disable();    http.exceptionHandling().authenticationEntryPoint(authenticationEntryPoint);    http.formLogin().successHandler(authenticationSuccessHandler);    http.formLogin().failureHandler(authenticationFailureHandler);    http.logout().logoutUrl("/logout");    http.logout().logoutSuccessUrl("/"); }


In one of my service interface, i added this annotation

@PreAuthorize("hasRole('ADMIN')")


but actually that don't work, all role seem to have access to this function

do i need another thing to setup in the config?

hi

I use spring boot, i created a class who extends WebSecurityConfigurerAdapter

@Order(SecurityProperties.ACCESS_OVERRIDE_ORDER) public class GymApplicationSecurity extends WebSecurityConfigurerAdapter { @Override protected void configure(HttpSecurity http) throws Exception { http.authorizeRequests().antMatchers("/rest/**").authenticated(); http.csrf().disable(); http.exceptionHandling().authenticationEntryPoint(authenticationEntryPoint); http.formLogin().successHandler(authenticationSuccessHandler); http.formLogin().failureHandler(authenticationFailureHandler); http.logout().logoutUrl("/logout"); http.logout().logoutSuccessUrl("/"); }

I can log without problem to the application.

Now i would like to allow only some role to acess some url

I added

http.authorizeRequests().antMatchers("/rest/report/**").access("hasRole('ROLE_ADMIN')");


My user has ROLE_USER role and access report page without problem, do i need to add any other configuration to get it working?

thanks

hi

i search a library on the client side to do i18n.
don't know if there are some who exist where we need to put a tag and the key...

something like


<li id="report" ><a ><span class="glyphicon glyphicon-stats"></span> <i18n tag="report" /></a></li>

other info
https://coderanch.com/t/666836/java/java/Fix-strategy-display#3110083

Jesper de Jong wrote:There are multiple issues going on here.

The first one is: how do you store an enum in the database? There are different ways to do this, each with pros and cons.

1. You can store the enum ordinal (the index of the enum constant in the definition of the enum). Pros: simple and you don't need to add extra code to the enum. Cons: if you re-order the enum constants, or add a new constant in between existing constants, the ordinals will change and things break.

2. You can store the name of the enum constant as a string in the database. Pros: simple, you don't need extra mapping code. Cons: strings take up more space than a simple int value (such as an ordinal) in the database.

3. Have some explicit mapping from enum constants to codes, store those codes in the DB, and then translate back and forth as you save / load values from the DB. Pros: You don't have the problem of changing ordinals as with solution 1. Cons: Needs more code, because you need to do this mapping.

The second issue is displaying on the client side. This is a completely separate issue from how you store enum values in the database. You'll need to have some mapping mechanism (for example a Properties file) to convert enum values to display texts. But as I already said, this is separate from how you store enum values in the database. There is no need to store the display texts in the database whenever you need to store an enum value (which you seem to imply when you say "store key/value pairs in the database?").

thanks for theses information

Actually to store information, i use @Enumerated(EnumType.STRING)
On the client side, i display directly the value of this... that bad

Need to find a library on the client side to be able to do i18n.

Don't know if one exist where i could put a kind of 18n tag in the html file

coderanch is maybe not the place to talk about js...

hi,

I have a spring boot, application with rest architecture and JQuery on the client side

Many time in a applicaiton, we have static value: like type of communication (mobile, fix, email...), this kind of value don't change.

public enum CommunicationType{ EMAIL, MOBILE, FIX; } public enum CommunicationType{ EMAIL(1), MOBILE(2), FIX(3); } public class CommunicationType{ public int communicationTypeId; public String name; }

Database

Using direct value

1 - Email
2 - Mobile
3 - Fix

or use properties key

1 - EMAIL
2 - MOBILE
3 - FIX

Properties file

EMAIL=Email
MOBILE=Mobile
FIX= Fix

if these values can be displayed in a html page, do you think is better to use an enum, store it in a database maybe there are other solutions.

what to do if we want to support multiple langage? we put key value in the db?

i would like to know what do you in this kind of case.

hi

i use spring boot and spring rest.

in my service layer, some error can happen, so i throw error

in my rest controller, i would like to know what to do to send it to the client.


thank

hi

I have a form with many input.

<form id="contactInformationForm" class="form-horizontal" role="form" data-fv-framework="bootstrap" data-fv-icon-valid="glyphicon glyphicon-ok" data-fv-icon-invalid="glyphicon glyphicon-remove" data-fv-icon-validating="glyphicon glyphicon-refresh"> <input type="hidden" class="form-control" name="lodgerId" id="lodgerId"> <input type="text" class="form-control" id="lodgerFirstName" name="firstName" placeholder="Entrer le prénom"> <input type="hidden" id="oldAddressAddressId" name="oldAddress.addressId"> <input type="text" class="form-control" id="oldAddressName" name="oldAddress.name" placeholder="Entrer le nom"> <input type="text" class="form-control" id="oldAddressAddress" name="oldAddress.address" placeholder="Entrer l'adresse"> ... </form>

A have some dto in java

public class LodgerInformationDto { private long lodgerId; private String firstName; private String lastName; @JsonFormat(shape = JsonFormat.Shape.STRING, pattern = "dd/MM/yyyy") private Date birthdate; private long statusId; @JsonFormat(shape = JsonFormat.Shape.STRING, pattern = "dd/MM/yyyy") private Date entryDate; @JsonFormat(shape = JsonFormat.Shape.STRING, pattern = "dd/MM/yyyy") private Date releaseDate; private PhoneDto contactPersonelMobile; private List<IdentityCardDto> identityCardList; private OldAddressDto oldAddress; private VehicleDto vehicle; } public class OldAddressDto { private long addressId; private String name; private String address; private PhoneDto phone; } public class PhoneDto { private long phoneId; private String phone; private int extension; }


When i click to save, i do

$.fn.serializeObject = function () { var o = {}; var a = this.serializeArray(); $.each(a, function () { if (o[this.name] !== undefined) { if (!o[this.name].push) { o[this.name] = [o[this.name]]; } o[this.name].push(this.value || ''); } else { o[this.name] = this.value || ''; } }); return o; }; var frm = $('#contactInformationForm').serializeObject(); var data = JSON.stringify(frm);

and a ajax call

On the server side i have

@RequestMapping(value = "/lodgers", method = {RequestMethod.POST, RequestMethod.PUT}) public LodgerInformationDto saveLodger(@RequestBody @Valid final LodgerInformationDto lodgerDto) { return lodgerService.save(lodgerDto); }


It's the value sent to the server

{
"lodgerId": "",
"firstName": "paul",
"lastName": "houlde",
"contactPersonelMobile.phone": "4506778989",
"birthdate": "16/07/2015",
"entryDate": "16/07/2015",
"releaseDate": "31/07/2015",
"oldAddress.addressId": "",
"oldAddress.name": "bixi",
"oldAddress.address": "23 marie victorin",
"oldAddress.phone.phoneId": "",
"oldAddress.phone.phone": "1234567896",
"brandId": "26",
"brand": "Honda",
"modelId": "519",
"color": "#5484ed",
"year": "2000",
"licencePlate": "1h2r43",
"identityCardList[0].identityCardId": "",
"identityCardList[0].identityCardType": "1",
"identityCardList[0].value": "cadfadfa",
"identityCardList[1].identityCardId": "",
"identityCardList[1].identityCardType": "",
"identityCardList[1].value": "",
"identityCardList[0].expiration": "",
"identityCardList[2].identityCardId": "",
"identityCardList[2].value": "",
"identityCardList[2].expiration": ""
}

on the server side, value for identityCardList, oldAddress, brand, brandId... are null only firstName, lastName, birthdate, entryDate, releaseDate are not null

It's like the way the value are sent, it's not correct.

thanks

In a wsdl file, i try to use some element

My PolicyRequest.xsd file

<?xml version="1.0" encoding="UTF-8"?> <xsd:schema xmlns:p="http://www.example.org/Payment" xmlns:n="http://www.example.org/Note" xmlns:c="http://www.example.org/Consent" xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified"> <xsd:import namespace="http://www.example.org/Payment" schemaLocation="Payment.xsd" /> <xsd:import namespace="http://www.example.org/Note" schemaLocation="Note.xsd" /> <xsd:element name="PolicyRequest"> <xsd:complexType> <xsd:sequence> <xsd:element name="Payments" type="p:Payment" maxOccurs="unbounded" minOccurs="1" /> <xsd:element name="Notes" type="n:Note" maxOccurs="unbounded" minOccurs="1" /> </xsd:sequence> </xsd:complexType> </xsd:element>

My wsdl file

<?xml version="1.0" encoding="UTF-8" standalone="no"?> <wsdl:definitions xmlns:pr="http://www.example.org/PolicyRequest" xmlns:prst="http://www.example.org/PolicyResult" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tns="http://www.example.org/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="TNI" targetNamespace="http://www.example.org/"> <wsdl:types> <xsd:schema xmlns:pr="http://www.example.org/PolicyRequest" targetNamespace="http://www.example.org/"> <xsd:import namespace="http://www.example.org/PolicyRequest" schemaLocation="PolicyRequest.xsd" /> <xsd:import namespace="http://www.example.org/PolicyResult" schemaLocation="PolicyResult.xsd" /> <xsd:element name="PolicyRequest" type="pr:PolicyRequest"></xsd:element> <xsd:element name="PolicyResult" type="prst:PolicyResult"></xsd:element> </xsd:schema> </wsdl:types> <wsdl:message name="PolicyRequest"> <wsdl:part element="pr:PolicyRequest" name="parameters" /> </wsdl:message> <wsdl:message name="PolicyResult"> <wsdl:part element="prst:PolicyResult" name="parameters" /> </wsdl:message> <wsdl:message name="OfferRequest"> <wsdl:part element="or:OfferRequest" name="parameters" /> </wsdl:message> <wsdl:portType name="TNI"> <wsdl:operation name="Purchase"> <wsdl:input message="tns:NewMessage" /> <wsdl:output message="prst:PolicyResult" /> <wsdl:fault name="fault" message="tns:PurchaseFault"></wsdl:fault> </wsdl:operation> </wsdl:portType> <wsdl:binding name="TNISOAP" type="tns:TNI"> <soap:binding style="document" transport="http://schemas.xmlsoap.org/soap/http" /> <wsdl:operation name="Purchase"> <soap:operation soapAction="http://www.example.org/Purchase" /> <wsdl:input> <soap:body use="literal" /> </wsdl:input> <wsdl:output> <soap:body use="literal" /> </wsdl:output> </wsdl:operation> </wsdl:binding> <wsdl:service name="TNI"> <wsdl:port binding="tns:TNISOAP" name="TNISOAP"> <soap:address location="http://www.example.org/" /> </wsdl:port> </wsdl:service> ...

In the wsdl file i get

XSD: Type reference 'http://www.example.org/PolicyRequest#PolicyRequest' is unresolved

Why I'm not able to access element from my xsd?

Hi

i have an wsdl file. All my element, complexType is done there.

i have two datatype who have the same name but have different element.

is there a way to manage this in the same wsdl file?

it look like directly the same thing i done.

hi

in an xsd i need to create a array.

So i have to create an objet: PolicyRequest who contain an array of Payment

<xsd:element name="PolicyRequest"> <xsd:complexType> <xsd:sequence> <xsd:element name="Payments" type="tns:Payment" maxOccurs="unbounded" minOccurs="1" /> </xsd:sequence> </xsd:complexType> </xsd:element>

minOccurs and maxOccurs don't seem related to doing that. any suggestion?

thanks