Howdy - I am trying to get Anthony Ogiers datasourcepersistencemanager to
work with jackrabbit. I am using sqlserver as my datasource in jboss4.0.4ga
I have configured the following:
1) Jackrabbit-mssql-search.xml - this is a copy of
jackrabbit-mysql-search.xml from WEB-INF/config/repo-conf that I tweeked to
use DataSourcePersistenceManager, i.e.,
<PersistenceManager
class="com.iorgagroup.jackrabbit.core.state.db.DataSourcePersistenceManager"
>
<!--<param name="dataSourceLocation"
value="java:comp/env/jdbc/magnoliaAuthor"/>--> <!--- This did not work, so I
looked at jmx-console and found that db was jndified at the following: -->
<param name="dataSourceLocation" value="java:jdbc/magnoliaAuthor"/>
<param name="schemaObjectPrefix" value="${wsp.name}_"/>
<param name="externalBLOBs" value="false"/>
<param name="schema" value="mssql"/>
<!--<param name="optimizedServerSidePreparedStatement"
value="true"/>-->
</PersistenceManager>
2) Magnolia.properties - I modified thias to point to the new erpository
config file, i.e.,
magnolia.repositories.jackrabbit.config=WEB-INF/config/repo-conf/jackrabbit-
mssql-search.xml
3)Mssql-ds.xml - I created this and put it in <jboss server>/deploy
directory (where my datasource config files reside)
i.e., <datasources>
<local-tx-datasource>
<jndi-name>jdbc/magnoliaAuthor</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://CANHCSNSQL001:11001;DatabaseName=
magnoliaAuthor;SelectMethod=cursor;</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>jboss_magnolia </user-name>
<password>dev_pwd</password>
<min-pool-size>8</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>20</idle-timeout-minutes>
<track-statements/>
<prepared-statement-cache-size>32</prepared-statement-cache-size>
</local-tx-datasource>
.
.
.
4) I placed the datasourcepersistencemanager.jar in WEB-INF/lib
5) My sqlserver drivers are in <jboss server>/lib - where my other db
drivers live
6) I removed magnoliaAuthor repositories dir - wanted a clean bootstrap
After doing the above, and restarting jboss, I get the following errors
INFO info.magnolia.cms.beans.config.ConfigLoader 28.12.2006 17:26:29 --
Init content repositories
INFO info.magnolia.cms.beans.config.ContentRepository 28.12.2006 17:26:29
-- System : loading JCR
INFO info.magnolia.cms.beans.config.ContentRepository 28.12.2006 17:26:29
-- Loading workspace:website
INFO info.magnolia.cms.beans.config.ContentRepository 28.12.2006 17:26:29
-- Loading workspace:config
INFO info.magnolia.cms.beans.config.ContentRepository 28.12.2006 17:26:29
-- Loading workspace:users
INFO info.magnolia.cms.beans.config.ContentRepository 28.12.2006 17:26:29
-- Loading workspace:userroles
INFO info.magnolia.cms.beans.config.ContentRepository 28.12.2006 17:26:29
-- Loading workspace:usergroups
INFO info.magnolia.cms.beans.config.ContentRepository 28.12.2006 17:26:29
-- Loading workspace:mgnlSystem
INFO info.magnolia.cms.beans.config.ContentRepository 28.12.2006 17:26:29
-- Loading workspace:mgnlVersion
INFO info.magnolia.cms.beans.config.ContentRepository 28.12.2006 17:26:29
-- Loading workspace:dms
INFO info.magnolia.cms.beans.config.ContentRepository 28.12.2006 17:26:29
-- Loading workspace:Store
INFO info.magnolia.cms.beans.config.ContentRepository 28.12.2006 17:26:29
-- Loading workspace:Expressions
INFO info.magnolia.cms.beans.config.ContentRepository 28.12.2006 17:26:29
-- System : loading JCR magnolia
INFO info.magnolia.jackrabbit.ProviderImpl 28.12.2006 17:26:29 -- Loading
repository at
C:\servers\jboss-4.0.4.GA\server\homeq\.\deploy\magnoliaAuthor.war\repositor
ies\magnolia (config file:
C:\servers\jboss-4.0.4.GA\server\homeq\.\deploy\magnoliaAuthor.war\WEB-INF\c
onfig\repo-conf\jackrabbit-mssql-search.xml)
ERROR
org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/magnoliaAut
hor] 28.12.2006 17:26:31 -- Exception sending context initialized event to
listener instance of class info.magnolia.cms.servlets.PropertyInitializer
java.lang.AbstractMethodError:
com.microsoft.jdbc.base.BaseDatabaseMetaData.supportsStatementPooling()Z
at
com.iorgagroup.jackrabbit.core.state.db.DataSourcePersistenceManager.checkSc
hema(DataSourcePersistenceManager.java:982)
at
com.iorgagroup.jackrabbit.core.state.db.DataSourcePersistenceManager.init(Da
taSourcePersistenceManager.java:306)
at
org.apache.jackrabbit.core.RepositoryImpl.createPersistenceManager(Repositor
yImpl.java:1029)
at
org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImp
l.java:286)
at
org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:235)
at
org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:484)
at
org.apache.jackrabbit.core.jndi.BindableRepository.init(BindableRepository.j
ava:136)
at
org.apache.jackrabbit.core.jndi.BindableRepository.create(BindableRepository
.java:1
.
.
.
Any one out there get DataSourcePersistenceManager working in JBOSS with sql
server???
Have a great day!
[EMAIL PROTECTED]
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------
