Hi Clint,
Maybe you could provide the specific steps you are following so we could
perhaps reproduce the problem? What version of H2 are you using?
Also, what do you mean specifically by "lucene is worse...that doesn't work
anywhere" -- do you have actual error messages?
Thanks
Kerry
On Thu, Aug 12, 2010 at 5:39 AM, clint <clinthyd...@gmail.com> wrote:
> yes, I've already done that...note that I said this works just fine on
> my laptop.
>
> lucene is worse...that doesn't work anywhere.
>
>
> I am doing this by cutting and pasting the exact code from the
> documentation...which I hoped was going to be ok...
>
> -- clint
>
>
>
> On Aug 10, 3:09 am, Thomas Mueller <thomas.tom.muel...@gmail.com>
> wrote:
> > Hi,
> >
> > I don't think the problem is related to the operating system. Does
> > your application install the fulltext methods? This is done by
> > executing CREATE ALIAS FT_INIT ... and CALL FT_INIT(). This should be
> > documented I believe.
> >
> > Regards,
> > Thomas
> >
> > On Sunday, August 8, 2010, clint <clinthyd...@gmail.com> wrote:
> > > I seriously need this text search to work, but I am having strange
> > > problems.
> >
> > > My SQL is fairly simple, the whole database is not very complex, but I
> > > need it online very very soon.
> >
> > > The error I get is that FT_CREATE_INDEX is reported as "can't find
> > > method":
> >
> > > ------------
> >
> > > CALL FT_CREATE_INDEX('MAGAZINE_INDEX', 'STORY', 'TITLE' );
> > > Function "FT_CREATE_INDEX" not found; SQL statement:
> > > CALL FT_CREATE_INDEX('MAGAZINE_INDEX', 'STORY', 'TITLE' ) [90022-140]
> > > 90022/90022 (Help)
> >
> > > CALL FT_CREATE_INDEX('MAGAZINE_INDEX', 'AUTHOR', 'NAME');
> > > Function "FT_CREATE_INDEX" not found; SQL statement:
> > > CALL FT_CREATE_INDEX('MAGAZINE_INDEX', 'AUTHOR', 'NAME') [90022-140]
> > > 90022/90022 (Help)
> >
> > > CALL FT_CREATE_INDEX('MAGAZINE_INDEX', 'TAG', 'NAME');
> > > Function "FT_CREATE_INDEX" not found; SQL statement:
> > > CALL FT_CREATE_INDEX('MAGAZINE_INDEX', 'TAG', 'NAME') [90022-140]
> > > 90022/90022 (Help)
> >
> > > CALL FT_CREATE_INDEX('MAGAZINE_INDEX', 'PHOTOGRAPHER', 'NAME');
> > > Function "FT_CREATE_INDEX" not found; SQL statement:
> > > CALL FT_CREATE_INDEX('MAGAZINE_INDEX', 'PHOTOGRAPHER', 'NAME')
> > > [90022-140] 90022/90022 (Help)
> >
> > > -------
> >
> > > the part I can't figure out is that this works just fine on my intel
> > > macintosh powerbook. the above errors are on my friend's intel
> > > macintosh mini. There is an O/S difference, I have 10.5, he has 10.6
> >
> > > is that o/s diff the cause?
> >
> > > --------
> >
> > > I have not tried the Lucene indexing yet. That is next.
> >
> > > otherwise, I am very happy with H2's abilities and performance. I've
> > > been using it all year, multiple databases, some tiny, some with
> > > millions of records.
> >
> > > -- clint
> >
> > > --
> > > You received this message because you are subscribed to the Google
> Groups "H2 Database" group.
> > > To post to this group, send email to h2-datab...@googlegroups.com.
> > > To unsubscribe from this group, send email to
> h2-database+unsubscr...@googlegroups.com<h2-database%2bunsubscr...@googlegroups.com>
> .
> > > For more options, visit this group athttp://
> groups.google.com/group/h2-database?hl=en.
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To post to this group, send email to h2-datab...@googlegroups.com.
> To unsubscribe from this group, send email to
> h2-database+unsubscr...@googlegroups.com<h2-database%2bunsubscr...@googlegroups.com>
> .
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-datab...@googlegroups.com.
To unsubscribe from this group, send email to
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
