杰表技术论坛 - Powered by Discuz! Board

标题: 想问下简表连接Oracle ORC! [打印本页]

作者: wunaia 时间: 2011-9-20 16:35 标题: 想问下简表连接Oracle ORC!

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

作者: admin 时间: 2011-9-20 17:08

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

作者: wunaia 时间: 2011-9-21 10:45

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

作者: support2 时间: 2011-9-22 11:36

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

作者: wunaia 时间: 2011-9-22 15:00

内网机器没有截图工具把错误信息贴下.
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 时间: 2011-9-22 15:02

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

作者: admin 时间: 2011-9-23 11:50

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

作者: wunaia 时间: 2011-9-23 14:22

lib下就一个 Oracle10g的包啊

作者: frostytop 时间: 2011-12-1 14:11 标题: 在Oracle下真是有问题吗？不支持别名，报一大堆错

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

作者: wunaia 时间: 2011-12-12 11:25

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

欢迎光临杰表技术论坛 (http://bbs.jatools.com/)