Abgeschickt von nitin am 04 Oktober, 2005 um 03:07:40
Hi,
I have some problem in logging to db. Though it did not complaint in server.log in jboss, I don't get anything logged in db. Can someone point out if doing something wrong?
my configuration is as under:
<appender name="JDBC" class="org.apache.log4j.jdbcplus.JDBCAppender">
<param name="url" value="jdbc:sybase:Tds:192.168.40.23:5000/Cadenza_nk" />
<param name="username" value="cadenza"/>
<param name="password" value="cadenza"/>
<param name="connector" value="com.infocomp.cadenza.util.jdbc.SybaseConnectionHandler" />
<param name="dbclass" value="com.sybase.jdbc3.jdbc.SybDataSource" />
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="INSERT INTO log_log4j(Message) VALUES ('%d - %c - %p - %m')"/>
</layout>
</appender>
Here is my handler class.
public class SybaseConnectionHandler implements JDBCConnectionHandler {
Connection con = null;
String url = "jdbc:sybase:Tds:192.168.40.23:5000/Cadenza_nk?user=cadenza&password=cadenza";
String username = "cadenza";
String password = "cadenza";
static {
try {
// load driver
Driver dMySql = (Driver) (Class.forName("com.sybase.jdbc3.jdbc.SybDataSource").newInstance());
DriverManager.registerDriver(dMySql);
} catch (Exception e) {
System.err.println("Could not register driver.");
e.printStackTrace();
}
}
public Connection getConnection() {
return getConnection(url, username, password);
}
public Connection getConnection(String _url, String _username, String _password) {
try {
if (con != null && !con.isClosed())
con.close();
con = DriverManager.getConnection(url);
con.setAutoCommit(false);
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
}