To ask how to solve the postgrelsql stack overflow error-CodePudding

stmt=conn.createStatement();
conn.setAutoCommit(false);
For (var j=0; jTableName=(grid [j]. Journal of tableName). The toUpperCase ();
SqlStr="rowid varchar primary key,";
//query primary key, and the primary key of the data type

Rs=STMT. ExecuteQuery (" the select pg_constraint conname, pg_type. Typname from pg_constraint where pg_class. Relname='" + tableName + "' ");
}
Walk to rs. When the system will be submitted to the Java lang, StackOverflowError stack overflow error, bosses, please help to solve the

CodePudding user response:

There is something wrong with the SQL:

The select pg_constraint conname, pg_type. Typname the from pg_constraint

Pg_type did not appear in the from behind

CodePudding user response:

And will quote after stack overflow error, also checked on the Internet about the stack overflow error, but now this code a dead cycle, no object calls back and forth, this kind of problem, also does not have a primary key conflict is really don't understand why the rs this line of code will appear a stack overflow error

CodePudding user response:

Statements don't run in the Java first, under the PSQL running to see what's the problem
Should be the problem of JDBC in certain circumstances

CodePudding user response:

Find a mistake, there is something wrong with the SQL statements written