Tagged Questions
0
votes
0answers
18 views
Error connecting to postgres using sessionFactory
Im using spring 3.1.2, postgres 8.4, jdbc driver 9.0-801.jdbc4, OS redhat 6
Im doing a connection with hibernate 4.1.4.Final
I have this in my dataSource
<bean id="dataSource" ...
0
votes
1answer
33 views
Can't insert a Date object into a PostgreSQL Timestamp column using Hibernate
I am trying to use the primefaces schedule component, I found problem in inserting the date () in the database (postgresql), there is a problem of incompatibility between the date type of java and ...
0
votes
1answer
16 views
Hibernate @ManyToOne annotation creating only the child referencing existing parent table
I am currently working on a project in which i have to use manytoone relationship. I want to retrieve the parent from an existing table in the DB and map to a new child object. But each time i do this ...
0
votes
1answer
26 views
Can I continue to use Hibernate 3.0 when migrating PostgreSQL 8.2 to 9.2?
I'm working on a project that uses Hibernate 3.0. The program was released around 2007 and is connected to a PosgreSQL 8.2 Database.
As we want to relaunch the project (thousands and thousands lines ...
0
votes
1answer
34 views
Hibernate / postgreSQL
I am using Hibernate 3.6.4 on eclipse-Juno/EE with postgreSQL9.2.
I am not being able to run-- keep getting the following error log:
16:07:18,605 INFO [main] Main - ...
0
votes
0answers
29 views
Data Insertion error while using Spring Roo with Postgres
I'm very new to using Roo, Hibernate, and Postgres. I've been working on Java, JDBC and MySQL so far but I've had to change to the former platform recently.
I tried to create a basic CRUD web app ...
0
votes
1answer
26 views
Upgrade to Postgres 9.2 (incl. Hibernate) & Tomcat 7
We are planning an upgrade from PostgreSQL 8.2 to 9.2.4, and Tomcat from 6 to 7.
I have worked through various migration guide and want to ask you if you have any experience and whether there are any ...
0
votes
1answer
42 views
Hibernate @SqlInsert w/ PostgreSQL function — What does my function need to return?
I have a JPA app that is receiving GBs of string data each day. The biggest storage sink is a set of strings that can be pretty long and are repeated very often (maybe 1000 unique strings and I might ...
0
votes
0answers
33 views
Multiple schema postgres on hibernate
I'm new to hibernate.
In my web application, users after login have to point to different schema (with same tables) on the same postgres database to make queries.
Is there a method to specify at ...
0
votes
0answers
27 views
Unable to update a timestamp field of a table in PostgreSQL from hibernate
I have a table 'task' with a field 'updated_ts' of type Timestamp in PostgreSQL. I am trying to update this field using hibernate as follows:
Timestamp currentTimestamp= new Timestamp((new ...
0
votes
2answers
48 views
Hibernate nested query using criteria
Is it posible to create a criteria for generating below sql:
select name from (select distinct name from person) as aliasname order by lower(name);
here there are two sql -
select distinct name ...
0
votes
0answers
49 views
How to create hibernate criteria with DISTINCT in this case
I am using hibernate criteria to create postgres query:
criteria.addOrder(Order.asc(property).ignoreCase()).setProjection(
...
1
vote
1answer
39 views
JPA/Hibernate + Postgres SequenceGenerator
I'm trying for the all day long get the Sequence from a Postgres with JPA/Hibernate, but it gives me all the time:
INFO: Hibernate:
call next value for tb_cdr_id_seq
WARN: SQL Error: 0, ...
0
votes
1answer
36 views
Hibernate autocommit true for a single command
Hibernate automatically sets autocommit to false, and indeed even recommends against setting it to true.
I find myself in the need of having autocommit set to true for a single database command (I ...
0
votes
2answers
107 views
Java, PostgreSQL, and Hibernate: Select statement with nested strings
I'm trying to unload data from RedShift to S3 using Java + Hibernate, but cannot figure out how to get it to accept the string-within-a-string in the SQL.
No matter the escape sequences I try to use ...
