About FROM

51-60 of 200Refresh
Forum
12

Finance data from SQL Server into ObjectDB daily

feedback from the community to see if I'm thinking about it right.   We have a finance data mart that is appended to daily via an SSIS package. I would like to pull the data from SQL, add ... ? Is there a way to map the structure of the table directly into ObjectDB from SQL Server?   Thanks
Forum
12

How to define database structure and insert some initial objects from scratch

Hi from Spain! We're evaluating ObjectDB and we have some questions: - How can we create ... need initial structure like tables, but how can we populate some "tables" with initial data from ... jdbc driver for ETL software like Kettle? How about migrating data from another database
Forum
12

Is there a function of "drop table" or "delete from table"?

Besides the em.remove() one by one, is there a function of "drop table" or "delete from table"? TIA You can execute a DELETE query:     em.createQuery("DELETE FROM MyEntity e").executeUpdate ... . The code “createQuery("DELETE FROM MyEntity e").executeUpdate();” works, but it can not reset id to zero
Forum
12

migration path from JPA / Hibernate

when using Entities previously geared towards JPA / Hibernate migrating data from existing ... program that retrieves entity objects from Hibernate, detaches them and then persists them using ObjectDB ... for the detailed answers! > retrieves entity objects from Hibernate, detaches them and then persists them using
Issue
12

Navigation through lazy loading from Detached Objects

) is: Retrieval by navigation from detached objects is not supported, so only persistent fields ... : on accessing lazy loaded relationships outside a transaction, after a query, from Glassfish forum thread ... a similar extension in ObjectDB would ease emigration of web applications from EclipseLink to ObjectDB. Just
Forum
12

Query becomes slower on moving from ObjectDB 1.x to ObjectDB 2.x

from 1.x to 2.x. To activate the index the database has to be rebuilt by running the Doctor in repair ... . i will check it and let you know. I will use the following command after i convert from 1.x to 2.x ... more. So, please let me know what exactly i need to do to solve this ? You didn't mention step 4 from post #9
Result
12

ObjectDB Object Database Features

attributes, grouping queries and aggregate queries) which are usually missing from Object Oriented ... can manage databases of various sizes efficiently, ranging from kilobytes to terabytes. Platform ... operating system resources). Unlimited CPUs and cores. Reliability and Stability Recovery from failure by
Manual
12

Index Definition

, float, double. Equivalent wrapper classes from package java.lang: Byte, Short, Character, Integer ... execution. Indexes are especially efficient in lookup and range queries: SELECT p FROM Point p WHERE p.x = 100 SELECT p FROM Point p WHERE p.x BETWEEN 50 AND 80 SELECT p FROM Point p WHERE p.x >= 50
Manual
12

JPA Query Structure (JPQL / Criteria)

rather than just field values from database tables, as with SQL. That makes JPQL more object oriented friendly ...  of up to 6 clauses in the following format: SELECT ... FROM ... [WHERE ...] [GROUP BY ... [HAVING ...]] [ORDER BY ...] The first two clauses, SELECT and FROM are required in every retrieval query
Forum
12

Import data from MySQL

mysql data into objectdb? Currently to import data from other databases to ObjectDB you will have to write your own conversion program. If you use JPA with MySQL you can retrieve old data from MySQL ... Replication feature. You may subscribe to this feature request to increase its priority. See also the migration path from JPA / Hibernate forum thread. gzdillon