Oninit cdi / Archive
Talk to an expert →

Table not unlock after create index statement

Posted in 2006

Topics: Java & JDBC Development

berso — — source: Usenet: comp.databases.informix

This is kinda wierd, i'm programing with java, i create an index using a Statement.executeUpdate("CREATE INDEX..."), after that, i'm try to update the table and give me this error: update error :java.sql.SQLException: Table (infocorp.it_r38y39) has been dropped, altered or renamed. if i remove the CREATE INDEX the it runs fine, but way to slow, so i asuming that the table is not unlocking....any ideas? BTW already ask in the java group.....they send me here.... Thanks

↪ replying to berso
Madison Pruet — — source: Usenet: comp.databases.informix

berso wrote: > This is kinda wierd, i'm programing with java, i create an index using > a > Statement.executeUpdate("CREATE INDEX..."), after that, i'm try to > update the table and give me this error: > > update error :java.sql.SQLException: Table (infocorp.it_r38y39) has > been > dropped, altered or renamed. Sounds like you are updating the table through the execution of a prepared statement, and the statement needs to be re-prepared after the creation of the index. > > if i remove the CREATE INDEX the it runs fine, but way to slow, so i > asuming that the table is not unlocking....any ideas? > > BTW already ask in the java group.....they send me here.... > > Thanks >

↪ replying to Madison Pruet
berso — — source: Usenet: comp.databases.informix

Madison Pruet ha escrito: > berso wrote: > > This is kinda wierd, i'm programing with java, i create an index using > > a > > Statement.executeUpdate("CREATE INDEX..."), after that, i'm try to > > update the table and give me this error: > > > > update error :java.sql.SQLException: Table (infocorp.it_r38y39) has > > been > > dropped, altered or renamed. > > Sounds like you are updating the table through the execution of a > prepared statement, and the statement needs to be re-prepared after the > creation of the index. > > > > > if i remove the CREATE INDEX the it runs fine, but way to slow, so i > > asuming that the table is not unlocking....any ideas? > > > > BTW already ask in the java group.....they send me here.... > > > > Thanks > > That was the problem, Thanks a lot.

↪ replying to berso
Quman — — source: Usenet: comp.databases.informix

First, Create a index in Java code is strange! you may want tocreate it with a server side dbaccess( ask the DBA). I am surprised if you like repeately create the same index whenever you run the code!. Second, if you like create a index in Java code, you may need update statistics before you continue.to do the rest.. Quman On 5 Oct 2006 08:48:04 -0700, berso <berso1@gmail.com> wrote: > This is kinda wierd, i'm programing with java, i create an index using > a > Statement.executeUpdate("CREATE INDEX..."), after that, i'm try to > update the table and give me this error: > > update error :java.sql.SQLException: Table (infocorp.it_r38y39) has > been > dropped, altered or renamed. > > if i remove the CREATE INDEX the it runs fine, but way to slow, so i > asuming that the table is not unlocking....any ideas? > > BTW already ask in the java group.....they send me here.... > > Thanks > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >

↪ replying to Quman
berso — — source: Usenet: comp.databases.informix

Quman ha escrito: > First, Create a index in Java code is strange! you may want tocreate > it with a server side dbaccess( ask the DBA). I am surprised if you > like repeately create the same index whenever you run the code!. > > Second, if you like create a index in Java code, you may need update > statistics before you continue.to do the rest.. > > Quman > > > > On 5 Oct 2006 08:48:04 -0700, berso <berso1@gmail.com> wrote: > > This is kinda wierd, i'm programing with java, i create an index using > > a > > Statement.executeUpdate("CREATE INDEX..."), after that, i'm try to > > update the table and give me this error: > > > > update error :java.sql.SQLException: Table (infocorp.it_r38y39) has > > been > > dropped, altered or renamed. > > > > if i remove the CREATE INDEX the it runs fine, but way to slow, so i > > asuming that the table is not unlocking....any ideas? > > > > BTW already ask in the java group.....they send me here.... > > > > Thanks > > > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > > Yes i now it's not so common, but is very handly if you need to transport data betwen 2 diferent databases, and manipulate it wile transmiting, i now ther are sofwares to do it but i doing very custom stuff, and have a lot of demand for it, btw good point on the update statistcs, i'm already doing it, otherwise the index may be useless....

Related threads