ObjectDB Database Search

: java.util.Date cannot be cast to java. sql .Timestamp at org.eclipse.birt.data.engine.odaconsumer ... .lang.ClassCastException: java.util.Date cannot be cast to java. sql .Timestamp at com.objectdb.oda ... cannot be cast to java. sql .Timestamp at com.objectdb.oda.ResultSet.getTimestamp(ResultSet.java:348

with Oracle or MS SQL you simply have a JDBC or ODBC driver and can query the database from virtually ... for ObjectDB, if it helps.  It will support running SELECT queries in JPQL syntax only (not SQL , except SQL queries that are also valid in JPQL), and then iterating over a result sets, as in ordinary

found sql solution but I would like to use criteria builder and I don´t if exist CAST and AS UNSIGNED   The sql that works is ORDER BY CAST(SUBSTR(username FROM 4) AS UNSIGNED) ASC Using JPQL ... CriteriaBuilder to do it as sql did please let me know. Thanks   mlevinspuhl Marcel Levinspuhl

datasource it requires a SQL driver (confusing a bit!). Anyhow solved this without referring to the API ... .xml file. If the IDE requires specifying SQL driver, etc - specify default settings

should work. support Support Thanks for answer. I changed type of start field to: java. sql .Date, java. sql

I apologize if this post is 'out of order'. If so, the moderators should feel free to delete it. I am sure that my recent questions have shown my incompetence with ObjectDB (although I have used many other SQL and non- SQL databases). Therefore, my questions must seem trivial. So often one sees

to popular RDBMS (such as Oracle, SQL Server, My SQL , etc) object databases in general are much less popular

" is called. Is java. sql .Timestamp not supported? Any ideas are welcome :) kind Regard, Thomas /** * Date ... for something that was told to be working ... package comfortable.data.sandbox; import java. sql .Timestamp

still exists. As far as I know indices are only good for fields that appear in the WHERE part of the SQL ... the WHERE part of the SQL /JPQL. In our case the fields are in the ORDER part. So, I do not think an index

Using JDBC, I can use a String to create the schema of a table: String sql = "CREATE TABLE REGISTRATION " + "(id INTEGER not NULL, " + " first VARCHAR(255), " + " last VARCHAR(255), " + " age INTEGER, " + " PRIMARY KEY ( id ))"; stmt = conn.createStatement(); stmt.executeUpdate( sql ); I want

Hello your documentation and tutorials would make a lot more sense if SQL TABLES, QUERIES and INDEXES were included. Frankly it is a huge wast those examples have not been provided. For example ... Employee where ZipCode=:zipCode" Just my two cents here but a full fledged example complete with SQL

services. It is successfully connected. Connection is OK. Restart Database server ( SQL Server ... ? Thanks In Advance, GAJESH gajesh Gajesh Tripathi  Restart Database server ( SQL Server

and java. sql export package javax.transaction.xa to module commons.collections Process finished ... layer java.lang.module.ResolutionException: Modules java. sql and objectdb export package javax

I am copying data from a postgres database to objectDB. Some of the rows in the postgres table were created by postgres DDL / SQL insert statements and so do not abide by all JPA rules and recommendations, in particular there are some primary keys with value == 0. These cause problems for objectDB

Hi In objectdb site i found : Note: This ORM/ SQL annotation is silently ignored by ObjectDB so i want  join tow table and generate a third table. Ex:  table 1: employee    table 2: address  and the generate table will be table 3: emp_add employee: e_id, e_name address: add

Question on dates. SQL doesn't seem to store timezone with dates (oddly). So, any best practises with ODB? 1. use java.util.Date 2. Milliseconds since January 1, 1970, 00:00:00 GMT 3. other? dmoshal David Moshal When a Date instance is stored in an ObjectDB database it is converted automatically

one of the supported types for primary keys . JPA supports only java. sql .Date (or java.util.Date

.io.Serializable; import java. sql .Date; import java.util.ArrayList; import javax.persistence.Entity

; Caused by: java. sql .SQLException: The DELETE statement conflicted with the REFERENCE constraint

mleUtility11; requires java. sql ; requires objectdb; exports common; exports exceptions; exports gui

Hi , when i try to use this entity as shown below: package persistence.jpa.models; import javax.jdo.annotations.Indices; import javax.persistence.*; import java.io.Serializable; import java. sql .Date; import java.util.Objects; @Entity @Table(name = "usrlist", schema = "posts") @NamedQueries

than the write method, in my very simple benchmark. I guess the reason there is no SQL in the write method

hi, I want to create only a table without insertions of data. And also table contains constraints like not_null, unique, primary key etc. Ex: (In sql ) create table emp (id int(5) primary key, name varchar2(20)); , so it will create only table. when we want to see the table structure

file (basically a sql dump) and reload.  Is there a capability in ObjectDb to provide a vacuum

, the following test: import java.util.*; import java. sql .*; import javax.persistence.*; public final class T383

a script ? In SQL world we have scripts like "insert into..." - Can we use main objectdb.jar library

. Could you explain how can I fix this problem? Harman Alexander Golyshkin ORM/ SQL annotations are silently ignored

Can someone please explain ObjectDB falls into which category of CAP theorem ? C : Consistency, A: Availability , P : Partition Tolerance  Example:  CA == SQL Server, Oracle, Sybase, MySQL CP == MongoDB, HBase, Redis, MemCache  AP == Cassandra, CouchDB, DynamoDB is ObjectDB

the new book added by B?. And does this change if FetchType.LAZY changes to FetchType.EAGER? In a SQL

; * (in the Java Persistence query language or in native SQL ).      * @param name

: * How can i see the low level batch SQL operations before flushing the merge. So i

more the SQL way than the JPA way. Clear the internal EntityManager cache by using clear after an UPDATE

-memory mode, as supported by SQL databases like H2 or SQLite. Thanks, David dbb David Blumenthal-Barby

Hi I no longer want to use an Entity .. (in SQL terms the whole Table ) ... How do I delete it ?   Thanks Paul Newman pnewman Paul Newman Currently classes cannot be removed but this only affects the list of classes in the Explorer. Removing of classes will be supported in the future. support Support

of connecting objects using ids (which is more appropriate in RDBMS and SQL ), use should consider using

. sql Could you please advice me how to make my app locate this class ? Regards, Gergely jakab Gergely

sake (to avoid SQL injection when the parameter value is obtained from an untrusted user). By the way

for the mapFromCli field in an SQL DB and had no problem with it. Emil prolancer Emil Andonov Thank

I am trying to build a SELECT query as follows. SELECT p FROM Persons p WHERE creationDate="07-25-2013" Here I have created Persons object as java. sql .Date attribute.   But in doing so I am getting following exception Operand type mismatch for operator '=' (error 757) (position 51) at com

1. Is it possible to run async objectDb queries for long time operations and stop them if it necessary? 2. Is it possible to stop sync ObjectDb query from another thread for long time operation for example getResultList()? Link to Java API: https://docs.oracle.com/javase/7/docs/api/java/ sql

.persistence.*; public final class T1473 {     static java. sql .Date myDate;  

Hi All, For some reason I'm not able to make the @OrderColumn annotation work. The test case is attached to the thread. Kind regards Martin1978 Martin Mihalev As stated on this documentation page,  this ORM/ SQL annotation is silently ignored by ObjectDB. This is because ObjectDB does not map

I am having trouble getting a simple string comparison to work in an SQL "where" clause.  It is my understanding that queries are case sensitive by default and I do not want that, so I am constructing the query as follows... SELECT e FROM Exercise AS e WHERE UPPER(e.name) = ?0 and then I

driver, for SELECT queries with JPQL syntax (not SQL , except SQL queries that are also valid

property method names . Fixed a bug in retrieving pure time values (java. sql .Time). Fixed a bug in MEMBER ... change . Fixed a bug in indexing java. sql .Date fields during time / time zone change . Fixed a bug in detachment of embedded objects ( if enabled ).

error (not only in ObjectDB and also in SQL ), since there are strict rules regarding what is allowed ... that are part of the results. Not just in ObjectDB but in SQL in general. ObjectDB is a little

I think it would be revolutionary if it were possible to persist any Java object, not just the standard SQL -based objects. Perhaps introducing an annotation will allow for this, something like @BasicType. The ability to store the state of an entire application would be a new innovative approach

. sql .Timestamp dateTime;     } }   support Support Unfortunately, I have not

, a java. sql .Data and a java.util.Data as the "date" parameter but for all three tries I

a built-in function.  But, it would also require the expansion of the SQL syntax to support