Scribd
Upload
21 views

Enable JDBC Logging - Driver Database SQL JDBC Java

The document discusses how to enable JDBC logging by setting a PrintWriter to DriverManager.setLogWriter() and executing JDBC statements. It also lists related examples for getting driver information and loading JDBC drivers.

Uploaded by

Praveen Kumar
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
21 views

Enable JDBC Logging - Driver Database SQL JDBC Java

The document discusses how to enable JDBC logging by setting a PrintWriter to DriverManager.setLogWriter() and executing JDBC statements. It also lists related examples for getting driver information and loading JDBC drivers.

Uploaded by

Praveen Kumar
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Enable JDBC logging : Driver Database SQL JDBC Java

http://www.java2s.com/Code/Java/Database-SQL-JDBC/EnableJDBC...

Enable JDBC logging : Driver Database SQL JDBC Java

Home Java
1. 2D Graphics GUI 2. 3D 3. Advanced Graphics 4. Ant 5. Apache Common 6. Chart 7. Class 8. Collections Data Structure 9. Data Type 10. Database SQL JDBC 11. Design Pattern 12. Development Class 13. EJB3 14. Email 15. Event 16. File Input Output 17. Game 18. Generics 19. GWT 20. Hibernate 21. I18N 22. J2EE 23. J2ME 24. JDK 6 25. JNDI LDAP 26. JPA 27. JSP 28. JSTL 29. Language Basics 30. Network Protocol 31. PDF RTF 32. Reflection 33. Regular Expressions 34. Scripting 35. Security 36. Servlets 37. Spring 38. Swing Components 39. Swing JFC 40. SWT JFace Eclipse 41. Threads 42. Tiny Application 43. Velocity 44. Web Services SOA 45. XML

Java Database SQL JDBC Driver

Screenshots

Enable JDBC logging

import import import import import

java.io.OutputStreamWriter; java.io.PrintWriter; java.sql.Connection; java.sql.DriverManager; java.sql.PreparedStatement;

public class Main { public static void main(String args[]) throws Exception { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String URL = "jdbc:odbc:dbName"; Connection dbConn = DriverManager.getConnection(URL, "user", "pass"); PrintWriter w = new PrintWriter(new OutputStreamWriter(System.out)); DriverManager.setLogWriter(w); dbConn.close(); PreparedStatement prepstmt; prepstmt = dbConn.prepareStatement("SELECT id FROM employee"); prepstmt.execute(); prepstmt.close(); dbConn.close(); } }

Related examples in the same category


1. Get Driver Property Info 2. Get Driver Name 3. int java.sql.Driver.getMajorVersion() 4. int java.sql.Driver.getMinorVersion() 5. boolean java.sql.Driver.jdbcCompliant() 6. Enumeration java.sql.DriverManager.getDrivers() 7. Get Driver Version 8. JDBC Driver Information 9. Loading a JDBC Driver: call Class.forName() within the code 10.Listing All Loaded JDBC Drivers and gets information about each one. 11.DriverPropertyInfo[] java.sql.Driver.getPropertyInfo(String url, Properties info) 12.JDBC driver url java2s.com | Contact Us | Privacy Policy Copyright 2009 - 12 Demo Source and Support. All rights reserved. All other trademarks are property of their respective owners.

1 of 1

8/7/2012 1:14 AM

You might also like