Message4985

Author etelstan
Recipients etelstan
Date 2009-08-04.11:36:21
SpamBayes Score 0.00083802606
Marked as misclassified No
Message-id <1249385782.43.0.811608367217.issue1421@psf.upfronthosting.co.za>
In-reply-to
Content
Trying to execute select INTERVAL type column causes exception:

Java Traceback:
java.sql.SQLException: error getting index [1], type [-104]
	at com.ziclix.python.sql.DataHandler.getPyObject(DataHandler.java:307)
	at
com.ziclix.python.sql.FilterDataHandler.getPyObject(FilterDataHandler.java:110)
	at
com.ziclix.python.sql.JDBC20DataHandler.getPyObject(JDBC20DataHandler.java:151)
	at com.ziclix.python.sql.Fetch.createResult(Fetch.java:436)
	at com.ziclix.python.sql.Fetch.createResults(Fetch.java:411)
	at com.ziclix.python.sql.StaticFetch.add(Fetch.java:519)
	at com.ziclix.python.sql.StaticFetch.add(Fetch.java:505)
	at com.ziclix.python.sql.PyStatement.execute(PyStatement.java:219)
	at com.ziclix.python.sql.PyCursor.execute(PyCursor.java:612)
	at com.ziclix.python.sql.PyCursor.execute(PyCursor.java:584)
	at com.ziclix.python.sql.CursorFunc.__call__(PyCursor.java:912)
	at org.python.core.PyObject.__call__(PyObject.java:401)
...

Environment: 
Oracle 10.2, Oracle JDBC driver 9.0

Selected table DDL:
CREATE TABLE meeting (
    prj_id         VARCHAR(16) NOT NULL,
    item_no        NUMBER(38) NOT NULL,
    meeting_seq    NUMBER(38),
    starts_at      TIMESTAMP WITH TIME ZONE,
    duration       INTERVAL DAY TO SECOND,
    CONSTRAINT meeting_pk
      PRIMARY KEY (prj_id,item_no),
    CONSTRAINT meeting_uk
      UNIQUE (meeting_seq)
);

Selected table data:
INSERT INTO meeting (prj_id, item_no, meeting_seq, starts_at, duration)
VALUES
('smbl',2,1,'2005-12-10 15:30 -3:00',INTERVAL '1:30' HOUR TO MINUTE);
INSERT INTO meeting (prj_id, item_no, meeting_seq, starts_at, duration)
VALUES
('smbl',30,2,'2005-12-15 13:00 -3:00',INTERVAL '0:30' HOUR TO MINUTE);
INSERT INTO meeting (prj_id, item_no, meeting_seq, starts_at, duration)
VALUES
('smen',2,3,'2006-05-01 10:00 -3:00',INTERVAL '1:00' HOUR TO MINUTE);
INSERT INTO meeting (prj_id, item_no, meeting_seq, starts_at, duration)
VALUES
('smak',2,4,'2007-02-28 16:00 -4:00',INTERVAL '2:00' HOUR TO MINUTE);
INSERT INTO meeting (prj_id, item_no, meeting_seq, starts_at, duration)
VALUES
('smak',5,5,'2006-09-01 13:00 -4:00',INTERVAL '1:00' HOUR TO MINUTE);


SQL statement:
SELECT "_meeting_1"."DURATION" AS "_e_1", "_meeting_1"."PRJ_ID" AS
"_e_2", "_meeting_1"."ITEM_NO" AS "_e_3" FROM "MEETING" "_meeting_1"
ORDER BY "_e_2" ASC, "_e_3" ASC
History
Date User Action Args
2009-08-04 11:36:22etelstansetrecipients: + etelstan
2009-08-04 11:36:22etelstansetmessageid: <1249385782.43.0.811608367217.issue1421@psf.upfronthosting.co.za>
2009-08-04 11:36:22etelstanlinkissue1421 messages
2009-08-04 11:36:21etelstancreate