[JBoss-user] [Beginners Corner] - Jboss.jca.ManagedConnectionPool Using PostgreSQL JBoss 4.0.0
Hi all, I have a Jboss 4.0.0(200409200419) Zion, a PostgreSQL version 7.4.6 So i'm using NoTX dataSource for my webservices running on /ws4ee this is my WS-ds.xml | | | jdbc/WS_ds | jdbc:postgresql://localhost:5432/DB_XXX | org.postgresql.jdbc2.optional.PoolingDataSource | db_usr | db_pass | 0 | 100 | | | well i had to increase the max pool size because de AvailableConnectionCount decreases without release of connections.. so never i had available connections: y DB Connection Provider object is : | public class DBConnProvider { | private static final long serialVersionUID = 2345676785536765474L; | | private static final boolean DEBUG = false; | | protected static javax.naming.Context envCtx; | | protected static javax.sql.DataSource datasource; | | private static transient final Log log = LogFactory | .getLog(DBConnProvider.class); | | /** Creates a new instance of DBConnProvider */ | public DBConnProvider() { | datasource = null; | envCtx = null; | } | | // public static java.util.Vector vecConnections = new java.util.Vector(); | | public static java.sql.Connection getConnection() | throws java.sql.SQLException { | return DBConnProvider.getConnection("WS_ds"); | } | | /** | * @params dsDB String Nombre de la Base de Datos (u origen de datos) | * @return datasource.getConnection() una conexion a la base de datos | */ | private static synchronized java.sql.Connection getConnection(String dsDB) | throws java.sql.SQLException { | if (DEBUG) { | log.info("Obteniendo DataSource: jdbc/" + dsDB); | } | | if (datasource == null) { | try { | envCtx = (javax.naming.Context) (new javax.naming.InitialContext()) | .lookup("java:comp/env"); | datasource = (javax.sql.DataSource) envCtx.lookup("jdbc/" | + dsDB); | datasource.setLogWriter(new java.io.PrintWriter(System.out)); | envCtx.close(); | log.info("DataSource: java:comp/env/jdbc/" + dsDB); | } catch (Exception e) { | log.error("(getConnection) " + e.getMessage() + ":" + dsDB); | datasource = null; | } | } | | if (datasource == null) { | try { | envCtx = (javax.naming.Context) (new javax.naming.InitialContext()) | .lookup("java:jdbc"); | datasource = (javax.sql.DataSource) envCtx.lookup(dsDB); | datasource.setLogWriter(new java.io.PrintWriter(System.out)); | envCtx.close(); | log.info("DataSource: java:jdbc/" + dsDB); | } catch (Exception e) { | log.error("(getConnection) " + e.getMessage() + ":" + dsDB); | datasource = null; | } | } | | if (datasource == null) { | try { | envCtx = (javax.naming.Context) new javax.naming.InitialContext(); | datasource = (javax.sql.DataSource) envCtx.lookup("java:jdbc/" | + dsDB); | datasource.setLogWriter(new java.io.PrintWriter(System.out)); | envCtx.close(); | log.info("DataSource: java:jdbc/" + dsDB); | } catch (Exception e) { | log.error("(getConnection) " + e.getMessage() + ":" + dsDB); | datasource = null; | } | } | | java.sql.Connection conn = datasource.getConnection(); | | /* | * Se elimina pues 1.- AutoCommit, You cannot set autocommit during a | * managed transaction! 2.- ResultSet holdability no implementado, This | * method is not yet implemented. | * | * try { conn.setAutoCommit(false); } catch(java.sql.SQLException sqle) { | * log.warn("(getConnection) AutoCommit, " + sqle.getMessage()); } | * | * try { | * conn.setHoldability(java.sql.ResultSet.HOLD_CURSORS_O
[JBoss-user] [Beginners Corner] - Re: Jboss.jca.ManagedConnectionPool Using PostgreSQL JBoss 4
Shame on Me I've found the error i forgot to close one connection.. Sorry for your time View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3949157#3949157 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3949157 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JNDI/Naming/Network] - Re: Accessing EJB through HTTPS Invoker...
Hi, i don't kno wif this could help, but i've a JBoss behind a Firewall, i'm using JNDIFactory (JNDI over HTTP) and there is no documentation abot this, you have to open the port in your firewall pointing to Jboss server, i didn't know that, i've noticed scanning the port acces while trying to resolve jndi names and saw connect to 8080 port and port. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3892094#3892094 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3892094 --- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [EJB/JBoss] - Re: javax.ejb.ObjectNotFoundException: No such entity!
Hi, i've this problem: [Server] JBoss (MX MicroKernel) [4.0.0 (build: CVSTag=JBoss_4_0_0 date=200409200418)] Started in 52s:411ms 14:49:34,381 INFO [STDOUT] No se encontró servlet asociado al evento: listar_usuarios Error: No such entity! 14:49:34,383 INFO [STDOUT] javax.ejb.ObjectNotFoundException: No such entity! 14:49:34,385 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntityCommand.execute(JDBCFindEntityCommand.java:50) 14:49:34,386 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntity(JDBCStoreManager.java:589) 14:49:34,387 INFO [STDOUT] at org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPersistenceManager.java:300) 14:49:34,387 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntity(CachedConnectionInterceptor.java:298) 14:49:34,388 INFO [STDOUT] at org.jboss.ejb.EntityContainer.findSingleObject(EntityContainer.java:1086) 14:49:34,389 INFO [STDOUT] at org.jboss.ejb.EntityContainer.findLocal(EntityContainer.java:663) 14:49:34,390 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 14:49:34,391 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 14:49:34,391 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 14:49:34,392 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324) 14:49:34,392 INFO [STDOUT] at org.jboss.invocation.Invocation.performCall(Invocation.java:345) 14:49:34,392 INFO [STDOUT] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1113) 14:49:34,392 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:90) 14:49:34,392 INFO [STDOUT] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:192) 14:49:34,392 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:212) 14:49:34,392 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:90) 14:49:34,392 INFO [STDOUT] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:113) 14:49:34,392 INFO [STDOUT] at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61) 14:49:34,392 INFO [STDOUT] at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28) 14:49:34,392 INFO [STDOUT] at org.jboss.ejb.plugins.CallValidationInterceptor.invokeHome(CallValidationInterceptor.java:41) 14:49:34,393 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:109) 14:49:34,394 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:316) 14:49:34,395 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:129) 14:49:34,395 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:106) 14:49:34,395 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120) 14:49:34,395 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93) 14:49:34,395 INFO [STDOUT] at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:508) 14:49:34,395 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:876) 14:49:34,395 INFO [STDOUT] at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:342) 14:49:34,395 INFO [STDOUT] at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:118) 14:49:34,395 INFO [STDOUT] at $Proxy60.findByPrimaryKey(Unknown Source) 14:49:34,396 INFO [STDOUT] at cl.eftbanca.portaleft.ejb.PortalControlSessionBean.getServletByEvento(PortalControlSessionBean.java:189) Need helñp pliz View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3884235#3884235 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3884235 --- This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual core and dual graphics technology at this free one hour event hosted by HP, AMD, and NVIDIA. To register visit http://www.hp.com/go/dualwebinar ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user