Java. SQL. sqlexception: [Microsoft] [sqlserver 2000 driver for JDBC] object has been closed.

// Get the connection
Private connection conn = connectionfactory. getconnection ();
// Generate operable objects
Private preparedstatement pstmt = NULL;

 

When a connection is used as a private field of a class, it may only be an instance, which leads to this error. (The reason is somewhat far-fetched)

Even the connection pool reports such an error.

Therefore, each method requires an instance of its own.

 

Adding multiple entity instances to the list does not allow spring injection of get. It may not be possible. If we put get in the loop. The logic is the same as that of new.

 

 

Java. SQL. sqlexception: [Microsoft] [sqlserver 2000 driver for JDBC] object has been closed.