Hi Sujay Nadkarni,
As you said i am pasting my code here.
protected Connection getConnection () throws Exception{
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:globalcnts");
conn.setAutoCommit (true);
}
catch (SQLException sqle) {
context.log (" Error getting database connection", sqle);
}
return conn;
}
protected void freeConnection (Connection conn) {
try {
if (conn != null) {
conn.commit ();
conn.close ();
}
}
catch (Exception sqle) {
context.log ("Error freeing database connection", sqle);
}
}
I gave my DSN Name as globalcnts..Please redtify my doubt..
Thank You..