topic DB error on initializing NodeRef with Service Registry in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/db-error-on-initializing-noderef-with-service-registry/m-p/69481#M22927 <HTML><HEAD></HEAD><BODY><P>I was trying to initialize a NodeRef on Bean initialization but got error for Authentication so i tried to run my code under Authentication.runAs(...) now i'm getting the below error on application restart.</P><P></P><P><STRONG>My Code:</STRONG></P><P><SPAN style="font-family: terminal, monaco, monospace;">public void init() { // this has been refrenced as "init-method" in the service-context.xml</SPAN><BR /><SPAN style="font-family: terminal, monaco, monospace;">&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;doclibNode = AuthenticationUtil.runAs(new RunAsWork&lt;NodeRef&gt;() {</SPAN></P><P></P><P><SPAN style="font-family: terminal, monaco, monospace;">&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;@Override</SPAN><BR /><SPAN style="font-family: terminal, monaco, monospace;">&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;public NodeRef doWork() throws Exception {</SPAN><BR /><SPAN style="font-family: terminal, monaco, monospace;">&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;return getDocLibNode(); // also tried this without AuthenticationUtil.runAs(...)</SPAN><BR /><SPAN style="font-family: terminal, monaco, monospace;">&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;}</SPAN></P><P></P><P><SPAN style="font-family: terminal, monaco, monospace;">&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;}, AuthenticationUtil.getSystemUserName());</SPAN></P><P></P><P><SPAN style="font-family: terminal, monaco, monospace;">&nbsp;&nbsp; &nbsp;}</SPAN></P><P>&nbsp;&nbsp;</P><P>&nbsp;&nbsp; &nbsp;private NodeRef getDocLibNode() { // stores the document library node in a class variable<BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;LOG.info(siteId + ", " + containerId); // fetch these from properties<BR />&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;return serviceRegistry.getSiteService().getContainer(siteId, containerId); // returns docLib Node<BR />&nbsp;&nbsp; &nbsp;}</P><P></P><P><STRONG>Error:</STRONG></P><P><SPAN style="font-family: terminal, monaco, monospace;">org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'myService' defined in class path resource [alfresco/module/${my-modul-name}/context/service-context.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: </SPAN><BR /><SPAN style="font-family: terminal, monaco, monospace;">### Error querying database.&nbsp; Cause: org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed</SPAN><BR /><SPAN style="font-family: terminal, monaco, monospace;">### The error may exist in alfresco/ibatis/#resource.dialect#/node-common-SqlMap.xml</SPAN><BR /><SPAN style="font-family: terminal, monaco, monospace;">### The error may involve alfresco.node.select_StoreRootNodeByRef</SPAN><BR /><SPAN style="font-family: terminal, monaco, monospace;">### The error occurred while executing a query</SPAN><BR /><SPAN style="font-family: terminal, monaco, monospace;">### SQL: select&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as id,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.version&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as version,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; store.id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as store_id,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; store.protocol&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as protocol,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; store.identifier&nbsp;&nbsp;&nbsp; as identifier,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.uuid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as uuid,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.type_qname_id&nbsp; as type_qname_id,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.locale_id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as locale_id,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.acl_id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as acl_id,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; txn.id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as txn_id,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; txn.change_txn_id&nbsp;&nbsp; as txn_change_id,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.audit_creator&nbsp; as audit_creator,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.audit_created&nbsp; as audit_created,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.audit_modifier as audit_modifier,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.audit_modified as audit_modified,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node.audit_accessed&nbsp; as audit_accessed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; alf_store store&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; join alf_node node on (store.root_node_id = node.id)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; join alf_transaction txn on (txn.id = node.transaction_id)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; store.protocol = ? and&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; store.identifier = ?</SPAN><BR /><SPAN style="font-family: terminal, monaco, monospace;">### Cause: org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed</SPAN><BR /><SPAN style="font-family: terminal, monaco, monospace;">; bad SQL grammar []; nested exception is org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed</SPAN><BR /></P><P><SPAN style="font-family: terminal, monaco, monospace;">.......</SPAN></P><P></P><P>I'm using SDK 3.0.1. full error is in attachment</P></BODY></HTML> Tue, 08 Jan 2019 09:25:50 GMT abbask01 2019-01-08T09:25:50Z DB error on initializing NodeRef with Service Registry https://connect.hyland.com/t5/alfresco-forum/db-error-on-initializing-noderef-with-service-registry/m-p/69481#M22927 I was trying to initialize a NodeRef on Bean initialization but got error for Authentication so i tried to run my code under Authentication.runAs(...) now i'm getting the below error on application restart.My Code<IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ublic void init() { // this has been refrenced as "init-method" in the service-contex Tue, 08 Jan 2019 09:25:50 GMT https://connect.hyland.com/t5/alfresco-forum/db-error-on-initializing-noderef-with-service-registry/m-p/69481#M22927 abbask01 2019-01-08T09:25:50Z