Hello to everyone,
I'm new on this forum and on Alfresco development.
In the last days i developed a simple Java Web Script for Alfresco 3.4 with Spring configuration and iBatis framework.
After many tries and corrections, I can't get the WS to work on Alfresco.
I've commented various code portions and I founded what is wrong: the spring configuration on module-context.xml off course.
However, i wasn't able to find the solution.
I use Alfresco Community Edition 3.4 on Tomcat server (Alfresco bundle).
JAR directories tree (on WEB-INF/lib):
MANIFEST-MF:
… and the last but not least: module-context.xml
I tried also:
In this case, the exception is the following:
A, B and WSNAME is a simple mask for the real name wich I used.
Thank you,
Andrea
I'm new on this forum and on Alfresco development.
In the last days i developed a simple Java Web Script for Alfresco 3.4 with Spring configuration and iBatis framework.
After many tries and corrections, I can't get the WS to work on Alfresco.
I've commented various code portions and I founded what is wrong: the spring configuration on module-context.xml off course.
However, i wasn't able to find the solution.
I use Alfresco Community Edition 3.4 on Tomcat server (Alfresco bundle).
10:49:07,159 INFO [alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from URL [file:/C:/Users/andrea/Lavoro/Alfresco/tomcat/shared/classes/alfresco/extension/custom-vti.properties]
10:49:07,194 ERROR [web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanInitializationException: Could not load properties; nested exception is java.io.FileNotFoundException: Could not open ServletContext resource [/classpath*:/db.properties]
at org.springframework.beans.factory.config.PropertyResourceConfigurer.postProcessBeanFactory(PropertyResourceConfigurer.java:78)
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:624)
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:599)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:398)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: java.io.FileNotFoundException: Could not open ServletContext resource [/classpath*:/db.properties]
at org.springframework.web.context.support.ServletContextResource.getInputStream(ServletContextResource.java:118)
at org.springframework.core.io.support.PropertiesLoaderSupport.loadProperties(PropertiesLoaderSupport.java:181)
at org.springframework.core.io.support.PropertiesLoaderSupport.mergeProperties(PropertiesLoaderSupport.java:161)
at org.springframework.beans.factory.config.PropertyResourceConfigurer.postProcessBeanFactory(PropertyResourceConfigurer.java:69)
… 31 more
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
10:49:33,492 INFO [extensions.webscripts.DeclarativeRegistry] Registered 309 Web Scripts (+0 failed), 319 URLsJAR directories tree (on WEB-INF/lib):
. alfresco/
. extension/
. module-context-xml
. module.properties
. WSNAME.post.desc.xml
. WSNAME.post.html.ftl
. it/
. a/
. b/
. WSNAME/
. dao (contains .class)
. maps (contains ibatis xml files)
. domain (contains .class)
. support (contains .class)
. util (contains .class)
. webscript
. ProtocolloFileUpload.class
. META-INF
. db.properties
. log4j.properties
. sql-map-config.xml
MANIFEST-MF:
Manifest-Version: 1.0
Ant-Version: Apache Ant 1.7.1
Created-By: 17.1-b03 (Sun Microsystems Inc.)… and the last but not least: module-context.xml
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE beans PUBLIC '-//SPRING//DTD BEAN//EN' 'http://www.springframework.org/dtd/spring-beans.dtd'>
<beans>
<bean id="webscript.it.a.b.WSNAME.webscript.ProtocolloFileUpload.post" class="it.a.b.WSNAME.webscript.ProtocolloFileUpload"
parent="webscript">
<property name="authenticationService" ref="authenticationService" />
<property name="nodeService" ref="nodeService" />
<property name="namespaceService" ref="namespaceService" />
<property name="fileFolderService" ref="fileFolderService" />
<property name="contentService" ref="contentService" />
<property name="searchService" ref="searchService" />
<property name="authorityService" ref="authorityService" />
<property name="transactionService" ref="transactionService" />
<property name="permissionService" ref="permissionService" />
<property name="categoryService" ref="categoryService" />
</bean>
* <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
* <property name="location">
* <value>classpath*:/db.properties</value>
* </property>
* </bean>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean>
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation" value="classpath:/sql-map-config.xml" />
<property name="dataSource" ref="dataSource" />
</bean>
<bean id="daoSupport" class="it.insiel.archprot.protocolloAlfrescoInsiel.dao.DAOUtils">
<property name="sqlMapClient" ref="sqlMapClient" />
</bean>
<bean id="interactionsDAO" class="it.insiel.archprot.protocolloAlfrescoInsiel.dao.InteractionsDAO">
<property name="support" ref="daoSupport" />
</bean>
</beans>
I tried also:
<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location">
<value>classpath:/db.properties</value>
</property>
</bean>
In this case, the exception is the following:
11:13:21,599 INFO [alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
11:13:21,683 INFO [alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/module/org.alfresco.module.vti/context/vti.properties]
11:13:21,686 INFO [alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from URL [file:/C:/Users/andrea/Lavoro/Alfresco/tomcat/shared/classes/alfresco/extension/custom-vti.properties]
11:13:21,804 ERROR [web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanDefinitionStoreException: Invalid bean definition with name 'clusterPropertySetter' defined in class path resource [alfresco/core-services-context.xml]: Could not resolve placeholder 'alfresco.tcp.start_port'
at org.springframework.beans.factory.config.PropertyPlaceholderConfigurer.processProperties(PropertyPlaceholderConfigurer.java:272)
at org.springframework.beans.factory.config.PropertyResourceConfigurer.postProcessBeanFactory(PropertyResourceConfigurer.java:75)
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:624)
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:599)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:398)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository..
A, B and WSNAME is a simple mask for the real name wich I used.
Thank you,
Andrea
Hi mrogers, thank's for your interest.
At this moment, I'm traying to depoly a simple web script whitout call to any database.
I would like make a webscript, in Java EE, for integrate some business logic into Alfresco: the upload of some protocolled files, theirs registration on a external oracle database, and so. All security aspect isn't now important.
Now, i just trying to deploy a web script with Spring configuration and ready to use for iBatis.
I've one interaction.xml for iBatis wich containes all queries to DB, external, not Alfresco DB.
I can't use Web Services because my commiteer wouldn't it.
At this moment, I'm traying to depoly a simple web script whitout call to any database.
I would like make a webscript, in Java EE, for integrate some business logic into Alfresco: the upload of some protocolled files, theirs registration on a external oracle database, and so. All security aspect isn't now important.
Now, i just trying to deploy a web script with Spring configuration and ready to use for iBatis.
I've one interaction.xml for iBatis wich containes all queries to DB, external, not Alfresco DB.
I can't use Web Services because my commiteer wouldn't it.
Hi !
I found myself in the same point today, and i find out how to solve it, al least for version 4.0.d community. So, this is how i solve it.
First i installed the special dialect for oracle by installing the oracle amp that community provide for my alfresco version (http://forge.alfresco.com/gf/project/oracle/frs/).
Inside my own AMP configuration, I wrote in the context beans file this:
As you can note, i change hibernate.dialect property, this is because it's looking for new database dialect. In case you wonder, this can be seen it in this path: [whare is your alfresco installatin]\tomcat\webapps\alfresco\WEB-INF\classes\alfresco\ibatis
Best regards and hope this was usefull .
Tatiana HM
!I found myself in the same point today, and i find out how to solve it, al least for version 4.0.d community. So, this is how i solve it.
First i installed the special dialect for oracle by installing the oracle amp that community provide for my alfresco version (http://forge.alfresco.com/gf/project/oracle/frs/).
Inside my own AMP configuration, I wrote in the context beans file this:
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
<property name="url" value="jdbc:oracle:thin:@xxx.xxx.xxx.xxx:EX" />
<property name="username" value="xxx" />
<property name="password" value="xxx" />
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="hibernateProperties">
<props>
<!– <prop key="hibernate.dialect">org.hibernate.dialect.OracleDialect</prop> –>
<prop key="hibernate.dialect">org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>
</bean>
As you can note, i change hibernate.dialect property, this is because it's looking for new database dialect. In case you wonder, this can be seen it in this path: [whare is your alfresco installatin]\tomcat\webapps\alfresco\WEB-INF\classes\alfresco\ibatis
Best regards and hope this was usefull
.Tatiana HM
