postgresql and jdbc

Site menu:

Topics

Recent Posts

Blog

 

September 2010
M T W T F S S
« Aug    
 12345
6789101112
13141516171819
20212223242526
27282930  

Past Posts

Links:

Archive for 'JavaRanch Forum Migration'

postgresql and jdbc

June 13th, 2010 by Jeanne Boyarsky

In postgresql – selecting maximum for each group, we saw the actual stored function.  That was the easy part.  Then there was dealing with Postgresql and JDBC.  I encountered a few surprises while doing this. Calling the stored function I expected to use JDBC’s CallableStatement since I was calling a stored procedure.  Nope.  The proper [...]

postgresql – selecting maximum for each group

June 13th, 2010 by Jeanne Boyarsky

I had a requirement to return the thread with the most replies in each forum at JavaRanch‘s Coderanch forums.  In Postgresql 8.4, this would be very easy – just use the window functions.  Unfortunately, we aren’t on Postgresql 8.4 yet.  The other common pattern is something like SELECT stuff FROM mytable t1 WHERE date = [...]

process builder to run multi-platform postgres import

April 25th, 2010 by Jeanne Boyarsky

We saw how to clone a postgresql database for testing cleanly in an earlier blog post. The next step is to do so from Java so it can be part of an integration test. How to run each of 4 DDLs: Running a DDL file is easy which is good since we have four of [...]