Can't obtain Primary Key value by JPQL

Hi everybody, I am using openJPA2.0.1 + Mysql5.1. Table definition like below, ===DML START=== CREATE TABLE t_user ( uid int(10) unsigned NOT NULL AUTO_INCREMENT, name varchar(255) DEFAULT NULL, age int(11) NOT NULL, PRIMARY KEY (uid) ) ENGINE=InnoDB

Re: SAP MaxDB not supported?

On Mon, Nov 1, 2010 at 3:58 AM, joe fischauto...@yahoo.de wrote: Hi, I think (haven't verified it) that you can use the base DBDictionary class - this might be closer to MaxDB than Oracle or HSQL. Which value i have to set for using the base DBDictionary class? property

Re: Can't obtain Primary Key value by JPQL

Can you post the SQL trace from when you execute your query? Thanks, Rick On Wed, Nov 3, 2010 at 3:51 AM, Alex, Huang primemo...@gmail.com wrote: Hi everybody, I am using openJPA2.0.1 + Mysql5.1. Table definition like below, ===DML START=== CREATE TABLE

Re: Binary column

This is a bug, the column definition is being overridden by a type set in the MySQL dictionary. I went ahead and opened a JIRA on your behalf : OPENJPA-1870 https://issues.apache.org/jira/browse/OPENJPA-1870, and posted to stack overflow.. FWIW it should be fairly straight forward to fix. -mike

Re: Can't obtain Primary Key value by JPQL

Hi Rick, Thanks a lot. I don't know how to write unit test to recreate the problem, would you give me a link or any sample? Alex,Huang - Original Message - From: Rick Curtis curti...@gmail.com To: users@openjpa.apache.org Sent: Thursday, November 04, 2010 2:30 AM Subject: Re: Can't

Re: Can't obtain Primary Key value by JPQL

Hi Rick, I wrote a small test case like below, ==START== public class TestQuery extends SingleEMFTestCase { public void setUp() throws Exception { // registers TUser as persistence-capable entity super.setUp(TUser.class); }