When I try a standard code I get the following error message. javax.persistence.PersistenceException: Error encountered when extracting results for SQL query "get_person_list_sp" at org.datanucleus.ap

I have a JDO query that is caching its result set which makes sense as caching results sets is turned on by default. Part of the app adds a new object to the database (and I verify that the new record

I use PrePersist, PreUpdate, ... callbacks to perform validation on object graphs. When an error is identified, the callback raise an exception ( instance of a sub-sub-class of RuntimeException). I ex

I have a hierarchy of persistent 'Event' type classes, the base class of which stores a timestamp of millisecond precision and the app can produce an audit trail that orders objects according to this

Hello, After a while (of successes and failures) I reach a point where inserts break the unique index on the database table. I use MySQL, with a Long id for each class and hikari as connection pool. T

In JPA, the equivalent to JDOHelper.getObjectId, seems to be PersistenceUnitUtil.getIdentifier. Trying to use it (test purposes) with the L2Cache I face an issue. Using the model of the DN example, em

Regarding date format, there is a error in the documentation. Month are specified as 'mm' like minutes. It would be better to mention MM (looks like SimpledateFormat) JPQL supports literals of the fol

I have an inheritance model with OneToMany (Collections) declared in the super-class (persistent). When I perform a query on the subclasses I would like to load these elements. So far I can't find how

I faced the bellow "issue" while detaching a query result. An application fix is to desactivate the L2Cache. Cannot make object non-transactional since object is dirty org.datanucleus.exceptions.Nucle

Hi, The schema tool is creating unique indexes on every foreign-key. I'm trying to reproduce the case on a shareable application, but I can't reproduce. The index name pattern is <Target table>_U<numb

Hi, It seems DN parse the native queries before execution. I found 2 cases: -1- Query with * projection on flat inheritance model The model (ex: Client -|> Person) mapped on one single table PERSON (I

Hi, In the orm.xml files all names are lower case, but they are created in upper case in the database. How to make schema tool to keep unchanged the case of column names ? thanks -- Stephane

Hello, Is it possible to have one mapping (file I guess) per database type, which are chosen at runtime "automatically" ? ex: orm-mysql.xml orm-h2.xml ... My need is I'm running the same application o

When a candidate class for a query is a class that has no base class then, in an RDBMS datastore at least, there should be no need to specify discriminators because they don't need to be part of any f

I am trying to connect to informix with no success. Here is the staketrace: Failed initialising database. Please check that your database JDBC driver is accessible, and the database URL and username/p

The following error says I should report this to the DataNucleus developers so just doing my duty :) 22:54:15.392 [main] WARN DataNucleus.Datastore - Default type for java type of java.math.BigInteger

Hi Guys, I would like to ask some help regarding the issue below. DataNucleus.Persistence : Error : Could not find API definition for name "JDO". Perhaps you dont have the requisite datanucleus-api-XX

To all my fellow DNers out there you might find this useful: I was experimenting with detachAllOnCommit and noticed that while it can be convenient by: Avoiding explicit code to carefully perform deta

Hi, It looks like the CassandraSchemaHandler in the 5.1.0-release build does not have the appropriate cassandra CSQL for adding a column to the table. I am getting a sql error when the auto column cre

Hi Guys, I have posted this question here https://stackoverflow.com/questions/51088208/datanucleus-occasional-javax-jdo-jdodetachedfieldaccessexception-you-have-just. We get occasional exception while