Urgent! JDBC connection fail -- first time succeed, second time fail

From: "Kitty" <kitty(at)crossland(dot)com(dot)au>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Urgent! JDBC connection fail -- first time succeed, second time fail
Date: 2001-11-23 03:09:43
Message-ID: 004a01c173cc$519ab2e0$9701a8c0@ctm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Dear sir,
I have downloaded the postgres jdbc driver to be run with Lotus Domino R5 in Red Hat Linux6.2. I am using Postgres 6.5.3 and I have downloaded the file "jdbc6.5-1.2.jar". I have used the following code to connect to the database.

import lotus.domino.*;
import java.sql.*;
import java.util.Properties;
import java.util.Vector;
import lotus.domino.*;
import java.util.Enumeration;

public class agtSaveRecord extends AgentBase{

Driver drv = null;
public void NotesMain() {
try {
Session session = getSession();
AgentContext agentContext = session.getAgentContext();
Database db = agentContext.getCurrentDatabase();
Document doc = agentContext.getDocumentContext();

drv = (Driver) Class.forName("postgresql.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:postgresql://192.168.1.28:5432/notestest", "notes", "lotusnotes");
Statement st = con.createStatement();
String strSql;

strSql = "INSERT INTO ktest VALUES ('" + doc.getItemValueString("txtUCN") +
"', '" + doc.getItemValueString("txtSubject") +
"', '" + doc.getItemValueString("txtContent") + "')";
st.executeUpdate(strSql);

st.close();
con.close();
// doc.remove(true);
} catch(Exception ex) {
System.out.println("Error problem!");
System.out.println(ex.getMessage());
ex.printStackTrace();
} finally {
try {
Enumeration eDrivers = DriverManager.getDrivers();
for (; eDrivers.hasMoreElements();) {
System.out.println("Drivers not empty.");
DriverManager.deregisterDriver((Driver) eDrivers.nextElement());
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
}

I can succeed to connect to the database and insert the data into the database occasionally.
After that, I tried to run the program again, but it failed with the following error.

No suitable driver

java.sql.SQLException: No suitable driver

at java.sql.DriverManager.getConnection(DriverManager.java:103)

at java.sql.DriverManager.getConnection(DriverManager.java:126)

at agtSearchRecord.NotesMain(agtSearchRecord.java:21)

at lotus.domino.AgentBase.runNotes(AgentBase.java:160)

at lotus.domino.NotesThread.run(NotesThread.java:203)

If after seeing this error, I will wait for around 5 mins and run the program again, and it will be ok.
It seems that the driver cannot be released out for use immediately.
Is it the problem of the driver or cause by some imcompability or anything else?

Regards,
Kitty Chan

Browse pgsql-jdbc by date

  From Date Subject
Next Message balaji Srinivas 2001-11-23 06:39:00 Postgres JDBC Driver Name for V7.1
Previous Message Per Ivansson 2001-11-22 17:29:55 postgreSQL functions and postgres JDBC