Re: Getting error code when creating an index via java
May be you need to get the errors:
...........
} catch (SQLException e ) {
String themessage;
themessage = "Error:"+e.getErrorCode()+
" "+e.getMessage();
e=e.getNextException();
if( e != null ) {
themessage = themessage + " " +
e.getErrorCode()+ " " + e.getMessage();
}
System.out.println(themessage);
.............
dependant on what the errors are one can may be decide what to do??
set lock mode to wait or
onstat -uk or have a look at sysmaster:syslocks
maybe you have to checkout the greatest undoced env var ever:
IFX_DIRTY_WAIT
you most likely have to set it in the env of the engine; it may be in
the jdbc stuff
too however the chance is smaller...
Superboer.
berso schreef:
> This is kinda wierd, i have few aplications in java tha what basicly do
> is
> drop a table, create the table (instad of using "delete from table", i
> do it this way for performance reasons), insert new data into the
> table, and then, when i try to create the table indexes i get this
> error:
>
> java.sql.SQLException: Could not open database table
>
> kinda like if the table where locked, or some one is using the table ,
> but i'm sure nobody is.
> the best i can do so far is, close the connection , open a new
> connection , and then try to create the index, but not always work.
>
> Any ideas on what can i'm doing wrong? or how to fix this issue?
>
> Thanks in advance.