Problemas de conexão

0 respostas
williambegot

Olá pessoas, estou com um problema quanto a conexão do Banco MySQL com a minha aplicação WEB.
Segue o erro que ocorre quando tento fazer login no sistema.

16:36:57,697  INFO CollectionBinder:581 - Mapping collection: portal.entidade.CercaEletronica.pontosRotaCerca -> ponto_rota_cerca
16:36:57,874  INFO NamingHelper:26 - JNDI InitialContext properties:{}
16:36:57,876  INFO DatasourceConnectionProvider:61 - Using datasource: java:comp/env/jdbc/xxxxxxx
16:36:57,897  INFO Dialect:141 - Using dialect: org.hibernate.dialect.MySQLDialect
16:36:57,903  INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
16:36:57,908  INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-le
vel cache is not recommended)
16:36:57,911  INFO SettingsFactory:134 - Automatic flush during beforeCompletion(): disabled
16:36:57,912  INFO SettingsFactory:138 - Automatic session close at end of transaction: disabled
16:36:57,921  INFO SettingsFactory:153 - Scrollable result sets: disabled
16:36:57,921  INFO SettingsFactory:161 - JDBC3 getGeneratedKeys(): disabled
16:36:57,923  INFO SettingsFactory:169 - Connection release mode: auto
16:36:57,927  INFO SettingsFactory:193 - Maximum outer join fetch depth: 2
16:36:57,928  INFO SettingsFactory:196 - Default batch fetch size: 1
16:36:57,934  INFO SettingsFactory:200 - Generate SQL with comments: disabled
16:36:57,936  INFO SettingsFactory:204 - Order SQL updates by primary key: disabled
16:36:57,938  INFO SettingsFactory:369 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
16:36:57,944  INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactory
16:36:57,945  INFO SettingsFactory:212 - Query language substitutions: {}
16:36:57,946  INFO SettingsFactory:217 - JPA-QL strict compliance: disabled
16:36:57,948  INFO SettingsFactory:222 - Second-level cache: enabled
16:36:57,950  INFO SettingsFactory:226 - Query cache: disabled
16:36:57,952  INFO SettingsFactory:356 - Cache provider: org.hibernate.cache.NoCacheProvider
16:36:57,954  INFO SettingsFactory:241 - Optimize cache for minimal puts: disabled
16:36:57,956  INFO SettingsFactory:250 - Structured second-level cache entries: disabled
16:36:57,965  INFO SettingsFactory:277 - Statistics: disabled
16:36:57,966  INFO SettingsFactory:281 - Deleted entity synthetic identifier rollback: disabled
16:36:57,967  INFO SettingsFactory:296 - Default entity-mode: pojo
16:36:58,003  INFO SessionFactoryImpl:161 - building session factory
16:36:58,554  INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
16:36:58,605 ERROR ExcecaoInterceptor:33 - Erro nÒo tratado do portal
java.lang.UnsupportedOperationException: Not supported by BasicDataSource
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1062)
        at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:66)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
        at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
        at portal.action.interceptor.HibernateOpenSessionInViewInterceptor.intercept(HibernateOpenSessionInViewInterceptor.java:25)
        at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
        at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
        at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
        at portal.action.interceptor.ExcecaoInterceptor.intercept(ExcecaoInterceptor.java:30)
        at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
        at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
        at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
        at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:50)
        at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:504)
        at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:422)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:662)

A exceção é gerada quando tento fazer o Login no Sistema!

Talvez o erro seja tolo...
Já verifiquei todas as chamas dentro do meu código, entre eles arquivos de configurações e até o Context.xml do Tomcat 6.0

no context.xml

<Context>

    <!-- Default set of monitored resources -->
    <WatchedResource>WEB-INF/web.xml</WatchedResource>

	<Resource
	name="jdbc/xxxxx"
	Auth="Container"
	type="javax.sql.DataSource"
	username="root"
	password="bluesat"
	driverClassName="com.mysql.jdbc.Driver"                              
	url="jdbc:mysql://127.0.0.1/xxxxxxx?autoReconnect=true"
	maxActive="10000"
	maxIdle="5000"/>

</Context>

Aqui meu arquivo Config.properties

hibernate.connection.username     = root
hibernate.connection.password     = bluesat
hibernate.connection.url   = jdbc:mysql://127.0.0.1/xxxxxx?autoReconnect=true
hibernate.connection.driver_class = com.mysql.jdbc.Driver

hibernate.dialect = org.hibernate.dialect.MySQLDialect

hibernate.connection.autoReconnect                     = true
hibernate.connection.autoReconnectForPools             = true
hibernate.connection.is-connection-validation-required = true

hibernate.c3p0.min_size         = 5
hibernate.c3p0.max_size         = 300
hibernate.c3p0.timeout          = 300
hibernate.c3p0.max_statements   = 0
hibernate.c3p0.idle_test_period = 100
hibernate.maxAdministrativeTaskTime = 50

Ae pessoal, vocês tem algum norte dessa bronca ae?

Desde já agradeço a compreensão de todos.

Criado 9 de agosto de 2011
Respostas 0
Participantes 1