Hi All,
Hi I have one table DataSheet in oracle 9i with two column
NETOBJECTID and EVENT_DATE_TIME.
What a strange problem is coming,
ResultSet rs = statement.executeQuery("SELECT NETOBJECTID FROM DataSheet");
query is working fine through
JDBC api, and
ResultSet rs = statement.executeQuery("SELECT NETOBJECTID,EVENT_DATE_TIME FROM DataSheet");
query is not working throught JDBC api, while this is working fine directly in oracle sql client .
Is EVENT_DATE_TIME i any keyword in
java When we include it into query this gives the following exception
java.sql.SQLException: ORA-03115: unsupported network datatype or representation
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.v8Odscrarr.receive(v8Odscrarr.java:191)
at oracle.jdbc.ttc7.TTC7Protocol.describe(TTC7Protocol.java:586)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:647)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)*********QUERY=SELECT EVENT_DATE_TIME,NETOBJECTID,ALARM_ID,SEVERITY,CATEGORY,SOURCE,GROUP_NAME,ADDITIONAL_INFO,BACKEUPOBJECT,BACKEDUPSTATUS,CAUSE,
REPAIRACTION_PROPOSED,SPECIFIC_PROBLEMS,ALARM_STATE,ASSIGNEDTO,
OPERATOR_NAME,THRESHOLD_INFO,TREND_INDICATION,ESCALATED_FROM,ESCALATED_TO,STATECHANGEDEF FROM Alarm_Table WHERE Threshold_Info is not null
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:538)
at com.sisl.snms.server.util.db.DBUtil.getData(DBUtil.java:485)
at com.sisl.snms.server.util.db.DBUtil.getColumnData(DBUtil.java:824)
at com.sisl.snms.server.util.db.DBManager.getTcas(DBManager.java:1986)
at com.sisl.db.Demo.main(Demo.java:146)
Regards -
Vikas Kumar Sahu
[ August 29, 2005: Message edited by: Bear Bibeault ]
[edited to add line break]
[ August 29, 2005: Message edited by: Jeanne Boyarsky ]
