Bom dia, estou com erro na geração de relatório com iReport no NetBeans e banco de dados SQLServer 2008.
A aplicação roda normalmente, com seus métodos de alteração, exclusão, inserção, mas ao gerar o relatório dá o erro no final da mensagem.
Já configurei o SQLServer com a porta 1433 e liberei no firewall, pois acesso o banco no servidor.
Conexão
[code]
/*
- Uma fabrica de conexoes.
-
@author David Buzatto (help)
*/
package iReport;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ConnectionFactory {
static {
try {
Class.forName( "com.microsoft.sqlserver.jdbc.SQLServerDriver" );
} catch ( ClassNotFoundException exc ) {
exc.printStackTrace();
}
}
public static Connection getConnection(
String url,
String usuario,
String senha ) throws SQLException {
return DriverManager.getConnection( url, usuario, senha );
}
public static Connection getUniocupsystemConnection() throws SQLException {
return getConnection("jdbc:sqlserver://192.168.0.107:1433/UniOcupSystem","usuario","senha");
}
}[/code]
Exibir relatórios:
[code]
InputStream inputStream = getClass().getResourceAsStream
("/iReport/RelatorioAcidente.jasper");
Map parametros = new HashMap();
try {
ReportUtils.openReport("Acidente", inputStream, parametros,
ConnectionFactory.getUniocupsystemConnection());
}
catch(SQLException exc){
exc.printStackTrace();
}
catch (JRException exc){
exc.printStackTrace();
}
} [/code]
ERRO:
com.microsoft.sqlserver.jdbc.SQLServerException: The port number 1433/UniOcupSystem is not valid.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:580)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:841)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at iReport.ConnectionFactory.getConnection(ConnectionFactory.java:31)
at iReport.ConnectionFactory.getUniocupsystemConnection(ConnectionFactory.java:35)
at telas.Principal.RelatórioAcidentesActionPerformed(Principal.java:525)
at telas.Principal.access$2800(Principal.java:17)
at telas.Principal$29.actionPerformed(Principal.java:371)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1223)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1264)
at java.awt.Component.processMouseEvent(Component.java:6267)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6032)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4630)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Tenta assim:
jdbc:microsoft:sqlserver://192.168.0.107:1433;databaseName=UniOcupSystem;selectMethod=cursor;
Inseri a linha conforme você mencionou, mas dá erro,
pois a conexão requer 3 argumentos:
[code]
public static Connection getConnection(
String url,
String usuario,
String senha ) throws SQLException {
return DriverManager.getConnection( url, usuario, senha );[/code]
então não sei como modificar para que fique correto sua sintaxe.
Aguardo,
Aline
Aquela linha é só a url do teu parâmetro:
DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.0.107:1433;databaseName=UniOcupSystem;selectMethod=cursor", usuario, senha );
após a alteração deu o seguinte erro, o .jar log4j já está no meu projeto.
log4j:WARN No appenders could be found for logger (net.sf.jasperreports.extensions.ExtensionsEnvironment).
log4j:WARN Please initialize the log4j system properly.
Exception in thread "AWT-EventQueue-0" java.lang.AbstractMethodError: org.apache.crimson.tree.ElementNode.getTextContent()Ljava/lang/String;
at net.sf.jasperreports.engine.fonts.SimpleFontExtensionHelper.parseFontFamily(SimpleFontExtensionHelper.java:233)
at net.sf.jasperreports.engine.fonts.SimpleFontExtensionHelper.parseFontFamilies(SimpleFontExtensionHelper.java:204)
at net.sf.jasperreports.engine.fonts.SimpleFontExtensionHelper.loadFontFamilies(SimpleFontExtensionHelper.java:173)
at net.sf.jasperreports.engine.fonts.SimpleFontExtensionHelper.loadFontFamilies(SimpleFontExtensionHelper.java:142)
at net.sf.jasperreports.engine.fonts.SimpleFontExtensionsRegistryFactory.createRegistry(SimpleFontExtensionsRegistryFactory.java:63)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.instantiateRegistry(DefaultExtensionsRegistry.java:238)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:213)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:162)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getRegistries(DefaultExtensionsRegistry.java:132)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getExtensions(DefaultExtensionsRegistry.java:104)
at net.sf.jasperreports.engine.util.JRStyledTextParser.<clinit>(JRStyledTextParser.java:81)
at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:182)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:77)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:87)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:57)
at net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:142)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:52)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:378)
at Relatorio.Utils.ReportUtils.openReport(ReportUtils.java:29)
at telas.Principal.RelatórioAcidentesActionPerformed(Principal.java:525)
at telas.Principal.access$2800(Principal.java:17)
at telas.Principal$29.actionPerformed(Principal.java:371)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1223)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1264)
at java.awt.Component.processMouseEvent(Component.java:6267)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6032)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4630)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
CONSTRUÍDO COM SUCESSO (tempo total: 14 segundos)
ola [color=red][size=18] alinelozano[/size][/color]
geralmente isso:
[quote]log4j:WARN No appenders could be found for logger (net.sf.jasperreports.extensions.ExtensionsEnvironment).
log4j:WARN Please initialize the log4j system properly. [/quote]
é configuração do log4j
vê se ajuda:
http://www.guj.com.br/posts/list/200228.java
http://javafree.uol.com.br/viewtopic.jbb?p=189898&page=1
Nossa, já havia lido todos esses links e mais alguns e nada que me ajudou ou que eu tenha entendido.
:shock:
Só uma dica: o plugin do iReport pro NetBeans vem quebrado, com libs faltando e/ou corrompidas.
No próprio blog do David Buzatto ele explica essa substituição que precisas fazer, com relação às libs.
Provavelmente é isso…
Bom dia, 
Depois da dica do [color=blue]leoramos[/color], refiz toda a conexão e plugins do iReport conforme o blog do David Buzatto, e realmente era isso, agora está funcionando certinho.
Muito obrigada à todos