Message4985
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 |
|
Date |
User |
Action |
Args |
2009-08-04 11:36:22 | etelstan | set | recipients:
+ etelstan |
2009-08-04 11:36:22 | etelstan | set | messageid: <1249385782.43.0.811608367217.issue1421@psf.upfronthosting.co.za> |
2009-08-04 11:36:22 | etelstan | link | issue1421 messages |
2009-08-04 11:36:21 | etelstan | create | |
|