Jeff,

Thanks a lot for your response.

I use standard JDBC API, single thread to access Netezza. The Netezza build is (Release 4.6.2 (P-4) [Build 9909])

the sample code very simple:

---------------------------------------------------------------------------------------------------------

url = "jdbc:netezza://" + server + "/" + databaseName ;

Class.forName("org.netezza.Driver");

con = DriverManager.getConnection(url,user, password);

ps = con.prepareStatement(SQLStatementDefinitions.validateUDFName);

ps.execute(); ()// exception at here for the second time, SQLSTATE=HY014, it likes a "no more handler" problem.

-----------------------------------------------------------------------------------------------------------

But I'm sure I have closed PreparedStatement in the first connection.

We use similar code to access teradata (the only different are driver and URL),but do not meet this problem.

Is that Netezza build version is a limited version or we need change some settings in database such as MAXAPPLS in DB2?  

Thanks,

Frank

Jeff,

Thanks, I have found a workaround for this problem,

when I use Statement to replace prepareStatement for a specific query, it works fine.

I'm not sure  it's a defect of Netezza, I will do more investigation when I have enough time.

Thank,

Frank