RE: Antw: RE: Connection reset by peer: socket write error

2002-04-02 Thread Verma_Dilip

I get a strange problem using Oracle pooled connection. And the same problem
I saw in JRun 4.0.
The problem is when I connect using oracle pool I get incomplete data. In
other words, if I am suppose to get three records in a result set whereas I
get only one. The same problem I experienced when I tried JRun's Oracle
datasource.
So I left with no choice than using JRun 3.1's datasource.


-Original Message-
From: Sebastian Millies [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 5:22 AM
To: JRun-Talk
Subject: Antw: RE: Connection reset by peer: socket write error


as far as I know, the Oracle drivers come with Oracle's
implementation of a pooled data source/pooled connection.
How about using that? -- Sebastian


 [EMAIL PROTECTED] 28.03.2002  17.50 Uhr 
Ya, I am using Oracle's thin driver. 

-Original Message-
From: Ben Groeneveld [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 28, 2002 11:34 AM
To: JRun-Talk
Subject: Re: Connection reset by peer: socket write error


What's JRun's Oracle driver?  Have you tried using oracle's free thin 
driver?  We use oracle JDBC driver-8.1.6.2.0 on a large variety of 
projects and operations w/o a hiccup.  Maybe trying it will help you.  BenG.

[EMAIL PROTECTED] wrote:

Hi,
I am getting the following error while accessing the database. 
I have JRun 3.1.15506 app server running on win2000 and NT both, and using
oracle database. Instead of using JRun's connection pool for oracle I am
using my own connection pool. The system works fine most of the times but
all of a sudden it starts giving Connection reset by peer. I didn't have
this problem when I was using JRun's Oracle thin driver connection pool
before. But for migrating reasons I started using my own connection pool.
Sometimes when I query the database using preparedStatement, it throws the
below exception. I am seeing the same exception both on NT and win2000. 
Please tell what might the reason behind.
Thanks
_
_

Thu Mar 28 10:13:31 EST 2002
Io exception: Connection reset by peer: socket write error
java.sql.SQLException: Io exception: Connection reset by peer: socket write
error
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:292)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:307)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j
a
va:194)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j
a
va:177)
   at
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:
3
39)
   at
com.emc.asi.ejb.pool.ASIConnection.prepareStatement(ASIConnection.java:61)
   at com.emc.asi.ejb.LoginBean.processLogin(LoginBean.java:48)
   at java.lang.reflect.Method.invoke(Native Method)
   at
allaire.ejipt._BeanMethod._invoke(allaire/ejipt/_BeanMethod.java:166)
   at
allaire.ejipt._SessionObject._invoke(allaire/ejipt/_SessionObject.java:182)
   at
allaire.ejipt._CallableObject.call(allaire/ejipt/_CallableObject.java:101)
   at java.lang.reflect.Method.invoke(Native Method)
   at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
   at sun.rmi.transport.Transport$1.run(Transport.java:152)
   at java.security.AccessController.doPrivileged(Native Method)
   at sun.rmi.transport.Transport.serviceCall(Transport.java:148)
   at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465)
   at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:
7
06)
   at java.lang.Thread.run(Thread.java:484)




__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Connection reset by peer: socket write error

2002-04-01 Thread Verma_Dilip

Thanks savant for writing.
We are using Oracle 8.1.5 version.
And I get the problem when I use my connectio pooling, but if I use JRun's
connection pooling then it works fine.
So the problem lies somewhere in my connection pooling. I have tried
resetting the connection to null after closing but that also doesn't work. 
Let me describe a bit more about the situation in that  this error occurs.
We have a Oracle database that is down for 15 minutes everyday in the night
for some backup process. When database is up we get Connection reset by
peer, until we restart the JRun server. But that doesn't happen using
JRun's connection pool.
Now do you still think that this is related to query not pool?

Regards
Dilip 

-Original Message-
From: Savantraj, Chennamakal Subramanian [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 31, 2002 7:21 PM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Hi Dilip,
Are you using Oracle 8.1.6 Version? 
Try to run the same SQL from SQLPLUS. If that also fails problem is not with
JAVA .Problem is with Oracle.
I have encountered this problem while I was running a complicated SQL having
a few inner Queries and Distinct clauses.
Funny thing was once I removed some Distinct clause the SQL worked. The
problem is still a misery.We moved to Oracle 8.1.7 then everything went
fine.

Rgds
Savant

-Original Message-
From: Theodore Zimmerman [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 29, 2002 2:26 AM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Are you using a datatypes like blobs or clobs?  I've been doing some testing
lately with those datatypes and unless you used Oracle's implementation
would get that same error.

Ted Zimmerman

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 11:51 AM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Ya, I am using Oracle's thin driver. 

-Original Message-
From: Ben Groeneveld [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 11:34 AM
To: JRun-Talk
Subject: Re: Connection reset by peer: socket write error


What's JRun's Oracle driver?  Have you tried using oracle's free thin 
driver?  We use oracle JDBC driver-8.1.6.2.0 on a large variety of 
projects and operations w/o a hiccup.  Maybe trying it will help you.  BenG.

[EMAIL PROTECTED] wrote:

Hi,
I am getting the following error while accessing the database. 
I have JRun 3.1.15506 app server running on win2000 and NT both, and using
oracle database. Instead of using JRun's connection pool for oracle I am
using my own connection pool. The system works fine most of the times but
all of a sudden it starts giving Connection reset by peer. I didn't have
this problem when I was using JRun's Oracle thin driver connection pool
before. But for migrating reasons I started using my own connection pool.
Sometimes when I query the database using preparedStatement, it throws the
below exception. I am seeing the same exception both on NT and win2000. 
Please tell what might the reason behind.
Thanks
_
_

Thu Mar 28 10:13:31 EST 2002
Io exception: Connection reset by peer: socket write error
java.sql.SQLException: Io exception: Connection reset by peer: socket write
error
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:292)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:307)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j
a
va:194)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j
a
va:177)
   at
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:
3
39)
   at
com.emc.asi.ejb.pool.ASIConnection.prepareStatement(ASIConnection.java:61)
   at com.emc.asi.ejb.LoginBean.processLogin(LoginBean.java:48)
   at java.lang.reflect.Method.invoke(Native Method)
   at
allaire.ejipt._BeanMethod._invoke(allaire/ejipt/_BeanMethod.java:166)
   at
allaire.ejipt._SessionObject._invoke(allaire/ejipt/_SessionObject.java:182)
   at
allaire.ejipt._CallableObject.call(allaire/ejipt/_CallableObject.java:101)
   at java.lang.reflect.Method.invoke(Native Method)
   at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
   at sun.rmi.transport.Transport$1.run(Transport.java:152)
   at java.security.AccessController.doPrivileged(Native Method)
   at sun.rmi.transport.Transport.serviceCall(Transport.java:148)
   at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465)
   at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:
7
06

RE: Connection reset by peer: socket write error

2002-04-01 Thread Savantraj, Chennamakal Subramanian

Hi Dileep,

Now I understood your problem clearly.
This is quite normal. When the database goes down all the connection object
in your pool become Invalid.
Basically you need to create new connections in order to connect to the
restarted db.
When you use JRun pooling, JRun is handling this. So either you can use JRun
pooling or change your algorithm accordingly.

This is absolutely nothing to do with query.

Regards
Savant

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 11:11 PM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Thanks savant for writing.
We are using Oracle 8.1.5 version.
And I get the problem when I use my connectio pooling, but if I use JRun's
connection pooling then it works fine.
So the problem lies somewhere in my connection pooling. I have tried
resetting the connection to null after closing but that also doesn't work. 
Let me describe a bit more about the situation in that  this error occurs.
We have a Oracle database that is down for 15 minutes everyday in the night
for some backup process. When database is up we get Connection reset by
peer, until we restart the JRun server. But that doesn't happen using
JRun's connection pool.
Now do you still think that this is related to query not pool?

Regards
Dilip 

-Original Message-
From: Savantraj, Chennamakal Subramanian [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 31, 2002 7:21 PM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Hi Dilip,
Are you using Oracle 8.1.6 Version? 
Try to run the same SQL from SQLPLUS. If that also fails problem is not with
JAVA .Problem is with Oracle.
I have encountered this problem while I was running a complicated SQL having
a few inner Queries and Distinct clauses.
Funny thing was once I removed some Distinct clause the SQL worked. The
problem is still a misery.We moved to Oracle 8.1.7 then everything went
fine.

Rgds
Savant

-Original Message-
From: Theodore Zimmerman [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 29, 2002 2:26 AM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Are you using a datatypes like blobs or clobs?  I've been doing some testing
lately with those datatypes and unless you used Oracle's implementation
would get that same error.

Ted Zimmerman

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 11:51 AM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Ya, I am using Oracle's thin driver. 

-Original Message-
From: Ben Groeneveld [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 11:34 AM
To: JRun-Talk
Subject: Re: Connection reset by peer: socket write error


What's JRun's Oracle driver?  Have you tried using oracle's free thin 
driver?  We use oracle JDBC driver-8.1.6.2.0 on a large variety of 
projects and operations w/o a hiccup.  Maybe trying it will help you.  BenG.

[EMAIL PROTECTED] wrote:

Hi,
I am getting the following error while accessing the database. 
I have JRun 3.1.15506 app server running on win2000 and NT both, and using
oracle database. Instead of using JRun's connection pool for oracle I am
using my own connection pool. The system works fine most of the times but
all of a sudden it starts giving Connection reset by peer. I didn't have
this problem when I was using JRun's Oracle thin driver connection pool
before. But for migrating reasons I started using my own connection pool.
Sometimes when I query the database using preparedStatement, it throws the
below exception. I am seeing the same exception both on NT and win2000. 
Please tell what might the reason behind.
Thanks
_
_

Thu Mar 28 10:13:31 EST 2002
Io exception: Connection reset by peer: socket write error
java.sql.SQLException: Io exception: Connection reset by peer: socket write
error
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:292)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:307)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j
a
va:194)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j
a
va:177)
   at
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:
3
39)
   at
com.emc.asi.ejb.pool.ASIConnection.prepareStatement(ASIConnection.java:61)
   at com.emc.asi.ejb.LoginBean.processLogin(LoginBean.java:48)
   at java.lang.reflect.Method.invoke(Native Method)
   at
allaire.ejipt._BeanMethod._invoke(allaire/ejipt/_BeanMethod.java:166)
   at
allaire.ejipt._SessionObject._invoke(allaire/ejipt

Antw: RE: Connection reset by peer: socket write error

2002-04-01 Thread Sebastian Millies

as far as I know, the Oracle drivers come with Oracle's
implementation of a pooled data source/pooled connection.
How about using that? -- Sebastian


 [EMAIL PROTECTED] 28.03.2002  17.50 Uhr 
Ya, I am using Oracle's thin driver. 

-Original Message-
From: Ben Groeneveld [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 28, 2002 11:34 AM
To: JRun-Talk
Subject: Re: Connection reset by peer: socket write error


What's JRun's Oracle driver?  Have you tried using oracle's free thin 
driver?  We use oracle JDBC driver-8.1.6.2.0 on a large variety of 
projects and operations w/o a hiccup.  Maybe trying it will help you.  BenG.

[EMAIL PROTECTED] wrote:

Hi,
I am getting the following error while accessing the database. 
I have JRun 3.1.15506 app server running on win2000 and NT both, and using
oracle database. Instead of using JRun's connection pool for oracle I am
using my own connection pool. The system works fine most of the times but
all of a sudden it starts giving Connection reset by peer. I didn't have
this problem when I was using JRun's Oracle thin driver connection pool
before. But for migrating reasons I started using my own connection pool.
Sometimes when I query the database using preparedStatement, it throws the
below exception. I am seeing the same exception both on NT and win2000. 
Please tell what might the reason behind.
Thanks
_
_

Thu Mar 28 10:13:31 EST 2002
Io exception: Connection reset by peer: socket write error
java.sql.SQLException: Io exception: Connection reset by peer: socket write
error
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:292)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:307)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j
a
va:194)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j
a
va:177)
   at
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:
3
39)
   at
com.emc.asi.ejb.pool.ASIConnection.prepareStatement(ASIConnection.java:61)
   at com.emc.asi.ejb.LoginBean.processLogin(LoginBean.java:48)
   at java.lang.reflect.Method.invoke(Native Method)
   at
allaire.ejipt._BeanMethod._invoke(allaire/ejipt/_BeanMethod.java:166)
   at
allaire.ejipt._SessionObject._invoke(allaire/ejipt/_SessionObject.java:182)
   at
allaire.ejipt._CallableObject.call(allaire/ejipt/_CallableObject.java:101)
   at java.lang.reflect.Method.invoke(Native Method)
   at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
   at sun.rmi.transport.Transport$1.run(Transport.java:152)
   at java.security.AccessController.doPrivileged(Native Method)
   at sun.rmi.transport.Transport.serviceCall(Transport.java:148)
   at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465)
   at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:
7
06)
   at java.lang.Thread.run(Thread.java:484)



__
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/jrun-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Connection reset by peer: socket write error

2002-03-31 Thread Savantraj, Chennamakal Subramanian

Hi Dilip,
Are you using Oracle 8.1.6 Version? 
Try to run the same SQL from SQLPLUS. If that also fails problem is not with
JAVA .Problem is with Oracle.
I have encountered this problem while I was running a complicated SQL having
a few inner Queries and Distinct clauses.
Funny thing was once I removed some Distinct clause the SQL worked. The
problem is still a misery.We moved to Oracle 8.1.7 then everything went
fine.

Rgds
Savant

-Original Message-
From: Theodore Zimmerman [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 29, 2002 2:26 AM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Are you using a datatypes like blobs or clobs?  I've been doing some testing
lately with those datatypes and unless you used Oracle's implementation
would get that same error.

Ted Zimmerman

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 11:51 AM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Ya, I am using Oracle's thin driver. 

-Original Message-
From: Ben Groeneveld [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 11:34 AM
To: JRun-Talk
Subject: Re: Connection reset by peer: socket write error


What's JRun's Oracle driver?  Have you tried using oracle's free thin 
driver?  We use oracle JDBC driver-8.1.6.2.0 on a large variety of 
projects and operations w/o a hiccup.  Maybe trying it will help you.  BenG.

[EMAIL PROTECTED] wrote:

Hi,
I am getting the following error while accessing the database. 
I have JRun 3.1.15506 app server running on win2000 and NT both, and using
oracle database. Instead of using JRun's connection pool for oracle I am
using my own connection pool. The system works fine most of the times but
all of a sudden it starts giving Connection reset by peer. I didn't have
this problem when I was using JRun's Oracle thin driver connection pool
before. But for migrating reasons I started using my own connection pool.
Sometimes when I query the database using preparedStatement, it throws the
below exception. I am seeing the same exception both on NT and win2000. 
Please tell what might the reason behind.
Thanks
_
_

Thu Mar 28 10:13:31 EST 2002
Io exception: Connection reset by peer: socket write error
java.sql.SQLException: Io exception: Connection reset by peer: socket write
error
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:292)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:307)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j
a
va:194)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j
a
va:177)
   at
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:
3
39)
   at
com.emc.asi.ejb.pool.ASIConnection.prepareStatement(ASIConnection.java:61)
   at com.emc.asi.ejb.LoginBean.processLogin(LoginBean.java:48)
   at java.lang.reflect.Method.invoke(Native Method)
   at
allaire.ejipt._BeanMethod._invoke(allaire/ejipt/_BeanMethod.java:166)
   at
allaire.ejipt._SessionObject._invoke(allaire/ejipt/_SessionObject.java:182)
   at
allaire.ejipt._CallableObject.call(allaire/ejipt/_CallableObject.java:101)
   at java.lang.reflect.Method.invoke(Native Method)
   at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
   at sun.rmi.transport.Transport$1.run(Transport.java:152)
   at java.security.AccessController.doPrivileged(Native Method)
   at sun.rmi.transport.Transport.serviceCall(Transport.java:148)
   at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465)
   at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:
7
06)
   at java.lang.Thread.run(Thread.java:484)




__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Connection reset by peer: socket write error

2002-03-28 Thread Verma_Dilip

Hi,
I am getting the following error while accessing the database. 
I have JRun 3.1.15506 app server running on win2000 and NT both, and using
oracle database. Instead of using JRun's connection pool for oracle I am
using my own connection pool. The system works fine most of the times but
all of a sudden it starts giving Connection reset by peer. I didn't have
this problem when I was using JRun's Oracle thin driver connection pool
before. But for migrating reasons I started using my own connection pool.
Sometimes when I query the database using preparedStatement, it throws the
below exception. I am seeing the same exception both on NT and win2000. 
Please tell what might the reason behind.
Thanks
_
_

Thu Mar 28 10:13:31 EST 2002
Io exception: Connection reset by peer: socket write error
java.sql.SQLException: Io exception: Connection reset by peer: socket write
error
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:292)
at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:307)
at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.ja
va:194)
at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.ja
va:177)
at
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:3
39)
at
com.emc.asi.ejb.pool.ASIConnection.prepareStatement(ASIConnection.java:61)
at com.emc.asi.ejb.LoginBean.processLogin(LoginBean.java:48)
at java.lang.reflect.Method.invoke(Native Method)
at
allaire.ejipt._BeanMethod._invoke(allaire/ejipt/_BeanMethod.java:166)
at
allaire.ejipt._SessionObject._invoke(allaire/ejipt/_SessionObject.java:182)
at
allaire.ejipt._CallableObject.call(allaire/ejipt/_CallableObject.java:101)
at java.lang.reflect.Method.invoke(Native Method)
at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
at sun.rmi.transport.Transport$1.run(Transport.java:152)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:148)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:7
06)
at java.lang.Thread.run(Thread.java:484)
__
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/jrun-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Connection reset by peer: socket write error

2002-03-28 Thread Ben Groeneveld

What's JRun's Oracle driver?  Have you tried using oracle's free thin 
driver?  We use oracle JDBC driver-8.1.6.2.0 on a large variety of 
projects and operations w/o a hiccup.  Maybe trying it will help you.  BenG.

[EMAIL PROTECTED] wrote:

Hi,
I am getting the following error while accessing the database. 
I have JRun 3.1.15506 app server running on win2000 and NT both, and using
oracle database. Instead of using JRun's connection pool for oracle I am
using my own connection pool. The system works fine most of the times but
all of a sudden it starts giving Connection reset by peer. I didn't have
this problem when I was using JRun's Oracle thin driver connection pool
before. But for migrating reasons I started using my own connection pool.
Sometimes when I query the database using preparedStatement, it throws the
below exception. I am seeing the same exception both on NT and win2000. 
Please tell what might the reason behind.
Thanks
_
_

Thu Mar 28 10:13:31 EST 2002
Io exception: Connection reset by peer: socket write error
java.sql.SQLException: Io exception: Connection reset by peer: socket write
error
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:292)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:307)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.ja
va:194)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.ja
va:177)
   at
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:3
39)
   at
com.emc.asi.ejb.pool.ASIConnection.prepareStatement(ASIConnection.java:61)
   at com.emc.asi.ejb.LoginBean.processLogin(LoginBean.java:48)
   at java.lang.reflect.Method.invoke(Native Method)
   at
allaire.ejipt._BeanMethod._invoke(allaire/ejipt/_BeanMethod.java:166)
   at
allaire.ejipt._SessionObject._invoke(allaire/ejipt/_SessionObject.java:182)
   at
allaire.ejipt._CallableObject.call(allaire/ejipt/_CallableObject.java:101)
   at java.lang.reflect.Method.invoke(Native Method)
   at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
   at sun.rmi.transport.Transport$1.run(Transport.java:152)
   at java.security.AccessController.doPrivileged(Native Method)
   at sun.rmi.transport.Transport.serviceCall(Transport.java:148)
   at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465)
   at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:7
06)
   at java.lang.Thread.run(Thread.java:484)

__
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/jrun-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Connection reset by peer: socket write error

2002-03-28 Thread Verma_Dilip

Ya, I am using Oracle's thin driver. 

-Original Message-
From: Ben Groeneveld [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 11:34 AM
To: JRun-Talk
Subject: Re: Connection reset by peer: socket write error


What's JRun's Oracle driver?  Have you tried using oracle's free thin 
driver?  We use oracle JDBC driver-8.1.6.2.0 on a large variety of 
projects and operations w/o a hiccup.  Maybe trying it will help you.  BenG.

[EMAIL PROTECTED] wrote:

Hi,
I am getting the following error while accessing the database. 
I have JRun 3.1.15506 app server running on win2000 and NT both, and using
oracle database. Instead of using JRun's connection pool for oracle I am
using my own connection pool. The system works fine most of the times but
all of a sudden it starts giving Connection reset by peer. I didn't have
this problem when I was using JRun's Oracle thin driver connection pool
before. But for migrating reasons I started using my own connection pool.
Sometimes when I query the database using preparedStatement, it throws the
below exception. I am seeing the same exception both on NT and win2000. 
Please tell what might the reason behind.
Thanks
_
_

Thu Mar 28 10:13:31 EST 2002
Io exception: Connection reset by peer: socket write error
java.sql.SQLException: Io exception: Connection reset by peer: socket write
error
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:292)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:307)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j
a
va:194)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j
a
va:177)
   at
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:
3
39)
   at
com.emc.asi.ejb.pool.ASIConnection.prepareStatement(ASIConnection.java:61)
   at com.emc.asi.ejb.LoginBean.processLogin(LoginBean.java:48)
   at java.lang.reflect.Method.invoke(Native Method)
   at
allaire.ejipt._BeanMethod._invoke(allaire/ejipt/_BeanMethod.java:166)
   at
allaire.ejipt._SessionObject._invoke(allaire/ejipt/_SessionObject.java:182)
   at
allaire.ejipt._CallableObject.call(allaire/ejipt/_CallableObject.java:101)
   at java.lang.reflect.Method.invoke(Native Method)
   at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
   at sun.rmi.transport.Transport$1.run(Transport.java:152)
   at java.security.AccessController.doPrivileged(Native Method)
   at sun.rmi.transport.Transport.serviceCall(Transport.java:148)
   at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465)
   at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:
7
06)
   at java.lang.Thread.run(Thread.java:484)


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Connection reset by peer: socket write error

2002-03-28 Thread Verma_Dilip

Hi,
I am using clobs and nested tables but I am also using oracle implementation
of those.
I am getting this error on prepared statement.


-Original Message-
From: Theodore Zimmerman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 1:26 PM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Are you using a datatypes like blobs or clobs?  I've been doing some testing
lately with those datatypes and unless you used Oracle's implementation
would get that same error.

Ted Zimmerman

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 11:51 AM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Ya, I am using Oracle's thin driver. 

-Original Message-
From: Ben Groeneveld [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 11:34 AM
To: JRun-Talk
Subject: Re: Connection reset by peer: socket write error


What's JRun's Oracle driver?  Have you tried using oracle's free thin 
driver?  We use oracle JDBC driver-8.1.6.2.0 on a large variety of 
projects and operations w/o a hiccup.  Maybe trying it will help you.  BenG.

[EMAIL PROTECTED] wrote:

Hi,
I am getting the following error while accessing the database. 
I have JRun 3.1.15506 app server running on win2000 and NT both, and using
oracle database. Instead of using JRun's connection pool for oracle I am
using my own connection pool. The system works fine most of the times but
all of a sudden it starts giving Connection reset by peer. I didn't have
this problem when I was using JRun's Oracle thin driver connection pool
before. But for migrating reasons I started using my own connection pool.
Sometimes when I query the database using preparedStatement, it throws the
below exception. I am seeing the same exception both on NT and win2000. 
Please tell what might the reason behind.
Thanks
_
_

Thu Mar 28 10:13:31 EST 2002
Io exception: Connection reset by peer: socket write error
java.sql.SQLException: Io exception: Connection reset by peer: socket write
error
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:292)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:307)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j
a
va:194)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j
a
va:177)
   at
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:
3
39)
   at
com.emc.asi.ejb.pool.ASIConnection.prepareStatement(ASIConnection.java:61)
   at com.emc.asi.ejb.LoginBean.processLogin(LoginBean.java:48)
   at java.lang.reflect.Method.invoke(Native Method)
   at
allaire.ejipt._BeanMethod._invoke(allaire/ejipt/_BeanMethod.java:166)
   at
allaire.ejipt._SessionObject._invoke(allaire/ejipt/_SessionObject.java:182)
   at
allaire.ejipt._CallableObject.call(allaire/ejipt/_CallableObject.java:101)
   at java.lang.reflect.Method.invoke(Native Method)
   at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
   at sun.rmi.transport.Transport$1.run(Transport.java:152)
   at java.security.AccessController.doPrivileged(Native Method)
   at sun.rmi.transport.Transport.serviceCall(Transport.java:148)
   at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465)
   at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:
7
06)
   at java.lang.Thread.run(Thread.java:484)




__
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/jrun-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Connection reset by peer: socket write error

2002-03-28 Thread Theodore Zimmerman

Verma,
In what scenarios do you get this problem.  Is it on inserts or selects or both?  

Does it happen all the time?  If so is there a way to reproduce the problem.

Does JRun continue to work properly after the problem occurs?  Have you tried it 
without connection pooling?  I know you indicated previously that this didn't happen 
when you used JRun's pooling.  The problem may very well have to do with the 
connection pooling classes that you are using.

Ted Zimmerman

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 1:35 PM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Hi,
I am using clobs and nested tables but I am also using oracle implementation
of those.
I am getting this error on prepared statement.


-Original Message-
From: Theodore Zimmerman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 1:26 PM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Are you using a datatypes like blobs or clobs?  I've been doing some testing
lately with those datatypes and unless you used Oracle's implementation
would get that same error.

Ted Zimmerman

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 11:51 AM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Ya, I am using Oracle's thin driver. 

-Original Message-
From: Ben Groeneveld [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 11:34 AM
To: JRun-Talk
Subject: Re: Connection reset by peer: socket write error


What's JRun's Oracle driver?  Have you tried using oracle's free thin 
driver?  We use oracle JDBC driver-8.1.6.2.0 on a large variety of 
projects and operations w/o a hiccup.  Maybe trying it will help you.  BenG.

[EMAIL PROTECTED] wrote:

Hi,
I am getting the following error while accessing the database. 
I have JRun 3.1.15506 app server running on win2000 and NT both, and using
oracle database. Instead of using JRun's connection pool for oracle I am
using my own connection pool. The system works fine most of the times but
all of a sudden it starts giving Connection reset by peer. I didn't have
this problem when I was using JRun's Oracle thin driver connection pool
before. But for migrating reasons I started using my own connection pool.
Sometimes when I query the database using preparedStatement, it throws the
below exception. I am seeing the same exception both on NT and win2000. 
Please tell what might the reason behind.
Thanks
_
_

Thu Mar 28 10:13:31 EST 2002
Io exception: Connection reset by peer: socket write error
java.sql.SQLException: Io exception: Connection reset by peer: socket write
error
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:292)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:307)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j
a
va:194)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j
a
va:177)
   at
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:
3
39)
   at
com.emc.asi.ejb.pool.ASIConnection.prepareStatement(ASIConnection.java:61)
   at com.emc.asi.ejb.LoginBean.processLogin(LoginBean.java:48)
   at java.lang.reflect.Method.invoke(Native Method)
   at
allaire.ejipt._BeanMethod._invoke(allaire/ejipt/_BeanMethod.java:166)
   at
allaire.ejipt._SessionObject._invoke(allaire/ejipt/_SessionObject.java:182)
   at
allaire.ejipt._CallableObject.call(allaire/ejipt/_CallableObject.java:101)
   at java.lang.reflect.Method.invoke(Native Method)
   at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
   at sun.rmi.transport.Transport$1.run(Transport.java:152)
   at java.security.AccessController.doPrivileged(Native Method)
   at sun.rmi.transport.Transport.serviceCall(Transport.java:148)
   at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465)
   at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:
7
06)
   at java.lang.Thread.run(Thread.java:484)





__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Connection reset by peer: socket write error

2002-03-28 Thread Verma_Dilip

Dear Zimmerman,
The problem does not occur always. It happens once in a while. I have seen
this problem 2-3 times but I am unable to figure out it's basic nature. When
I get a conneciotn from the pool and try to call a prepared statement on
that then it problem occurs, but not always. I got this error this morning
when I tried to login in the system, which further get login info from the
database. There is a possibility that our network was down for few minutes
but it was back soon. May that causes that error. I am attaching my
connectio pooling classes. Check out if you can find anything wrong.

Thanks

-Original Message-
From: Theodore Zimmerman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 4:33 PM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Verma,
In what scenarios do you get this problem.  Is it on inserts or selects or
both?  

Does it happen all the time?  If so is there a way to reproduce the problem.

Does JRun continue to work properly after the problem occurs?  Have you
tried it without connection pooling?  I know you indicated previously that
this didn't happen when you used JRun's pooling.  The problem may very well
have to do with the connection pooling classes that you are using.

Ted Zimmerman

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 1:35 PM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Hi,
I am using clobs and nested tables but I am also using oracle implementation
of those.
I am getting this error on prepared statement.


-Original Message-
From: Theodore Zimmerman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 1:26 PM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Are you using a datatypes like blobs or clobs?  I've been doing some testing
lately with those datatypes and unless you used Oracle's implementation
would get that same error.

Ted Zimmerman

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 11:51 AM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Ya, I am using Oracle's thin driver. 

-Original Message-
From: Ben Groeneveld [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 11:34 AM
To: JRun-Talk
Subject: Re: Connection reset by peer: socket write error


What's JRun's Oracle driver?  Have you tried using oracle's free thin 
driver?  We use oracle JDBC driver-8.1.6.2.0 on a large variety of 
projects and operations w/o a hiccup.  Maybe trying it will help you.  BenG.

[EMAIL PROTECTED] wrote:

Hi,
I am getting the following error while accessing the database. 
I have JRun 3.1.15506 app server running on win2000 and NT both, and using
oracle database. Instead of using JRun's connection pool for oracle I am
using my own connection pool. The system works fine most of the times but
all of a sudden it starts giving Connection reset by peer. I didn't have
this problem when I was using JRun's Oracle thin driver connection pool
before. But for migrating reasons I started using my own connection pool.
Sometimes when I query the database using preparedStatement, it throws the
below exception. I am seeing the same exception both on NT and win2000. 
Please tell what might the reason behind.
Thanks
_
_

Thu Mar 28 10:13:31 EST 2002
Io exception: Connection reset by peer: socket write error
java.sql.SQLException: Io exception: Connection reset by peer: socket write
error
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:292)
   at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:307)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j
a
va:194)
   at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j
a
va:177)
   at
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:
3
39)
   at
com.emc.asi.ejb.pool.ASIConnection.prepareStatement(ASIConnection.java:61)
   at com.emc.asi.ejb.LoginBean.processLogin(LoginBean.java:48)
   at java.lang.reflect.Method.invoke(Native Method)
   at
allaire.ejipt._BeanMethod._invoke(allaire/ejipt/_BeanMethod.java:166)
   at
allaire.ejipt._SessionObject._invoke(allaire/ejipt/_SessionObject.java:182)
   at
allaire.ejipt._CallableObject.call(allaire/ejipt/_CallableObject.java:101)
   at java.lang.reflect.Method.invoke(Native Method)
   at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
   at sun.rmi.transport.Transport$1.run(Transport.java:152)
   at java.security.AccessController.doPrivileged(Native

RE: Connection reset by peer: socket write error

2002-03-28 Thread Daniel . Broadway

We were getting this problem (Connection reset by peer: socket write error)
consistently when our application was under a pretty heavy load.  We
attributed the problem to the bitmechanic JDBC connection pool that we were
using at the time (we never looked into exactly what was wrong with the
pool).  We switched to the PoolMan JDBC connection pool and the problem
went away.



P.S.  We aren't using the JRun connection pool because we need to use our
connection pool outside of JRun.




[EMAIL PROTECTED]
03/28/2002 03:53 PM





Please respond to [EMAIL PROTECTED]

To:JRun-Talk [EMAIL PROTECTED]
cc:

Subject:RE: Connection reset by peer: socket write error


Dear Zimmerman,
The problem does not occur always. It happens once in a while. I have seen
this problem 2-3 times but I am unable to figure out it's basic nature.
When
I get a conneciotn from the pool and try to call a prepared statement on
that then it problem occurs, but not always. I got this error this morning
when I tried to login in the system, which further get login info from the
database. There is a possibility that our network was down for few minutes
but it was back soon. May that causes that error. I am attaching my
connectio pooling classes. Check out if you can find anything wrong.

Thanks

-Original Message-
From: Theodore Zimmerman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 4:33 PM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Verma,
In what scenarios do you get this problem.  Is it on inserts or selects or
both?

Does it happen all the time?  If so is there a way to reproduce the
problem.

Does JRun continue to work properly after the problem occurs?  Have you
tried it without connection pooling?  I know you indicated previously that
this didn't happen when you used JRun's pooling.  The problem may very well
have to do with the connection pooling classes that you are using.

Ted Zimmerman

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 1:35 PM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Hi,
I am using clobs and nested tables but I am also using oracle
implementation
of those.
I am getting this error on prepared statement.


-Original Message-
From: Theodore Zimmerman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 1:26 PM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Are you using a datatypes like blobs or clobs?  I've been doing some
testing
lately with those datatypes and unless you used Oracle's implementation
would get that same error.

Ted Zimmerman

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 11:51 AM
To: JRun-Talk
Subject: RE: Connection reset by peer: socket write error


Ya, I am using Oracle's thin driver.

-Original Message-
From: Ben Groeneveld [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 11:34 AM
To: JRun-Talk
Subject: Re: Connection reset by peer: socket write error


What's JRun's Oracle driver?  Have you tried using oracle's free thin
driver?  We use oracle JDBC driver-8.1.6.2.0 on a large variety of
projects and operations w/o a hiccup.  Maybe trying it will help you.
BenG.

[EMAIL PROTECTED] wrote:

Hi,
I am getting the following error while accessing the database.
I have JRun 3.1.15506 app server running on win2000 and NT both, and using
oracle database. Instead of using JRun's connection pool for oracle I am
using my own connection pool. The system works fine most of the times but
all of a sudden it starts giving Connection reset by peer. I didn't have
this problem when I was using JRun's Oracle thin driver connection pool
before. But for migrating reasons I started using my own connection pool.
Sometimes when I query the database using preparedStatement, it throws the
below exception. I am seeing the same exception both on NT and win2000.
Please tell what might the reason behind.
Thanks
_
_

Thu Mar 28 10:13:31 EST 2002
Io exception: Connection reset by peer: socket write error
java.sql.SQLException: Io exception: Connection reset by peer: socket
write
error
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
 at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:292)
 at
oracle.jdbc.driver.OracleStatement.init(OracleStatement.java:307)
 at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j

a
va:194)
 at
oracle.jdbc.driver.OraclePreparedStatement.init(OraclePreparedStatement.j

a
va:177)
 at
oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:

3
39)
 at
com.emc.asi.ejb.pool.ASIConnection.prepareStatement

java.net.SocketException: Connection reset by peer: socket write error

2001-02-21 Thread travis

Any ideas why I would be getting this?  It doesn't happen all the time, just sometimes 
and it seems only with some users as well?

Basically all it is doing is sending a file through a jsp page and I get the following.

Current Page: /secure/files/file_sender.jsp -- fid=5339

java.net.SocketException: Connection reset by peer: socket write error

java.net.SocketException: Connection reset by peer: socket write error 
at java.net.SocketOutputStream.socketWrite(Native Method) 
at java.net.SocketOutputStream.write(SocketOutputStream.java:83) 
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:72) 
at java.io.BufferedOutputStream.write(BufferedOutputStream.java:111) 
at allaire.jrun.jrpp.JrppOutputStream.write(../jrpp/ProxyEndpoint.java:727) 
at java.io.ByteArrayOutputStream.writeTo(ByteArrayOutputStream.java:126) 
at allaire.jrun.servlet.ServletBAOS.commit(../servlet/ServletBAOS.java:163) 
at allaire.jrun.servlet.ServletBAOS.commit(../servlet/ServletBAOS.java:140) 
at 
allaire.jrun.servlet.JRunOutputStream.write(../servlet/JRunOutputStream.java:100) 
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:72) 
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:130) 
at com.spaceprogram.util.FileUtils.returnFile(FileUtils.java:148) 
at com.thinkvirtual.files.File.returnFile(File.java:170) 
at 
jrun__secure__files__file_sender2ejsp1d._jspService(jrun__secure__files__file_sender2ejsp1d.java:90)
 
at allaire.jrun.jsp.HttpJSPServlet.service(../jsp/HttpJSPServlet.java:40) 
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1013) 
at allaire.jrun.servlet.JRunSE.runServlet(../servlet/JRunSE.java:925) 
at 
allaire.jrun.servlet.JRunNamedDispatcher.forward(../servlet/JRunNamedDispatcher.java:34)
 
at allaire.jrun.jsp.JSPServlet.service(../jsp/JSPServlet.java:175) 
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1013) 
at allaire.jrun.servlet.JRunSE.runServlet(../servlet/JRunSE.java:925) 
at 
allaire.jrun.servlet.JRunRequestDispatcher.forward(../servlet/JRunRequestDispatcher.java:88)
 
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1131) 
at allaire.jrun.servlet.JvmContext.dispatch(../servlet/JvmContext.java:330) 
at allaire.jrun.jrpp.ProxyEndpoint.run(../jrpp/ProxyEndpoint.java:382) 
at allaire.jrun.ThreadPool.run(../ThreadPool.java:272) 
at allaire.jrun.WorkerThread.run(../WorkerThread.java:75) 

Travis Reeder
Chief Software Architect
www.ThinkVirtual.com


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: java.net.SocketException: Connection reset by peer: socket write error

2001-02-21 Thread rhampl1


I have seen this "error" when the use hits the stop button on the browser.
Its not consistent but I have seen it.



   
   
travis@thinkv  
   
irtual.com   To: JRun-Talk 
[EMAIL PROTECTED]  
 cc: (bcc: Russ A Hampleman/KC/HALLMARK)   
   
02/21/01 Subject: java.net.SocketException: 
Connection reset by peer: socket  
03:05 PM write error   
   
Please 
   
respond to 
   
jrun-talk  
   
   
   
   
   




Any ideas why I would be getting this?  It doesn't happen all the time,
just sometimes and it seems only with some users as well?

Basically all it is doing is sending a file through a jsp page and I get
the following.

Current Page: /secure/files/file_sender.jsp -- fid=5339

java.net.SocketException: Connection reset by peer: socket write error

java.net.SocketException: Connection reset by peer: socket write error
at java.net.SocketOutputStream.socketWrite(Native Method)
at java.net.SocketOutputStream.write(SocketOutputStream.java:83)
at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:72)
at java.io.BufferedOutputStream.write(BufferedOutputStream.java:111)
at allaire.jrun.jrpp.JrppOutputStream.write
(../jrpp/ProxyEndpoint.java:727)
at
java.io.ByteArrayOutputStream.writeTo(ByteArrayOutputStream.java:126)
at allaire.jrun.servlet.ServletBAOS.commit
(../servlet/ServletBAOS.java:163)
at allaire.jrun.servlet.ServletBAOS.commit
(../servlet/ServletBAOS.java:140)
at allaire.jrun.servlet.JRunOutputStream.write
(../servlet/JRunOutputStream.java:100)
at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:72)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:130)
at com.spaceprogram.util.FileUtils.returnFile(FileUtils.java:148)
at com.thinkvirtual.files.File.returnFile(File.java:170)
at jrun__secure__files__file_sender2ejsp1d.
_jspService(jrun__secure__files__file_sender2ejsp1d.java:90)
at allaire.jrun.jsp.HttpJSPServlet.service
(../jsp/HttpJSPServlet.java:40)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1013)
at allaire.jrun.servlet.JRunSE.runServlet(../servlet/JRunSE.java:925)
at allaire.jrun.servlet.JRunNamedDispatcher.forward
(../servlet/JRunNamedDispatcher.java:34)
at allaire.jrun.jsp.JSPServlet.service(../jsp/JSPServlet.java:175)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1013)
at allaire.jrun.servlet.JRunSE.runServlet(../servlet/JRunSE.java:925)
at allaire.jrun.servlet.JRunRequestDispatcher.forward
(../servlet/JRunRequestDispatcher.java:88)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1131)
at allaire.jrun.servlet.JvmContext.dispatch
(../servlet/JvmContext.java:330)
at allaire.jrun.jrpp.ProxyEndpoint.run(../jrpp/ProxyEndpoint.java:382)
at allaire.jrun.ThreadPool.run(../ThreadPool.java:272)
at allaire.jrun.WorkerThread.run(../WorkerThread.java:75)

Travis Reeder
Chief Software Architect
www.ThinkVirtual.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists