Postgres « Database « JPA Q&A

1. Image not getting stored in postgres stackoverflow.com

I have stored images in image data type in binary format in MSSQL.Now I have migrated my database from MSSQL to Postgres 9.0 and trying to store image files in bytea ...

2. Problem with special characters Postgres + Hibernate stackoverflow.com

I've a e-mail configuration table containing the html content that will be sent. In this html content, there is many special character, but when I retrieve this content using hibernate, this ...

3. postgres + hibernate stackoverflow.com

I am using postgres + hibernate + jboss final 6.0.0 server. When I try to open the database connection, it throws the following exception:

Caused by: org.postgresql.util.PSQLException: FATAL: sorry, too many clients ...

4. Hell with postgres + hibernate coderanch.com

Hi, i've been mapping using annotation as jpa standard and using hibernate as my orm and session manager. Nevertheless i've been experience a huge problem i got this error when i'm trying to insert or update my class. Hibernate: insert into tbl_usuario (activo, conectado, contrasenna, no_ip_sesion, nombre, id_sucursal, ultima_sesion, direccion, email, p_apellido, p_nombre, s_apellido, s_nombre, telefono, tipo, id_usuario) values (?, ?, ...

5. PostgreSQLDialect & postgres 8.4 (operator does not exist) forum.hibernate.org

Hi there, Does someone know about an issue with hibernate 3.x and Postgres > 8.2 ? We currently use Postgres 8.2.x and hibernate 3.2 within glassfish v2ur2. We plan to migrate to an earlier machine with a little refresh of all of that. That means Postgres 8.4.1, hibernate 3.3.2, glassfish v2.1.1 For now, i just run our application in this new ...

6. Hibernate and postgres for web application forum.hibernate.org

Hello to everyone.. I'm new in this forum and of course I'm new in hibernate.. (sorry for english) I have to do a project (a web application) for university and I don't have much time.. So I'm asking for some help to do things faster (maybe..:)) Well I use Netbeans 6.8, postgreSQL 8.3 on macos 10.5. By now I'm tryng to ...

7. Postgres inet type operators forum.hibernate.org

I am trying to use Hibernate/JPA to query a table that has a Postgres inet type. If I do simple things like retrieve all of the rows or retrieve a row by the key (which is a long, not an inet) it works fine and Hibernate pulls all of the columns back putting the inet into a String attribute in my ...

8. How hibernate get postgres oid type to java bytes? forum.hibernate.org

9. Postgres 9 Support forum.hibernate.org

10. cancel that... its a postgres thing... forum.hibernate.org

11. Support for Advanced Postgres Features: Arrays, OID ? forum.hibernate.org

Hi, Does Hibernate support any of the advanced features found in PostgreSQL? Particularly I'm interested in knowing whether SQL Arrays are supported. Also ... What about all the cool types that are supported by Postgres like Point, etc? I think Hibernate supports some sort of custom types ... has anyone written a class to support a built in postgres type or ...

12. problems with hibernate and postgres forum.hibernate.org

Hi! I have a little problem with hibernate(2.0.3) and postgres (7.2) when i use net.sf.hibernate.tool.hbm2ddl.SchemaExport to generate my database i've used a lot of different drivers JDBC and the result is the same. It perfectly run with hsqldb (good for test ;-) so i don't think it's a problem of hbm file. here are some example of the errors : v.g. ...

13. Hibernate/Postgres Perforamance Issues Worrying forum.hibernate.org

I recently moved a medium sized web project (50 normalized tables in the database) from mysql to postgres (latest version, 7.4.2 I think). Getting 90% of the functionality to work was fairly easy to do in a few hours and in two work days, I did the following: - I modified all the hibernate mappings to do sequences and I had ...

14. problem with postgres forum.hibernate.org

Newbie Joined: Thu Sep 09, 2004 9:01 am Posts: 3 Hi people, I was using hibernate 2.1.4 with MySQL and i had no problems. But, i decided to do tests with another DB(postgres 7.4.1) and i got some errors. Here is my hibernate-mapping:

15. Postgres 8.0 Windows and Postgres 7.4 Cygwin Windows Support forum.hibernate.org

I have some detailed questions about Hibernate support for Postgres. They're based on a decision I'm trying to make whether to use Postgres 8.0 or Postgres 7.4 for a Windows installation. 1. The website states that Postgres 7.4 is officially supported. Does this include the Cygwin port of Postgres? In other words, has official testing been done on the Cygwin Postgres ...

16. Postgres 8.0.4 forum.hibernate.org

It works fine. I haven't tried it under Windows, but it's perfect under Linux, and the Postgres JDBC (which is how Hibernate ultimately talks to the database) doesn't care or know whether the server is Windows or Linux. And I have used PG 8 under Windows (but not with Hibernate) and it worked fine. Not as robust as with Linux, but ...

17. classNotFoundException for postgres forum.hibernate.org

hibernate3.1.2,postgresql 7.4.1...... hi, now in process to complete hibernate tutorial..As mentioned early, i'm using postgres database server and put the jdbc driver to /lib folder. I got error when try to run this command: ant run -Daction=store the error: [java] 17:40:42,147 FATAL DriverManagerConnectionProvider:65 - JDBC Driver class not found: org.postgresql.Driver [java] java.lang.ClassNotFoundException: org.postgresql.Driver [java] at java.net.URLClassLoader$1.run(URLClassLoader.java:199) i already check my postgres ...

18. classNotFoundException for postgres forum.hibernate.org

19. A substring problem using 'from' keyword from postgres forum.hibernate.org

20. Hibernate and Postgres dialect forum.hibernate.org

21. Hibernate and Postgres and case sensitivity and persistance forum.hibernate.org

Author Message keyzervega Post subject: Hibernate and Postgres and case sensitivity and persistance Posted: Thu Aug 10, 2006 6:32 pm Newbie Joined: Thu Aug 10, 2006 12:25 am Posts: 13 Hi Been doning some searching to find the answer to how to deal with case sensitivity when using postgres and hibernate. I have a database that is already created ...

22. Could you please include a trivial postgres patch into 3.2? forum.hibernate.org

23. index index creation on postgres 8.2.3 forum.hibernate.org

Hi, I use Hibernate annotation to define a POJO which I would like to create index on a column. Following is my POJO: @Entity @Table(name = "ROUTER") @org.hibernate.annotations.Table(appliesTo="ROUTER", indexes = { @Index(name="router_mac_index", columnNames = { "MAC" } ) } ) public class Router { @Column(name="MAC", length=18) public String getMac() { return mac; } } After the table is created in postgres ...

24. Postgres + longvarchar forum.hibernate.org

25. naming strategy class for use with Postgres? forum.hibernate.org

Does anyone have an implementation of NamingStrategy that works with Postgres? What I mean, is something that comes up with names similar to what org.hibernate.cfg.ImprovedNamingStrategy does, but takes into account object fields that also happen to be common SQL keywords such as "left", "right", "order", etc. and creates column names like "left_", "right_", "order_" or other legal names. Thanks.

26. Problem with cidr type in Postgres forum.hibernate.org

I have a class with a property ipRcja (String) , and a column in a table of my DB of type cidr (Postgres), when i try to persist the object into the data base: ... myObject.setIpRcja("127.0.1.1/32"); ... session.saveOrUpdate(myObject); i get the next message: ERROR: The column ip_rcja is of type cidr but the expression is of type character varying Could not ...

27. Hibernate chokes on Postgres case sensitiviness forum.hibernate.org

28. OID support for Postgres forum.hibernate.org

I have a simple question, that is giving me a hard work. I'm from Brazil, and, here, we don't have many support from the comunity in hibernate questions. How can i map an OID type from Postgres, that represents a File in my application ? java.io.File, byte[], blob ??? do i have to make a special configuration to make hibernate accept ...

29. Escaping Postgres' reserved words forum.hibernate.org

Personally, I wouldn't mind if Hibernate always did put the correct quotes around table and column names. Or at least, if there was a global setting that could turn this on. However, I think the documentation is quite clear on this issue. No backticks -> no quotes. One reason for this behavior may be that quotes changes case-sensitivity in some databases. ...

30. create-drop sometimes hangs in Postgres forum.hibernate.org

Hi, we've got some trouble running Hibernate in Glassfish using "create-drop" or development usage. Before switching to Postgres everything worked fine but with Postgres Hibernate sometimes hangs forever while recreating the database tables after a redeploy. I've used pgAdmin III to get an overview of what's going on on the Postgres server if this problem occurs and noticed that there is ...

31. Problem with SequenceStyleGenerator under Postgres forum.hibernate.org

ERROR 15:38:06 0 could not read a hi value (TableStructure.java:140) org.postgresql.util.PSQLException: ERROR: syntax error at or near "id_val" at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:437) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:257) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at org.hibernate.id.enhanced.TableStructure.doWorkInCurrentTransaction(TableStructure.java:130) ...

32. BUG: Problem with SequenceStyleGenerator under Postgres forum.hibernate.org

33. Hibernate on postgres hangs - PersistentSet.size() issue forum.hibernate.org

PersistentSet.size() doesn't return at all while working on postgres database. It's not the case always, but, sometimes it happens. After enabling the logs came to know that a select statement like the following select * from table1 where table1.column1 in (select column2 from table2 where table2.column=?) The above select statement is not returning at all. The following is the stack trace ...