wunaia

简表支持吗?现在用的这个 报表就显示不正常.

admin

怎么个不正常，jdbc驱动，是不是正确？

wunaia

我用设计器直接连集群进行测试.进去后  数据集就出问题了,第一次预览有数据 ,第二次的时候就说连不上数据库.

support2

有啥出错信息，截个图上来嘛。

wunaia

内网机器 没有截图工具 把错误信息贴下.
sql 出错.Io 异常: The Network Adapter could not establish the connection

java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at jatools.data.reader.sql.ConnectionPools.getConnection(ConnectionPools.java:67)
        at jatools.data.reader.sql.Connection.getConnection(Connection.java:211)
        at jatools.data.reader.sql.SqlReader.getConnection2(SqlReader.java:338)
        at jatools.data.reader.sql.SqlReader.readStart(SqlReader.java:217)
        at jatools.designer.data.DatasetTable.setDataSet(DatasetTable.java:82)
        at jatools.designer.data.DatasetPreviewer$1.windowOpened(DatasetPreviewer.java:91)
        at java.awt.AWTEventMulticaster.windowOpened(Unknown Source)
        at java.awt.Window.processWindowEvent(Unknown Source)
        at javax.swing.JDialog.processWindowEvent(Unknown Source)
        at java.awt.Window.processEvent(Unknown Source)
        at java.awt.Component.dispatchEventImpl(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.pumpOneEventForFilters(Unknown Source)
        at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
        at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
        at java.awt.Dialog$1.run(Unknown Source)
        at java.awt.Dialog$3.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.awt.Dialog.show(Unknown Source)
        at jatools.designer.data.DatasetPreviewer.show(DatasetPreviewer.java:211)
        at jatools.designer.variable.action.DataSourceAction.preview(DataSourceAction.java:214)
        at jatools.designer.variable.action.DataSourceAction.actionPerformed(DataSourceAction.java:105)
        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.AbstractButton.doClick(Unknown Source)
        at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
        at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
        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.pumpOneEventForFilters(Unknown Source)
        at java.awt.EventDispatchThread.pumpEventsForFilter(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)

Io 异常: The Network Adapter could not establish the connection

wunaia

对一个 select * from table 的语句,预览数据集的时候,有时候数据就显示出来了,有时候就抛这个异常了.

admin

我觉得，你这个，还是驱动不配套的问题。

wunaia

  lib下就一个 Oracle10g的包啊

frostytop

在Oracle下真是有问题吗？不支持别名，报一大堆错

wunaia

http://blog.vsharing.com/songtao1971/A730963.html  RAC的问题大概明白了,先找数据库的人去改改.