Not sure if you looked at this or not, but I misspoke. Since Nick already applied the 1st patch from the ticket you should not reapply that one. The 2nd patch was just a minor thing for migrations so that one may or may not matter to you.
JA
On Fri, May 2, 2008 at 9:35 AM, Joseph Athman <
jjathman@...> wrote:
Maybe Nick can help you out as far as the best way to patch it, or maybe push out a new version of the gems. Although there is *some* support for SQLite3, I did find that there are issues with Date/Datetime fields with the work I did. According to the SQLite site, it isn't supposed to support Date/Time fields natively, but if you run migrations with the standard Ruby adapter it seems to create them anyways. I'm hoping someone would like to pitch in and help, or at least point me in the right direction. I'm by no means a SQLite expert so I wasn't sure where to go from here.
Not sure how much experience you have with patching and SVN, but here are the basics of how I was doing it.
do a checkout of the activerecord code from SVN
apply the 2 patches that are attached to the JIRA ticket
Then run these commands:
jruby -S rake package
jruby -S gem install pkg/*.gem
cd drivers/sqlite3
jruby -S rake package
jruby -S gem install pkg/*.gem
Hope this gets you started in the right direction.
Joe
On Thu, May 1, 2008 at 9:23 AM, rob08 <
rob99brown@...> wrote:
Guys this is great! i've been waiting for this.
Would it be possible to get some quick instructions on how to patch this
into a JRuby 1.1.1 install?
Thanks,
Joseph Athman wrote:
>
> I created a ticket to track this under:
>
http://jira.codehaus.org/browse/JRUBY-2438
> I believe I have a very good start on the adapter. It passes all of the
> simple tests except for the column rename which isn't natively supported
> in
> SQLite3. I'm pretty sure there is some unused code in the jdbc_sqlite3.rb
> file. I copied a lot of it from other adapters and tried to piece it
> together.
>
> I'm pretty unsure of the support for date/time columns. Since SQLite
> doesn't natively support this I'm storing them as integers which is what
> the
> JDBC driver is doing as well. I think this should work ok, it seems like
> it
> works. Let me know what else I can do, and if you have any feedback. I
> attached the patch to the ticket. Thanks.
>
> Joe
>
>
>
--
View this message in context: http://www.nabble.com/Sqlite-3-adapter-tp16790361p16993265.html
Sent from the JRuby - User mailing list archive at Nabble.com.
