2 Copyright 2010 Sun Microsystems, Inc.
3 All rights reserved. Use is subject to license terms.
5 This program is free software; you can redistribute it and/or modify
6 it under the terms of the GNU General Public License as published by
7 the Free Software Foundation; version 2 of the License.
9 This program is distributed in the hope that it will be useful,
10 but WITHOUT ANY WARRANTY; without even the implied warranty of
11 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 GNU General Public License for more details.
14 You should have received a copy of the GNU General Public License
15 along with this program; if not, write to the Free Software
16 Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
19 package com.mysql.clusterj.jpatest.model;
21 import java.util.Date;
23 import javax.persistence.Column;
24 import javax.persistence.Entity;
25 import javax.persistence.Id;
26 import javax.persistence.Table;
30 drop table if exists datetypes;
31 create table datetypes (
32 id int not null primary key,
39 date_not_null_hash date,
40 date_not_null_btree date,
41 date_not_null_both date,
42 date_not_null_none date
44 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
46 create unique index idx_date_null_hash using hash on datetypes(date_null_hash);
47 create index idx_date_null_btree on datetypes(date_null_btree);
48 create unique index idx_date_null_both on datetypes(date_null_both);
50 create unique index idx_date_not_null_hash using hash on datetypes(date_not_null_hash);
51 create index idx_date_not_null_btree on datetypes(date_not_null_btree);
52 create unique index idx_date_not_null_both on datetypes(date_not_null_both);
56 @Table(name="datetypes")
57 public class DateAsUtilDateTypes implements IdBase {
60 private Date date_not_null_hash;
61 private Date date_not_null_btree;
62 private Date date_not_null_both;
63 private Date date_not_null_none;
68 public void setId(int id) {
73 @Column(name="date_not_null_hash")
74 public Date getDate_not_null_hash() {
75 return date_not_null_hash;
77 public void setDate_not_null_hash(Date value) {
78 this.date_not_null_hash = value;
81 @Column(name="date_not_null_btree")
82 public Date getDate_not_null_btree() {
83 return date_not_null_btree;
85 public void setDate_not_null_btree(Date value) {
86 this.date_not_null_btree = value;
89 @Column(name="date_not_null_both")
90 public Date getDate_not_null_both() {
91 return date_not_null_both;
93 public void setDate_not_null_both(Date value) {
94 this.date_not_null_both = value;
97 @Column(name="date_not_null_none")
98 public Date getDate_not_null_none() {
99 return date_not_null_none;
101 public void setDate_not_null_none(Date value) {
102 this.date_not_null_none = value;