Skip to Content
0
Former Member
Apr 25, 2007 at 11:18 AM

SQL exception: This driver is locked for use with embedded applications.

757 Views

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?