Internal Website Search

1-50 of 200 results

Database size is much larger than expected (x2)

insertions? Question 2 : Why the size of db increased to 16,671,309,824, while the original images ... every 256 images. The database size should be larger than the size of the image files on the file ... The database size should be larger than the size of the image files on the file system, but more than 100

Page size - changing after database creation

Hi, I was wondering, is it safe to change page size after database is created and filled with data? Should I set page size to the same value as block size on my filesystem? lwalkowski Lukasz Walkowski The page size configuration setting should only affect new created databases

CriteriaBuilder.size(collection) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression size (   C collection ) Create an expression that tests the size of a collection. Parameters: collection - collection Return: size expression Since: JPA 2.0

CriteriaBuilder.size(collection) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression size (    Expression  collection ) Create an expression that tests the size of a collection. Parameters: collection - expression Return: size expression Since: JPA 2.0

Database(*.odb) file size on disk

Hello, we have questions about the file size of ObjectDB database on disk. Can you tell us something about how the deleting of entities affects the size of *.odb files on disk? -Will the released ... than the initial size . import java.util.ArrayList; import java.util.List; import javax.persistence.Basic

ObjectDB size not reducing

that DB and the size does not decrease.  In fact it keeps growing as records decrease.  ... are persisted. However, the size of the database file is not reduced. So this is a normal behaviour. Currently, the way to reduce the size of a database is to use the Doctor utility, creating a new (smaller

Size of recording directory keeps growing

the size or history of recording? Is there any setting in configuration file? Thank you   Below are sizes of our database files: Main database: nef@l1:~/objectdb$ ls -lah db/cloudai/genose.odb -rw-r

odb file size doesn't shrink

Hello, why delete from ... doesnt modify size of odb? Even in in embedded mode, and in server mode i use recovery, not recording mode. mastervoland Vladimir Sadovnikov When objects are deleted from the database their space is marked as unused and becomes available for future objects. The size

Speeding up reporting queries with size() on list

Hi, I'm working on some reporting stuff in our application. One of few different reports should include activity on last modified objects. The query for now looks like this: select date(insp.lastModificationDate), insp.modifiedBy, insp.description.length(), insp.products. size (), insp.picture from

Max transaction size

What’s the max transaction size , or how is it determined? Trianglehead Json Error The main limit is the available memory in the JVM. There is no hard limit. support Support

Database Management Settings

:    The element The element specifies the database file and page size settings: The initial attribute specifies the initial size of every new database file. The resize attribute specifies the size by which to extend the database file when additional space is needed. Small initial size

Collections in JPQL and Criteria Queries

if the collection is empty and TRUE otherwise. SIZE The SIZE (collection) function returns the number of elements in a specified collection. For example: SIZE (c.languages)  is evaluated ... ;  Predicate i2 = param. in ("English", "French"); // SIZE (collection) Expression size = cb. size (languages);  

General Settings and Logging

a limit size that is specified by the threshold attribute. The mb and kb suffixes represent megabytes ... . The size attribute specifies the maximum size of this list. This feature can be disabled by specifying 0 as the maximum list size . The user attribute specifies if user names should be saved

Shared (L2) Entity Cache

class - using annotations. ObjectDB Configuration The shared cache size is specified in the ObjectDB configuration :       The level2 attribute determines the size of the EntityManagerFactory 's shared cache. The default size , 0 , indicates that the cache is disabled. To enable

WHERE clause (JPQL / Criteria API)

The following query retrieves only countries with a population size above a population size p ... them to the SELECT clause. For example, the following query retrieves all the countries with population size

UPDATE SET Queries in JPA/JPQL

three equivalent queries increase the population size of all the countries by 10%: UPDATE Country SET ... query updates the population size of countries whose population size is smaller than a specified

GROUP BY and HAVING clauses

, and for each group returns the currency and the cumulative population size in countries that use ... that pass the FROM/WHERE phase are considered as one group, for which the cumulative population size and the average population size is then calculated. Any JPQL query that contains an aggregate

Is ObjectDB scalable? What are its limitations?

ObjectDB is highly scalable and can manage efficiently databases in a wide range of sizes , from a few Kilobytes to hundreds of Gigabytes and even Terabytes. ObjectDB can be used in small embedded ... supports: Database file size up to 128 TB (= 131,072 GB = 134,217,728 MB). Up to 2,147,483,648 entity

ObjectDB Object Database Features

can manage databases of various sizes efficiently, ranging from kilobytes to terabytes . Platform ... mode. Capabilities and Limitations Database file size up to 128 TB (= 131,072 GB = 134,217,728 MB

Database Explorer

with the query results, and the size of the result collection and the query execution time are displayed ... side to choose font face, font size , font style, background color and foreground color. Click

SELECT clause (JPQL / Criteria API)

duplicate results. Filtering duplicate results might have some effect on performance, depending on the size

Setting and Tuning of JPA Queries

. The setMaxResults method is used to specify the result window size . Any result after hitting that specified

FROM clause (JPQL / Criteria API)

, MEMBER, MIN, MOD, NEW, NOT, NULL, NULLIF, OBJECT, OF, OR, ORDER, OUTER, POSITION, SELECT, SET, SIZE

JPA Query Expressions (JPQL / Criteria)

expressions  ( isEmpty , isNotEmpty , isMember , isNotMember , size ). Comparison expressions

Auto Generated Values

a sequence and accepts a name, an initial value (the default is 1) and an allocation size (the default

Numbers in JPQL and Criteria Queries

functions - when the return value is numeric, e.g. INDEX, SIZE . as string functions - when the return

DELETE Queries in JPA/JPQL

size that is smaller than a specified limit: DELETE FROM Country c WHERE c.population

Chapter 6 - Configuration

and kilobytes (respectively), can be used in any size value attribute in the configuration file. Appropriate

Entity Management Settings

), regardless of this setting. The level2 attribute specifies the size of the shared level 2 cache

Paths and Types in JPQL and Criteria API

are considered as one group, and COUNT calculates its size ). Criteria Query Paths and Types Paths

JPA Criteria API Queries

, isMember , isNotMember , size ). Comparison expressions ( equal , notEqual , gt , ge , lt , le , between

ORDER BY clause (JPQL / Criteria API)

The ORDER BY clause specifies a required order for the query results. Any JPQL query that does not include an ORDER BY clause produces results in an undefined and non-deterministic order. ORDER BY Expressions The following query returns names of countries whose population size

ObjectDB Overview

environments. Can easily be embedded in applications of any type and size . Tested with Tomcat, Jetty

Database Server

heap size and improve performance by using HotSpot JVM server mode: java -server -Xmx512m com

Transaction size limit

Although I read in this post https://www.objectdb.com/forum/2606 that the size of the transaction ... TransactionTooBigException. But what would help us most, would be a way to check the current size of the transaction ... : java.lang.OutOfMemoryError: Requested array size exceeds VM limit at com.objectdb.o.FIW.m(FIW.java

Bug when using SIZE in combination with date lower parameter

Hello, I have 2 entity types, which I want to query, ParserJob and Tag. Unfortunately there seems to be a bug if I use the lower date select: SELECT j.jobId, SIZE (j.tags) FROM ParserJob j WHERE j ... should return the same results but they do not. The first query returns 1 result and a tags size of 1

javax.jdo.FetchPlan.FETCH_SIZE_OPTIMAL

JDO Static Field in javax.jdo.FetchPlan FETCH_ SIZE _OPTIMAL For use with setFetchSize . Value: 0. Since: JDO 2.0

javax.jdo.FetchPlan.FETCH_SIZE_GREEDY

JDO Static Field in javax.jdo.FetchPlan FETCH_ SIZE _GREEDY For use with setFetchSize . Value: -1. Since: JDO 2.0

javax.persistence.criteria.CriteriaBuilder

expression Since: JPA 2.0 Expression size (C collection) Create an expression that tests the size of a collection. Parameters: collection - collection Return: size expression Since: JPA 2.0 Expression size ( Expression  collection) Create an expression that tests the size of a collection

[ODB1] Chapter 7 - JDOQL Queries

objects can be obtained using the size () method: int count = result. size (); Iteration over the result ... .newQuery(Person.class, "this.age = 18"); query.setOrdering("age descending, children. size ... ordering is children. size () (which is supported by ObjectDB as an extension to JDO). Results

javax.persistence.AttributeOverride

({ @AttributeOverride(name="key.street", column=@Column(name="STREET_NAME")), @AttributeOverride(name="value. size ... parcelNumber; Integer size ; BigDecimal tax; } See Also: Embedded Embeddable MappedSuperclass

[ODB1] Chapter 9 - ObjectDB Explorer

with the query results and the size of the result collection and the query execution time ... side to choose font face, font size , font style, background color and foreground color. Click the "Reset

[ODB1] Chapter 2 - A Quick Tour

} 27 28 // Add a new string to the persistent list: 29 list.add("Hello World " + list. size ()); 30 31

[ODB1] Chapter 4 - JDO Metadata

.String field, empty collection, 0 size array, and so on). primary-key The primary-key attribute, defined

[ODB1] Chapter 1 - About ObjectDB

ObjectDB for Java/JDO is a powerful Object Database Management System (ODBMS) written entirely in Java. It can efficiently handle a wide range of database sizes , from a few KBs to hundreds of GBs. It has a small footprint, high performance, and a flexible architecture (1-Tier, 2-Tier or N-Tier). 1

javax.jdo.FetchPlan

int getFetchSize () Return the fetch size , or FETCH_ SIZE _OPTIMAL if not set, or FETCH_ SIZE _GREEDY to fetch all. Return: the fetch size Since: JDO 2.0 Set getGroups () Return an immutable Set ... roots. Since: JDO 2.0 FetchPlan setFetchSize (int fetchSize) Set the fetch size for large result

FetchPlan.setFetchSize(fetchSize) - JDO Method

JDO Method in javax.jdo.FetchPlan FetchPlan setFetchSize (   int fetchSize ) Set the fetch size for large result set support. Use FETCH_ SIZE _OPTIMAL to unset, and FETCH_ SIZE _GREEDY to force loading of everything. Parameters: fetchSize - the fetch size Return: the FetchPlan Since: JDO 2.0

FetchPlan.getFetchSize() - JDO Method

JDO Method in javax.jdo.FetchPlan int getFetchSize () Return the fetch size , or FETCH_ SIZE _OPTIMAL if not set, or FETCH_ SIZE _GREEDY to fetch all. Return: the fetch size Since: JDO 2.0

Query.setUnique(unique) - JDO Method

JDO Method in javax.jdo.Query void setUnique (   boolean unique ) Specify that only the first result of the query should be returned, rather than a collection. The execute method will return null if the query result size is 0. Parameters: unique - if true, only one element is returned Since: JDO 2.0

javax.jdo.Query

should be returned, rather than a collection. The execute method will return null if the query result size