About array

forum_thread

Getting sales quantity per country with a query, an idea anyone?

Hi, For the purpose of some charts on a dashboard for our ERP i would like to get the list of countries and the sales quantity for each of them. I am pretty sure it is somehow possible to get that directly from a more or less complex query but i failed to find it; Does any have an idea? The entity (we call it OrderData) contains fields and other entities related to an order, fields we are interrested in are  buyerCountry and orderPrice. ... This call will retrieve a list of 3 dimensional Object array containing respectively countries, quantity of orders and sum of orders, ...

 
manual

GROUP BY and HAVING clauses

Explains how to use the GROUP BY and HAVING clauses in a JPA/JPQL query. The GROUP BY clause enables grouping of query results. A JPQL query with a GROUP BY clause returns properties of generated groups instead of individual objects and fields. The position of a GROUP BY clause in the query execution order is afte ...

 
forum_thread

Performance tuning, best practices

we have a system where we serve from a host process around 200 clients connected via webSockets (Jetty). The core process is running on a dedicated Windows 2012 server with 16 GByte RAM and 8 processor cores.  What is strange for us is that max 20% of the cpu resources are used and the IO subsystem is at maximum 30% of activity under heavy load but database queries are let's say not at the speed we would expect. We have currently 20.000.000 objects in the database, our configuration settings are: #1 2016-11-15 08:07 we have a system where we serve from a host process around 200 clients connected via webSockets (Jetty). The core ...

 
issue

Unable to stop server after starting in SSL mode

ObjectDB server starts & stops fine in non-SSL mode using start & stop shell scripts. ObjectDB server starts fine in SSL mode using start script but throws error and does not stop using stop shell script. Non-SSL mode server start/stop output: ObjectDB Server started on port 7032. ObjectDB Server stopped. SSL mode server start output: ObjectDB Server (SSL) started on port 7032. SSL mode server stop output: Bug Version: 2.6.5 Priority: Normal Status: Fixed Replies: 2 Type:  Bug ...

 
forum_thread

Find the error...JPA ENTITY HIBERNATE

Hey guys....i am searching for some days for the problem...Maybe one of you can find the error   DATABASE SHEMA: https://www.file-upload.net/download-12530779/2017-06-0214_25_00-MySQLWorkbench.png.html       Entities:   ... the error is that i get in return a endless array with message in users and users in message So my annotations are not ...

 
forum_thread

@AttributeOverrides , and postgresql + own TYPE

Hello,  first of all i want to thank for this is site. I'm begginer in Java and also in JPA and this site is very helpful for me. Now What is my problem. Unfortunately  i have to work with postgresql + JPA + eclipselink, because is my school project. Database is final and i can't do any changes even if i wanted to. In structure of DB  is this. -- -- Name: address; Type: TYPE; Schema: artio; Owner: facman --   ... will be getAddress method what data type it will be ? Array ?  4.I uploded for you my entity class of table Property ...

 
manual

[ODB1] Chapter 9 - ObjectDB Explorer

Explains how to view and manipulate database files in the database explorer. ... an initial value and arrays require specifying an array length. Click the "OK" button to construct the new persistent objects. ...

 
forum_thread

IN operator syntax

Hi, what is the correct syntax for IN operator when list of literals ia used instead of parameter, e.g. SELECT FROM Info i WHERE i.status IN (1,4) ? (Suppose status is int.) I always get this exception: SELECT FROM Info i WHERE i.status IN (1 ==> , <== 4) javax.persistence.PersistenceException Unexpected query token ',' (closing ')' is missing) (error 752)   Query with only one item in list works fine: #1 2013-03-20 15:30 Hi, what is the correct syntax for IN operator when list of literals ia used instead of parameter, e.g. ...

 
forum_thread

significant performance decrease

we are using objected in embedded mode (on OS X and WINDOWS). The database increased now to around 400000 entities of one class (database file size around 1.5 GByte). The response time of standard queries increased with this database size to an unacceptable rate (several seconds compared to around 30% when the number of entities was just half of the current). We tried to optimize the cache settings, current objectdb.conf is: <!-- ObjectDB Configuration --> <objectdb> #1 2016-03-15 14:57 we are using objected in embedded mode (on OS X and WINDOWS). The database increased now to around 400000 entitie ...

 
page

How to upgrade from ObjectDB 1.0?

Explains how to upgrade from ObjectDB 1.0 to ObjectDB 2.0. Upgrade - Step By Step To upgrade an existing application that uses ObjectDB 1.0 to ObjectDB 2.0: Replace the old ObjectDB and JDO jar files with the new objectdb.jar file. Make sure that the old jar files are removed from the classpath ...