Ola amigos estou trabalhando em um sistema legado que é usado o java 1.4, e esse sistema rodava bunitinho em uma maquina com XP 32bits mas recentemente na empresa as maquinas foram trocadas por win7 64bits e as configurações foram refeitas de acordo como estava no XP 32bits, mas está dando erro sempre que vou subir o servidor jboss.
aparentemente erro na conexão com o banco que é um oracle, eu tive muito problema em fazer o PLSql conectar com o banco oracle, estava dando erro no momento de logar mas instalei todos os programas fora da pasta Arquivos de Programas(x86) porque estava dando conflito e executei o PLSql sempre como administrador e deu certo mas direto na aplicção está dando erro ainda.
parte do erro:
Caused by: java.sql.SQLException: Violação de protocolo
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
at oracle.jdbc.ttc7.O3log.receive2nd(O3log.java:535)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:279)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:365)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:547)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:347)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:171)
... 29 more
15:32:06,871 ERROR [componenteSistema] SistemaImpl.consultarAtributosConfiguracao(dadosVerificados): br.com.prefeituras.util.comum.exception.CpqdException: SistemaDAOImpl.consultarAtributosConfiguracao(): net.sf.hibernate.exception.GenericJDBCException: Cannot open connection
15:32:06,871 ERROR [componenteUtil] JobValidarAmbiente.executa(): br.com.prefeituras.util.comum.exception.CpqdException: SistemaDAOImpl.consultarAtributosConfiguracao(): net.sf.hibernate.exception.GenericJDBCException: Cannot open connection
15:35:00,018 INFO [componenteUtil] JobValidarAmbiente.executa():
15:35:00,109 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Violação de protocolo)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:565)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:250)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:491)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:301)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59)
at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:292)
at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3373)
at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3333)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:67)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:784)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
at br.com.prefeituras.util.app.hibernate.persistencia.GenericPersistenceImpl.getList(GenericPersistenceImpl.java:362)
at br.com.prefeituras.componentes.sistema.app.dao.impl.SistemaDAOImpl.consultarAtributosConfiguracao(SistemaDAOImpl.java:135)
at br.com.prefeituras.componentes.sistema.app.pojo.SistemaImpl.consultarAtributosConfiguracao(SistemaImpl.java:321)
at br.com.prefeituras.componentes.sistema.comum.service.provider.ServiceProviderSistema.consultarAtributosConfiguracao(ServiceProviderSistema.java:174)
at br.com.prefeituras.prp.componenteSeguranca.app.job.impl.JobValidarAmbiente.executa(JobValidarAmbiente.java:26)
at br.com.prefeituras.util.app.job.provider.JobAdapter.execute(JobAdapter.java:28)
at org.quartz.core.JobRunShell.run(JobRunShell.java:191)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)
Caused by: java.sql.SQLException: Violação de protocolo
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
at oracle.jdbc.ttc7.O3log.receive2nd(O3log.java:535)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:279)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:365)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:547)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:347)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:171)
... 29 more
15:35:00,109 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: null
15:35:00,109 ERROR [JDBCExceptionReporter] Could not create connection; - nested throwable: (java.sql.SQLException: Violação de protocolo); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Violação de protocolo))
15:35:00,109 ERROR [STDERR] net.sf.hibernate.exception.GenericJDBCException: Cannot open connection
at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90)
at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79)
at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at net.sf.hibernate.impl.BatcherImpl.convert(BatcherImpl.java:328)
at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:295)
at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3373)
at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3333)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:67)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:784)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
at br.com.prefeituras.util.app.hibernate.persistencia.GenericPersistenceImpl.getList(GenericPersistenceImpl.java:362)
at br.com.prefeituras.componentes.sistema.app.dao.impl.SistemaDAOImpl.consultarAtributosConfiguracao(SistemaDAOImpl.java:135)
at br.com.prefeituras.componentes.sistema.app.pojo.SistemaImpl.consultarAtributosConfiguracao(SistemaImpl.java:321)
at br.com.prefeituras.componentes.sistema.comum.service.provider.ServiceProviderSistema.consultarAtributosConfiguracao(ServiceProviderSistema.java:174)
at br.com.prefeituras.prp.componenteSeguranca.app.job.impl.JobValidarAmbiente.executa(JobValidarAmbiente.java:26)
at br.com.prefeituras.util.app.job.provider.JobAdapter.execute(JobAdapter.java:28)
at org.quartz.core.JobRunShell.run(JobRunShell.java:191)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)
Caused by: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Violação de protocolo); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Violação de protocolo))
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)
at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59)
at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:292)
... 19 more
Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Violação de protocolo)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:565)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:250)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:491)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:301)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
... 21 more
Caused by: java.sql.SQLException: Violação de protocolo
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
at oracle.jdbc.ttc7.O3log.receive2nd(O3log.java:535)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:279)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:365)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:547)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:347)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:171)
... 29 more
15:35:00,109 ERROR [componenteSistema] SistemaImpl.consultarAtributosConfiguracao(dadosVerificados): br.com.prefeituras.util.comum.exception.CpqdException: SistemaDAOImpl.consultarAtributosConfiguracao(): net.sf.hibernate.exception.GenericJDBCException: Cannot open connection
15:35:00,109 ERROR [componenteUtil] JobValidarAmbiente.executa(): br.com.prefeituras.util.comum.exception.CpqdException: SistemaDAOImpl.consultarAtributosConfiguracao(): net.sf.hibernate.exception.GenericJDBCException: Cannot open connection
15:40:00,016 INFO [componenteUtil] JobValidarAmbiente.executa():
15:40:00,217 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Violação de protocolo)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:565)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:250)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:491)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:301)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59)
at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:292)
at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3373)
at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3333)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:67)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:784)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
at br.com.prefeituras.util.app.hibernate.persistencia.GenericPersistenceImpl.getList(GenericPersistenceImpl.java:362)
at br.com.prefeituras.componentes.sistema.app.dao.impl.SistemaDAOImpl.consultarAtributosConfiguracao(SistemaDAOImpl.java:135)
at br.com.prefeituras.componentes.sistema.app.pojo.SistemaImpl.consultarAtributosConfiguracao(SistemaImpl.java:321)
at br.com.prefeituras.componentes.sistema.comum.service.provider.ServiceProviderSistema.consultarAtributosConfiguracao(ServiceProviderSistema.java:174)
at br.com.prefeituras.prp.componenteSeguranca.app.job.impl.JobValidarAmbiente.executa(JobValidarAmbiente.java:26)
at br.com.prefeituras.util.app.job.provider.JobAdapter.execute(JobAdapter.java:28)
at org.quartz.core.JobRunShell.run(JobRunShell.java:191)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)