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
[code]
<!-- 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"/>
[/code]
Aqui meu arquivo Config.properties
[code]
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[/code]
Ae pessoal, vocês tem algum norte dessa bronca ae?
Desde já agradeço a compreensão de todos.