rock cordial

Greenhorn
+ Follow
since Jul 22, 2002
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by rock cordial

I changed it!
And now would anyone answer my question?
21 years ago
I got perhaps the same question with it,but I want to delete or select one or more items at a time,what should I do?
21 years ago
does it get any permission to allow client access host db or client db?
21 years ago
I got same problem like you,but use db2.
when i use jdbc,everything is ok,but when i use was4.02 it didn't work.And there is no firework exist.
21 years ago
when i use request dispatcher in servlet,code is
RequestDispatcher rd = getServletContext().getRequestDispatcher(url);
rd.forward(request,response);
I found exceptin in stdout.out file,content as
[02.07.29 09:34:04:910 CDT] 119813a3 WebGroup X Servlet Error: Error flushing streams: java.lang.IllegalStateException: Error flushing streams
at com.ibm.servlet.dynacache.FragmentComposer.flushStreams(FragmentComposer.java(Compiled Code))
at com.ibm.servlet.dynacache.FragmentComposer.flushStreams(FragmentComposer.java(Compiled Code))
at com.ibm.servlet.dynacache.CacheHook.handleFragment(CacheHook.java(Compiled Code))
at com.ibm.servlet.dynacache.CacheHook.handleServlet(CacheHook.java(Compiled Code))
at com.ibm.servlet.dynacache.CacheManager.handleServlet(CacheManager.java(Compiled Code))
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java(Compiled Code))
at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java(Compiled Code))
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code))
at com.oaking.znxg.znxgServlet.performTask(znxgServlet.java:225)
at com.oaking.znxg.znxgServlet.doPost(znxgServlet.java:59)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.servlet.dynacache.CacheHook.handleFragment(CacheHook.java(Compiled Code))
at com.ibm.servlet.dynacache.CacheHook.handleServlet(CacheHook.java(Compiled Code))
at com.ibm.servlet.dynacache.CacheProxyServlet.service(CacheProxyServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code))
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code))
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code))
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code))
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code))
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java(Compiled Code))
Any help is appreciated.
Thanks.
21 years ago
I get error in our website auto deploy news program , the out log contained following error
  [02.07.12 17:53:08:509 CDT] 42627f1c StaleConnecti A CONM7007I:StaleConnectionException:
com.ibm.websphere.ce.cm.StaleConnectionException: class com.ibm.ejs.cm.proxy.ResultSetProxy is closed
at com.ibm.ejs.cm.proxy.Proxy.__preInvoke(Proxy.java(Compiled Code))
at com.ibm.ejs.cm.proxy.Proxy.__preInvoke(Proxy.java(Compiled Code))
at com.ibm.ejs.cm.proxy.ResultSetProxy.next(ResultSetProxy.java(Compiled Code))
at com.oaking.deploy.AutoDeployService.run(AutoDeployService.java:61)
[02.07.12 17:53:08:594 CDT] 42627f1c SystemOut U autodeployservice error:class com.ibm.ejs.cm.proxy.ResultSetProxy is closed
I had set attribute in the admin console,
property name: connectionAttribute ,
type: java.lang.String,value: cursorhold=1 ,
if I don't set this parameter,one connection can not process more than one statement,got function sequence error
After I set the attribute , met the new error!
AutoDeployService's run method
public void run()
{
String tmp = AppManager.getProperty( application, "deployInterval", "30" );
int dbtype = 0;
long interval = 1800000;
try
{
interval = Long.parseLong( tmp ) * 60 * 1000;
dbtype = AppManager.getDBType( application, dbName );
}
catch( Exception e ) {}
while ( true )
{
if ( application == null ) break;
Connection con = null;
Statement stmt = null;
Statement stmt1 = null;
try
{
String sql = "delete from webNews where columnId = 0";
con = AppManager.getConnection( application, dbName, 30000 );
stmt = con.createStatement();
stmt1 = con.createStatement();
stmt.executeUpdate( sql );
con.commit();
sql = "update webNews set returned = '0' where isbaught = '1' and returned is null";
stmt.executeUpdate( sql );
con.commit();
sql = "update webNews set delmark = '0' where isbaught = '1' and delmark is null";
stmt.executeUpdate( sql );
con.commit();
sql = "select newsId, columnId from webNews where isBaught = "
+ DBTypes.getDBConst( dbtype, "1", java.sql.Types.CHAR )
+ " and deployed <> " + DBTypes.getDBConst( dbtype, "1", java.sql.Types.CHAR )
+ " and delmark <> " + DBTypes.getDBConst( dbtype, "1", java.sql.Types.CHAR )
+ " order by editTime";
ResultSet rs = stmt.executeQuery( sql );
while ( rs.next() )
{
if ( application == null ) break;
try
{
String newsId = rs.getString( 1 );
String columnId = rs.getString( 2 );
//System.out.println( columnId );
WebNews.deploy( application, dbName, newsId, columnId );
//WebNews.deploy also execute access db command
sql = "update webNews set auditGrade = 1, deployed = "
+ DBTypes.getDBConst( dbtype, "1", java.sql.Types.CHAR )
+ ", checked = " + DBTypes.getDBConst( dbtype, "1", java.sql.Types.CHAR )
+ " where newsId = " + newsId;
stmt1.executeUpdate( sql );
sleep( 2000 );
}
catch( Exception exp )
{
System.out.println( "autodeployservice error:" + exp.getMessage() );
//exp.printStackTrace( System.out );
}
finally
{
try { con.commit(); }
catch( Exception e )
{
try { con.rollback(); } catch( Exception exp ) {}
}
}
}
}
catch( Exception e )
{
System.out.println( "autodeployservice error:" + e.getMessage() );
}
finally
{
try
{
if( con != null ) AppManager.freeConnection( application, dbName, con );
if( stmt != null ) stmt.close();
if( stmt1 != null ) stmt1.close();
}
catch( Exception e ) {}
}
try
{
sleep( interval );
}
catch( Exception e ) {}
} //end of while
System.out.println( "auto deploy service finish!" );
}
We deployed it in WebSphere4.01+Db2V7.2 at AIX4.3.3
Thanks!
21 years ago