Olá membros do fórum Geplanes,
recorro a vocês para me ajudarem na instalação do Geplanes no Tomcat 7. Tendo eu já lido bastante mensagens no fórum vi que é possível instalar o Geplanes no Tomcat ao invés do JBoss.
Estou utilizando o Kubuntu 10.10, Postgres 8.4 e Tomcat 7. Conseguir realizar o dump do banco de dados para dentro do Postgres. Baixei a biblioteca jdbc do Postgres 8.4 e a copiei para a pasta lib do Tomcat e para a pasta WEB-INF/lib da aplicação geplanes.
Adicionei o arquivo geplanes_bsc_postgresql-ds.xml dentro da pasta webapps do Tomcat. Alterei o nome de usuário e senha de acordo com a instalação do banco de dados do geplanes.
Configurei o arquivo web.xml adicionando a ele as linhas abaixo:
<resource-ref>
<description>DB Connection</description>
<res-ref-name>geplanes_bsc_PostgreSQLDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>localhost_geplanes_bsc_PostgreSQLDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
<Context
reloadable="true"
debug="0"
docBase="geplanes_bsc"
path="/geplanes_bsc">
<Resource name="geplanes_bsc_PostgreSQLDS"
auth="Container"
scope="Shareable"
type="javax.sql.DataSource"
maxActive="50"
maxIdle="30"
maxWait="2000"
username="postgres"
password="Info%$)%"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/geplanes_bsc?charset=latin1"/>
<Resource name="localhost_geplanes_bsc_PostgreSQLDS"
auth="Container"
scope="Shareable"
type="javax.sql.DataSource"
maxActive="50"
maxIdle="30"
maxWait="2000"
username="postgres"
password="Info%$)%"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/geplanes_bsc?charset=latin1"/>
<Resource name="172.30.20.102_geplanes_bsc_PostgreSQLDS"
auth="Container"
scope="Shareable"
type="javax.sql.DataSource"
maxActive="50"
maxIdle="30"
maxWait="2000"
username="postgres"
password="Info%$)%"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/geplanes_bsc?charset=latin1"/>
Entretando, pessoal, quando inicio a aplicação no Tomcat e tento acessá-la pelo browser me é retornada a seguinte mensagem de log no Tomcat:
22/02/2011 11:38:43 org.apache.catalina.core.ApplicationDispatcher invoke
GRAVE: Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
at java.sql.DriverManager.getDriver(DriverManager.java:253)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at br.com.linkcom.sgm.util.JndiGeplanesFactory$1.getConnection(JndiGeplanesFactory.java:76)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1577)
at org.hibernate.loader.Loader.doQuery(Loader.java:696)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2232)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
at org.hibernate.loader.Loader.list(Loader.java:2124)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at br.com.linkcom.neo.persistence.QueryBuilder$1.doInHibernate(QueryBuilder.java:802)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:365)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:333)
at br.com.linkcom.neo.persistence.QueryBuilder.list(QueryBuilder.java:789)
at br.com.linkcom.neo.persistence.GenericDAO.findAll(GenericDAO.java:607)
at br.com.linkcom.neo.persistence.GenericDAO.findAll(GenericDAO.java:595)
at br.com.linkcom.sgm.service.ParametrosSistemaService.getParametrosSistema(ParametrosSistemaService.java:36)
at br.com.linkcom.sgm.util.GeplanesUtils.getLogoEmpresaId(GeplanesUtils.java:240)
at org.apache.jsp.login_jsp._jspService(login_jsp.java:141)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:306)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329)
at br.com.linkcom.neo.authorization.AuthenticationControlFilter.dispachError(AuthenticationControlFilter.java:320)
at br.com.linkcom.neo.authorization.AuthenticationControlFilter.doAuth(AuthenticationControlFilter.java:264)
at br.com.linkcom.neo.authorization.AuthenticationControlFilter.doFilter(AuthenticationControlFilter.java:97)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:244)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at br.com.linkcom.neo.core.web.NeoFilter.doFilterInternal(NeoFilter.java:103)
at br.com.linkcom.sgm.util.RequestFilter.doFilterInternal(RequestFilter.java:45)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:244)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:383)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:288)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
22/02/2011 11:38:43 org.apache.catalina.core.StandardWrapperValve invoke
GRAVE: Servlet.service() for servlet [sgm] in context with path [/geplanes_bsc] threw exception [org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot create JDBC driver of class '' for connect URL 'null'; nested exception is org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'] with root cause
java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
at java.sql.DriverManager.getDriver(DriverManager.java:253)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at br.com.linkcom.sgm.util.JndiGeplanesFactory$1.getConnection(JndiGeplanesFactory.java:76)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1577)
at org.hibernate.loader.Loader.doQuery(Loader.java:696)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2232)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
at org.hibernate.loader.Loader.list(Loader.java:2124)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at br.com.linkcom.neo.persistence.QueryBuilder$1.doInHibernate(QueryBuilder.java:802)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:365)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:333)
at br.com.linkcom.neo.persistence.QueryBuilder.list(QueryBuilder.java:789)
at br.com.linkcom.neo.persistence.GenericDAO.findAll(GenericDAO.java:607)
at br.com.linkcom.neo.persistence.GenericDAO.findAll(GenericDAO.java:595)
at br.com.linkcom.sgm.service.ParametrosSistemaService.getParametrosSistema(ParametrosSistemaService.java:36)
at br.com.linkcom.sgm.util.GeplanesUtils.getLogoEmpresaId(GeplanesUtils.java:240)
at org.apache.jsp.login_jsp._jspService(login_jsp.java:141)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:306)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329)
at br.com.linkcom.neo.authorization.AuthenticationControlFilter.dispachError(AuthenticationControlFilter.java:320)
at br.com.linkcom.neo.authorization.AuthenticationControlFilter.doAuth(AuthenticationControlFilter.java:264)
at br.com.linkcom.neo.authorization.AuthenticationControlFilter.doFilter(AuthenticationControlFilter.java:97)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:244)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at br.com.linkcom.neo.core.web.NeoFilter.doFilterInternal(NeoFilter.java:103)
at br.com.linkcom.sgm.util.RequestFilter.doFilterInternal(RequestFilter.java:45)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:244)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:383)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:288)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
22/02/2011 11:38:43 org.apache.catalina.core.ApplicationDispatcher invoke
GRAVE: Servlet.service() for servlet jsp threw exception
br.com.linkcom.neo.exception.NotInNeoContextException: O código não está sendo excecutado em um contexto NEO!
Classe: org.apache.jsp.error_jsp
Método: _jspService
Linha: 94
Se você estiver excecutanto em um ambiente J2EE verifique se você configurou no web.xml o filtro da classe ,
a configuração desse filtro é importante porque é ele que cria o contexto NEO
at br.com.linkcom.neo.core.standard.Neo.getRequestContext(Neo.java:116)
at br.com.linkcom.neo.core.web.NeoWeb.getRequestContext(NeoWeb.java:60)
at org.apache.jsp.error_jsp._jspService(error_jsp.java:94)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:306)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:465)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329)
at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:466)
at org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:315)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:179)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:383)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:288)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
22/02/2011 11:38:43 org.apache.catalina.core.StandardHostValve custom
GRAVE: Exception Processing ErrorPage[exceptionType=java.lang.Throwable, location=/error.jsp]
org.apache.jasper.JasperException: br.com.linkcom.neo.exception.NotInNeoContextException: O código não está sendo excecutado em um contexto NEO!
Classe: org.apache.jsp.error_jsp
Método: _jspService
Linha: 94
Se você estiver excecutanto em um ambiente J2EE verifique se você configurou no web.xml o filtro da classe ,
a configuração desse filtro é importante porque é ele que cria o contexto NEO
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:532)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:306)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:465)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329)
at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:466)
at org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:315)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:179)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:383)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:288)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: br.com.linkcom.neo.exception.NotInNeoContextException: O código não está sendo excecutado em um contexto NEO!
Classe: org.apache.jsp.error_jsp
Método: _jspService
Linha: 94
Se você estiver excecutanto em um ambiente J2EE verifique se você configurou no web.xml o filtro da classe ,
a configuração desse filtro é importante porque é ele que cria o contexto NEO
at br.com.linkcom.neo.core.standard.Neo.getRequestContext(Neo.java:116)
at br.com.linkcom.neo.core.web.NeoWeb.getRequestContext(NeoWeb.java:60)
at org.apache.jsp.error_jsp._jspService(error_jsp.java:94)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
... 22 more
Alguém poderia me ajudar com o erro ocorrido? Fico grato por quem puder me dar a solução!
Autor: Thiago Aderaldo

33 comentários
auth="Container"
scope="Shareable"
type="javax.sql.DataSource"
maxActive="50"
maxIdle="30"
maxWait="2000"
username="postgres"
password="Info%$)%"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/geplanes_bsc?charset=latin1"/> <Resource name="localhost_geplanes_bsc_PostgreSQLDS"
auth="Container"
scope="Shareable"
type="javax.sql.DataSource"
maxActive="50"
maxIdle="30"
maxWait="2000"
username="postgres"
password="Info%$)%"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/geplanes_bsc?charset=latin1"/> <Resource name="172.30.20.102_geplanes_bsc_PostgreSQLDS"
auth="Container"
scope="Shareable"
type="javax.sql.DataSource"
maxActive="50"
maxIdle="30"
maxWait="2000"
username="postgres"
password="Info%$)%"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/geplanes_bsc?charset=latin1"/> 5) Inicie o Tomcat. É isso. Espero tê-lo ajudado. Att, Rodrigo Alvarenga