[JCR-2223] MSSqlFileSystem - JNDI & several configuration issues

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0-alpha4
• Fix Version/s: 1.6
• Component/s: jackrabbit-core
• Environment: JBoss 4.2.3GA, SQLServer JDBC Driver 2.0, xa-datasource
• Assignee: Unassigned
• Reporter: Torsten Weck
• Created: 23/Jul/09 08:27
• Updated: 13/Aug/09 15:03
• Resolved: 04/Aug/09 09:31

Description

there are several configuration issues using the org.apache.jackrabbit.core.fs.db.MSSqlFileSystem
my (working) configuration (repository.xml) looks like:

<FileSystem class="org.apache.jackrabbit.core.fs.db.MSSqlFileSystem">
<param name="driver" value="javax.naming.InitialContext"/>
<param name="url" value="java:MYDatasource"/>
<param name="schema" value="mssql"/>
<param name="schemaObjectPrefix" value="MYPREFIX_"/>
<param name="user" value="MYUSERNAME"/>
<param name="password" value="MYPASSWORD"/>
<param name="tableSpace" value=""/>
</FileSystem>

i have to unnecessarily specify username & password, because the MSSqlFileSystem presets them to an empty string instead of null. funnily enough the tableSpace is preset to null, which leads to a nullpointer in createSchemaSql