Erro com Banco de Dados

1 resposta
M

Olá pessoal!
Estou tentando rodar meu arquivo .jar em um micro e o banco de dados está em outro micro, porém ocorre o seguinte erro:
Banco de Dados: PosteGreSQL 8

<blockquote>C:\Transferência_Zu\Sistema SSTintas>java -jar sstintas.jar

org.postgresql.util.PSQLException: ConexÒo negada. Verifique se o nome da maquina e a porta estão corretos e se o postmaster está aceitando conex§es TCP/IP.

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Conne

ctionFactoryImpl.java:122)

at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactor

y.java:65)

at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Conn

ection.java:117)

at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Conn

ection.java:30)

at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)

at org.postgresql.Driver.connect(Driver.java:195)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at br.com.sstintas.modelo.bd.GerenciadorBD.getConexao(GerenciadorBD.java

:19)

at br.com.sstintas.modelo.bd.GerenciadorBDFuncionario.consultaUsuarioSen

ha(GerenciadorBDFuncionario.java:293)

at br.com.sstintas.view.AcessoView$2.actionPerformed(AcessoView.java:154

)

at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)

at javax.swing.DefaultButtonModel.setPressed(Unknown Source)

at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Sour

ce)

at java.awt.Component.processMouseEvent(Unknown Source)

at javax.swing.JComponent.processMouseEvent(Unknown Source)

at java.awt.Component.processEvent(Unknown Source)

at java.awt.Container.processEvent(Unknown Source)

at java.awt.Component.dispatchEventImpl(Unknown Source)

at java.awt.Container.dispatchEventImpl(Unknown Source)

at java.awt.Component.dispatchEvent(Unknown Source)

at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

at java.awt.Container.dispatchEventImpl(Unknown Source)

at java.awt.Window.dispatchEventImpl(Unknown Source)

at java.awt.Component.dispatchEvent(Unknown Source)

at java.awt.EventQueue.dispatchEvent(Unknown Source)

at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.net.ConnectException: Connection refused: connect

at java.net.PlainSocketImpl.socketConnect(Native Method)

at java.net.PlainSocketImpl.doConnect(Unknown Source)

at java.net.PlainSocketImpl.connectToAddress(Unknown Source)

at java.net.PlainSocketImpl.connect(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at java.net.Socket.<init>(Unknown Source)

at java.net.Socket.<init>(Unknown Source)

at org.postgresql.core.PGStream.<init>(PGStream.java:58)

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Conne

ctionFactoryImpl.java:77) 34 more

Exception in thread AWT-EventQueue-0 java.lang.NullPointerException

at br.com.sstintas.modelo.bd.GerenciadorBDFuncionario.consultaUsuarioSen

ha(GerenciadorBDFuncionario.java:293)

at br.com.sstintas.view.AcessoView$2.actionPerformed(AcessoView.java:154

)

at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)

at javax.swing.DefaultButtonModel.setPressed(Unknown Source)

at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Sour

ce)

at java.awt.Component.processMouseEvent(Unknown Source)

at javax.swing.JComponent.processMouseEvent(Unknown Source)

at java.awt.Component.processEvent(Unknown Source)

at java.awt.Container.processEvent(Unknown Source)

at java.awt.Component.dispatchEventImpl(Unknown Source)

at java.awt.Container.dispatchEventImpl(Unknown Source)

at java.awt.Component.dispatchEvent(Unknown Source)

at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

at java.awt.Container.dispatchEventImpl(Unknown Source)

at java.awt.Window.dispatchEventImpl(Unknown Source)

at java.awt.Component.dispatchEvent(Unknown Source)

at java.awt.EventQueue.dispatchEvent(Unknown Source)

at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)</blockquote>

Se alguém puder me ajudar agradeço! :roll:

1 Resposta

D

Coleguinha, o erro está bem transparente…
1 - verifique qual o ip q. vc colocou na String de conexao do banco
2 - Se o ip estiver correto, verifique as permissoes do psql sobre acesso externo (de outra máquina na mesma rede, de outra máquina fora da rede)
3 - se o erro persistir, poste aqui novamente…

[]'s

Criado 23 de agosto de 2006
Ultima resposta 23 de ago. de 2006
Respostas 1
Participantes 2