Procedure
When the MashZone NextGen User Repository is your LDAP Directory, the default administrator account (Administrator user) is disabled.
Make sure this database is supported by MashZone NextGen. See Additional MashZone NextGen System and Software Requirements for details.
The jTDS driver and the original Microsoft driver are available for Microsoft SQL Server. You must make different settings depending on the driver type selected. For details see the following steps.
If you want MashZone NextGen to support international characters in meta-data for artifacts, make sure the database uses the UTF-16 character encoding and case insensitive collation. See documentation for your database for specific instructions.
It is a best practice to require passwords for every database account that can access the MashZone NextGen Repository.
If you do not use the default dbo schema, you have to specify the name of the used schema (value="schema_name" ) in the bean PMF in the rdsApplicationContext.xml file.
The file is located in <MashZone NextGen installation>\apache-tomcat\webapps\mashzone\WEB-INF\classes\.
<bean id="pmf" class="com.jackbe.jbp.sas.rds.impl.jdo .PersistenceManagerFactoryBean"> <property name="lifecycleListener" ref="entityLifecycleLsnr"/> <property name="dataSource" ref="dataSource" /> <property name="configLocation" value="classpath:datanucleus.properties"/> <!-- overwrite settings in configLocation file --> <property name="jdoProperties"> <map> <entry key="datanucleus.ConnectionFactoryName" value="java:comp/env/MashzoneNextGenRepository"/> <entry key="datanucleus.storeManagerType" value="rdbms"/> <entry key="datanucleus.mapping.Schema" value="schema_name"/> </map> </property> </bean>
MashZoneNG-install/apache-tomcat/lib
MashZoneNG-install/prestorepository/jackbe-presto-rds-oracle-mysql-mssql.jar
To the web-apps-home/mashzone/WEB-INF/lib folder.
Example for jTDS driver
<Resource name="MashzoneNextGenRepository" auth="Container" type="javax.sql.DataSource" maxTotal="200" maxIdle="30" maxWaitMillis="10000" username="app" password="app" driverClassName="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://host-name:port/database" />
The JTA managed property must be false.
Example for original Microsoft driver
<Resource name="MashzoneNextGenRepository" auth="Container" type="javax.sql.DataSource" maxTotal="200" maxIdle="30" maxWaitMillis="10000" username="app" password="app" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://host-name:port;databaseName=your_database" />
Tomcat Datasource Properties
for a complete list of optional properties and information on defaults.Some common properties you may need to set include:
validationQuery = select 1
Common tuning properties for connections pools. See Tuning the MashZone NextGen Repository Connection Pool.
If the MashZone NextGen Server does not start up successfully, see Troubleshooting Connections to the MashZone NextGen Repository for suggestions.
If the MashZone NextGen Server does not start up successfully, see Troubleshooting Connections to the MashZone NextGen Repository for suggestions.