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 ... |
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(
...
|
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 ... |
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 ... |
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. ... |
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), ... |
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 ... |
|
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 ... |
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);
// ...
|
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 ...
|
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. ... |
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 ... |
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 ... |
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 ... |
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 ... |
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 ... |
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 ... |
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 ... |
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* ... |
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 ... |
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). ... |
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 ... |
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 ... |
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 ... |
|
|
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 ... |
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, ... |
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 ... |
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 = ... |
|
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 ... |
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 ... |
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 ... |
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 ... |
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 ... |
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 ... |
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 ... |
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 ... |
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 ... |
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 ... |
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 ... |