I have used the Liferay Portal before. Here is a thought. I thought about trying this myself but never got around to it. Liferay portal creates a datasource is liferay.xml. In Tomcat this is /%LIFERAY_HOME/conf/Catalina/localhost/liferay.xml
Why not have OJB use existing datasource for transactions? http://db.apache.org/ojb/docu/guides/deployment.html#Configure+OJB+for+manag ed+environments+considering+as+JBoss+example Regard, Eric ->-----Original Message----- ->From: Marcel Souza [mailto:[EMAIL PROTECTED] ->Sent: Wednesday, May 17, 2006 12:21 PM ->To: OJB Users List ->Subject: Re: Error in beginTransaction! -> ->Hello Armin, -> ->I am posting the whole trace. ->One strange fact: my application works perfectly fine using ->Oracle but shows the error (Can't lookup a connection) using Mysql. ->I did the replacements in code you sugested, unfortunatelly ->it keeps showing the same error message. :( Thanks for your help, -> ->marcel. -> ->14:06:56,203 INFO [Server] JBoss (MX MicroKernel) [3.2.5 (build: ->CVSTag=JBoss_3 ->_2_5 date=200406251954)] Started in 1m:282ms ->14:06:56,203 INFO [Tomcat5] Saw ->org.jboss.system.server.started notification, s tarting ->connectors 14:06:56,250 INFO [Http11Protocol] Starting ->Coyote HTTP/1.1 on ->http-0.0.0.0-808 ->0 ->14:06:56,500 INFO [ChannelSocket] JK2: ajp13 listening on ->/0.0.0.0:8009 ->14:06:56,515 INFO [JkMain] Jk running ID=0 time=0/109 config=null ->14:07:14,093 INFO [STDOUT] [BOOT] ERROR: ->14:07:14,093 INFO [STDOUT] The specified class ->"org.apache.ojb.broker.locking.L ockManagerInMemoryImpl" does ->not implement the interface org.apache.ojb.odmg.loc ->king.LockManager, which is a requirement for the key ->"LockManagerClass". ->Using d ->efault class class org.apache.ojb.odmg.locking.LockManagerDefaultImpl ->14:07:14,234 INFO [PersistenceBrokerFactoryDefaultImpl] ->Create PersistenceBroke r instance pool, pool configuration ->was {whenExhaustedAction=0, maxIdle=-1, maxA ctive=100, ->maxWait=2000, removeAbandoned=false, ->numTestsPerEvictionRun=10, testW hileIdle=false, ->minEvictableIdleTimeMillis=1000000, testOnReturn=false, ->logAband oned=false, removeAbandonedTimeout=300, ->timeBetweenEvictionRunsMillis=-1, testOn Borrow=false} ->14:07:14,250 INFO [RepositoryPersistor] OJB Descriptor Repository: ->file:/C:/jbo ->ss-3.2.5/server/default/deploy/9audaces.war/WEB-INF/classes/re ->pository.xml ->14:07:14,250 INFO [RepositoryPersistor] Building repository ->from :file:/C:/jbos ->s-3.2.5/server/default/deploy/9audaces.war/WEB-INF/classes/rep ->ository.xml ->14:07:14,562 INFO [RepositoryPersistor] Read class ->descriptors took 312 ms ->14:07:14,562 INFO [RepositoryPersistor] OJB Descriptor Repository: ->file:/C:/jbo ->ss-3.2.5/server/default/deploy/9audaces.war/WEB-INF/classes/re ->pository.xml ->14:07:14,578 INFO [RepositoryPersistor] Building repository ->from :file:/C:/jbos ->s-3.2.5/server/default/deploy/9audaces.war/WEB-INF/classes/rep ->ository.xml ->14:07:14,609 INFO [RepositoryPersistor] Read connection ->repository took 47 ms ->14:07:14,703 INFO [ObjectCacheFactory] Start creating new ->ObjectCache instance ->14:07:14,703 INFO [ObjectCacheFactory] Default ObjectCache ->class was org.apache .ojb.broker.cache.ObjectCacheDefaultImpl ->14:07:14,703 INFO [CacheDistributor] Use property ->'descriptorBasedCaches' ->is se ->t 'false' ->14:07:14,703 INFO [ObjectCacheFactory] Instantiate new ->org.apache.ojb.broker.ca che.CacheDistributor class object ->14:07:14,734 INFO [ObjectCacheFactory] New ObjectCache ->instance was created ->14:07:14,796 INFO [ConnectionFactoryPooledImpl] Create new ->connection pool:org. ->[EMAIL PROTECTED] -> jcd-alias=default -> default-connection=true -> dbms=Oracle -> jdbc-level=2.0 -> driver=oracle.jdbc.driver.OracleDriver -> protocol=jdbc -> sub-protocol=oracle -> db-alias=thin:@192.168.0.5:1521:dbserver -> user=tlportal -> password=***** -> eager-release=false -> ConnectionPoolDescriptor={whenExhaustedAction=2, ->maxIdle=50, maxActive=100, ma xWait=5000, ->removeAbandoned=false, numTestsPerEvictionRun=10, ->testWhileIdle=fals e, minEvictableIdleTimeMillis=600000, ->testOnReturn=false, logAbandoned=false, re ->moveAbandonedTimeout=300, timeBetweenEvictionRunsMillis=-1, ->testOnBorrow=true} -> batchMode=false -> useAutoCommit=AUTO_COMMIT_IGNORE_STATE -> ignoreAutoCommitExceptions=false -> ->sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDesc ->[EMAIL PROTECTED] -> sequenceManagerClass=class ->org.apache.ojb.broker.util.sequence.SequenceMana ->gerNextValImpl -> Properties={autoNaming=false} ->] ->] ->14:07:15,781 INFO [ObjectCacheFactory] Start creating new ->ObjectCache instance ->14:07:15,781 INFO [ObjectCacheFactory] Default ObjectCache ->class was org.apache .ojb.broker.cache.ObjectCacheDefaultImpl ->14:07:15,781 INFO [CacheDistributor] Use property ->'descriptorBasedCaches' ->is se ->t 'false' ->14:07:15,781 INFO [ObjectCacheFactory] Instantiate new ->org.apache.ojb.broker.ca che.CacheDistributor class object ->14:07:15,781 INFO [ObjectCacheFactory] New ObjectCache ->instance was created ->14:07:15,781 INFO [ConnectionFactoryPooledImpl] Create new ->connection pool:org. ->[EMAIL PROTECTED] -> jcd-alias=mysql -> default-connection=false -> dbms=MySQL -> jdbc-level=3.0 -> driver=com.mysql.jdbc.Driver -> protocol=jdbc -> sub-protocol=mysql -> db-alias=//localhost:3306/lportal -> user=root -> password=***** -> eager-release=false -> ConnectionPoolDescriptor={whenExhaustedAction=2, ->validationQuery=SELECT 1, max Idle=2, maxActive=30, ->maxWait=5000, removeAbandoned=false, numTestsPerEvictionRu ->n=10, testWhileIdle=false, minEvictableIdleTimeMillis=600000, ->testOnReturn=false ->, logAbandoned=false, removeAbandonedTimeout=300, ->timeBetweenEvictionRunsMillis= -1, testOnBorrow=true} -> batchMode=false -> useAutoCommit=AUTO_COMMIT_IGNORE_STATE -> ignoreAutoCommitExceptions=false -> sequenceDescriptor=<null> ->] ->14:07:15,812 INFO [ConnectionFactoryPooledImpl] Destroy ->object was called, try to close connection: ->[EMAIL PROTECTED] ->14:07:15,828 INFO [STDOUT] javax.portlet.PortletException: ->Erro DoViewPadrao - Can't lookup a connection ->14:07:15,828 INFO [STDOUT] at ->com.audaces.portlets.grdocs.GrDocsPortlet.doV ->iewPadrao(GrDocsPortlet.java:50) ->14:07:15,828 INFO [STDOUT] at ->com.audaces.portlets.PortletGen.doView(Portle ->tGen.java:168) ->14:07:15,828 INFO [STDOUT] at ->javax.portlet.GenericPortlet.doDispatch(Gener ->icPortlet.java:235) ->14:07:15,828 INFO [STDOUT] at ->javax.portlet.GenericPortlet.render(GenericPo ->rtlet.java:163) ->14:07:15,843 INFO [STDOUT] at ->com.liferay.portlet.CachePortlet.render(Cache ->Portlet.java:176) ->14:07:15,843 INFO [STDOUT] at ->org.apache.jsp.html.portal.layout_jsp._jspSer ->vice(layout_jsp.java:1252) ->14:07:15,843 INFO [STDOUT] at ->org.apache.jasper.runtime.HttpJspBase.service ->(HttpJspBase.java:94) ->14:07:15,843 INFO [STDOUT] at ->javax.servlet.http.HttpServlet.service(HttpSe ->rvlet.java:810) ->14:07:15,843 INFO [STDOUT] at ->org.apache.jasper.servlet.JspServletWrapper.s ->ervice(JspServletWrapper.java:324) ->14:07:15,843 INFO [STDOUT] at ->org.apache.jasper.servlet.JspServlet.serviceJ ->spFile(JspServlet.java:292) ->14:07:15,843 INFO [STDOUT] at ->org.apache.jasper.servlet.JspServlet.service( ->JspServlet.java:236) ->14:07:15,859 INFO [STDOUT] at ->javax.servlet.http.HttpServlet.service(HttpSe ->rvlet.java:810) ->14:07:15,859 INFO [STDOUT] at ->org.apache.catalina.core.ApplicationFilterCha ->in.internalDoFilter(ApplicationFilterChain.java:237) ->14:07:15,859 INFO [STDOUT] at ->org.apache.catalina.core.ApplicationFilterCha ->in.doFilter(ApplicationFilterChain.java:157) ->14:07:15,859 INFO [STDOUT] at ->org.apache.catalina.core.ApplicationDispatche ->r.invoke(ApplicationDispatcher.java:703) ->14:07:15,859 INFO [STDOUT] at ->org.apache.catalina.core.ApplicationDispatche ->r.doInclude(ApplicationDispatcher.java:589) ->14:07:15,859 INFO [STDOUT] at ->org.apache.catalina.core.ApplicationDispatche ->r.include(ApplicationDispatcher.java:499) ->14:07:15,859 INFO [STDOUT] at ->com.liferay.taglib.IncludeTag.doEndTag(Includ ->eTag.java:72) ->14:07:15,859 INFO [STDOUT] at ->org.apache.jsp.html.tiles.layout_005fportal_j ->sp._jspService(layout_005fportal_jsp.java:1439) ->14:07:15,875 INFO [STDOUT] at ->org.apache.jasper.runtime.HttpJspBase.service ->(HttpJspBase.java:94) ->14:07:15,875 INFO [STDOUT] at ->javax.servlet.http.HttpServlet.service(HttpSe ->rvlet.java:810) ->14:07:15,875 INFO [STDOUT] at ->org.apache.jasper.servlet.JspServletWrapper.s ->ervice(JspServletWrapper.java:324) ->14:07:15,875 INFO [STDOUT] at ->org.apache.jasper.servlet.JspServlet.serviceJ ->spFile(JspServlet.java:292) ->14:07:15,875 INFO [STDOUT] at ->org.apache.jasper.servlet.JspServlet.service( ->JspServlet.java:236) ->14:07:15,875 INFO [STDOUT] at ->javax.servlet.http.HttpServlet.service(HttpSe ->rvlet.java:810) ->14:07:15,875 INFO [STDOUT] at ->org.apache.catalina.core.ApplicationFilterCha ->in.internalDoFilter(ApplicationFilterChain.java:237) ->14:07:15,890 INFO [STDOUT] at ->org.apache.catalina.core.ApplicationFilterCha ->in.doFilter(ApplicationFilterChain.java:157) ->14:07:15,890 INFO [STDOUT] at ->org.apache.catalina.core.ApplicationDispatche ->r.invoke(ApplicationDispatcher.java:703) ->14:07:15,890 INFO [STDOUT] at ->org.apache.catalina.core.ApplicationDispatche ->r.processRequest(ApplicationDispatcher.java:463) ->14:07:15,890 INFO [STDOUT] at ->org.apache.catalina.core.ApplicationDispatche ->r.doForward(ApplicationDispatcher.java:398) ->14:07:15,890 INFO [STDOUT] at ->org.apache.catalina.core.ApplicationDispatche ->r.forward(ApplicationDispatcher.java:312) ->14:07:15,890 INFO [STDOUT] at ->com.liferay.portal.struts.StrutsUtil.forward( ->StrutsUtil.java:71) ->14:07:15,890 INFO [STDOUT] at ->com.liferay.portal.struts.PortalRequestProces ->sor.doForward(PortalRequestProcessor.java:151) ->14:07:15,906 INFO [STDOUT] at ->org.apache.struts.tiles.TilesRequestProcessor ->.processTilesDefinition(TilesRequestProcessor.java:237) ->14:07:15,906 INFO [STDOUT] at ->org.apache.struts.tiles.TilesRequestProcessor ->.processForwardConfig(TilesRequestProcessor.java:300) ->14:07:15,906 INFO [STDOUT] at ->com.oroad.stxx.plugin.StxxTilesRequestProcess ->or.processForwardConfig(StxxTilesRequestProcessor.java:134) ->14:07:15,906 INFO [STDOUT] at ->org.apache.struts.action.RequestProcessor.pro ->cess(RequestProcessor.java:231) ->14:07:15,906 INFO [STDOUT] at ->com.liferay.portal.struts.PortalRequestProces ->sor.process(PortalRequestProcessor.java:137) ->14:07:15,906 INFO [STDOUT] at ->org.apache.struts.action.ActionServlet.proces ->s(ActionServlet.java:1164) ->14:07:15,906 INFO [STDOUT] at ->org.apache.struts.action.ActionServlet.doGet( ->ActionServlet.java:397) ->14:07:15,921 INFO [STDOUT] at ->javax.servlet.http.HttpServlet.service(HttpSe ->rvlet.java:697) ->14:07:15,921 INFO [STDOUT] at ->com.liferay.portal.servlet.MainServlet.callPa ->rentService(MainServlet.java:304) ->14:07:15,921 INFO [STDOUT] at ->com.liferay.portal.servlet.MainServlet.servic ->e(MainServlet.java:559) ->14:07:15,921 INFO [STDOUT] at ->javax.servlet.http.HttpServlet.service(HttpSe ->rvlet.java:810) ->14:07:15,921 INFO [STDOUT] at ->org.apache.catalina.core.ApplicationFilterCha ->in.internalDoFilter(ApplicationFilterChain.java:237) ->14:07:15,921 INFO [STDOUT] at ->org.apache.catalina.core.ApplicationFilterCha ->in.doFilter(ApplicationFilterChain.java:157) ->14:07:15,921 INFO [STDOUT] at ->com.liferay.filters.secure.SecureFilter.doFil ->ter(SecureFilter.java:103) ->14:07:15,937 INFO [STDOUT] at ->org.apache.catalina.core.ApplicationFilterCha ->in.internalDoFilter(ApplicationFilterChain.java:186) ->14:07:15,937 INFO [STDOUT] at ->org.apache.catalina.core.ApplicationFilterCha ->in.doFilter(ApplicationFilterChain.java:157) ->14:07:15,937 INFO [STDOUT] at ->com.liferay.filters.compression.CompressionFi ->lter.doFilter(CompressionFilter.java:111) ->14:07:15,937 INFO [STDOUT] at ->org.apache.catalina.core.ApplicationFilterCha ->in.internalDoFilter(ApplicationFilterChain.java:186) ->14:07:15,937 INFO [STDOUT] at ->org.apache.catalina.core.ApplicationFilterCha ->in.doFilter(ApplicationFilterChain.java:157) ->14:07:15,937 INFO [STDOUT] at ->org.apache.catalina.core.StandardWrapperValve ->.invoke(StandardWrapperValve.java:214) ->14:07:15,937 INFO [STDOUT] at ->org.apache.catalina.core.StandardValveContext ->.invokeNext(StandardValveContext.java:104) ->14:07:15,953 INFO [STDOUT] at ->org.apache.catalina.core.StandardPipeline.inv ->oke(StandardPipeline.java:520) ->14:07:15,953 INFO [STDOUT] at ->org.apache.catalina.core.StandardContextValve ->.invokeInternal(StandardContextValve.java:198) ->14:07:15,953 INFO [STDOUT] at ->org.apache.catalina.core.StandardContextValve ->.invoke(StandardContextValve.java:152) ->14:07:15,953 INFO [STDOUT] at ->org.apache.catalina.core.StandardValveContext ->.invokeNext(StandardValveContext.java:104) ->14:07:15,953 INFO [STDOUT] at ->org.jboss.web.tomcat.security.SecurityAssocia ->tionValve.invoke(SecurityAssociationValve.java:72) ->14:07:15,953 INFO [STDOUT] at ->org.apache.catalina.core.StandardValveContext ->.invokeNext(StandardValveContext.java:102) ->14:07:15,953 INFO [STDOUT] at ->org.jboss.web.tomcat.security.JBossSecurityMg ->rRealm.invoke(JBossSecurityMgrRealm.java:275) ->14:07:15,968 INFO [STDOUT] at ->org.apache.catalina.core.StandardValveContext ->.invokeNext(StandardValveContext.java:102) ->14:07:15,968 INFO [STDOUT] at ->org.apache.catalina.authenticator.Authenticat ->orBase.invoke(AuthenticatorBase.java:540) ->14:07:15,968 INFO [STDOUT] at ->org.apache.catalina.core.StandardValveContext ->.invokeNext(StandardValveContext.java:102) ->14:07:15,968 INFO [STDOUT] at ->org.apache.catalina.core.StandardPipeline.inv ->oke(StandardPipeline.java:520) ->14:07:15,968 INFO [STDOUT] at ->org.apache.catalina.core.StandardHostValve.in ->voke(StandardHostValve.java:137) ->14:07:15,968 INFO [STDOUT] at ->org.apache.catalina.core.StandardValveContext ->.invokeNext(StandardValveContext.java:104) ->14:07:15,968 INFO [STDOUT] at ->org.apache.catalina.valves.ErrorReportValve.i ->nvoke(ErrorReportValve.java:117) ->14:07:15,984 INFO [STDOUT] at ->org.apache.catalina.core.StandardValveContext ->.invokeNext(StandardValveContext.java:102) ->14:07:15,984 INFO [STDOUT] at ->org.apache.catalina.core.StandardPipeline.inv ->oke(StandardPipeline.java:520) ->14:07:15,984 INFO [STDOUT] at ->org.apache.catalina.core.StandardEngineValve. ->invoke(StandardEngineValve.java:109) ->14:07:15,984 INFO [STDOUT] at ->org.apache.catalina.core.StandardValveContext ->.invokeNext(StandardValveContext.java:104) ->14:07:15,984 INFO [STDOUT] at ->org.apache.catalina.core.StandardPipeline.inv ->oke(StandardPipeline.java:520) ->14:07:15,984 INFO [STDOUT] at ->org.apache.catalina.core.ContainerBase.invoke ->(ContainerBase.java:929) ->14:07:15,984 INFO [STDOUT] at ->org.apache.coyote.tomcat5.CoyoteAdapter.servi ->ce(CoyoteAdapter.java:160) ->14:07:16,000 INFO [STDOUT] at ->org.apache.coyote.http11.Http11Processor.proc ->ess(Http11Processor.java:799) ->14:07:16,000 INFO [STDOUT] at ->org.apache.coyote.http11.Http11Protocol$Http1 ->1ConnectionHandler.processConnection(Http11Protocol.java:705) ->14:07:16,000 INFO [STDOUT] at ->org.apache.tomcat.util.net.TcpWorkerThread.ru ->nIt(PoolTcpEndpoint.java:577) ->14:07:16,000 INFO [STDOUT] at ->org.apache.tomcat.util.threads.ThreadPool$Con ->trolRunnable.run(ThreadPool.java:683) ->14:07:16,000 INFO [STDOUT] at ->java.lang.Thread.run(Thread.java:595) -> -> ->--------------------------------------------------------------------- ->To unsubscribe, e-mail: [EMAIL PROTECTED] ->For additional commands, e-mail: [EMAIL PROTECTED] -> -> -> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
