Hi, I don't know what the problem is, but FYI error #23505 means "duplicate key": The error with code 23505 is thrown when trying to insert a row that would violate a unique index or primary key. Example:
CREATE TABLE TEST(ID INT PRIMARY KEY); INSERT INTO TEST VALUES(1); INSERT INTO TEST VALUES(1); So possibly you try to create the same index twice? Regards, Thomas On Sat, Mar 9, 2013 at 9:04 PM, Zach <[email protected]> wrote: > > I checked out the latest google code svn and built the jar. I no longer see the "Could not find class" error, but I'm still seeing the same runtime error that proceeded it (which I didn't mention it because I figured they were related): > > org.h2.jdbc.JdbcBatchUpdateException: (Message 23505 not found); SQL statement: > INSERT INTO FT.INDEXES(SCHEMA, TABLE, COLUMNS) VALUES(?, ?, ?) [23505-170] > > I'm guessing this is probably an issue with my code, and I know it's caused by FT_CREATE_INDEX because no runtime error is thrown if I remove that line. Is it bad to call FT_INIT and FT_CREATE_INDEX in the same transaction? > > On Saturday, March 9, 2013 8:24:23 AM UTC-5, Thomas Mueller wrote: >> >> Hi, >> >> I guess the problem is that this class is loaded when trying to create the fulltext index. I moved the referenced method "escapeMetaDataPattern" now to StringUtils, could you verify this fixed the problem? You would need to download the latest source code and compile H2 yourself however. >> >> Regards, >> Thomas >> >> >> >> On Sat, Mar 9, 2013 at 5:57 AM, Zach <[email protected]> wrote: >>> >>> I'm getting the following error on Android: >>> >>> Could not find class 'javax.naming.Context', referenced form method org.h2.util.JdbcUtils.getConnection >>> >>> This happens when I try to run FT_CREATE_INDEX to make an index for an existing table. I know Android doesn't have the javax.naming.* namespace, so how do I avoid touching anything that uses it? >>> >>> -- >>> You received this message because you are subscribed to the Google Groups "H2 Database" group. >>> To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> >>> Visit this group at http://groups.google.com/group/h2-database?hl=en. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >> >> > -- > You received this message because you are subscribed to the Google Groups "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
