Discussoes de Programacao e Tecnologia

Problemas com banco de dados no IReports

9 respostas
Vinicius_Sartori
Vinicius_Sartori

eu estou utilizando o iReports, e estou tentando configurar ele como mandam os tutoriais, e mesmo assim está dando erro

[img]http://images.cjb.net/fc139.png[/img]

Abaixo da Tela o Erro:

Exceção
 

Message:
    java.sql.SQLException: Illegal connection port value 'mysql:'
Level:
    SEVERE
Stack Trace:
    com.mysql.jdbc.Connection.createNewIO(Connection.java:2533)
    com.mysql.jdbc.Connection.<init>(Connection.java:1474)
    com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
    it.businesslogic.ireport.connection.JDBCConnection.getConnection(JDBCConnection.java:105)
    it.businesslogic.ireport.connection.JDBCConnection.test(JDBCConnection.java:404)
    it.businesslogic.ireport.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:322)
    it.businesslogic.ireport.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:24)
    it.businesslogic.ireport.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:274)
    javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
    java.awt.Component.processMouseEvent(Unknown Source)
    javax.swing.JComponent.processMouseEvent(Unknown Source)
    java.awt.Component.processEvent(Unknown Source)
    java.awt.Container.processEvent(Unknown Source)
    java.awt.Component.dispatchEventImpl(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Window.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.EventQueue.dispatchEvent(Unknown Source)
    java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.Dialog$1.run(Unknown Source)
    java.awt.Dialog$3.run(Unknown Source)
    java.security.AccessController.doPrivileged(Native Method)
    java.awt.Dialog.show(Unknown Source)
    java.awt.Component.show(Unknown Source)
    java.awt.Component.setVisible(Unknown Source)
    java.awt.Window.setVisible(Unknown Source)
    java.awt.Dialog.setVisible(Unknown Source)
    it.businesslogic.ireport.gui.ConnectionsDialog.jButtonModifyParameterActionPerformed(ConnectionsDialog.java:514)
    it.businesslogic.ireport.gui.ConnectionsDialog.jTableParametersMouseClicked(ConnectionsDialog.java:447)
    it.businesslogic.ireport.gui.ConnectionsDialog.access$100(ConnectionsDialog.java:53)
    it.businesslogic.ireport.gui.ConnectionsDialog$5.mouseClicked(ConnectionsDialog.java:196)
    java.awt.AWTEventMulticaster.mouseClicked(Unknown Source)
    java.awt.Component.processMouseEvent(Unknown Source)
    javax.swing.JComponent.processMouseEvent(Unknown Source)
    java.awt.Component.processEvent(Unknown Source)
    java.awt.Container.processEvent(Unknown Source)
    java.awt.Component.dispatchEventImpl(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Window.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.EventQueue.dispatchEvent(Unknown Source)
    java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.Dialog$1.run(Unknown Source)
    java.awt.Dialog$3.run(Unknown Source)
    java.security.AccessController.doPrivileged(Native Method)
    java.awt.Dialog.show(Unknown Source)
    java.awt.Component.show(Unknown Source)
    java.awt.Component.setVisible(Unknown Source)
    java.awt.Window.setVisible(Unknown Source)
    java.awt.Dialog.setVisible(Unknown Source)
    it.businesslogic.ireport.gui.ConnectionsDialog.setVisible(ConnectionsDialog.java:623)
    it.businesslogic.ireport.gui.MainFrame.jMenuItemConnectionsActionPerformed(MainFrame.java:6276)
    it.businesslogic.ireport.gui.MainFrame.access$13800(MainFrame.java:101)
    it.businesslogic.ireport.gui.MainFrame$175.actionPerformed(MainFrame.java:3606)
    javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    javax.swing.AbstractButton.doClick(Unknown Source)
    javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
    javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
    java.awt.Component.processMouseEvent(Unknown Source)
    javax.swing.JComponent.processMouseEvent(Unknown Source)
    java.awt.Component.processEvent(Unknown Source)
    java.awt.Container.processEvent(Unknown Source)
    java.awt.Component.dispatchEventImpl(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Window.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.EventQueue.dispatchEvent(Unknown Source)
    java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.run(Unknown Source)
Alura Análise de Dados Desenvolva hard skills técnicas e soft skills essenciais para trabalhar de forma colaborativa,...

9 Respostas

fpavao
fpavao

Vc colocou o driver na lib do ireport ???

Vinicius_Sartori
Vinicius_Sartori

Aham já coloquei la no Classpath foi a primeira coisa que eu fiz, mais mesmo assim da este erro.

gilberto_oliveira
gilberto_oliveira

Ei amigo,

acho que o problema está no campo ‘caminho do JDBC’,

onde tá escrito
jdbc:mysql://jdbc:mysql://localhost/teste/MYDATABASE

deveria ser assim:
jdbc:mysql://localhost/teste/MYDATABASE

flw.

Vinicius_Sartori
Vinicius_Sartori

Já tentei mais continua dando erro

Exceção
 

Message:
    java.lang.NullPointerException
Level:
    SEVERE
Stack Trace:
    it.businesslogic.ireport.connection.JDBCConnection.getConnection(JDBCConnection.java:105)
    it.businesslogic.ireport.connection.JDBCConnection.test(JDBCConnection.java:404)
    it.businesslogic.ireport.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:322)
    it.businesslogic.ireport.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:24)
    it.businesslogic.ireport.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:274)
    javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
    java.awt.Component.processMouseEvent(Unknown Source)
    javax.swing.JComponent.processMouseEvent(Unknown Source)
    java.awt.Component.processEvent(Unknown Source)
    java.awt.Container.processEvent(Unknown Source)
    java.awt.Component.dispatchEventImpl(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Window.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.EventQueue.dispatchEvent(Unknown Source)
    java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.Dialog$1.run(Unknown Source)
    java.awt.Dialog$3.run(Unknown Source)
    java.security.AccessController.doPrivileged(Native Method)
    java.awt.Dialog.show(Unknown Source)
    java.awt.Component.show(Unknown Source)
    java.awt.Component.setVisible(Unknown Source)
    java.awt.Window.setVisible(Unknown Source)
    java.awt.Dialog.setVisible(Unknown Source)
    it.businesslogic.ireport.gui.ConnectionsDialog.jButtonModifyParameterActionPerformed(ConnectionsDialog.java:514)
    it.businesslogic.ireport.gui.ConnectionsDialog.access$300(ConnectionsDialog.java:53)
    it.businesslogic.ireport.gui.ConnectionsDialog$7.actionPerformed(ConnectionsDialog.java:232)
    javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
    java.awt.Component.processMouseEvent(Unknown Source)
    javax.swing.JComponent.processMouseEvent(Unknown Source)
    java.awt.Component.processEvent(Unknown Source)
    java.awt.Container.processEvent(Unknown Source)
    java.awt.Component.dispatchEventImpl(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Window.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.EventQueue.dispatchEvent(Unknown Source)
    java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.Dialog$1.run(Unknown Source)
    java.awt.Dialog$3.run(Unknown Source)
    java.security.AccessController.doPrivileged(Native Method)
    java.awt.Dialog.show(Unknown Source)
    java.awt.Component.show(Unknown Source)
    java.awt.Component.setVisible(Unknown Source)
    java.awt.Window.setVisible(Unknown Source)
    java.awt.Dialog.setVisible(Unknown Source)
    it.businesslogic.ireport.gui.ConnectionsDialog.setVisible(ConnectionsDialog.java:623)
    it.businesslogic.ireport.gui.MainFrame.jMenuItemConnectionsActionPerformed(MainFrame.java:6276)
    it.businesslogic.ireport.gui.MainFrame.access$13800(MainFrame.java:101)
    it.businesslogic.ireport.gui.MainFrame$175.actionPerformed(MainFrame.java:3606)
    javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    javax.swing.AbstractButton.doClick(Unknown Source)
    javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
    javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
    java.awt.Component.processMouseEvent(Unknown Source)
    javax.swing.JComponent.processMouseEvent(Unknown Source)
    java.awt.Component.processEvent(Unknown Source)
    java.awt.Container.processEvent(Unknown Source)
    java.awt.Component.dispatchEventImpl(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Window.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.EventQueue.dispatchEvent(Unknown Source)
    java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.run(Unknown Source)
gilberto_oliveira
gilberto_oliveira

esse erro aí ocorre no seu aplicativo ou no ireport? se for no aplicativo posta o código onde tá o erro.

Vinicius_Sartori
Vinicius_Sartori

o Erro é no próprio ireports

Segue abaixo uma screenshot…

gilberto_oliveira
gilberto_oliveira

Verifica estas coisinhas por favor:

  • Vc tem o mysql instalado, configurado, e executando no momento?
  • Vc já criou o banco de dados no mysql?
  • no campo 'caminho do JDBC’
    onde tá escrito
    jdbc:mysql://localhost/teste/MYDATABASE

deveria ser assim: (não tinha visto isso aqui também) :XD:
jdbc:mysql://localhost/MYDATABASE

onde MYDATABASE = é o nome do seu banco (que vc criou no mysql e que está tentando se conectar agora).

  • vc preencheu o nome do usuário?
  • vc preencheu a senha?

Se ainda assim não der certo, tenta outro tutorial. No começo tive dor de cabeça com o ireport mas depois foi tranquilo :roll:

Vinicius_Sartori
Vinicius_Sartori

você não teria algum tutorial para me recomendar, por que mesmo com as suas dicas ele continua com o mesmo erro brother

gilberto_oliveira
gilberto_oliveira

tenho sim,

o melhor que eu achei:

na web tem muitos, e muitos bons também.

Fique a vontade para procurar no google também :mrgreen: busca por ireport, tutorial ireport, etc

Sugestão:
pq não faz assim, lê vários tutoriais para pegar uma visão geral e vai montando um o seu tutorial, depois quando tiver pronto vc tenta gerar os relatórios. se funfa legal publica o seu tutorial pq pode ajudar outras pessoas.

Acho que é o suficiente, bom até mais!

Criado 3 de junho de 2008
Ultima resposta 3 de jun. de 2008
Respostas 9
Participantes 3

Topicos relacionados

Componente de forum 4 respostas Consultar CPF pelo nome na Receita Federal 5 respostas Pegadinhas que se fazem com os pobres estagiários 62 respostas [Resolvido] Como comparar Strings em C? 6 respostas Converter pixels para centímetros 9 respostas
Alura POO: o que é programação orientada a objetos? Aprenda os conceitos básicos da programação orientada a objetos, como classes, objetos, herança, encapsulamento e polimorfismo, com exemplos.
Casa do Codigo Casa do Codigo — Livros de tecnologia Livros de programacao, infraestrutura e inovacao