ActiveRecord JDBC: General Discussion: Date issues?

Downloads
» Downloads
Message Forums
» General Discussion
Issue Tracking
» JIRA
Mailing Lists
Source Code Repositories
» Main
» Mirror (Github)
Wikis
» Wiki

ActiveRecord JDBC is a subproject of JRuby, was started in July 2008, is owned by Nick Sieger, and has 64 members.

» Join This Project

Date issues?

» Back to forum topics

2 posts

Replies: 1 - Last Post: October 19, 2010 20:53
by: Martin.Little

« Older Topic » Newer Topic

showing 1 - 2 of 2

Martin.Little

Posted: October 07, 2010 19:40 by Martin.Little

» Permalink

I tried to get some rails 3 code running under the jdbc adapter connecting to an Informix database. While some queries work anything involving dates gives me an error similar to this:

ActiveRecord::StatementInvalid (ActiveRecord::JDBCError: No message available: SELECT attendance.* FROM attendance WHERE (attendance.att_date = '10/7/2010') AND (attendance.att_time = 8) ORDER BY att_diary):
(don't judge me on the column names, this database long predates me by 15+ years)

I tried with both the current version as well as beta2 of 1.0.

Any pointers where I'd start to debug this would be appreciated.

Thanks.

Martin.Little	Posted: October 19, 2010 20:53 by Martin.Little » Permalink
	It turns out this seems to be because the informix adapter was copied from the ruby-informix project which uses a bit of a hack to convert dates internally which isn't necessary with JDBC. When I removed that everything seemed to work touch wood I'll file a defect.

Replies: 1 - Last Post: October 19, 2010 20:53
by: Martin.Little

« Older Topic » Newer Topic