You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@openjpa.apache.org by bigT <to...@hotmail.com> on 2013/01/21 13:45:30 UTC

JPA XmlValueHandler doesn't work with Multi Valued fileds

Hi,

I'm using XML type columns in some of our DB Tables, therefore I decided to
use:
@Strategy ("org.apache.openjpa.jdbc.meta.strats.XMLValueHandler")
annotation.
 
According to the documentation this allow me to map the XML columns from and
to Java Classes by using simple JAXB annotations and letting the JPA to
perform the Marshalling/UnMarshalling himself.
I encounter a problem when we try to SELECT from a List inside our annotated
Class, there I got an exception.

 
Here Is a simple java DTO example (annotated with JAXB) of Employee with 3
fields (employeeId, employeeName and List<EmployeeDetails>):
 
@XmlAccessorType(XmlAccessType.FIELD)
@XmlType(name = "", propOrder = {
"employeeId",
"employeeName",
"employeeDetails",
})
@XmlRootElement(name = "EMPLOYEE ")
publicclassEmployeeDTOimplementsSerializable {
 
      privatestaticfinallongserialVersionUID = 892691919044796049L;
 
      @XmlElement(name = "EMPLOYEE_ID")
      private Long employeeCountry;
     
      @XmlElement(name = "EMPLOYEE_NAME ")
      private String employeeName;
 
      @XmlElement(name = "EMPLOYEE_DETAILS")
      private List <EmployeeDetailsDTO>employeeDetails;
 
      public Long getEmployeeId() {
            returnemployeeId;
      }
 
      publicvoidsetEmployeeId(Long employeeId) {
            this.employeeId = employeeId;
      }
 
      public String getEmployeeName() {
            returnemployeeName;
      }
 
      publicvoidsetEmployeeName(String employeeName) {
            this.employeeName = employeeName;
      }
 
      public List <EmployeeDetailsDTO>getEmployeeDetails() {
            returnemployeeDetails;
      }
 
      publicvoidsetEmployeeDetails(List <EmployeeDetailsDTO>employeeDetails)
{
            this.employeeDetails = employeeDetails;
      }
 
Here is the Employee Details DTO:
 
@XmlAccessorType(XmlAccessType.FIELD)
@XmlType(name = "", propOrder = {
"employeeCountry",
"employeeCity",
"employeePhone",
})
@XmlRootElement(name = "EMPLOYEE_DETAILS ")
publicclassEmployeeDetailsDTOimplementsSerializable {
 
      privatestaticfinallongserialVersionUID = 892691919044796049L;
 
      @XmlElement(name = "EMPLOYEE_COUNTRY")
      private String employeeCountry;
     
      @XmlElement(name = "EMPLOYEE_CITY ")
      private String employeeCity;
 
      @XmlElement(name = "EMPLOYEE_PHONE")
      private String employeePhone;
 
      public Long getEmployeeCountry() {
            returnemployeeCountry;
      }
 
      publicvoidsetEmployeeCountry(String employeeCountry) {
            this.employeeCountry = employeeCountry;
      }
 
      public String getEmployeeCity() {
            returnemployeeCity;
      }
 
      publicvoidsetEmployeeCity(String employeeCity) {
            this.employeeCity = employeeCity;
      }
 
      public String getEmployeePhone() {
            returnemployeePhone;
      }
 
      publicvoidsetEmployeePhone(String employeePhone) {
            this.employeePhone = employeePhone;
      }
 
Entity Example:
@Entity
@Table(name="EMPLOYEEXML")
public class EmployeeEntity implements Serializable {
      private staticfinallongserialVersionUID = 1L;
 
      @Id
      @SequenceGenerator(name="EMPLOYEEXML_EMPLOYEEID_GENERATOR",
sequenceName="EMPLOYEE_ID")
      @GeneratedValue(strategy=GenerationType.SEQUENCE,
generator="EMPLOYEEXML_EMPLOYEEID_GENERATOR")
      private Long id;
 
      @Persistent
      @Strategy ("org.apache.openjpa.jdbc.meta.strats.XMLValueHandler")
      private EmployeeDTO data;
 
publiccEmployeeEntity() {
    }
 
      public Long getId() {
            returnthis.id;
      }
 
      public void setId(Long id) {
            this.id = id;
      }
 
      public EmployeeDTO getData() {
            returnthis.data;
      }
 
      public void setData(EmployeeDTO data) {
            this.data = data;
      }
 
Here an example of 2 records inside an xml column in the DB:
 
<EMPLOYEE>
      <EMPLOYEE_ID>1</EMPLOYEE_ID>
      <EMPLOYEE_NAME>JACOB JACOBY</EMPLOYEE_NAME>
      <EMPLOYEE_DETAILS>
            <EMPLOYEE_COUNTRY>FLORIDA</EMPLOYEE_COUNTRY>
            <EMPLOYEE_CITY>MIAMI</snifName>
            <EMPLOYEE_PHONE>97221234567</EMPLOYEE_PHONE>
      </EMPLOYEE_DETAILS>
      <EMPLOYEE_DETAILS>
            <EMPLOYEE_COUNTRY>FLORIDA</EMPLOYEE_COUNTRY>
            <EMPLOYEE_CITY>ORLANDO</snifName>
            <EMPLOYEE_PHONE>97247654321</EMPLOYEE_PHONE>
      </EMPLOYEE_DETAILS>
      <EMPLOYEE_DETAILS>
            <EMPLOYEE_COUNTRY>FLORIDA</EMPLOYEE_COUNTRY>
            <EMPLOYEE_CITY>OTHER</snifName>
            <EMPLOYEE_PHONE>97231234567</EMPLOYEE_PHONE>
      </EMPLOYEE_DETAILS>
</EMPLOYEE>
 
 
<EMPLOYEE>
      <EMPLOYEE_ID>2</EMPLOYEE_ID>
      <EMPLOYEE_NAME>MOSES MOSESY</EMPLOYEE_NAME>
      <EMPLOYEE_DETAILS>
            <EMPLOYEE_COUNTRY>FLORIDA</EMPLOYEE_COUNTRY>
            <EMPLOYEE_CITY>MIAMI</snifName>
            <EMPLOYEE_PHONE>97221234567</EMPLOYEE_PHONE>
      </EMPLOYEE_DETAILS>
      <EMPLOYEE_DETAILS>
            <EMPLOYEE_COUNTRY>FLORIDA</EMPLOYEE_COUNTRY>
            <EMPLOYEE_CITY>OTHER</snifName>
            <EMPLOYEE_PHONE>97231234567</EMPLOYEE_PHONE>
      </EMPLOYEE_DETAILS>
</EMPLOYEE>
 
Here are examples of JPQL query we are trying to use:
SELECT e.data FROM EmployeeEntity e WHERE e.data.employeeName = "JACOB" –
[OK]
SELECT e.data FROM EmployeeEntity e WHERE
e.data.employeeDetails.employeeCity = "ORLANDO" – [ERROR]
 
*How can I perform a search\select inside the EmployeeDetilsDTOList (that is
inside the EmployeeDTO)?*
 
Thank you for your Help.



--
View this message in context: http://openjpa.208410.n2.nabble.com/JPA-XmlValueHandler-doesn-t-work-with-Multi-Valued-fileds-tp7582589.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: JPA XmlValueHandler doesn't work with Multi Valued fileds

Posted by Miłosz Tylenda <mt...@o2.pl>.

Hi BigT,

I don't think there are plans to implement this, at least I don't know of any. You can vote on it or describe your ideas in OPENJPA-1465 [1]. And, of course, you can provide a patch :)

Greetings,
Milosz

[1] https://issues.apache.org/jira/browse/OPENJPA-1465

> Thank you for the reply Milosz,
> 
> Can you tell me if it shcedule to be supported in the future (if so, is it
> in the next version maybe?),
> because if it is a matter of time maybe I can use a temporary workaround,
> but if not I will have to perform all the multi-valued selection using Xpath
> or Xquery.
> 
> Regards,
> 
> BigT.
> 
> 
> 
> --
> View this message in context: http://openjpa.208410.n2.nabble.com/JPA-XmlValueHandler-doesn-t-work-with-Multi-Valued-fileds-tp7582589p7582640.html
> Sent from the OpenJPA Users mailing list archive at Nabble.com.
>

Re: JPA XmlValueHandler doesn't work with Multi Valued fileds

Posted by bigT <to...@hotmail.com>.

Thank you for the reply Milosz,

Can you tell me if it shcedule to be supported in the future (if so, is it
in the next version maybe?),
because if it is a matter of time maybe I can use a temporary workaround,
but if not I will have to perform all the multi-valued selection using Xpath
or Xquery.

Regards,

BigT.



--
View this message in context: http://openjpa.208410.n2.nabble.com/JPA-XmlValueHandler-doesn-t-work-with-Multi-Valued-fileds-tp7582589p7582640.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: JPA XmlValueHandler doesn't work with Multi Valued fileds

Posted by Miłosz Tylenda <mt...@o2.pl>.

Hi,

*How can I perform a search\select inside the EmployeeDetilsDTOList (that
is
inside the EmployeeDTO)?*

You can't. Only single-valued path expressions are supported.

Greetings,
Milosz