{"issue":{"milestone":null,"title":"[FRG-109] Error when trying to select column of type timestamp in oracle using foreign server or imported schema","created_at":"2011-12-30T03:47:32Z","user":{"login":"dynamobi-build","id":1123017,"url":"https://api.github.com/users/dynamobi-build","avatar_url":"https://secure.gravatar.com/avatar/cb215b3d786be20761071a562a56af64?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"cb215b3d786be20761071a562a56af64"},"labels":[{"name":"FRG","url":"https://api.github.com/repos/dynamobi/dynamobi/labels/FRG","color":"1f8f0d"},{"name":"JDBC Foreign Data Wrapper","url":"https://api.github.com/repos/dynamobi/dynamobi/labels/JDBC+Foreign+Data+Wrapper","color":"ef9296"}],"updated_at":"2011-12-30T03:47:33Z","state":"closed","id":2686313,"closed_at":"2011-12-30T03:47:33Z","html_url":"https://github.com/dynamobi/dynamobi/issues/761","pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"body":"<b><i>[reporter=\"elin\", created=\"Wed, 19 Apr 2006 11:35:53 -0500 (GMT-05:00)\"]</i></b>\nThe error encountered is:<br/>\n<br/>\nError: Cannot assign '<a href='mailto:oracle.sql.TIMESTAMP@101fa9e'>oracle.sql.TIMESTAMP@101fa9e</a>' to a TIMESTAMP value: not in format 'yyyy-MM-dd HH:mm:ss' (state=,code=0)<br/>\nnet.sf.farrago.jdbc.FarragoJdbcUtil$FarragoSqlException: Cannot assign '<a href='mailto:oracle.sql.TIMESTAMP@101fa9e'>oracle.sql.TIMESTAMP@101fa9e</a>' to a TIMESTAMP value: not in format 'yyyy-MM-dd HH:mm:ss'<br/>\n<br/>\nTo reproduce (change paths as necessary):<br/>\n===========================<br/>\ncreate foreign data wrapper ORCL_JDBC<br/>\nlibrary '/home/elin/open/luciddb/plugin/FarragoMedJdbc3p.jar'<br/>\nlanguage java;<br/>\n<br/>\ncreate server ORCL_SERVER<br/>\nforeign data wrapper ORCL_JDBC<br/>\noptions(<br/>\n    url 'jdbc:oracle:thin:@akela.lucidera.com:1521:XE',<br/>\n    user_name 'schoi',<br/>\n    password 'schoi',<br/>\n    driver_class 'oracle.jdbc.driver.OracleDriver'<br/>\n);<br/>\nselect * from ORCL_SERVER.SCHOI.\"types\" order by 1;<br/>\n-- Errors here<br/>\n<br/>\ncreate schema ORCL_is_schema;<br/>\nimport foreign schema SCHOI<br/>\nLIMIT TO TABLE_NAME like 'typ%' <br/>\nfrom server ORCL_SERVER <br/>\ninto ORCL_is_schema;<br/>\n<br/>\nselect * from ORCL_is_schema.\"types\";<br/>\n--- Errors here too<br/>\n<br/>\nHere's the stack trace:<br/>\n0: jdbc:farrago:> select * from ORCL_SERVER.SCHOI.\"types\" order by 1;<br/>\nError: Cannot assign '<a href='mailto:oracle.sql.TIMESTAMP@1b2380e'>oracle.sql.TIMESTAMP@1b2380e</a>' to a TIMESTAMP value: not in format 'yyyy-MM-dd HH:mm:ss' (state=,code=0)<br/>\nnet.sf.farrago.jdbc.FarragoJdbcUtil$FarragoSqlException: Cannot assign '<a href='mailto:oracle.sql.TIMESTAMP@1b2380e'>oracle.sql.TIMESTAMP@1b2380e</a>' to a TIMESTAMP value: not in format 'yyyy-MM-dd HH:mm:ss'<br/>\n        at net.sf.farrago.resource.FarragoResource$_Def9.ex(FarragoResource.java:1412)<br/>\n        at net.sf.farrago.type.runtime.SqlDateTimeWithoutTZ$SqlTimestamp.parse(SqlDateTimeWithoutTZ.java:359)<br/>\n        at net.sf.farrago.type.runtime.SqlDateTimeWithoutTZ.assignFrom(SqlDateTimeWithoutTZ.java:170)<br/>\n        at net.sf.farrago.type.runtime.SqlDateTimeWithoutTZ.assignFrom(SqlDateTimeWithoutTZ.java:175)<br/>\n        at net.sf.farrago.dynamic.stmt3115.Transformer1$2.makeRow(Unknown Source)<br/>\n        at org.eigenbase.runtime.ResultSetTupleIter.moveToNext(ResultSetTupleIter.java:108)<br/>\n        at org.eigenbase.runtime.ResultSetTupleIter.fetchNext(ResultSetTupleIter.java:59)<br/>\n        at net.sf.farrago.runtime.FarragoTransformImpl.execute(FarragoTransformImpl.java:71)<br/>\n        at net.sf.farrago.fennel.FennelStorage.tupleStreamFetch(Native Method)<br/>\n        at net.sf.farrago.fennel.FennelStreamGraph.fetch(FennelStreamGraph.java:175)<br/>\n        at net.sf.farrago.runtime.FennelTupleIter.populateBuffer(FennelTupleIter.java:110)<br/>\n        at net.sf.farrago.runtime.FennelAbstractTupleIter.fetchNext(FennelAbstractTupleIter.java:99)<br/>\n        at org.eigenbase.runtime.TupleIterResultSet.next(TupleIterResultSet.java:90)<br/>\n        at net.sf.farrago.runtime.FarragoTupleIterResultSet.next(FarragoTupleIterResultSet.java:97)<br/>\n        at sqlline.SqlLine$BufferedRows.<init>(Unknown Source)<br/>\n        at sqlline.SqlLine.print(Unknown Source)<br/>\n        at sqlline.SqlLine$Commands.execute(Unknown Source)<br/>\n        at sqlline.SqlLine$Commands.sql(Unknown Source)<br/>\n        at sqlline.SqlLine.dispatch(Unknown Source)<br/>\n        at sqlline.SqlLine.begin(Unknown Source)<br/>\n        at sqlline.SqlLine.mainWithInputRedirection(Unknown Source)<br/>\n        at sqlline.SqlLine.main(Unknown Source)<br/>\n0: jdbc:farrago:><br/>\n","number":761,"url":"https://api.github.com/repos/dynamobi/dynamobi/issues/761","comments":0,"assignee":null},"action":"opened"}