<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><DIV>Hi, </DIV>
<DIV> </DIV>
<DIV>I am trying to connect to another DB repository then the one that BRMS uses by default.</DIV>
<DIV>I tried applying the WIKI info, wich states that the following peace of code should be inserted after the <Repository> tag in the repository.xml found under the bin dir of the JBoss installation, but nothing seems to trigger the creation of the schema in the database I just created.</DIV>
<DIV>Tested with both SQL Server and My SQL and same behavior.</DIV>
<DIV> </DIV>
<DIV>I guess that if something is not right either in the syntax of the repository.xml file, or if any of the settings: eg. name of the driver, username, password etc, jackrabbit does not really warn me but connects to the default repository.</DIV>
<DIV> </DIV>
<DIV>Anyone had this kind of problems ?</DIV>
<DIV> </DIV>
<DIV>Here is the content of the <DataStore> tag.</DIV>
<DIV> </DIV><SPAN lang=EN>
<DIV><DataStore class="org.apache.jackrabbit.core.data.db.DbDataStore"></DIV>
<DIV><param name="url" value="jdbc:sqlserver://localhost\SQLEXPRESS;DatabaseName=drools_pilot;SelectMethod=cursor"/></DIV>
<DIV><param name="user" value="johnDoe"/></DIV>
<DIV><param name="password" value="jdpassword"/></DIV>
<DIV><param name="databaseType" value="sqlserver"/></DIV>
<DIV><param name="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/></DIV>
<DIV><param name="minRecordLength" value="1024"/></DIV>
<DIV><param name="maxConnections" value="3"/></DIV>
<DIV><param name="copyWhenReading" value="true"/></DIV>
<DIV><param name="tablePrefix" value=""/></DIV>
<DIV></DataStore></DIV></SPAN></td></tr></table>