connection « postgresql « Java Database Q&A

1. JDBC- postgres, connection refused    stackoverflow.com

This is my first time using java to access databases, so I probably have a simple mistake here, but when I go to retrieve my connection from a remote database I ...

2. How can I access the database native java.sql.Connection?    stackoverflow.com

I'm using WASCE as application server and defined a data source to PosgreSQL. I get the DB Connection from JNDI. The problem is I want to access specific method in the PostgreSQL ...

3. Is it possible to create a jdbc connection without a password (using postgresql 'trust')?    stackoverflow.com

I am using jdbc to connect to a postgresql database in a java application (actually the app is written in Groovy). I have postgresql set up to use the 'trust' ...

4. Associating Postgres Connections with Java code    stackoverflow.com

I'm trying to track down leaky connections. (In particular, I'm noticing connections staying open past the closure of the last DataSource, using C3P0 for connection pooling. I suspect a ...

5. shared DB connection vs private DB connections    stackoverflow.com

Trying to figure out how to manage/use long-living DB connections. I have too little experience of this kind, as I have used DB only with small systems (up to some 150 ...

6. Java proxies connection to postgres    stackoverflow.com

Could someone help me or suggest a solution? I want to connect from a computer that has firewall to other where the postgres server run. The problem is that computer (client) ...

7. How to determine if java.sql.Connection is valid with PostgreSQL JDBC4    stackoverflow.com

I'm trying write a test for a method that returns a java.sql.Connection to connect to a PostgreSQL. My test is very straightforward:

@Test
public void connectionFactoryShouldReturnOpenConnection() throws Exception {
    ...

8. CF8 SSL Connection to Postgres fails    stackoverflow.com

I'm attempting an SSL connection from a ColdFusion 8 Enterprise client to a Redhat 5 Postgres server. Another party set up Postgres and sent me the certificates.

1. I imported root.crt into ...

9. PostgreSQL doesn't close connections    stackoverflow.com

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 reusing. But sometimes we need a lot of updates ...

10. One database connection to each thread?    stackoverflow.com

I making a webcrawler and each thread makes insertion of pages and links constantly. I must have a database connection per thread or share one connection to them?

11. connection timeout when connecting to a remote postgresql database    stackoverflow.com

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

int i = 0;
   ...

12. How create an PostgreSQL connection pool using Java?    stackoverflow.com

I'm trying to use a Connection Pool, but I don't understand it right. Who implements it? The software, the driver or the database? How I do to have my program running using ...

13. Java server and PostgreSQL connection    stackoverflow.com

I would like to make a server (A) in Java. Some clients (B) connect to A and send informations. When (A) receives data from (B) it must store those information into ...

14. JDBC Connection pooling in postgresql    coderanch.com

15. Postgresql connection Failure    coderanch.com

Thanks Again Jeanne for the reply. This is a test environment i have at home and there is no firewall. I will post my pg_hba.conf file for your review. I strongly suspect the problem is my settings in the file. Thanks again jonas #pg_hba.conf file #========================================================== # Allow any user on the local system to connect to any database under # ...

16. postgresql connection with JDBC    forums.oracle.com

System.out.println("connecting to the " + name + " data source..."); Class.forName("org.postgresql.Driver"); c = DriverManager.getConnection(url, name, pass); ................... The error generated is the following: java.lang.ClassNotFoundException: org.postgresql.Driver at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClassInternal(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at Main.main(Main.java:30) Actually i dont know how to load ...