Thanks Shalin That really helped :handshake: I have created a plugin class and now things are working fine Thanks Again
Regards Con Shalin Shekhar Mangar wrote: > > On Tue, Jan 13, 2009 at 12:53 AM, con <convo...@gmail.com> wrote: > >> >> Hi all >> >> I am using solr to index data from my database. >> In my database there is a timestamp field of which data will be in the >> form >> of, >> 15-09-08 06:28:38.442000000 AM. The column is of type TIMESTAMP in the >> oracle db. >> So in the schema.xml i have mentioned as: >> <field name="LOGIN_TIMESTAMP" type="date" indexed="true" stored="true" >> /> >> >> While indexing data in the debug mode i get this timestamp value as >> <arr> >> <str>oracle.sql.TIMESTAMP:oracle.sql.timest...@f536e8</str> >> </arr> >> >> And when i do a searching this value is not displaying while all other >> fields indexed along with it are getting displayed. > > > Hmm, interesting. It seems oracle.sql.TIMESTAMP does not inherit from > java.sql.Timestamp or java.util.Date. This is why DataImportHandler/Solr > cannot make sense out of it and the string representation is being stored > in > the index. > > However it has a toJdbc() method which will return a Jdbc compatible > object. > > http://download-uk.oracle.com/otn_hosted_doc/jdeveloper/904preview/jdbc-javadoc/oracle/sql/TIMESTAMP.html#toJdbc() > > >> 1) So do i need to write a custom transformer to add these values to the >> index. > > > Yes, it seems like that is the only way. > > >> 2)And if yes I am confused how it is? Is there a sample code somewhere? > > > Yes, see an example here -- > http://wiki.apache.org/solr/DIHCustomTransformer > > >> >> I have tried the sample TrimTransformer and it is working. But can i >> convert >> this string to a valid date format.(I am not a java expert..:-( )? > > > I would start by trying something like this: > > oracle.jdbc.TIMESTAMP timestamp = (oracle.jdbc.TIMESTAMP) > row.get("your_timestamp_field_name"); > row.put("your_timestamp_field_name", timestamp.toJdbc()); > > >> >> -- >> View this message in context: >> http://www.nabble.com/Custom-Transformer-to-handle-Timestamp-tp21421742p21421742.html >> Sent from the Solr - User mailing list archive at Nabble.com. >> >> > > > -- > Regards, > Shalin Shekhar Mangar. > > -- View this message in context: http://www.nabble.com/Custom-Transformer-to-handle-Timestamp-tp21421742p21450404.html Sent from the Solr - User mailing list archive at Nabble.com.
