postgresql « Database « Spring Q&A





1. Large ResultSet on postgresql query    stackoverflow.com

I'm running a query against a table in a postgresql database. The database is on a remote machine. The table has around 30 sub-tables using postgresql partitioning capability. The query ...

2. JdbcTemplate batch update in postgresql - date loses time?    stackoverflow.com

I am inserting a list of object with java.util.date in format YYYY-MM-DDThh:mm:ssTZD (2008-09-26T14:34:59+02:00). SQL:

INSERT INTO cdate (key,valuedate,user_id) VALUES(?,?,?)
BatchPreparedStatementSetter bpss = new MetaJdbc().setMetaBatchPreparedStatement(
        ...

3. How to update a postgresql array column with spring JdbcTemplate?    stackoverflow.com

I'm using Spring JdbcTemplate, and I'm stuck at the point where I have a query that updates a column that is actually an array of int. The database is postgres 8.3.7. This ...

4. Foreign/accented characters in sql query    stackoverflow.com

I'm using Java and Spring's JdbcTemplate class to build an SQL query in Java that queries a Postgres database. However, I'm having trouble executing queries that contain foreign/accented characters. For example ...

5. Can not find Driver when using generic database bundle    stackoverflow.com

I have a project that is build up from several OSGi bundles. One of them is a generic Database bundle that defines a DataSource that can be used throughout the project. ...

6. Why are result sets so large?    stackoverflow.com

Why are result sets from data bases so large? I typically get result sets that are around a million rows, each of which contains a couple of numerics, a varchar(75), ...

7. groovy on spring working with jdbc on postgresql, cannot update database    stackoverflow.com

I configuired Spring, JDBC, and PostgreSQL, and it works. However, when I exit my application and re-enter it, I get the following error message; something like:

Caught:SpringFramework.bean.factory....Error creating ...

8. Best data base design to store transient statuses of parking spaces at a parking lot    stackoverflow.com

Hey. I'm designing a website (using spring, hibernate and postgres) for parking lot owners to keep track of the statuses(occupied or vacant or reserved) of the parking ...

9. Spring JDBC - Last inserted id    stackoverflow.com

I'm using Spring JDBC. Is a simple way to get last inserted ID using Spring Framework or i need to use some JDBC tricks ?

jdbcTemplate.update("insert into test (name) values(?)", params, types);
// ...





10. jdbc connection with java, singleton connection object or spring jdbc connection?    stackoverflow.com

I am manipulating a postgresql database with java. Please help me to choose a development practice. Must I:

  • create a jdbc singleton object?
  • create a new connection for every request?
  • or use the jdbc api ...

11. PostgreSQL's COPY...TO with JdbcTemplate    stackoverflow.com

I'm using c3p0 connection pool with spring's JdbcTemplate to execute PostgreSQL's COPY ... TO command such as:

jdbcTemplate.update("COPY (SELECT ....) TO '/path/file.txt'");
If the file does not exist there will be an error. ...

12. JodaTime and BeanPropertySqlParameterSource    stackoverflow.com

The situation is something like this: PostgreSQL Database table has a field dateAdded which is timestamp The Pojo Model object maps this field as

class MyModel{
   org.joda.time.DateTime dateAdded;

}
My Dao Implementation is ...

13. JdbcCursorItemReader throw out of memory in postgresql    forum.springsource.org

JdbcCursorItemReader throw out of memory in postgresql. i am using latest version(2.1.5.RELEASE). it seem that all the data is loaded in the client side. i am reading a lot of data ...

14. cannot pass class to postgresql stored function    forum.springsource.org

cannot pass class to postgresql stored function I am trying to pass a class to a postgresql stored function as a user defined type but I get a failure: PSQLException: Can't ...

15. @Id @GeneratedValue and Postgresql    forum.springsource.org

Well this works for me, when I want to put other value than default in schema in DB Postgresql, setting in the xml: Code: hibernate.default_schema=${hibernate.default_schema} Code: hibernate.default_schema = "DBMERCANCIAS" In upper ...

16. PostgreSQL won't work with Spring and Tomcat    forum.springsource.org

PostgreSQL won't work with Spring and Tomcat Hello, I'm not sure whether this is a problem with Spring or not, but I have to start asking somewhere. :wink: We're trying to ...





17. Odd PostgreSQL problem    forum.springsource.org

Forum Spring Projects Data Odd PostgreSQL problem If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before ...

18. Spring and Postgresql    forum.springsource.org

Postgresql and JDBC issue I would like to inform users out there who have the following configuration of issues they might experience: PostgreSQL Database - Release 8.0 Release date: 2005-01-19 for ...

19. Container freezes with Local TX on Oracle + Postgresql    forum.springsource.org

Container freezes with Local TX on Oracle + Postgresql Hi all, I'm about to deliver the system and while doing performance tests for the acceptance we are seeing a very *VERY* ...

20. proper postgresql configuration?    forum.springsource.org

proper postgresql configuration? I'm quite stuck. According to various hibernate tutorials and reference pages I appear to have everything correctly configured. This can't be the case as I get a BadSqlGrammarException ...

21. DeadlockLoserDataAccessException and PostgreSQL 8.0.3.    forum.springsource.org

DeadlockLoserDataAccessException and PostgreSQL 8.0.3. I tried to raise DatalockLoserDataAccessionException using PostgreSQL. But I can't raise this exception but UncategorizedSQLException occured instead(PostgreSQL 8.0.3 is running on Windows and Spring version is 1.2.3). ...

22. PostgreSQL getKey is null    forum.springsource.org

I converted from MySQL to PostgreSQL. My inserts no longer work on tables with an autogenerated key. The data gets created but the KeyHolder getKey call returns null. I am using ...

23. Does anyone use PostgreSQL with spring?    forum.springsource.org

To the best of my knowledge, PostgreSQL doesn't support this. I'm pretty sure it didn't in v. 7, and I'm not aware that's changed in 8. From the manual: The data ...

24. ACL DB Schema for PostgreSQL Needed!    forum.springsource.org

Hi, I need to run the ACEGI ACL stuff on a PostgreSQL DB (version 8). The HSQLDB schema is on the website, but does anyone have the schema creation recipe for ...

25. How to config PostgreSQL in JPetStore?Thanks    forum.springsource.org

26. Query on SPring MVC using postgreSQL    forum.springsource.org

27. PostgreSql and DataFieldMaxValueIncrementer    forum.springsource.org

PostgreSql and DataFieldMaxValueIncrementer Greetings! I'm trying to retrieve an autogenerated key from pgsql following a code example from "Spring In Action" and all seems to work as expected as long as ...

28. Request problem using iBatis and postgresql 8.1    forum.springsource.org

Dec 1st, 2006, 06:23 PM #1 ledauc View Profile View Forum Posts Private Message Junior Member Join Date Oct 2006 Posts 2 Request problem using iBatis and postgresql 8.1 hello all, ...

29. Connection Pooling Problem-spring JDBC and postgresql    forum.springsource.org

Connection Pooling Problem-spring JDBC and postgresql hi, i am new to spring and we are developing a web application on spring framework.we are using opensource postgresql as our database and spring ...

30. Batch Loading JdbcTemplate to PostgreSQL    forum.springsource.org

Batch Loading JdbcTemplate to PostgreSQL Hey guys I am trying to to a batch insert using JdbcTemplate here's the code i have Code: public int[] insertData(final List llts){ String sql = ...

31. dbinit for PostGreSQL    forum.springsource.org

32. creating temporary table PostgreSql 8.1 and iBatis 2.3    forum.springsource.org

creating temporary table PostgreSql 8.1 and iBatis 2.3 Greetings! I've build a script in pgAdmin 3 ( os x 10.4 on ppc) that does a select, some left outer joins and ...

33. iBatis & PostgreSql 8.1 - reading BLOB    forum.springsource.org

iBatis & PostgreSql 8.1 - reading BLOB Greetings! I've got a problem trying to read a BLOB from a PostgreSql table. I can upload and save a file (jpeg in this ...

34. org.postgresql.util.PSQLException: An I/O error    forum.springsource.org

Jul 17th, 2007, 08:36 AM #1 enjoystar View Profile View Forum Posts Private Message Junior Member Join Date Mar 2007 Posts 8 org.postgresql.util.PSQLException: An I/O error Hi All, I am using ...

35. Postgresql and Propagation nested working?    forum.springsource.org

Does spring support this feature with postgres? I turned the feature on in my spring config for a few methods, I see BEGIN/COMMIT around them in the postgres log, but not ...

36. Running samples on PostgreSQL    forum.springsource.org

Mar 7th, 2008, 05:46 AM #1 jamiebarrow View Profile View Forum Posts Private Message Junior Member Join Date Mar 2008 Posts 5 Running samples on PostgreSQL The issue was resolved, I ...

37. PostgreSQL data never saved    forum.springsource.org

Mar 19th, 2008, 01:54 AM #1 azpublic View Profile View Forum Posts Private Message Junior Member Join Date Mar 2008 Posts 7 PostgreSQL data never saved Hi, I'm quite new to ...

38. Accessing PostgreSQL Functions    forum.springsource.org

The following correctly calls the function demoschema.demo() on a PostgreSQL server: Code: JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource); SimpleJdbcCall simpleGetCall = new SimpleJdbcCall(jdbcTemplate); simpleGetCall.withProcedureName("demo"); simpleGetCall.withCatalogName("demoschema"); Map execute = simpleGetCall.execute(); However I ...

39. Error with PostgreSQL and setQueryTimeout    forum.springsource.org

Jun 27th, 2009, 09:13 AM #1 Tama-Chan View Profile View Forum Posts Private Message Junior Member Join Date Feb 2006 Posts 15 Error with PostgreSQL and setQueryTimeout Hi all, I'm using ...

40. How to update a postgresql array column with spring JdbcTemplate?    forum.springsource.org

How to update a postgresql array column with spring JdbcTemplate? Hi, I'm using Spring JdbcTemplate, and I'm stuck at the point where I have a query that updates a column that ...

41. PostgreSQL - passing composite type to a stored function    forum.springsource.org

PostgreSQL - passing composite type to a stored function Hi all, Does someone knows how to pass a composite type to a PostgreSQL stored function? For example the: - PostgreSQL type ...

42. Problem with PostgreSQL database    forum.springsource.org

Problem with PostgreSQL database Hi, I wanto to use SpringSecurity with my postgres db, but I get an error Your login attempt was not successful, try again. Reason: Bad credentials. This ...