topic jcr-context.xml screwes up iBATIS somehow... in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/jcr-context-xml-screwes-up-ibatis-somehow/m-p/39371#M20968 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to use iBATIS while also using JCR.&nbsp; I also use Spring.&nbsp; Spring is configured with iBATIS.&nbsp; </SPAN><BR /><BR /><SPAN>For some reason if I include jcr-context.xml in contextConfigLocation all my iBATIS queries get messed up.&nbsp; It adds "alfresco." to the Table and I get SQL exception.</SPAN><BR /><BR /><SPAN>so a simple query like:</SPAN><BR /><BR /><SPAN>&lt;statement id="getProjectsAsMap" resultClass="java.util.HashMap"&gt;</SPAN><BR /><SPAN>select ID from Projects;</SPAN><BR /><SPAN>&lt;/statement&gt;</SPAN><BR /><BR /><SPAN>throws "cannot find table alfresco.projects" SQL Exception.</SPAN><BR /><BR /><SPAN>If I remove jcr-context.xml from web.xml everything works (it looks for table Projects).&nbsp; I'll post here if I find more info.&nbsp; thanks!</SPAN></BODY></HTML> Tue, 14 Feb 2006 18:06:26 GMT alexeyg 2006-02-14T18:06:26Z jcr-context.xml screwes up iBATIS somehow... https://connect.hyland.com/t5/alfresco-archive/jcr-context-xml-screwes-up-ibatis-somehow/m-p/39371#M20968 I am trying to use iBATIS while also using JCR.&nbsp; I also use Spring.&nbsp; Spring is configured with iBATIS.&nbsp; For some reason if I include jcr-context.xml in contextConfigLocation all my iBATIS queries get messed up.&nbsp; It adds "alfresco." to the Table and I get SQL exception.so a simple query like:&lt;stat Tue, 14 Feb 2006 18:06:26 GMT https://connect.hyland.com/t5/alfresco-archive/jcr-context-xml-screwes-up-ibatis-somehow/m-p/39371#M20968 alexeyg 2006-02-14T18:06:26Z Re: jcr-context.xml screwes up iBATIS somehow... https://connect.hyland.com/t5/alfresco-archive/jcr-context-xml-screwes-up-ibatis-somehow/m-p/39372#M20969 <HTML><HEAD></HEAD><BODY><SPAN>hmm looks like Spring was picking up Alfresco's dataSource Spring bean…</SPAN></BODY></HTML> Wed, 15 Feb 2006 15:51:23 GMT https://connect.hyland.com/t5/alfresco-archive/jcr-context-xml-screwes-up-ibatis-somehow/m-p/39372#M20969 alexeyg 2006-02-15T15:51:23Z