[JBoss-user] [JCA/JBoss] - Broken pipe

2005-02-23 Thread lee_yuki2000
Hi,
   I am using jboss-3.2.3 and oracle 9i. I have broken pipe error when the sql 
statement takes long time (more than 15 minutes) to execute. This problem will 
not happen if the sql execution is fast. The error log is as follows:


 2005-03-06 18:57:58,959 WARN  
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Exception 
destroying ManagedConnection
org.jboss.resource.JBossResourceException: SQLException; - nested throwable: 
(java.sql.SQLException: Io exception: Broken pipe)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:546)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:252)
at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:502)
at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.returnConnection(InternalManagedConnectionPool.java:326)

Caused by: java.sql.SQLException: Io exception: Broken pipe
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
at oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1478)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:248)


I've suspect 2 problems which cause this error

1) For some reason the connection between the AppServer and the database is 
lost. May be that the DBMS itself or a firewall may shut down 
sockets/connections that are idle for too long. 

2) The jboss connection to the oracle server had timeout.

In my oracle-ds.xml, my setting is as below:

 
  
DB
jdbc:oracle:thin:@10.10.10.10:1521:ora

oracle.jdbc.driver.OracleDriver
user
password
 10
300
  1
20
select sysdate from dual
select sysdate from 
dual

org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
  



Even though i change the  idle-timeout from 20 minutes to 40 minutes, the i 
still get this error. Do i need to set  true 
? What is the  for?

Pls help. Thanks in advance




View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3867700#3867700

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3867700


---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
___
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [JCA/JBoss] - java.sql.SQLException: Io exception: Broken pipe

2004-12-16 Thread lee_yuki2000
Hi adrian,
 Do you know why i have this error? Sometimes i get broken pipe 
error and sometimes i don't get. I am using jboss 3.2.3, oracle 9 I, jdk 1.4.2. 
Is the connection open for too long? I am not sure how to solve it. I hope u 
can help me. Thanks

java.sql.SQLException: Io exception: Broken pipe
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
at 
oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:1416)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcRollback(BaseWrapperManagedConnection.java:514)
at 
org.jboss.resource.adapter.jdbc.WrappedConnection.rollback(WrappedConnection.java:477)
at 
sqlj.runtime.profile.ref.TransactionControlProfile$RollbackStatement.executeUpdate(TransactionControlProfile.java:263)
at 
sqlj.runtime.ExecutionContext$StatementFrame.executeUpdate(ExecutionContext.java:1221)
at 
sqlj.runtime.ExecutionContext.executeUpdate(ExecutionContext.java:698)
at 
com.scan.prisma.cams.sqlj.event.EventDomain.updateEventStatus(EventDomain.java:3710)
at 
com.scan.prisma.cams.ejb.session.event.EventManagerBean.userAction(EventManagerBean.java:438)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at 
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
at 
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
at 
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at 
org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:144)
at 
org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:62)
at 
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
at 
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at 
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at 
org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
at org.jboss.ejb.Container.invoke(Container.java:700)
at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at 
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
at 
org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:367)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at 
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at 
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3858973#3858973

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3858973


---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now. 
http://productguide.itmanagersjournal.com/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [JCA/JBoss] - Re: Return null pointer exception when i get connection from

2004-12-16 Thread lee_yuki2000
thanks for you reply

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3858971#3858971

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3858971


---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now. 
http://productguide.itmanagersjournal.com/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [JCA/JBoss] - Re: Return null pointer exception when i get connection from

2004-12-15 Thread lee_yuki2000
Hi adrian, 
 The stacktrace is as below:

004-12-09 22:45:01,546 ERROR [org.jboss.ejb.plugins.LogInterceptor] 
RuntimeException:
java.lang.NullPointerException
at 
sqlj.runtime.profile.ref.ProfileImpl.getConnectedProfile(ProfileImpl.java:170)
at 
sqlj.runtime.ref.ProfileGroup$ConnectedGroup.getProfile(ProfileGroup.java:194)
at 
sqlj.runtime.ref.ConnectionContextImpl.getConnectedProfile(ConnectionContextImpl.java:351)
at 
sqlj.runtime.ExecutionContext.registerStatement(ExecutionContext.java:598)
at 
com.scan.prisma.cams.sqlj.filter.FilterDomain.add(FilterDomain.java:1324)
at 
com.scan.prisma.cams.ejb.session.filter.FilterManagerBean.addFilter(FilterManagerBean.java:142)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at 
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
at 
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
at 
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at 
org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:144)
at 
org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:62)
at 
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
at 
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at 
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at 
org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
at org.jboss.ejb.Container.invoke(Container.java:700)
at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at 
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
at 
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
at 
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
at 
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
at 
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
at $Proxy93.addFilter(Unknown Source)
at com.scan.prisma.cams.business_logic.Filter.execute(Filter.java:72)
at 
com.scan.prisma.cams.presentation.struts.action.FilterAction.doAdd(FilterAction.java:286)
at 
com.scan.prisma.cams.presentation.struts.action.FilterAction.execute(FilterAction.java:97)
at 
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:480)
at 
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at 
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1420)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:520)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at 
org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at 
org.apache.catalina.valves.Certif

[JBoss-user] [Installation & Configuration] - java.sql.SQLException: Io exception: Connection reset

2004-12-14 Thread lee_yuki2000
Hi,
   Does any one know why i have this error java.sql.SQLException: Io exception: 
Connection reset. It happens once a while in the application. I am just 
wondering is it all the connections are used? Or the connection timeout is too 
long? I am using jboss 3.2.3 and oracle 9. My setting for oracle-ds.xml is as 
below:



  
ORA
jdbc:oracle:thin:@10.10.10.1:1521:dev

oracle.jdbc.driver.OracleDriver
xx
xxx
10
300
150
30
 
org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
  


The error is as below:

2004-12-18 00:44:59,829 ERROR [STDERR] java.sql.SQLException: Io exception: 
Connection reset
2004-12-18 00:44:59,831 ERROR [STDERR]  at 
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
2004-12-18 00:44:59,832 ERROR [STDERR]  at 
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
2004-12-18 00:44:59,832 ERROR [STDERR]  at 
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
2004-12-18 00:44:59,832 ERROR [STDERR]  at 
oracle.jdbc.driver.OracleConnection.setAutoCommit(OracleConnection.java:1260)
2004-12-18 00:44:59,832 ERROR [STDERR]  at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:395)
2004-12-18 00:44:59,832 ERROR [STDERR]  at 
org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:760)
2004-12-18 00:44:59,832 ERROR [STDERR]  at 
org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:208)
2004-12-18 00:44:59,832 ERROR [STDERR]  at 
sqlj.runtime.profile.ref.JDBCProfile.prepareCachedStatement(JDBCProfile.java:334)
2004-12-18 00:44:59,832 ERROR [STDERR]  at 
sqlj.runtime.profile.ref.JDBCProfile.getCachedStatement(JDBCProfile.java:192)
2004-12-18 00:44:59,832 ERROR [STDERR]  at 
sqlj.runtime.profile.ref.CachedStatementProfileWrapper.getCachedStatement(CachedStatementProfileWrapper.java:157)
2004-12-18 00:44:59,832 ERROR [STDERR]  at 
sqlj.runtime.profile.ref.IterConvertProfile.getCachedStatement(IterConvertProfile.java:113)
2004-12-18 00:44:59,832 ERROR [STDERR]  at 
sqlj.runtime.profile.ref.CachedStatementProfileWrapper.getCachedStatement(CachedStatementProfileWrapper.java:157)
2004-12-18 00:44:59,832 ERROR [STDERR]  at 
sqlj.runtime.profile.ref.UntypedSelectProfile.getCachedStatement(UntypedSelectProfile.java:109)
2004-12-18 00:44:59,833 ERROR [STDERR]  at 
sqlj.runtime.profile.ref.CachedStatementProfileWrapper.getCachedStatement(CachedStatementProfileWrapper.java:157)
2004-12-18 00:44:59,833 ERROR [STDERR]  at 
sqlj.runtime.profile.ref.ParamRegProfile.getCachedStatement(ParamRegProfile.java:57)
2004-12-18 00:44:59,833 ERROR [STDERR]  at 
sqlj.runtime.profile.ref.CachedStatementProfileWrapper.getCachedStatement(CachedStatementProfileWrapper.java:157)
2004-12-18 00:44:59,833 ERROR [STDERR]  at 
sqlj.runtime.profile.ref.PositionedProfile.getCachedStatement(PositionedProfile.java:162)
2004-12-18 00:44:59,833 ERROR [STDERR]  at 
sqlj.runtime.profile.ref.CachedStatementProfileWrapper.getCachedStatement(CachedStatementProfileWrapper.java:157)
2004-12-18 00:44:59,833 ERROR [STDERR]  at 
sqlj.runtime.profile.ref.TransactionControlProfile.getCachedStatement(TransactionControlProfile.java:164)
2004-12-18 00:44:59,833 ERROR [STDERR]  at 
sqlj.runtime.profile.ref.CachedStatementProfileWrapper.getStatement(CachedStatementProfileWrapper.java:134)
2004-12-18 00:44:59,833 ERROR [STDERR]  at 
sqlj.runtime.ExecutionContext$StatementStack.setStatement(ExecutionContext.java:1091)
2004-12-18 00:44:59,833 ERROR [STDERR]  at 
sqlj.runtime.ExecutionContext.registerStatement(ExecutionContext.java:613)


I am setting the blocking-timeout-millis to 150 milisecond which is 25 
minutes. Is it too long? The reason why it is set to 25 minutes is because 
sometimes when the application is trying to get connection it will return null 
pointer exception. I am trying to set the waiting time longer so that it will 
wait for the next connection. However i still get null pointer exception once a 
while. I am not sure why does it happen since i have already set the maximum 
connectins to 300. There isn't many user using the system. It's about 10 users. 


Besides that, sometimes when the application is updating the database, and 
before the updating process finish, the connection is closed. And it will 
return null pointer exception. The updating process maybe 1-2 minutes and  i 
have already set the  to 30 minutes. So it should wait 
till the updating process finish and then close the connection. The error is as 
below: 


2004-12-18 00:45:03,123 ERROR [org.jboss.ejb.plugins.LogInterceptor] 
RuntimeException:
java.lang.NullPointerException
at 
sqlj.runtime.profile.ref.RTStatementJDBCBase.releaseStatement(RTStatementJDBCBase.java:1257)
at 
sqlj.runtime.profile.ref.RTStatementJDBCBase.checkClose(RTStatementJDBCBase.java:954)
at 
sqlj.runtime.profile.ref.RTStatementJDBCBase.executeCo

[JBoss-user] [JCA/JBoss] - Return null pointer exception when i get connection from the

2004-12-09 Thread lee_yuki2000
Hi,
   I am using jboss-3.2.3 and oracle 9 database. My problem is sometimes i get 
null pointer exception when i get connection from the pool even though i have 
set the maximum pool size to 100. I think it is sufficient enough to handle the 
connections because there only 10 users connecting to the database 
simultaneously. The oracle-ds.xml setting is as follows:


  
ora
 
jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.1)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.2)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=oradb)))
   
oracle.jdbc.driver.OracleDriver
x
xx
50
100
180

org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
  


i am setting the minimum pool to 50 which mean it will have minimum of 50 
connections in the pool even though there isn't any connection being used? Am i 
right? Should i set the minimum pool to 0? 

I am not sure why i get null pointer exception when i try to get connection 
even though i have set 
180 which it suppose to 
wait for 30 minutes if the connections are all used up. Anyone know why? Pls 
help. Thanks alot

yuki

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3857988#3857988

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3857988


---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now. 
http://productguide.itmanagersjournal.com/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Installation & Configuration] - Re: Connection handle has been closed and is unusable

2004-12-08 Thread lee_yuki2000
Hi,
  Thanks for your reply. Now i am using jboss-3.2.3. I still get the error even 
though i've closed the connection in finally statement. I have a few sql 
statements in a method and it seems like jboss closed the connection before the 
all the queries are being executed. Anyone know why? Pls help. Thanks alot 

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3857839#3857839

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3857839


---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now. 
http://productguide.itmanagersjournal.com/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [HTTPD, Servlets & JSP] - Re: org.apache.jasper.JasperException

2004-08-25 Thread lee_yuki2000
There isn't any error. It only happen if  there is alot of data on the page. 
Could it be too many data? The log is as below:

2004-08-27 03:40:27,526 DEBUG [org.apache.struts.action.RequestProcessor] 
processForwardConfig(ForwardConfig[name=success,path=/event_sig_list.jsp,redirect=false,contextRelative=false])
2004-08-27 03:40:27,532 ERROR [org.jboss.web.localhost.Engine] ApplicationDispatcher[] 
Servlet.service() for servlet jsp threw exception
org.apache.jasper.JasperException
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3846242#3846242

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3846242


---
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [HTTPD, Servlets & JSP] - org.apache.jasper.JasperException

2004-08-24 Thread lee_yuki2000
Hi,
   I m using jboss 3.2.3 and i have this error once a while. It doesn't happen very 
often but i would like to know why this error occur. Pls help
Thank you very much 


When i click on the jsp page, this error occur

HTTP status 500

org.apache.jasper.JasperException
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
at 
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:575)
at 
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:498)
at 
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:822)
at org.apache.jsp.event_sig_list_jsp._jspService(event_sig_list_jsp.java:164)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:432)
at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:356)
at 
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1058)
at 
org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:451)
at 
org.apache.struts.action.RequestProcessor.processActionForward(RequestProcessor.java:401)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1420)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:502)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at 
org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at 
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at 
org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at 
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at 
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssocia

[JBoss-user] [Installation & Configuration] - No of connection and no of users Jboss can support

2004-05-25 Thread lee_yuki2000
Hi, 
Does any one know jboss can support how many users? Currently i am using jboss 3.2.1 
and oracle 9.1i. Now I am in testing phase. Jboss will hang when more than 25 users 
log in. I am not sure where is the bottle neck. 

Besides that, how many connection will be created if i didn't set the max and min 
connection in the data source. 

Please help. Thanks in advance. 

yuki

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3836156#3836156

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3836156



---
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g. 
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [JCA/JBoss] - Re: java.sql.SQLException: Use explicit XA call

2004-05-20 Thread lee_yuki2000
How do to add  no-tx-separate-pools? I've follow the example on how to configure the 
oracle-xa-ds but it doesn't work.

Besides that what is the difference between oracle-xa-ds and oracle-ds? Previously i 
was using oracle-ds in jboss 3.2.1. Now i m using jboss 3.2.3 and I had put in the 
wrong xml file. I shud be using oracle-ds instead of oracle-xa-ds. That's why i have 
this error java.sql.SQLException: Use explicit XA call. After i have change the xml, 
it is working. 

Thanks



View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835640#3835640

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3835640


---
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g. 
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [JCA/JBoss] - java.sql.SQLException: Use explicit XA call

2004-05-17 Thread lee_yuki2000
Hi,
   I've just install jboss 3.2.3. Previously i was using jboss 3.2.1.  I have this 
error java.sql.SQLException: Use explicit XA call when i run jboss 3.2.3. Is it i need 
to use the lastest jdbc driver which is ojdbc14.jar? Currently i m using classes 12 
and jdk 1.3.1. As i know jboss 3.x requires  jdk 1.3.1 and jboss 4.x requires jdk 1.4. 
Can u tell my why i have this error

java.sql.SQLException: Use explicit XA call
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285)
at oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:1188)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcRollback(BaseWrapperManagedConnection.java:514)
at 
org.jboss.resource.adapter.jdbc.WrappedConnection.rollback(WrappedConnection.java:477)
at 
sqlj.runtime.profile.ref.TransactionControlProfile$RollbackStatement.executeUpdate(TransactionControlProfile.java:263)
at 
sqlj.runtime.ExecutionContext$StatementFrame.executeUpdate(ExecutionContext.java:1221)
at sqlj.runtime.ExecutionContext.executeUpdate(ExecutionContext.java:698)

Thanks in advance

yuki

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835300#3835300

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3835300


---
This SF.Net email is sponsored by: SourceForge.net Broadband
Sign-up now for SourceForge Broadband and get the fastest
6.0/768 connection for only $19.95/mo for the first 3 months!
http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [JCA/JBoss] - Re: java.sql.SQLException: Io exception: Broken pipe

2004-05-13 Thread lee_yuki2000
I m using jboss 3.2.1 and oracle 9.1i

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3834762#3834762

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3834762


---
This SF.Net email is sponsored by: SourceForge.net Broadband
Sign-up now for SourceForge Broadband and get the fastest
6.0/768 connection for only $19.95/mo for the first 3 months!
http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [JCA/JBoss] - java.sql.SQLException: Io exception: Broken pipe

2004-05-13 Thread lee_yuki2000
Hi,
Does anyone know why i have this problem: Broken pipe , No more data to read from 
socket and Connection handle has been closed and is unusable

2004-05-15 19:32:56,742 INFO  
[org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener] 
Unregistered handle that was not registered! null for managedConnection: [EMAIL 
PROTECTED]
2004-05-15 19:32:56,743 INFO  
[org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener] 
Unregistered handle that was not registered! null for managedConnection: [EMAIL 
PROTECTED]
2004-05-15 19:32:56,743 INFO  
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Exception destroying 
ManagedConnection
org.jboss.resource.JBossResourceException: SQLException; - nested throwable: 
(java.sql.SQLException: Io exception: Broken pipe)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:445)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:229)
at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:374)
at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.returnConnection(InternalManagedConnectionPool.java:250)
at 
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool.returnConnection(JBossManagedConnectionPool.java:648)
at 
org.jboss.resource.connectionmanager.BaseConnectionManager2.returnManagedConnection(BaseConnectionManager2.java:451)
at 
org.jboss.resource.connectionmanager.BaseConnectionManager2$BaseConnectionEventListener.connectionErrorOccurred(BaseConnectionManager2.java:762)
at 
org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionErrorOccurred(TxConnectionManager.java:629)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.broadcastConnectionError(BaseWrapperManagedConnection.java:309)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.connectionError(BaseWrapperManagedConnection.java:294)
at 
org.jboss.resource.adapter.jdbc.WrappedConnection.checkException(WrappedConnection.java:819)
at 
org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:225)
at 
sqlj.runtime.profile.ref.JDBCProfile.prepareCachedStatement(JDBCProfile.java:334)
at 
sqlj.runtime.profile.ref.JDBCProfile.getCachedStatement(JDBCProfile.java:192)


2004-05-15 17:38:39,641 INFO  
[org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener] 
Unregistered handle that was not registered! null for managedConnection: [EMAIL 
PROTECTED]
2004-05-15 17:38:39,641 WARN  
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] ResourceException 
cleaning up ManagedConnection:org.jboss.resource.JBossResourceException: Could not 
cleanup: ; - nested throwable: (java.sql.SQLException: Io exception: Broken pipe)
2004-05-15 17:38:39,642 INFO  
[org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener] 
Unregistered handle that was not registered! null for managedConnection: [EMAIL 
PROTECTED]
2004-05-15 17:38:39,642 INFO  
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Exception destroying 
ManagedConnection
org.jboss.resource.JBossResourceException: SQLException; - nested throwable: 
(java.sql.SQLException: Io exception: Broken pipe)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:445)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:229)
at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:374)
at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.returnConnection(InternalManagedConnectionPool.java:250)
at 
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool.returnConnection(JBossManagedConnectionPool.java:648)



2004-05-15 19:32:56,747 ERROR [STDERR] java.sql.SQLException: No more data to read 
from socket
2004-05-15 19:32:56,747 ERROR [STDERR]  at 
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
2004-05-15 19:32:56,747 ERROR [STDERR]  at 
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
2004-05-15 19:32:56,747 ERROR [STDERR]  at 
oracle.jdbc.dbaccess.DBError.check_error(DBError.java:944)
2004-05-15 19:32:56,748 ERROR [STDERR]  at 
oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:741)
2004-05-15 19:32:56,748 ERROR [STDERR]  at 
oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:700)
2004-05-15 19:32:56,748 ERROR [STDERR]  at 
oracle.jdbc.ttc7.Oopen.receive(Oopen.java:103)
2004-05-15 19:32:56,748 ERROR [STDERR]  at 
oracle.jdbc.ttc7.TTC7Protocol.open(TTC7

[JBoss-user] [Installation & Configuration] - Re: IdleRemover notifying pools, interval: 450000

2004-04-19 Thread lee_yuki2000
It happens alot of time...Any idea why?

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3831328#3831328

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3831328


---
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Installation & Configuration] - IdleRemover notifying pools, interval: 450000

2004-04-18 Thread lee_yuki2000
 Hi, 
I am using Jboss 3.2.1 and oracle 9.1 i. I have this error in the jboss error log. 
Does anyone know what's the problem? Thanks in advance.

 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] run: IdleRemover notifying 
pools, interval: 45
DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Using 
properties: {user=sa, password=}
INFO  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Exception 
destroying ManagedConnection
org.jboss.resource.JBossResourceException: SQLException; - nested throwable: 
(java.sql.SQLException: Io exception: Connection reset by peer)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:445)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:229)
at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:374)
at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.removeTimedOut(InternalManagedConnectionPool.java:288)
at org.jboss.resource.connectionmanager.IdleRemover$1.run(IdleRemover.java:70)
at java.lang.Thread.run(Thread.java:479)
 + nested throwable: 
java.sql.SQLException: Io exception: Connection reset by peer
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
at oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1256)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:225)
at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:374)
at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.removeTimedOut(InternalManagedConnectionPool.java:288)
at org.jboss.resource.connectionmanager.IdleRemover$1.run(IdleRemover.java:70)
at java.lang.Thread.run(Thread.java:479)
2004-04-14 13:15:10,674 DEBUG 
[org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Using 
properties: {user=sa, password=}
2004-04-14 13:15:10,675 INFO  
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Exception destroying 
ManagedConnection
org.jboss.resource.JBossResourceException: SQLException; - nested throwable: 
(java.sql.SQLException: Io exception: Connection reset by peer)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:445)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:229)
at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:374)
at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.removeTimedOut(InternalManagedConnectionPool.java:288)
at org.jboss.resource.connectionmanager.IdleRemover$1.run(IdleRemover.java:70)
at java.lang.Thread.run(Thread.java:479)
 + nested throwable: 
java.sql.SQLException: Io exception: Connection reset by peer
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
at oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1256)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:225)
at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:374)
at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.removeTimedOut(InternalManagedConnectionPool.java:288)
at org.jboss.resource.connectionmanager.IdleRemover$1.run(IdleRemover.java:70)
at java.lang.Thread.run(Thread.java:479)

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3831313#3831313

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3831313


---
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Installation & Configuration] - Connection handle has been closed and is unusable

2004-04-04 Thread lee_yuki2000
Hi,
   I am using Jboss 3.2.1 and i have this problem sometimes java.sql.SQLException: 
Connection handle has been closed and is unusable. Does anyone know what's the 
problem? Thank you in advance



View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3829139#3829139

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3829139


---
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Datasource Configuration] - Unregistered handle that was not registered

2004-03-17 Thread lee_yuki2000
I m using jboss 3.2.1. Do any one know why sometimes i get this error when connecting 
to the database. I am using oracle 9.1i 

[TxConnectionManager$TxConnectionEventListener] Unregistered
handle that was not registered! null for managedConnection: [EMAIL PROTECTED]
[JBossManagedConnectionPool] Exception destroying ManagedConnection
org.jboss.resource.JBossResourceException: SQLException; - nested throwable: 
(java.sql.SQLException: Io exception: Connection reset by peer: socket write error)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkE
xception(BaseWrapperManagedConnection.java:445)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:229)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.do 
Destroy(InternalManagedConnectionPool.java:374)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.re
moveTimedOut(InternalManagedConnectionPool.java:288)
at org.jboss.resource.connectionmanager.IdleRemover$1.run(IdleRemover.java:70)
at java.lang.Thread.run(Thread.java:479)
 + nested throwable:

Thanks in advance

http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3826080#3826080";>View 
the original post

http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3826080>Reply 
to the post


---
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Datasource Configuration] - Multiple connectiont to multiple database setting

2004-02-16 Thread lee_yuki2000
View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3821805#3821805

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3821805

hi, 

I have 3 database and i would like to get the connection randomly from these 3 
database. My problem is sometimes i can get the connection and sometimes i can't get. 
Can anyone tell me what is wrong with the datasource configuration? I am using oracle 
version 9 





 

ds 

jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(LOAD_BALANCE=on) 

(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.1)(PORT=1521)) 

(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.2)(PORT=1521)) 

(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.3)(PORT=1521)) 

(CONNECT_DATA=(SERVICE_NAME=ds))) 

 



oracle.jdbc.driver.OracleDriver 

user 

password 25000 

5 

org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
 

 





Besides that i would like to extend the connecting time to 30 minutes. Where should i 
modify the connection time? Is it at the 
30? 

Where to set the maximum connection?





Thanks in advance


---
SF.Net is sponsored by: Speed Start Your Linux Apps Now.
Build and deploy apps & Web services for Linux with
a free DVD software kit from IBM. Click Now!
http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user