jdbc postgresql

I am facing this problem: I have a program that loops the following: connect to a postgresql database print a count number close the connection code…

I have the following JDBC code. Note that I am attempting to use PostGIS geography: PreparedStatement stmt = db.prepareStatement("INSERT INTO " +…

Hallo, I am writing a database application that does alot of inserts and updates with fake serialisable isolation level ( snapshot isolation ). To…

I have a query that looks something like this: SELECT A.A, A.B, B.A, B.C, B.D FROM tableone A, tabletwo B WHERE A.A = B.A AND B.C = :p_name When the…

I may not have enough information to provide the community to answer this question, but I'm kind of hoping my situation rings a bell in someone's…

I manipulate postgresql database with java , please help me to choose a development way, Must I create a jdbc singleton object ? create a new…

My data is in format: 2010-12-01 09:59:00.423 getDate in Java only returns the date portion. Is there a way to also extract the time?

im using JDBC4 (over JDK6) to connect to postgresql 9.0 using their latest JDBC4 driver. conn = dpaDs.getConnection(); PreparedStatement stmt =…

I am attempting to access a Postgres database inside of Clojure. I've found a ton of examples of projects using DBs, setting up the database like…

I have just installed NetBeans 7.0 and I am a newbie in NetBeans' world. can any one tell me how to connect my application to MySQl / PostGress ? I…

Hi I'm using JDBC to connect to postgresql database. We are trying to block access to database for users themselves. Instead they should be forced…

hello, After many search on the subject I finally think the solution of my problem is to ask you. So my problem is in the way to create logs on my…

If I query my database with SELECT current_setting('TIMEZONE') I get 'UTC' (as expected). Using PgAdmin, I run the following query: SELECT foo FROM…

Hi there! I just installed Netbeans (7.0 IDE Dev) on my mac, and I am quite happy that i dont need 2 editors anymore (1 for php, 1 for python) Now,…

This is my CreateQuery.java class . package DbConnect; import java.io.FileNotFoundException; import java.io.IOException; import java.sql.Connection;…

Hi, we are currently developing some kind of enterprise resource managment system with Google Web Toolkit. Our main goals are to keep our system…

as stated, does java jdbc driver for postgresql has client side \copy? I wanted to do batch inserts into a table in the database on a remote machine…

We are using Liferay Portal 5.2.3 (with Hibernate and C3P0) on Tomcat 5.5.27, PostgreSQL 8.3. Normally, c3p0 pools connections and return it for…

Hi, I am working on building a web service from scratch with JDBC for postgreSQL. thing is that the operations given in the wsdl file do not show…

I am trying to create a connection for the JDBC driver in netbeans for windows. THe problem is that i cannot make a domain source name with the .jar…