Looks like a clear cut JDBC problem. I don't think JRun has anything to do
with it. All the standard debugging practices apply: run it in a debugger,
use out.println, use printStackTrace(), etc. For example, to get more debug
info replace:
catch( SQLException sqle )
{
stmt.close();
dbcon.returnConection(con);
throw new SQLException( sqle.getMessage());
}
with:
catch( Throwable t )
{
t.printStackTrace();
}
Scott Stirling
Allaire
-----Original Message-----
From: Jim Gillaspy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 11:24 AM
To: JRun-Talk
Subject: RE: Server won't start
When the following code is executed on a 1253 row database (small!), the
bean stops in the rs.last() statement, puts the following message in the
-err.log then halts the server. Any suggestions?
Thanks.
try
{
if ( stmt != null ) stmt.close();
if ( con == null ) con = dbcon.getConnection();
stmt = con.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(thisQuery);
rs.last();
rows = rs.getRow( );
rs.beforeFirst();
}
catch( SQLException sqle )
{
stmt.close();
dbcon.returnConection(con);
throw new SQLException( sqle.getMessage());
}
Operating System: SunOS Version 5.6
Java Virtual Machine: build Solaris_JDK_1.2.2_05a, native threads, sunwjit
from Sun Microsystems Inc.
JRun 3.0 3.00.3252 Starting devel...
Current Locale: en
Loading scheduler
Loading logging
java.lang.OutOfMemoryError
java.lang.OutOfMemoryError
java.lang.OutOfMemoryError
java.lang.OutOfMemoryError
java.lang.OutOfMemoryError
java.lang.OutOfMemoryError
java.lang.OutOfMemoryError
java.lang.OutOfMemoryError
java.lang.OutOfMemoryError
java.lang.OutOfMemoryError
Operating System: SunOS Version 5.6
Java Virtual Machine: build Solaris_JDK_1.2.2_05a, native threads, sunwjit
from Sun Microsystems Inc.
JRun 3.0 3.00.3252 Starting devel...
Current Locale: en
Loading scheduler
Loading logging
java.sql.SQLException: Io exception: Broken pipe
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.sql.SQLException.<init>(Compiled Code)
at oracle.jdbc.dbaccess.DBError.throwSqlException(Compiled Code)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleConnection.setAutoCommit(Compiled Code)
at cmd.starfill.Starfill.loadConnection(Starfill.java:287)
at cmd.starfill.WebUser.isValidUser(WebUser.java:160)
at jrun__loginverify2ejsp10._jspService(Compiled Code)
at allaire.jrun.jsp.HttpJSPServlet.service(Compiled Code)
at allaire.jrun.servlet.JRunSE.service(Compiled Code)
at allaire.jrun.servlet.JRunSE.runServlet(Compiled Code)
at allaire.jrun.servlet.JRunNamedDispatcher.forward(Compiled Code)
at allaire.jrun.jsp.JSPServlet.service(Compiled Code)
at allaire.jrun.servlet.JRunSE.service(Compiled Code)
at allaire.jrun.servlet.JRunSE.runServlet(Compiled Code)
at allaire.jrun.servlet.JRunRequestDispatcher.forward(Compiled Code)
at allaire.jrun.servlet.JRunSE.service(Compiled Code)
at allaire.jrun.servlet.JvmContext.dispatch(Compiled Code)
at allaire.jrun.http.WebEndpoint.run(Compiled Code)
at allaire.jrun.ThreadPool.run(Compiled Code)
at allaire.jrun.WorkerThread.run(Compiled Code)
Jim Gillaspy
Director of Information Systems
CMD Services, Inc.
[EMAIL PROTECTED]
678-475-2030
-----Original Message-----
From: Jim Gillaspy [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, December 12, 2000 11:09 AM
To: JRun-Talk
Subject: RE: Server won't start
Scott,
This turned out to be a different problem. When the Unix admin looked at
the processes from the Unix side he found hung Java processes. Killing
those and restarting JRun fixed the problem. Apparently, the processes for
a particular server hung, then when we tried to restart that server, the
hung server already had the ports tied up so the new instance of that
server gave the "Address already in use" message and would not start.
Which is what we would want it to do, probably. This still leaves the
question of why the server hung. He was able to solve it when a second
server also stopped. Any ideas? We are in development, not production
with JRun, so all we had was some lost time. Later could be an issue.
I do like the program you wrote to display ports in use. It saved a lot of
time in the debug process.
I also like your book and recommend it to everyone -- "JavaServer Pages
Application Development" published by Sams.
Thanks,
Jim Gillaspy
Director of Information Systems
CMD Services, Inc.
[EMAIL PROTECTED]
678-475-2030
-----Original Message-----
From: Scott Stirling [SMTP:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 4:48 PM
To: JRun-Talk
Cc: '[EMAIL PROTECTED]'
Subject: RE: Server won't start
That's the port used by the Zeus server to communicate with the JRun
process. You're not using use, but this listening port is enabled by
default. You have the same port set for each server, which is undoubtedly
causing your problem. You should just disable the zeus service on each
JRun
service, or change the ports.
Nice, huh? Next thing to add to JRunPR would be to check the list of
active
ports it finds (it skips port settings that are commented out) and report
conflicts.
Best wishes,
Scott Stirling
Allaire Corporation
http://www.allaire.com/developer/jrunreferencedesk/
> -----Original Message-----
> From: Jim Gillaspy [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 08, 2000 4:44 PM
> To: 'Scott Stirling'
> Cc: '[EMAIL PROTECTED]'
> Subject: RE: Server won't start
>
>
> Scott:
> This is what I got. I don't see anything. The "development"
> server is the one that won't start. What is the Zeus port?
> Jim Gillaspy
>
> <=== JRun Server: development ===>
> ejipt.classServer.host=127.0.0.1
> ejipt.classServer.port=2328
> ejipt.homePort=2338
> control.endpoint.main.port=50028
> web.endpoint.main.port=8112
> zeus.endpoint.main.port=9100
> jcp.endpoint.main.port=9890
>
>
> <=== JRun Server: admin ===>
> control.endpoint.main.port=50002
> web.endpoint.main.port=8008
>
>
> <=== JRun Server: production ===>
> ejipt.classServer.host=127.0.0.1
> ejipt.classServer.port=2325
> ejipt.homePort=2334
> control.endpoint.main.port=50005
> web.endpoint.main.port=8110
> zeus.endpoint.main.port=9100
> jcp.endpoint.main.port=9898
>
>
> <=== JRun Server: webcontent ===>
> ejipt.classServer.host=127.0.0.1
> ejipt.classServer.port=2330
> ejipt.homePort=2340
> control.endpoint.main.port=50006
> web.endpoint.main.port=8116
> zeus.endpoint.main.port=9100
> jcp.endpoint.main.port=55560
>
>
> <=== JRun Server: default ===>
> ejipt.classServer.host=127.0.0.1
> ejipt.classServer.port=2323
> ejipt.homePort=2333
> control.endpoint.main.port=50003
> web.endpoint.main.port=8108
> zeus.endpoint.main.port=9100
> jcp.endpoint.main.port=55555
>
>
> <=== JRun Server: devel ===>
> ejipt.classServer.host=127.0.0.1
> ejipt.classServer.port=2329
> ejipt.homePort=2339
> control.endpoint.main.port=50009
> web.endpoint.main.port=8115
> zeus.endpoint.main.port=9100
> jcp.endpoint.main.port=55559
>
> Jim Gillaspy
> Director of Information Systems
> CMD Services, Inc.
> [EMAIL PROTECTED]
> 678-475-2030
>
> -----Original Message-----
> From: Scott Stirling [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, December 07, 2000 11:34 PM
> To: 'Jim Gillaspy '; 'JRun-Talk '
> Subject: RE: Server won't start
>
>
> Try this utility. It's super simple but might solve your
> problem. Just run
> it to see if there are any port conflicts in your servers'
> properties files.
>
> example: java JRunPR /home/jrun/JRun3
>
> It prints out all the port settings in all your
> local.properties files so
> you can see at a glance if there's a conflict.
>
> Output looks like this:
>
>
> <=== JRun Server: admin ===>
> web.endpoint.main.port=8000
> control.endpoint.main.port=50000
>
>
> <=== JRun Server: default ===>
> ejipt.classServer.host=127.0.0.1
> ejipt.classServer.port=2324
> ejipt.homePort=2334
> web.endpoint.main.port=8200
> control.endpoint.main.port=50002
> zeus.endpoint.main.port=9200
>
>
> Scott Stirling
> Allaire
>
> -----Original Message-----
> From: Jim Gillaspy
> To: JRun-Talk
> Sent: 12/7/00 2:56 PM
> Subject: Server won't start
>
> We have carefully checked all the ports for duplicates and found
> nothing.
> Can anyone tell us what address is already in use from this error
> message?
> Thanks,
> Jim Gillaspy
>
> Operating System: SunOS Version 5.6
> Java Virtual Machine: build Solaris_JDK_1.2.2_05a, native threads,
> sunwjit
> from Sun Microsystems Inc.
> JRun 3.0 3.00.3252 Starting development...
> Current Locale: en
> Loading scheduler
> Loading logging
> Exception: [12:44:00] Unable to install java:comp/env/ejb/TxnHome
> Exception: [12:44:00] Unable to install default.RoleHome
> Exception: [12:44:01] Unable to install default.QueueConnectorHome
> Exception: [12:44:01] Unable to install default.LoginSessionHome
> Exception: [12:44:01] Unable to install default.TopicConnectorHome
> Exception: [12:44:01] Unable to install default.UserHome
> Exception: [12:44:01] java.net.BindException: Address already in use
> java.net.BindException: Address already in use
> at java.lang.Throwable.fillInStackTrace(Native Method)
> at java.lang.Throwable.fillInStackTrace(Compiled Code)
> at java.lang.Throwable.<init>(Compiled Code)
> at java.lang.Exception.<init>(Compiled Code)
> at java.lang.RuntimeException.<init>(RuntimeException.java:47)
> at
> allaire.ejipt._InternalException.<init>(_InternalException.java:20)
> at allaire.ejipt._Runtime._createException(_Runtime.java:289)
> at
> allaire.ejipt._ClassServer._getServerSocket(_ClassServer.java:219)
> at allaire.ejipt._ClassServer.<init>(_ClassServer.java:51)
> at allaire.ejipt.Ejipt.start(Compiled Code)
> at allaire.jrun.ejb.EjbService.init(EjbService.java:78)
> at allaire.jrun.ServletService.init(Compiled Code)
> at allaire.jrun.ServletService.init(ServletService.java:31)
> at
> allaire.jrun.servlet.JRunServletLoader.loadServletInstance(Compiled
> Code)
> at allaire.jrun.servlet.JRunSE.initServices(Compiled Code)
> at
> allaire.jrun.servlet.JvmContext.initServices(JvmContext.java:96)
> at allaire.jrun.servlet.JRunSE.init(Compiled Code)
> at allaire.jrun.servlet.JvmContext.init(JvmContext.java:35)
> at allaire.jrun.ServletService.init(Compiled Code)
> at allaire.jrun.ServletService.init(ServletService.java:31)
> at JRun.main(Compiled Code)
>
> Jim Gillaspy
> Director of Information Systems
> CMD Services, Inc.
> [EMAIL PROTECTED]
> 678-475-2030
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
