I noticed that if a JDOQL query filter has something like: firstNameLow.startsWith("fred") it gets translated to a LOCATE in the where clause where LOCATE('fred',a0.first_name_low) = 1; In MySQL (test

When I try to read data from a very simple database table on the MS Sql Server 2012 by a DataNucleus JDO query, I get the following error message: Exception in thread "main" javax.jdo.JDODataStoreExce

Hi, I would like to know, Is there a way to prevent SQl injection by setting some properties in datanucleus / JDO side. We are heavily using JDO in our product , Our Security team saying that Product

Hello, I found out that I can map native query results to POJOs without any additional configuration: ```java public class Person { private int id; private String name; // getters/setters } List<Perso

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

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

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 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

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

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

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

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

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

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, 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

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

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

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

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

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