Обсуждение: BUG #4586: Supporting of Binary instead Bytea for Primary Keys
The following bug has been logged online: Bug reference: 4586 Logged by: Miroslav Nachev Email address: miro@space-comm.com PostgreSQL version: 8.3 Operating system: Windows Description: Supporting of Binary instead Bytea for Primary Keys Details: Most of the popular databases (Oracle, MySQL, MS SQL, etc.) support binary column type which can be used as primary key. For example UUID algorithm need of exact 16 bytes and is very useful for Primary Key. Of course it can be presented with characters in Hex format but in that case this will take 32 bytes which is 2 times bigger. It will be very helpful if in PostgreSQL binary/varbinary type is supported and can be used for indexes and primary keys.
Miroslav Nachev wrote: > Most of the popular databases (Oracle, MySQL, MS SQL, etc.) support binary > column type which can be used as primary key. For example UUID algorithm > need of exact 16 bytes and is very useful for Primary Key. Of course it can > be presented with characters in Hex format but in that case this will take > 32 bytes which is 2 times bigger. > It will be very helpful if in PostgreSQL binary/varbinary type is supported > and can be used for indexes and primary keys. There's a built-in UUID datatype that you might be interested in. It's 16 bytes, fixed-length. Also, what's wrong with bytea? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
(please keep the mailing list cc'd. (or take this to a more relevant list, actually)). Miroslav Nachev wrote: > Thank you very much. How can I map PostgreSQL UUID to JPA Hibernate with > annotations? Serializable or BigInteger or byte[] or java.util.UUID? No idea. > The big disadvantage of bytea is that it is not possible to use that type in > indexes and primary keys. Probably this restriction is because is very slow > column type because instead to keep the data this column keeps pointer to > the data. Huh? Of course it's possible: postgres=# CREATE TABLE foo (id bytea PRIMARY KEY); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "foo_pkey" for table "foo" CREATE TABLE postgres=# CREATE INDEX i_foo ON foo (id); CREATE INDEX postgres=# -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
Miroslav Nachev wrote: > And how to specify that bytea MUST be exact 16 bytes? Well, you could put a constraint on the column, or create a domain with such a constraint. But if you're dealing with uuids, you really want to use the UUID data type anyway. > What about the speed > because this is very important? > 1st of all when the length is variable then the speed is low. The overhead is small enough that you'd never notice. > 2nd when the column is with bigger length which require pointer to the data > instead data, then the speed will be extremely low. Again you're just assuming some overhead that's completely insignificant in the big scheme of things. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
Dear Heikki, Thank you very much. How can I map PostgreSQL UUID to JPA Hibernate with annotations? Serializable or BigInteger or byte[] or java.util.UUID? The big disadvantage of bytea is that it is not possible to use that type in indexes and primary keys. Probably this restriction is because is very slow column type because instead to keep the data this column keeps pointer to the data. Miro. On Wed, Dec 17, 2008 at 10:17 AM, Heikki Linnakangas < heikki.linnakangas@enterprisedb.com> wrote: > Miroslav Nachev wrote: > >> Most of the popular databases (Oracle, MySQL, MS SQL, etc.) support binary >> column type which can be used as primary key. For example UUID algorithm >> need of exact 16 bytes and is very useful for Primary Key. Of course it >> can >> be presented with characters in Hex format but in that case this will take >> 32 bytes which is 2 times bigger. >> It will be very helpful if in PostgreSQL binary/varbinary type is >> supported >> and can be used for indexes and primary keys. >> > > There's a built-in UUID datatype that you might be interested in. It's 16 > bytes, fixed-length. > > Also, what's wrong with bytea? > > -- > Heikki Linnakangas > EnterpriseDB http://www.enterprisedb.com >
And how to specify that bytea MUST be exact 16 bytes? What about the speed because this is very important? 1st of all when the length is variable then the speed is low. 2nd when the column is with bigger length which require pointer to the data instead data, then the speed will be extremely low. Miro. On Wed, Dec 17, 2008 at 11:19 AM, Heikki Linnakangas < heikki.linnakangas@enterprisedb.com> wrote: > (please keep the mailing list cc'd. (or take this to a more relevant list, > actually)). > > Miroslav Nachev wrote: > >> Thank you very much. How can I map PostgreSQL UUID to JPA Hibernate with >> annotations? Serializable or BigInteger or byte[] or java.util.UUID? >> > > No idea. > > The big disadvantage of bytea is that it is not possible to use that type >> in >> indexes and primary keys. Probably this restriction is because is very >> slow >> column type because instead to keep the data this column keeps pointer to >> the data. >> > > Huh? Of course it's possible: > > postgres=# CREATE TABLE foo (id bytea PRIMARY KEY); > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "foo_pkey" > for table "foo" > CREATE TABLE > postgres=# CREATE INDEX i_foo ON foo (id); > CREATE INDEX > postgres=# > > > -- > Heikki Linnakangas > EnterpriseDB http://www.enterprisedb.com >
On Wed, 17 Dec 2008, Miroslav Nachev wrote: > Thank you very much. How can I map PostgreSQL UUID to JPA Hibernate with > annotations? Serializable or BigInteger or byte[] or java.util.UUID? > The server uuid type is already mapped to java.util.UUID in recent JDBC driver versions: http://archives.postgresql.org/pgsql-jdbc/2008-09/msg00102.php Kris Jurka
Miroslav Nachev wrote: > I try to use it but I have the following exception: > > java.lang.IllegalArgumentException: Unknown entity: java.util.UUID > at > org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:223) > at psqluuidtest.Main.persist(Main.java:33) > at psqluuidtest.Main.main(Main..java:25) > Surely you want to persist a TestTable1 instance, not the uuid itself. Kris Jurka
Hi,
What if I convert to/from byte array with (see the attached java number
utility class):
NumberUtils.toByteArray(UUID uuid)
NumberUtils.toUUID(byte[] value)
Miro.
Miroslav Nachev wrote:
> Yes, you are right. With the correct code:
> public static void main(String[] args) {
> UUID uuid = UUID.randomUUID();
> TestTable1 testTable = new TestTable1(uuid);
> persist(testTable);
> }
>
> the exception is:
> Hibernate: insert into test_db.public.test_table_1 (description,
> my_id) values (?, ?)
> 2008-12-18 0:58:39 org.hibernate.util.JDBCExceptionReporter logExceptions
> WARNING: SQL Error: 0, SQLState: null
> 2008-12-18 0:58:39 org.hibernate.util.JDBCExceptionReporter logExceptions
> SEVERE: Batch entry 0 insert into test_db.public.test_table_1
> (description, my_id) values (NULL, '<stream of 80 bytes>') was
> aborted. Call getNextException to see the cause.
> 2008-12-18 0:58:39 org.hibernate.util.JDBCExceptionReporter logExceptions
> WARNING: SQL Error: 0, SQLState: 42804
> 2008-12-18 0:58:39 org.hibernate.util.JDBCExceptionReporter logExceptions
> SEVERE: ERROR: column "my_id" is of type uuid but expression is of
> type bytea
> Hint: You will need to rewrite or cast the expression.
> Position: 55
> 2008-12-18 0:58:39
> org.hibernate.event.def.AbstractFlushingEventListener performExecutions
> SEVERE: Could not synchronize database state with session
> org.hibernate.exception.SQLGrammarException: Could not execute JDBC
> batch update
> at
> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
>
> at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>
> at
> org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
> at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
> at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
> at
> org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
>
> at
> org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
>
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
> at
> org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
> at
> org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
>
> at
> org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
> at psqluuidtest.Main.persist(Main.java:34)
> at psqluuidtest.Main.main(Main.java:25)
> Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into
> test_db.public.test_table_1 (description, my_id) values (NULL,
> '<stream of 80 bytes>') was aborted. Call getNextException to see the
> cause.
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2556)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:395)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1348)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:343)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2693)
>
> at
> org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
>
> at
> org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
> ... 10 more
> javax.persistence.RollbackException: Error while commiting the
> transaction
> at
> org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71)
> at psqluuidtest.Main.persist(Main.java:34)
> at psqluuidtest.Main.main(Main.java:25)
> Caused by: org.hibernate.exception.SQLGrammarException: Could not
> execute JDBC batch update
> at
> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
>
> at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>
> at
> org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
> at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
> at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
> at
> org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
>
> at
> org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
>
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
> at
> org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
> at
> org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
>
> at
> org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
> ... 2 more
> Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into
> test_db.public.test_table_1 (description, my_id) values (NULL,
> '<stream of 80 bytes>') was aborted. Call getNextException to see the
> cause.
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2556)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:395)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1348)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:343)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2693)
>
> at
> org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
>
> at
> org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
> ... 10 more
> Exception in thread "main" java.lang.IllegalStateException:
> Transaction not active
> at
> org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:82)
> at psqluuidtest.Main.persist(Main.java:37)
> at psqluuidtest.Main.main(Main.java:25)
>
>
>
> Miro.
>
>
> Kris Jurka wrote:
>> Miroslav Nachev wrote:
>>> I try to use it but I have the following exception:
>>>
>>> java.lang.IllegalArgumentException: Unknown entity: java.util.UUID
>>> at
>>> org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:223)
>>>
>>> at psqluuidtest.Main.persist(Main.java:33)
>>> at psqluuidtest.Main.main(Main..java:25)
>>>
>>
>> Surely you want to persist a TestTable1 instance, not the uuid itself.
>>
>> Kris Jurka
>>
>
>
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package com.cosmos.util;
import java.math.BigInteger;
import java.util.UUID;
/**
*
* @author Miro
*/
public class NumberUtils
{
public static byte[] toByteArray(short value)
{
return toByteArray(value, 2);
}
public static byte[] toByteArray(int value)
{
return toByteArray(value, 4);
}
public static byte[] toByteArray(long value)
{
return toByteArray(value, 8);
}
public static byte[] toByteArray(UUID uuid)
{
byte[] firstBytes = toByteArray(uuid.getMostSignificantBits());
byte[] secondBytes = toByteArray(uuid.getLeastSignificantBits());
return append(firstBytes, secondBytes);
}
private static byte[] toByteArray(long value, int length)
{
byte[] result = new byte[length];
for(int i = 0; i < length; i++)
{
result[i] = (byte)(value & 0xFF);
value >>>= 8;
}
return result;
}
/**
* Appends two bytes array into one.
*
* @param a A byte[].
* @param b A byte[].
* @return A byte[].
*/
public static byte[] append(byte[] a, byte[] b)
{
byte[] z = new byte[a.length + b.length];
System.arraycopy(a, 0, z, 0, a.length);
System.arraycopy(b, 0, z, a.length, b.length);
return z;
}
public static short toShort(byte[] value)
{
return toShort(value, 0);
}
public static short toShort(byte[] value, int beginPos)
{
return (short)toNumber(value, beginPos, 2);
}
public static int toInt(byte[] value)
{
return toInt(value, 0);
}
public static int toInt(byte[] value, int beginPos)
{
return (int)toNumber(value, beginPos, 4);
}
public static long toLong(byte[] value)
{
return toLong(value, 0);
}
public static long toLong(byte[] value, int beginPos)
{
return toNumber(value, beginPos, 8);
}
private static long toNumber(byte[] value, int beginPos, int length)
{
if(value == null || value.length == 0)
return 0;
if(length > 8)
length = 8;
if((beginPos + length) > value.length)
length = value.length - beginPos;
if(length == 0)
return 0;
int endPos = beginPos + length;
long result = 0;
for(int i = (endPos - 1); i >= beginPos; i--)
{
int b = value[i] & 0xFF;
result |= b;
if(i > beginPos)
result <<= 8;
}
return result;
}
public static UUID toUUID(byte[] value)
{
return toUUID(value, 0);
}
public static UUID toUUID(byte[] value, int beginPos)
{
if(value.length < beginPos + 16)
throw new IllegalArgumentException("The length (" + value.length +
") of bytes is less than required (" + beginPos + 16 + ").");
long mostSigBits = toLong(value, beginPos);
long leastSigBits = toLong(value, beginPos + 8);
return new UUID(mostSigBits, leastSigBits);
}
public static UUID toUUID(BigInteger intValue)
{
return toUUID(intValue.toByteArray());
}
public static BigInteger toBigInteger(UUID uuid)
{
return new BigInteger(toByteArray(uuid));
}
public static void main(String[] args)
{
try
{
long l = 123456;
System.out.println("l: " + l);
byte[] ba = toByteArray(l);
l = toLong(ba);
System.out.println("l: " + l);
l = -123456;
System.out.println("l: " + l);
ba = toByteArray(l);
l = toLong(ba);
System.out.println("l: " + l);
int i = 123456;
System.out.println("i: " + i);
ba = toByteArray(i);
i = toInt(ba);
System.out.println("i: " + i);
i = -123456;
System.out.println("i: " + i);
ba = toByteArray(i);
i = toInt(ba);
System.out.println("i: " + i);
short s = 12345;
System.out.println("s: " + s);
ba = toByteArray(s);
s = toShort(ba);
System.out.println("s: " + s);
s = -12345;
System.out.println("s: " + s);
ba = toByteArray(s);
s = toShort(ba);
System.out.println("s: " + s);
UUID uuid1 = UUID.randomUUID();
System.out.println("uuid1: " + uuid1);
ba = toByteArray(uuid1);
UUID uuid2 = toUUID(ba);
System.out.println("uuid2: " + uuid2);
System.out.println("uuid1.equals(uuid2): " + uuid1.equals(uuid2));
BigInteger intValue1 = toBigInteger(uuid1);
uuid2 = toUUID(intValue1);
System.out.println("uuid1.equals(uuid2): " + uuid1.equals(uuid2));
BigInteger intValue2 = toBigInteger(uuid2);
System.out.println("intValue1.equals(intValue2): " + intValue1.equals(intValue2));
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
}
Yes, you are right. With the correct code:
public static void main(String[] args) {
UUID uuid = UUID.randomUUID();
TestTable1 testTable = new TestTable1(uuid);
persist(testTable);
}
the exception is:
Hibernate: insert into test_db.public.test_table_1 (description, my_id)
values (?, ?)
2008-12-18 0:58:39 org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 0, SQLState: null
2008-12-18 0:58:39 org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Batch entry 0 insert into test_db.public.test_table_1
(description, my_id) values (NULL, '<stream of 80 bytes>') was aborted.
Call getNextException to see the cause.
2008-12-18 0:58:39 org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 0, SQLState: 42804
2008-12-18 0:58:39 org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: ERROR: column "my_id" is of type uuid but expression is of type
bytea
Hint: You will need to rewrite or cast the expression.
Position: 55
2008-12-18 0:58:39 org.hibernate.event.def.AbstractFlushingEventListener
performExecutions
SEVERE: Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: Could not execute JDBC
batch update
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
at psqluuidtest.Main.persist(Main.java:34)
at psqluuidtest.Main.main(Main.java:25)
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into
test_db.public.test_table_1 (description, my_id) values (NULL, '<stream
of 80 bytes>') was aborted. Call getNextException to see the cause.
at
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2556)
at
org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:395)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1348)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:343)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2693)
at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
... 10 more
javax.persistence.RollbackException: Error while commiting the transaction
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71)
at psqluuidtest.Main.persist(Main.java:34)
at psqluuidtest.Main.main(Main.java:25)
Caused by: org.hibernate.exception.SQLGrammarException: Could not
execute JDBC batch update
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
... 2 more
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into
test_db.public.test_table_1 (description, my_id) values (NULL, '<stream
of 80 bytes>') was aborted. Call getNextException to see the cause.
at
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2556)
at
org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:395)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1348)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:343)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2693)
at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
... 10 more
Exception in thread "main" java.lang.IllegalStateException: Transaction
not active
at
org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:82)
at psqluuidtest.Main.persist(Main.java:37)
at psqluuidtest.Main.main(Main.java:25)
Miro.
Kris Jurka wrote:
> Miroslav Nachev wrote:
>> I try to use it but I have the following exception:
>>
>> java.lang.IllegalArgumentException: Unknown entity: java.util.UUID
>> at
>> org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:223)
>>
>> at psqluuidtest.Main.persist(Main.java:33)
>> at psqluuidtest.Main.main(Main..java:25)
>>
>
> Surely you want to persist a TestTable1 instance, not the uuid itself.
>
> Kris Jurka
>
I try to use it but I have the following exception:
java.lang.IllegalArgumentException: Unknown entity: java.util.UUID
       at
org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:223)
       at psqluuidtest.Main.persist(Main.java:33)
       at psqluuidtest.Main.main(Main.java:25)
The NetBeans
project is attached.
The used driver is postgresql-8.4dev-700.jdbc4.
Miro.
Miroslav Nachev wrote:
Hi,
This is very good. Can you give me some idea how to use that feature
together with Hibernate JPA? Is there some special annotation or ?
Regards,
Miro.
Kris Jurka wrote:
On Wed, 17 Dec 2008, Miroslav Nachev wrote:
Thank you very much. How can I map
PostgreSQL UUID to JPA Hibernate with
annotations? Serializable or BigInteger or byte[] or java.util.UUID?
The server uuid type is already mapped to java.util.UUID in recent JDBC
driver versions:
http://archives.postgresql.org/pgsql-jdbc/2008-09/msg00102.php
Kris Jurka
Hi, This is very good. Can you give me some idea how to use that feature together with Hibernate JPA? Is there some special annotation or ? Regards, Miro. Kris Jurka wrote: > > > On Wed, 17 Dec 2008, Miroslav Nachev wrote: > >> Thank you very much. How can I map PostgreSQL UUID to JPA Hibernate with >> annotations? Serializable or BigInteger or byte[] or java.util.UUID? >> > > The server uuid type is already mapped to java.util.UUID in recent > JDBC driver versions: > > http://archives.postgresql.org/pgsql-jdbc/2008-09/msg00102.php > > Kris Jurka >