Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (nike.apache.org: domain of maxtorzito@gmail.com designates
 74.125.82.169 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <1358949167883-7582616.post@n2.nabble.com>
References: <1358949167883-7582616.post@n2.nabble.com>
Date: Wed, 23 Jan 2013 08:11:37 -0600
Message-ID: 
 <CAPyf0gdWdaLgBWT2NY-yaxEufRrTT0GR51hQG3boQigOrvCAhw@mail.gmail.com>
Subject: Re: Insert not using foreign key
From: =?ISO-8859-1?Q?Jos=E9_Luis_Cetina?= <maxtorzito@gmail.com>
To: users@openjpa.apache.org
Content-Type: multipart/alternative; boundary=089e0141a002bced7304d3f54538

--089e0141a002bced7304d3f54538
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Check your table where the field DATA_QUERY_REF is. This field have a
"wrong" date value. Some date before 1970 or just like 0000-00-00 could be
the problem. JPA sometimes do selects before inserts.
El 23/01/2013 07:53, "J=E9r=F4me" <the_supergg@hotmail.com> escribi=F3:

> Hi guys,
>
> I'm trying to create a little project around EJB / JPA linked to a Mysql
> database. I got two tables FctData and RefKpiDataQuery linked by a foreig=
n
> key.
>
> FctData :
>
> public class FctData implements Serializable {
>
>     @Id
>     @GeneratedValue(strategy =3D GenerationType.IDENTITY)
>     @Column(name =3D "DATA_ID")
>     private Long dataId;
>
>     ...
>
>     @JoinColumn(name =3D "DATA_QUERY_REF", referencedColumnName =3D
> "KPI_DATA_QUERY_ID")
>     @ManyToOne(cascade =3D CascadeType.ALL)
>     private RefKpiDataQuery dataQueryRef;
>
> ----------------
>
> RefKpiDataQuery :
>
> public class RefKpiDataQuery implements Serializable {
>
>     @Id
>     @GeneratedValue(strategy =3D GenerationType.IDENTITY)
>     @Basic(optional =3D false)
>     @Column(name =3D "KPI_DATA_QUERY_ID")
>     private Long kpiDataQueryId;
>
>     ...
>
>     @OneToMany(cascade =3D CascadeType.ALL, mappedBy =3D "dataQueryRef")
>     private Set<FctData> fctDataSet;
>
> I got a client which is just trying to insert a FctData in the database
>
> RefKpiDataQuery refKpiDataQuery =3D new RefKpiDataQuery();
> refKpiDataQuery.setKpiDataQueryId((long) 2);
>
> FctData fctData =3D new FctData();
> fctData.setDataQueryRef(refKpiDataQuery);
>
> fctDataFacade.insert(fctData);
>
>
> The Facade is a kind of DAO. This thing is working great with object whic=
h
> don't have a FK.
>
> Here is the error that i get in my log :
>
> Field 'DATA_QUERY_REF' doesn't have a default value {prepstmnt 7235700
> INSERT INTO FCT_DATA(DATA_DATE, DATA_TIME, DATA_VALIDITY, DATA_VALUE,
> ISACTIVE, UPDATE_OWNER, UPDATE_TS) VALUES (?, ?, ?, ?, ?, ?, ?)
>
>
> As we can see in my insert it never talks about the dataQuery. Someone ca=
n
> explain me what did i miss ? I can't find my mistake.
>
> Thanks for your time. Cheers
>
>
>
> --
> View this message in context:
> http://openjpa.208410.n2.nabble.com/Insert-not-using-foreign-key-tp758261=
6.html
> Sent from the OpenJPA Users mailing list archive at Nabble.com.
>

--089e0141a002bced7304d3f54538--