Oracle sequence

HA_kan_Rosenberg · March 14, 2006, 12:33pm

Hi,

I’m having problems calling a sequence in an Oracle database.

Using the sequence in TOAD works OK:
“select seq_name.nextval from dual”

But when trying to run the same SQL in a JDBC Adapter Service I get the following error message:

“com.wm.pkg.art.error.DetailedServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service myPackage.dbServices:executeStatement. [ADA.1.316] Cannot execute the SQL statement “select seq_name.nextval from dual”. " (08S01/0) [wm-cjdbc33-0069][Oracle JDBC Driver]Software caused connection abort: socket write error” [wm-cjdbc33-0069][Oracle JDBC Driver]Software caused connection abort: socket write error"

Thanks!

HA_kan_Rosenberg · March 14, 2006, 1:01pm

Seems that there were som problems with the connection pool.
The problem was solved by restarting the IS.