I'm trying to use driver in par to access DB, as followed:
private String JdbcDriver = "com.sap.nwmss.jdbc.sqlserver.SQLServerDriver"; private String JdbcUrl = "jdbc:nwmss:sqlserver://ep6sp9test:1433;databasename=UM"; private String User = "sa"; private String Pass = "admin"; public void doInitialization() { Connection con = null; Statement ps = null; ResultSet rs = null; try { Class.forName(this.JdbcDriver); con = DriverManager.getConnection(this.JdbcUrl,this.User,this.Pass); ps = con.createStatement(); String sqlstring = "SELECT SELECT * FROM Banner_Table"; rs = ps.executeQuery(sqlstring); while (rs.next()) { response.write(rs.getString("RoleName") + "<br>" + rs.getString("PictureName") + "<br>" + rs.getString("Text") + "<br>" + "<br>"); } } catch (Exception e) { response.write("Exception: " + e + "<br>"); } }
and I get this exception on screen after I deploy:
java.sql.SQLException: [NWMss][SQLServer JDBC Driver]This driver is locked for use with embedded applications.
Should I add something to portalapp.xml? or something else?