About execute

forum_thread

dual access

Hello Exploring the product having had significant experience win Kodo/BEA/JDO1.x, yes I know dated but still works.  Is it possible to still have the SQL emitted from only the JAVA syntax?  If so is it also possible get each SQL statement before it is sent to the store?  Does objectdb only permit direct SQL coding? #1 2012-02-24 02:39 Hello Exploring the product having had significant experience win Kodo/BEA/JDO1.x, yes I know dated but s ...

 
forum_thread

Not able to update records

Hi,   I am tring to update the simple object by using Update query by i am getting following exception [ObjectDB 2.4.4_15] javax.persistence.TransactionRequiredException Attempt to run update query when no transaction is active (error 611) at com.objectdb.jpa.JpaQuery.executeUpdate(JpaQuery.java:758) Following is the code i am executing   #1 2013-02-26 06:13 Hi,   I am tring to update the simple object by using Update query by i am getting following ...

 
forum_thread

Query and commit simultaneously

#1 2010-07-14 09:02 Is it possible to query and commit on the same persistence manager (i.e. same odb file) at the same time? ...

 
forum_thread

Managing software release cycles.

How do you manage software release cycles with objectDB? For example we might have different installation of a given web application, and we might need to introduce new fields with default values or to change something in the database "structure".  How can we apply the update script without downloading the entire DB file? Are there any command line tools like sqlPlus to connect to a DB and execute queries / scripts? ... any command line tools like sqlPlus to connect to a DB and execute queries / scripts? edit ...

 
forum_thread

Possible issue for JPQL IN expression

Possible issue for JPQL IN expression with a set of more than one string literals values in the path expression. #1 2012-04-17 16:40 Possible issue for JPQL IN expression with a set of more than one string literals values in the path expression. ...

 
issue

Unexpected Query Token / Casting in Query

Hi! Please find the attached database. Doing a simple query with casting SELECT COUNT(DISTINCT $1) FROM com.quasado.foundation.contact.individual.IndividualContact $1 WHERE UPPER(((com.quasado.foundation.warehouse.api.model.account.contact.IndividualContactDebitorAccountFragment) $1.qubletFRAGMENTMAP.get('com.quasado.foundation.warehouse.api.model.account.contact.IndividualContactDebitorAccountFragment')).debitorAccount.bankAccounts.routingNumber) LIKE UPPER('%28%') results in the error Bug Version: Priority: Normal Status: Fixed Replies: 7 Type:  Bug ...

 
api-jdo

jdoPreAttach()

This method is called during the execution of javax.jdo.PersistenceManager.makePersistent on the detached instance before the copy is made.(Method of javax.jdo.listener.AttachCallback)

 
forum_thread

Unable to delete the .odb file programatically

Hi, I created the test.odb file, read the contents and now trying the delete the odb file using objectd2.x. I see the folder there are two files created test.odb and test.odb$. Using the following code to delte the odb files #1 2012-07-23 16:16 Hi, I created the test.odb file, read the contents and now trying the delete the odb file using objectd2. ...

 
forum_thread

Problem with byte arrays in JDO - ClassCastException

A bizarre ClassCastException is thrown if I attempt to obtain a byte array field as the result of a Query: Exception in thread "main" java.lang.ClassCastException: java.lang.Boolean cannot be cast to [B at spiffy.test.ObjectdbTest.main(ObjectdbTest.java:44) ... ( List<byte [ ] > ) query. execute ( "name1" ) ; for ( byte ...

 
forum_thread

Failed to create a new file 'target\objectdb\log\archive' (error 112)

Hi, we are using ObjectDB 2.4.6_10 (embedded mode). The pre-registration of a data type (see below) fails because ODB can't create a new file in a non-existing folder hierarchy. The user under which the JVM is executed in which the code below is run does have write permissions on the folder "target\objectdb". The folder "target\objectdb\log" does not exist yet. Do we have to create it beforehand? This issue is affecting our integration tests against ODB and is pretty major for us. Thanks #1 2013-07-02 12:06 Hi, we are using ObjectDB 2.4.6_10 (embedded mode). The pre-registration of a data type (see below) fails ...