awax187
asked on
Using Date type in an EJB Query Language
I am developing an application in NetBeans thats uses the built in database server (apache derby), i've used the IDE to generate entity classes refelecting tables in my database. The IDE has also created a persistance unit and an entity manager, i am trying to run an EJB Query on a table in the database but i am having some syntactical difficulties which i am having trouble resolving.
This is the EJB QL:
SELECT m FROM Measurement m WHERE m.measurementDateofbooking = '07.10.2008'
This is the Measurement Table Structure in the database:
MEASUREMENT Data Type
========================== ========== =
measurement_id Auto Gen Int PK
measurement_customer_id Int FK
measurement_dateofbooking Date
measurement_timeofbooking Time
measurement_completed Char
This is a relevant snippet of the measurement Entity Class: (See Code Snippet)
This is the exception i recieve:
Exception Description: The object [07.10.2008], of class [class java.lang.String], from mapping [oracle.toplink.essentials .mappings. DirectToFi eldMapping [measureme ntDateofbo oking-->ME ASUREMENT. "measureme nt_dateofb ooking"]] with descriptor [RelationalDescriptor(mk_c arpets_alp ha_entity_ classes.Me asurement --> [DatabaseTable(MEASUREMENT )])], could not be converted to [class java.sql.Date].
Exception in thread "AWT-EventQueue-0" Local Exception Stack:
Exception [TOPLINK-3002] (Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))): oracle.toplink.essentials. exceptions .Conversio nException
Exception Description: The object [07.10.2008], of class [class java.lang.String], from mapping [oracle.toplink.essentials .mappings. DirectToFi eldMapping [measureme ntDateofbo oking-->ME ASUREMENT. "measureme nt_dateofb ooking"]] with descriptor [RelationalDescriptor(mk_c arpets_alp ha_entity_ classes.Me asurement --> [DatabaseTable(MEASUREMENT )])], could not be converted to [class java.sql.Date].
at oracle.toplink.essentials. exceptions .Conversio nException .incorrect DateFormat (Conversio nException .java:119)
at oracle.toplink.essentials. internal.h elper.Help er.dateFro mString(He lper.java: 747)
After looking at the exception i thought it might be the format of the date, but i tried the same date in the database sql command ('07.10.2008') and it retrieved the results fine. I even tried changing my EJB Q to this: SELECT m FROM Measurement m WHERE m.measurementDateofbooking = new Date(2008,10,7)
and it still didnt work.
This is the EJB QL:
SELECT m FROM Measurement m WHERE m.measurementDateofbooking
This is the Measurement Table Structure in the database:
MEASUREMENT Data Type
==========================
measurement_id Auto Gen Int PK
measurement_customer_id Int FK
measurement_dateofbooking Date
measurement_timeofbooking Time
measurement_completed Char
This is a relevant snippet of the measurement Entity Class: (See Code Snippet)
This is the exception i recieve:
Exception Description: The object [07.10.2008], of class [class java.lang.String], from mapping [oracle.toplink.essentials
Exception in thread "AWT-EventQueue-0" Local Exception Stack:
Exception [TOPLINK-3002] (Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))): oracle.toplink.essentials.
Exception Description: The object [07.10.2008], of class [class java.lang.String], from mapping [oracle.toplink.essentials
at oracle.toplink.essentials.
at oracle.toplink.essentials.
After looking at the exception i thought it might be the format of the date, but i tried the same date in the database sql command ('07.10.2008') and it retrieved the results fine. I even tried changing my EJB Q to this: SELECT m FROM Measurement m WHERE m.measurementDateofbooking
and it still didnt work.
package mk_carpets_alpha_entity_classes;
import java.beans.PropertyChangeListener;
import java.beans.PropertyChangeSupport;
import java.io.Serializable;
import java.util.Date;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import javax.persistence.Transient;
/**
*
* @author ______
*/
@Entity
@Table(name = "MEASUREMENT")
@NamedQueries({@NamedQuery(name = "Measurement.findByMeasurementId", query = "SELECT m FROM Measurement m WHERE m.measurementId = :measurementId"), @NamedQuery(name = "Measurement.findByMeasurementDateofbooking", query = "SELECT m FROM Measurement m WHERE m.measurementDateofbooking = :measurementDateofbooking"), @NamedQuery(name = "Measurement.findByMeasurementTimeofbooking", query = "SELECT m FROM Measurement m WHERE m.measurementTimeofbooking = :measurementTimeofbooking"), @NamedQuery(name = "Measurement.findByMeasurementCompleted", query = "SELECT m FROM Measurement m WHERE m.measurementCompleted = :measurementCompleted")})
public class Measurement implements Serializable {
@Transient
private PropertyChangeSupport changeSupport = new PropertyChangeSupport(this);
private static final long serialVersionUID = 1L;
@Id
@Column(name = "\"measurement_id\"", nullable = false)
private Integer measurementId;
@Column(name = "\"measurement_dateofbooking\"", nullable = false)
@Temporal(TemporalType.DATE)
private Date measurementDateofbooking;
@Column(name = "\"measurement_timeofbooking\"", nullable = false)
@Temporal(TemporalType.TIME)
private Date measurementTimeofbooking;
@Column(name = "\"measurement_completed\"")
private Character measurementCompleted;
@JoinColumn(name = "\"measurement_customer_id\"", referencedColumnName = "\"customer_id\"")
@ManyToOne
private Customer measurementCustomerId;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.