Starting with 15.7 ESD #4, SAP jConnect for JDBC supports logging mechanism by implementing the standard Java logger mechanism.
The application obtains the handle of the SAP jConnect logger, and turn logging on or off as and when required.
try { // Get logger for all classes present in //"com.sybase.jdbc4.jdbc" package Logger LOG = Logger.getLogger("com.sybase.jdbc4.jdbc"); // To log class-specific log message, // provide complete class name, for example: //Logger.getLogger("com.sybase.jdbc4.jdbc. //SybConnection"); //Get handle as per user's requirement Handler handler = new ConsoleHandler(); //Set logging level handler.setLevel(Level.ALL); //Added user specific handler to logger object LOG.addHandler(handler); //Set logging level LOG.setLevel(Level.ALL); Class.forName("com.sybase.jdbc4.jdbc.SybDriver"); Properties properties = new Properties(); properties.put("USER", USER_NAME); properties.put("PASSWORD", PASSWORD); Connection con = DriverManager.getConnection("jdbc:sybase:Tds:" + HOST_PORT, properties); Statement stmt = con.createStatement(); stmt.execute("select @@version"); //Dynamically turn off logging mechanism LOG.setLevel(Level.OFF); con.close(); ... }
SAP jConnect allows application users to set message granularity to Level.FINE, Level.FINER, and Level.FINEST. For example: