Using the static method NativeSQLAccess.getVendorID(Connection conn), you can determine the underlying database vendor. You use this method to ensure that a non-portable SQL statement is issued on the corresponding database platform only.
The NativeSQLAccess class offers three options for issuing a non-portable SQL statement:
· NativeSQLAccess.createNativeStatement() – generates an object of the class java.sql.Statement.
· NativeSQLAccess.prepareNativeStatement() – generates an object of the class java.sql.PreparedStatement.
· NativeSQLAccess.prepareNativeCall() – generates an object of the class java.sql.CallableStatement (a Stored Procedure is called).
import java.sql.PreparedStatement;
import com.sap.sql.NativeSQLAccess;
String mssOnlyStmt = "…";
// ensure correct process environment
if (NativeSQLAccess.getVendorID(conn) !=
NativeSQLAccess.VENDOR_MS_SQL_SERVER) {
// error handling
} else {
// variant 1
PreparedStatement ps =
NativeSQLAccess.prepareNativeStatement(
conn, mssOnlyStmt);
. . .
// variant 2
Statement stmt =
NativeSQLAccess.createNativeStatement(conn);
int result = stmt.execute(mssOnlyStmt);
. . .
// variant 3
CallableStatement cs =
NativeSQLAccess.prepareNativeCall(
conn, mssOnlyStmt);
. . .
}
And also see this link..
http://help.sap.com/saphelp_nw04/helpdata/en/bb/d604ad96d444bfa6cb15652d44b2a8/frameset.htm
Urs GS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.