Como chamar .Jasper no SQL Server

0 respostas
B
Boa tarde, estou com um problema, no mysql consigo fazer funcionar.. mais no sql server nao da certo.. achei esse codigo aqui no forum, porem mesmo assim não deu certo..
public void DisplayReport() {
        Connection conn = null;
        try {
            Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
            String reportname = "C:/Users/Bruno/Desktop/EPI/EPI/Relatorios/EstoqueGeral.jasper";
            InputStream fis = this.getClass().getClassLoader().getResourceAsStream(reportname);
            conn = DriverManager.getConnection("jdbc:jtds:sqlserver://server-protheus:1433/EPI", "bruno", "bruno");
            HashMap map = new HashMap();
            JasperPrint print = JasperFillManager.fillReport(fis, map, conn);
            JasperViewer jv = new JasperViewer(print, false); // false Needed not to close parent frame
            jv.setVisible(true);
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            if (conn != null) {
                try {
                    conn.close();
                } catch (Exception ex) {
                    System.err.println(ex);
                }
            }
        }
    }

erro

        at java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java:2265)
        at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2278)
        at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.java:2749)
        at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:779)
        at java.io.ObjectInputStream.<init>(ObjectInputStream.java:279)
        at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:191)
        at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:361)
        at epi.fr_relatAtual.DisplayReport(fr_relatAtual.java:278)
        at epi.fr_relatAtual.jButton2ActionPerformed(fr_relatAtual.java:268)
        at epi.fr_relatAtual.access$600(fr_relatAtual.java:22)
        at epi.fr_relatAtual$8.actionPerformed(fr_relatAtual.java:171)
        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.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
        at java.awt.Component.processMouseEvent(Component.java:6288)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
        at java.awt.Component.processEvent(Component.java:6053)
        at java.awt.Container.processEvent(Container.java:2041)
        at java.awt.Component.dispatchEventImpl(Component.java:4651)
        at java.awt.Container.dispatchEventImpl(Container.java:2099)
        at java.awt.Component.dispatchEvent(Component.java:4481)
        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:4481)
        at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:643)
        at java.awt.EventQueue.access$000(EventQueue.java:84)
        at java.awt.EventQueue$1.run(EventQueue.java:602)
        at java.awt.EventQueue$1.run(EventQueue.java:600)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
        at java.awt.EventQueue$2.run(EventQueue.java:616)
        at java.awt.EventQueue$2.run(EventQueue.java:614)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:613)
        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: 5 segundos)
Criado 20 de dezembro de 2011
Respostas 0
Participantes 1