devxlogo

Displaying Native SQL

Displaying Native SQL

Java Database Connectivity (JDBC) drivers sometimes perform conversions on Structured Query Language (SQL) statements that you execute before sending them to the database. It can be helpful for debugging purposes to see the translated SQL, and you can accomplish this by using the nativeSQL() method in the java.sql.Connection class:

 java.sql.Connection conn;...java.util.Date curdate = new java.util.Date();java.text.SimpleDateFormat sdf =		new java.text.SimpleDateFormat(		"yy-MM-dd hh:mm:ss");String datetext = "{ts " + sdf.format(curdate) + "}";System.out.println(conn.nativeSQL(		"UPDATE MYTABLE SET DATECOL = " +datetext));

Running this code will display the converted SQL that the JDBC driver will be sending to the database, such as:

 UPDATE MYTABLE SET SOMEDATE = TO_DATE (99-04-21 09:23:48, 'YYYY-MM-DD HH24:MI:SS')
See also  How College Students Can Shape the Future of Tech Responsibility
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist