WebSphere Application Server - DB2SQLJJDBCProfile Error: No more JDBC Cursors with hold

This is Interesting: Free IT Magazines  
Home > Archive > WebSphere Application Server > February 2004 > DB2SQLJJDBCProfile Error: No more JDBC Cursors with hold





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author DB2SQLJJDBCProfile Error: No more JDBC Cursors with hold

2004-01-19, 2:54 pm

I am running a JSP and servlet application on WAS 4.0 (running as a plug-in in the HTTP Server). This error intermittently pops up from out of nowhere. Has anyone seen this before?

Thanks.

Karen
PM \(pm3iinc-nospam\)

2004-02-07, 6:33 pm

Would be nice to know the DB2 level you use and the url/driver type you use.

Here is the link to DB2 v8.x most recent doc.
http://publib.boulder.ibm.com/infoc...2help/index.jsp

If you're at v8 level and you use the jcc driver/universal jdbc driver, you
may search for the
db2jdbcbind command.

db2jdbcbind - DB2 JDBC Package Binder Command

try with -size 20 (default is 3)
(db2 dba needs to do this)
sqlj, jdbc, odbc and cli share some packages.

size number of packages
The number of internal packages to bind for each DB2 transaction isolation
level and holdability setting. The default is 3. Since there are
four DB2 isolation levels and two cursor holdability settings, there will be
4x2=8 times as many dynamic packages bound as are specified by this
option. In addition, a single static package is always bound for
internal use.

Could also relate to this command.
db2sqljbind - DB2 SQLJ Profile Binder Command
db2sqljcustomize / db2profc

PM

<karen.nally@ssa.gov> a écrit dans le message de
news:1454443849.1073600186581.JavaMail.wasadmin@swg3ws006...
> I am running a JSP and servlet application on WAS 4.0 (running as a

plug-in in the HTTP Server). This error intermittently pops up from out of
nowhere. Has anyone seen this before?
>
> Thanks.
>
> Karen



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com