Internal Website Search

51-100 of 200 results

The attribute column name (EXCEPTION) is a reserved SQL-99 keyword.

How do I fix this error/warning that Netbeans gives me? "The attribute column name (EXCEPTION ... but could be with other DBMS. To remove the warning, either rename your field (e.g. to exceptionText ), or add a Column annotation that will map the name of the Java field to another name in the database: @ Column (name

@Column length is not working.

I am using objectdb 2.8.3, I have a Entity class with a column that is declared as  @ Column ... for that column with a string that has more than 16 character, not able to get any error or exception from ... so its very difficult to validate the column string length. Please find the below project

Order in WHERE Clause affects behaviour on DATE/DATETIME columns

Quick example:  public class MyClass { @ Column (name = "myText") String myText; @Temporal(TemporalType.TIMESTAMP) @ Column (name = "myDate") Date myDate; } Now, when querying the db with: Query q ... a difference. The date column seems to be converted to a String so it can be compared with the query

@Column( name = "columnName") doesn't work

@GeneratedValue @ Column (name = "KEY_ID") private long id; private Long timestamp; @ManyToOne @ Column ... , cascade = CascadeType.ALL) @ Column ( name = "DATA_ITEMS" ) private List dataItems; @OneToOne(fetch ... by ObjectDB (as indicated for example on the Column annotation doc page ). When you use ObjectDB

Adding new unique columns

What is the best practice for when you need to add a new unique column to an existing database? Simply adding the column with the @Unique annotation will result in "Attempt to reuse an existing value (null)", so the only option I can surmise is to add the column , update all existing entries

drop a column from table

Hi, I want to drop one column from my database table suppose i have 3 column (id, name, address) now i want to drop address. then what will be the query or procedure..   Bimal Bimal kumar dalei ... a column  permanently then what will be the procedure. Bimal Bimal kumar dalei Because the data

Index on a low cardinality column

up queries." "An index on the gender column likely would  not  help because there's no value in an index on a low cardinality column . Meaning, there's not enough variety in the values for the index to provide any value." an index on a low cardinality column is generally not recommended as

Entity with java.util.Date column gives ClassCastException in BIRT

;  private boolean privacy;     @ Column (name="birthdate")     ... .engine.odaconsumer.OdaDataException: Cannot get the timestamp value column : 3.     org

javax.persistence.SqlResultSetMapping.columns

JPA Annotation Attribute in javax.persistence.SqlResultSetMapping ColumnResult [] columns default {} Specifies the result set mapping to scalar values. Since: JPA 1.0

Unable to create 128 column of a table.

Hi, Can we create 128 column of table? am getting following error. java.lang.ArrayIndexOutOfBoundsException: -128 at com.objectdb.o.ALS.g(ALS.java:135) at com.objectdb.o.ANT.G(ANT.java:594) at com.objectdb.o.ANT.x(ANT.java:526) at com.objectdb.o.SCM.o(SCM.java:175) at com.objectdb.o.TYS.d(TYS.java

How can allow multiple null value in a Unique column.

of a Column ? Eg: Name : null (allow) Name : xyx (allow) Name : null (allow) Name : abc (allow) Name

How to delete a specific column data form a entity.

query instead and set the field ( column ) to null . support Support Ok Tank you   Manoj Manoj Kumar Maharana

Make Column values Case insensitive

How do make table column values to case insensitive in object db 2.8.1 version? objdbuser This is currently not supported. A possible workaround is to keep a case-insensitive copy of the relevaant string in a separate field. e.g. in a lowercase format. support Support

Comparison in JPQL and Criteria API

each comparison operator. One column presents a comparison of NULL value with a non NULL value. The other column presents a comparison of two NULL values: Operators One NULL operand Two NULL operands

Database Explorer

a single object, every column represents a persistent field, and the content of a cell is the value ... ). There are three views. The [Table View] determines which fields in each persistent class are displayed as columns in

javax.persistence.JoinColumn

a column for joining an entity association or element collection. If the JoinColumn annotation itself is defaulted, a single join column is assumed and the default values apply. Example: @ManyToOne ... _ID") // join column is in table for Order public Set getOrders() {return orders

javax.persistence.MapKeyJoinColumn

a mapping to an entity that is a map key. The map key join column is in the collection table, join ... annotation is specified, a single join column is assumed and the default values apply. Example 1: @Entity ... ="INVENTORY", joinColumns=@JoinColumn(name="STORE")) @ Column (name="COPIES_IN_STOCK") @MapKeyJoinColumn(name

javax.persistence.CollectionTable

to the collection-valued field or property. By default, the columns of the collection table that correspond ... from the basic type according to the default values of the Column annotation. In the case of a basic type, the column name is derived from the name of the collection-valued field or property. In the case

javax.persistence.MapKeyColumn

the mapping for the key column of a map whose map key is a basic type. If the name element is not ... @MapKeyColumn(name="IMAGE_NAME") @ Column (name="IMAGE_FILENAME") @CollectionTable(name="IMAGE ... for the column . Defaults to the generated SQL to create a column of the inferred type. Since: JPA 2

javax.persistence.AttributeOverride

. If AttributeOverride is not specified, the column is mapped the same as in the original mapping. Example 1 ... @AttributeOverride(name="address", column =@ Column (name="ADDR")) public class PartTimeEmployee extends Employee ... ({ @AttributeOverride(name="state", column =@ Column (name="ADDR_STATE")), @AttributeOverride(name="zipcode

javax.persistence.PrimaryKeyJoinColumn

Specifies a primary key column that is used as a foreign key to join to another table. It is used ... is specified for a subclass in the JOINED mapping strategy, the foreign key columns are assumed to have the same names as the primary key columns of the primary table of the superclass. Example: Customer

javax.persistence.SecondaryTable

table. If no primary key join columns are specified, the join columns are assumed to reference the primary key columns of the primary table, and have the same names and types as the referenced primary key columns of the primary table. Example 1: Single secondary table with a single primary key

javax.persistence.OrderColumn

a column that is used to maintain the persistent order of a list. The persistence provider ... on the side of the relationship that references the collection that is to be ordered. The order column is not visible ... is not used when OrderColumn is specified. The order column must be of integral type

javax.persistence.ColumnResult

with the SqlResultSetMapping annotation or ConstructorResult annotation to map a column of the SELECT list of a SQL query. The name element references the name of a column in the SELECT list — i.e., column ... (name="id", column ="order_id"), @FieldResult(name="quantity", column ="order_quantity"), @FieldResult

javax.persistence.DiscriminatorColumn

the discriminator column for the SINGLE_TABLE and JOINED Inheritance mapping strategies. The strategy and the discriminator column are only specified in the root of an entity class hierarchy or ... is missing, and a discriminator column is required, the name of the discriminator column defaults to "DTYPE

javax.persistence.JoinColumn.referencedColumnName

"" (Optional) The name of the column referenced by this foreign key column . When used with entity relationship mappings other than the cases described here, the referenced column is in the table of the target entity. When used with a unidirectional OneToMany foreign key mapping, the referenced column

Step 6: Design a BIRT Report Table

) layout. Set the column number to 2 , number of details to 1 , select the data set (e.g. Points by X ) in the third field and click OK . Fill the table with data by dragging the x and y columns from

javax.persistence.FieldResult

with the EntityResult annotation to map columns specified in the SELECT list of a SQL query to the properties or ... ", entities={ @EntityResult(entityClass=com.acme.Order.class, fields={ @FieldResult(name="id", column ="order_id"), @FieldResult(name="quantity", column ="order_quantity"), @FieldResult(name="item", column

javax.persistence.Index

key index will be created automatically. The syntax of the columnList element is a column _list , as follows: column ::= index_ column [,index_ column ] index_ column ::= column _name [ASC | DESC] If ASC or ... null (Required) The names of the columns to be included in the index, in order. Since: JPA 2.1 String

javax.persistence.AttributeConverter

of the database column A class that implements this interface can be used to convert entity attribute state into database column representation and back again. Note that the X and Y types ... to be stored in the database column Since: JPA 1.0 X convertToEntityAttribute (Y dbData) Converts

javax.persistence.ConstructorResult

a constructor for the target class, passing in as arguments values from the specified columns . All columns corresponding to arguments of the intended constructor must be specified using the columns ... .CustomerDetails.class, columns ={ @ColumnResult(name="id"), @ColumnResult(name="name"), @ColumnResult

javax.persistence.JoinColumn.name

) The name of the foreign key column . The table in which it is found depends upon the context. If the join is for a OneToOne or ManyToOne mapping using a foreign key mapping strategy, the foreign key column ... , the foreign key is in a collection table. Default (only applies if a single join column is used

javax.persistence.EntityResult

. If this annotation is used, the SQL statement should select all of the columns that are mapped to the entity object. This should include foreign key columns to related entities. The results obtained ... "" Specifies the column name (or alias) of the column in the SELECT list that is used to determine

javax.persistence.MapKeyJoinColumn.referencedColumnName

"" (Optional) The name of the column referenced by this foreign key column . The referenced column is in the table of the target entity. Default (only applies if single join column is being used.) The same name as the primary key column of the referenced table Since: JPA 2.0

javax.persistence.MapKeyJoinColumn.name

) The name of the foreign key column for the map key. The table in which it is found depends upon the context. If the join is for a map key for an element collection, the foreign key column is in ... or for a OneToMany entity relationship using a join table, the foreign key column is in a join table

javax.persistence.CollectionTable.joinColumns

{} (Optional) The foreign key columns of the collection table which reference the primary table of the entity. The default only applies if a single join column is used. The default is the same as ... of the referenced primary key column .) However, if there is more than one join column , a JoinColumn annotation

javax.persistence.SqlResultSetMapping

=com.acme.Order.class, fields={ @FieldResult(name="id", column ="order_id"), @FieldResult(name="quantity", column ="order_quantity"), @FieldResult(name="item", column ="order_item")})}, columns ... the result set mapping to constructors. Since: JPA 2.1 ColumnResult [] columns default {} Specifies

javax.jdo.annotations.Column.extensions

JDO Annotation Attribute in javax.jdo.annotations. Column Extension [] extensions default {} Vendor extensions. Since: JDO 2.1

[ODB1] Chapter 9 - ObjectDB Explorer

of traditional visual database tools. Every row in the table represents a single object, every column ... ). There are three views. The "Table View" determines which fields in each persistent class are displayed as columns

[ODB1] Chapter 1 - About ObjectDB

with relational database concepts and the tables and columns defined for an application in order to perform

javax.jdo.annotations.Join

". Since: JDO 2.1 Public Annotation Attributes String column default "" Name of the column in the join table. Since: JDO 2.1 Column [] columns default {} Detail definition of the join column (s). This is needed for more than one join column . Since: JDO 2.1 ForeignKeyAction deleteAction default

javax.jdo.annotations.Value

.1 Public Annotation Attributes String column default "" Name of the column to store the value in. Since: JDO 2.1 Column [] columns default {} The column (s) for the value. Since: JDO 2.1 ... generateForeignKey default "" Generate or assume a foreign key constraint exists on the column or columns

javax.jdo.annotations.Key

Public Annotation Attributes String column default "" Name of the column to store the key in. Since: JDO 2.1 Column [] columns default {} The column (s) for the key Since: JDO 2.1 ForeignKeyAction ... "" Generate or assume a foreign key constraint exists on the column or columns associated

javax.jdo.annotations.Persistent

" Whether this field/property is cacheable in a Level2 cache. Since: JDO 2.2 String column default "" Column name where the values are stored for this member. Since: JDO 2.1 Column [] columns default {} Column definition(s) for this member. Used for mapping multiple columns to the same member

javax.jdo.annotations.Element

"element". Since: JDO 2.1 Public Annotation Attributes String column default "" Name of the column to store the element in. Since: JDO 2.1 Column [] columns default {} The column (s) for the element ... exists on the column or columns associated with this join. Specify "true" or "false". Since: JDO 2.1

javax.jdo.annotations.PrimaryKey

persistent interface using application identity. Also used to define the primary key columns ... Attributes String column default "" Name of the column to use for the primary key Since: JDO 2.1 Column [] columns default {} The column (s) for the primary key Since: JDO 2.1 String name default "" Name of the primary key constraint Since: JDO 2.1

javax.jdo.annotations.Version

" elements. Since: JDO 2.1 Public Annotation Attributes String column default "" Name of the column for the version. Since: JDO 2.1 Column [] columns default {} The column (s) making up the version ... [] extensions default {} Vendor extensions. Since: JDO 2.1 String indexed default "" Whether the version column

javax.jdo.annotations.Order

". Since: JDO 2.1 Public Annotation Attributes String column default "" The name of the column to use for ordering the elements of the member. Since: JDO 2.1 Column [] columns default {} The definition of the column (s) to use for ordering. Since: JDO 2.1 String mappedBy default "" Name of a field or

javax.jdo.annotations.Discriminator

" of the "inheritance" element. Since: JDO 2.1 Public Annotation Attributes String column default "" Name of the column for the discriminator Since: JDO 2.1 Column [] columns default {} The column (s) making

javax.jdo.annotations.DatastoreIdentity

" of the "class" element. Since: JDO 2.1 Public Annotation Attributes String column default "" Name of the column for the datastore identity Since: JDO 2.1 Column [] columns default {} The column (s