BzW2hSqlLoginDataProvider

Microsoft does not allow the redistribution of its SQL Server drivers. You must download and install them to use this data provider.

The BzW2hSqlLoginDataProvider is defined in applicationConext.xml. The default definition of this bean is commented out by default:

<bean id="bzW2hSqlLoginDataProvider"
          class="com.bluezone.w2h.data.BzW2hSqlLoginDataProvider">
          <property name="dataSource" ref="msSqlDataSource" />
          <property name="passwordEncrypted" value="true" />
          <property name="passwordHasher" ref="bzW2hShaPasswordHasher" />
          <property name="userTableName" value="BzUsers" />
          <property name="userIdFieldName" value="UserId" />
          <property name="userPasswordFieldName" value="Password" />
</bean>

Create your database and table using the following format:

•

first column is the user ID (String)

•

second column is the password (String)

•

third column is the e-mail address (String)

•

fourth column is the site name (String)

•

fifth column is the page name (String)

•

all other columns are arbitrary data (String)

The default definition of this bean is commented out by default:

<bean id="msSqlDataSource"
          class="org.springframework.jdbc.datasource.DriverManagerDataSource"
          p:driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
          p:url="jdbc:sqlserver://yourserver.com;databasename=BlueZone"
          p:username="JoeAdmin"
          p:password="secret" />