Hi, i'am using hibernate with WebSphere Application Server Community Edition 2.0. Everytime my application start always fail cause:<code>19:27:27,453 FATAL C3P0ConnectionProvider could not instantiate C3P0 connection pooljava.lang.NullPointerExceptionat java.util.Hashtable.put(Hashtable.java:396)at com.mchange.v2.c3p0.DataSources.pooledDataSource(DataSources.java:314)at org.hibernate.connection.C3P0ConnectionProvider.configure(C3P0ConnectionProvider.java:159)at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)at org.hibernate.con
I am trying to implement a web app that uses the com.mysql.jdbc.Connection with a tomcat connection pool using dbcp drivers. When trying to return the connection object frmo the datasource i can get a java.sql.Connection object, but then cannot cast this into a com.mysql.jdbc.Connection object. The connection object returned is of type: org.apache.commons.dbcp.PoolableConnection - which implements the java.mysql.Connection interface - why cant i cast it?? I presume that the mysql Connection object does not implement some methods... see code: private javax.sql.DataSource queryDataSource = null;
I am using Connector/J 3.1.6, Tomcat 5, and MySql 4.1. I have successfully set up MySql as a JNDI Datasource as described in the Tomcat HOWTO located at: http://jakarta.apache.org/tomcat/tomcat-5.0-doc/printer/jndi-datasource-examples-howto.html#MySQL%20DBCP%20Example Depending on what documentation you believe, there are a number of standard properties the JDBC Datasource accepts for configuring the connection pooling. Of particular interest to me are "initialPoolSize" and "minPoolSize"...or, as other documents refer to them.... "initialSize" and "minIdle
I'm trying to use my application server connection pool trought Hibernate.When i use hibernate without a connection pool, it works.When i use my connection pool without hibernate, it works.When i use my connection pool with hibernate, i've got the following error :cause mère java.lang.ExceptionInInitializerError HibernateUtil.<clinit>(HibernateUtil.java:26) MyConnection.doPost(MyConnection.java:53) javax.servlet.http.HttpServlet.service(HttpServlet.java:713) javax.servlet.http.HttpServlet.service(HttpServlet.java:806) cause mère org.hibernate.HibernateExcept
wen we create a connection pool in mysql for a j2ee application do we have to modify the server.xml file of tomcat?in the steps listed in this site it is given that we shud edit the server.xml file. Wen i try editing it, while saving it says access denied. wat shud i do?
I'm working with Oracle 9i, Java (netBeans) and Tomcat. I'm trying to do a connection pool with Tomcat but I've problems and I don't know how. My problem is this, when I try connect to my db an exception ocurres:org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'at org.apache.tomcat.dbcp.dbcp.BasicDataSource.create DataSource(BasicDataSource.java:780)at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getCon nection(BasicDataSource.java:540)at servbib.GestorBD.<init>(GestorBD.java:69)at servbib.GestorBD.<init>(GestorBD.java:50)at
I'm building a web app that uses servlets to connect to a mysql database. I'm looking for a solid implementation of a connection pool that I can use. I don't have access to the Tomcat server configuration, so I'm looking for a library that implements the connection pool from within the servlet itself.Any suggestions?
I have this problem. I'm using Tomcat 5.0.28 and MySql 3.23.58 I use a connection pool to access database from my web application; when nobody querying the database after 8 hours or more it throws this exception (the library for connection pool is commons-pool-1.2): JDBCRealm[/......]: Exception performing authentication java.sql.SQLException: Communication link failure: java.net.SocketException, underlying cause: Broken pipe ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: Broken pipe STACKTRACE: java.net.SocketException: Broken pipe at java.net.SocketOutputStream.socketWrite0(N
Hi, I'm kind of new to databases, well at least in a production environment. Anyways i have a server that is inserting ~100 records per ~20sec, and I'm opening and closing a connection each time. I'm finding out that i'm using too much cpu, although mysql itself seems to be ok. I've been reading on how to optimize database access by using a connection pool, but they all seem to be using EE or on a webserver using Tomcat or some other app server. Is it possible to use a connection pool with SE or do I have to write my own connection pool? Can I get some sample snippets or point me to a tutorial
Hi Thank you for reading my post. I have tried to create a connection pool for DB2 9.5, both Application server and DB2 are on the same linux box.first I tried to create the connection pool using db2inst1 user and its password, but it failed with an error.Then I add another user to my databse which with all permissions, I tried to use that user/password and it return the same error again. Does any one can tell me what should i do? I installed db2 9.5 jar files in the application server and used them, and it returned the same error. com.ibm.db2.jcc.b.mm: jcct4201311249http://3.50.152 Connection
I'm hosting webapps w/in tomcat and using tomcat to manage the connection pool. Applications access the DataSource from tomcat via JNDI. I'd like to configure the JDBC URL such that it functioned in a failover using two servers. Is there a way to do this using just the JDBC URL? I've tried the following syntax (and variations on it), but get the error "ORA-12514, TNS:listener does not currently know of service requested in connect descriptor".Thanks!--john//whitespace added for readabilityjdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host1.ngdc.noaa.gov
Does any one know or have an example of how to use websphere's built in Connection pool from outside /standalone application
Our env: DB2 8.2 on Aix5.3We are running performance scalability stuff on DB2 platform and found that the connections are getting returned to the connection pool despite the process / activity is complete. When I query the db2 database, I see a number of connections with status "unit of work waiting". My question is: why are the connections not returned to the connection pool? Does UOW waiting has any relavance to holding up memory because we are seeing memory usage to be 100% full...!!Any thoughts greatly appreciated.
The current version of the Database Connection Pool Analyzer in ISA is 1.5. The most current version on Alphaworks is 2.3. Is the updated version going to be made available thru ISA? The reason I ask is that the version in ISA doesn't appear to work with WAS 6.1 logs. I'm hoping the newer version will work correctly.
I need to close my jdbc connection-pool and free all the connections, but the standard driver for informix (2.21.JC3) doen't support it. Anybody knows how can i do it?
I got the connection pool sample code from OTN something like:InitialContext context = new InitialContext();OracleConnectionPoolDataSource poolDS = (OracleConnectionPoolDataSource) context.lookup("jdbc/pool/OracleConnPoolDS");PooledConnection poolConn = poolDS.getPooledConnection();Connection conn = poolConn.getConnection();...My question is: what is the right way of releasing the connection back to the pool? I have seen 2 different ways:1. conn.close();2. conn.close();poolConn.close(); I assume that if using connection pool correctly, I should always see the session(s) for the generic user th
I was having a problem with connections going bad. Sometimes I would getnull connection. Sometimes I would get connection closed. And sometimes Iwould get an invalid state typeerror when setting a parameter or executing a prepared statement.For any given build of my code the problem would generally be consistent.However, minorchanges would cause the symptom to move.I am using the Jakarta commons connection pooling.The database is DB2 UDB version 7 on both Windows and Linux.After a lot of testing I finally narrowed the problem down to the sharing ofconnections amongdifferent threads. Now, I'm n
I´m trying to make a connection pool in WebLogic with SQL Server 2000.I´m trying to make it with the driver weblogic.jdbc.mssqlsrv4.Driver and the answer of WebLogic is "cannot load driver class".I´m trying too with other driver that I download (com.microsoft.jdbc.sqlserver.SQLServerDriver) and the answer of WebLogic is "null".Please, help me!!!!!
For our new application in C# .net. We came across a situation where i want failsafe without load balancing. That means if the primary server is out the insertions will go to secondary server. and when the primary server comes alive it has to drop all connections in the connection pool (just clear the connections in the connection pool atleast from the secondary). Thanks and Regards Bijesh ThomasSoftware analyst
HiI have IBM DB2 installed on Windows 2003 Server with 3 databases on server grade machine with RAID-1.I am running jsp/servlet web application in IBM WebSphere and accesing database connection from IBM DB2 V8 Server.Also, I checked that we are releasing the database connection properly. Now, Whenever I am going to connect to database using web applicatin I encounter the following error in logs :-COM.ibm.db2.jdbc.DB2Exception: IBMCLI Driver SQL1040N The maximum number of applications is already connected to the database. SQLSTATE=57030Af of now, 20 users are consistent connected to database us
HiI have IBM DB2 installed on Windows 2003 Server with 3 databases on server grade machine with RAID-1.I am running jsp/servlet web application in IBM WebSphere and accesing database connection from IBM DB2 V8 Server.Also, I checked that we are releasing the database connection properly.Now, Whenever I am going to connect to database using web applicatin I encounter the following error in logs :-COM.ibm.db2.jdbc.DB2Exception: IBMCLI Driver SQL1040N The maximum number of applications is already connected to the database. SQLSTATE=57030Af of now, 8 users are consistent connected to database usin
HiI have installed IBM UDB V8.2 Ent. Edition and IBM websphere 6.0. I have deployed web application on websphere.I encountering following connection pool and TCP/IP SOCKETS Communication error in systemerr.log file. I am sure that this is related to connection pool problem. Since yesterday we are facing this problem. I have already checked all the tcp/ip connectivity and data source also. 7/18/05 18:10:27:054 IST 00000489 SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Compiled Code))7/18/05 18:10:27:054 IST 0000048b SystemErr R com.ibm.websphere.ce.cm.Sta
We have an intermittent issue around the DB2 used from a Glassfish connection pool. What happens is this:Under situations where the database (DB2 on ZOS) is under stress, our application (which is a multi-threaded application using connections to DB2 via a Glassfish connection pool) stops doing anything.The following are observed:1) Looking at the server using JConsole, we can see a thread waiting indefinitely in the DB2 driver's getConnection() method. We can also see that it has gained a lock on a Vector within the driver. Several other threads are also calling the getConnection() method in
got problem with setting connection pool via admin console for cloudscape 10 embedded in j2ee 1.4 (Application server 8.1), what im doing is:-in resources/jdbc/ConnectionPools i add a new pool datasource classname i set up as: "org.apache.derby.jdbc.EmbeddedXADataSource" -resource type: "javax.sql.XADataSource"-DatabaseName: "jdbc:derby:D:\\Programowanie\J2EE\domains\domain1\config\notesData"-set no password and user, becouse i havet set this in databaseand when i ping to that datebase i got error:"Operation 'pingConnectionPool' failed in 'resources' Config Mbean."when i change Datasource Clas
I'm getting errors when I attempt to combine an SqlDataSource control (mapped to DB2) with: a separate myDB2Connection.Open() in the page or a reference to a DB2Connection in another class. I am using DB2 8.2.4 (fix11) with vs.net 2.0. Also have vs.net 2003 and .net 1.1 installed on the same computer.Specifically, I get "InnerException Message: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. I have traced this error to the connection pool. I suspect somehow multiple connection pool wires are crossing and its throwing an exception. If I res
I am a .Net developer of a Large Online Retailling Company. I would like to have your help on a Connection Pool issue.Recently we have developed a Web Application on ODP .Net to work with Oracle Database 10g. To gain the performance, connection pool enable is a must. Everything work fine throughout the development period and the performance is Great, however while the Web Application is deployed to the production, sooner or later (a few minutes or a few days) all the Connections in the connection pool will be unavailable and the ODP .NET keeps throwing:"The Exception: Oracle.DataAccess.Cl
Scenario:1. There is a connection pool for DB2 UDB for iSeries on IBM Websphere Application server2. The caller retrieves 'DataSource' from the 'Connection Pool' on Websphere3. The caller calls SQL stored procedure on iSeries Problems:1. Should I cose the connection(obtain from the Connection Pool) if the caller does not need it again.2. If the SQL stored procedure return a ResultSet to caller, does the caller have to close the ResutSet ? And if so, should it bother the 'ODP' reusable issue, I mean the 'ODP hard close' ?
What I am concerned about is scale out of our web server farm and their connections pools going against our databases. 1) Connections Pools on each server are set to not go beyond the max connections on the database servers, but if we are forced to bring a few servers online, then the connection math is wrong and we would have to reconfigure the whole cluster. 2) I want to load balance across a pool of replicants, without having to configure precisely which replication which webserver will go to. I know Connector/J has some support for this, but I bet the proxy would support it much better. 3)
hello,recently i used the mysql-proxy 0.8.0 in red hat 5.4(32bit). at first ,i established some connections in the pool,but when i use the connection in the pool with "return proxy.PROXY_IGNORE_RESULT" in connect_server(). error happend,the connection was closed then, who can help me solve the problem,at the same time ,i want to ask whether the connection pool can deal of a lot of connections from the clients.
I'm working with a Java Web application that tries to connect itself via JDBC to the AS400 through a connection pool. By each connection that we establish, a QZDASOINIT job is created at AS400 server. When each one of these connections is used at least 2 times, the job blocks the file to which we are acceding with a blockade of type SHRRD. We would need to unblock these files. The solution that we have seen happens to close the connections after using them and thus work QZDASOINIT disappears, but this is not possible, since we want to use the connections pool that remain always open. I'm using
We are using a connection pool that connect to DB2. Frequently there are threads on DB2 that I can see running for 14 hours, even two days.Below are my connection pool settings (JACL):{name somename}{jndiName jdbc/sof}{driver DB2_TYPE4}{databaseName DB2P}{serverName someserver} {portNumber 5023} {agedTimeout 1200} {reapTime 300} {unusedTimeout 1800} {connectionTimeout 180} {maxConnections 50} {minConnections 5} {statementCacheSize 50} Also, what does it mean when I have 5 connections in the pool (Min). Does that mean I will see 5 threads on Db2 side. Are these physical connections ?Documentati
I am curious what the expected behavior is here: I am developing an application in C# and using the .NET connector v1.0.9 What should happen when I do the following: a) connect using the following string const string connString = "server=localhost;" + "uid=dbadmin;" + "pwd=pwpwpw;" + "database=database;" + "Min Pool Size=3;" + "Max Pool Size=3;" + "Pooling=true;"; b) execute a begin; c) execute a select * from testtable limit 1 for update; d) call .Close() on the MySqlConnection(notice, I did not call commit or rollback) now
Anybody know how to set up a Glassfish connection pool to talk to an AS/400 (IBM iSeries)?
Sorry for all my previous postslet me explain the exact problemThere is a singleton object in the shared memory. It conatins a pool of connection objects to a server. (more likely an array of connection objects).I want to go through the array and find which connection object is free to access.Then that particular object is locked, used for connection and then unlocked.The following is the singleton object which encapsulates the connection pool array.class single{private:~single();single();connectionObj[5];public:connectionObj & GetConnectionObj() ;void Lock();void UnLock();}There are at le
Hi, I am trying to connect Oracle database v7.3.2 to a WSAD using classes12.zip I used the JDBC driver for connection pool as oracle.jdbc.pool.OracleConnectionPoolDataSourceURL prefix is oracle:jdbc:thinI am configuring a datasource with JNDI name jdbc/OracleDSIn my CMP im using the Datasource as jdbc/OracleDS but while starting the server it automatically adds jdbc/ to the JNDI name to make it jbdc/jdbc/OracleDS as the lookup string and fails. I cannot figure out whether the problem is with ConnectionPool or Lookup or something else. How to investigate & solve the prob?I tried the same us
I have an RMI application where the user logs in an do some scheduling or browse the scheduler. When a user logs in to the tool a dedicated connection is issue to then for there session. However, I am running out of connection because many users hold there connection for long time or refuse to disconnect. I am thinking of implementing a connection pool but I Not sure how to do this in reference to RMI.Any suggession will be very helpful PS:I am thinking of not passing the connection to the client but construct the SQL string in the client and pass it to the server and have to server get a conn
I am trying to create a connection pool for my MySql database on Sun Application Server(Version 8.1) using 'asadmin'. I am also able to create the connection pool successfully but when i am trying to ping the connection pool, it is giving me the java.net.UnknownHostException. The command I am using for creating the connection pool is as follows: create-jdbc-connection-pool --user admin --password adminadmin --host localhost --port 4849 --datasourceclassname com.mysql.jdbc.jdbc2.optional.MySqlConnectionPoolDataSource --restype javax.sql.XADatasource --property User=root:Password=admin:SelectMet
I'm trying to get a clear idea on how connection pooling operates with MySQL and i am bit lost about ConnectionPoolDataSource and PooledConnection from JDBC2 standard. MySQL connector/J provides implementation of those interfaces that are supposed to be used by a connection pool, right ? However, unless i missed something, connection pool implementation i know (c3p0, DBCP, BEA) doesn't seem to use those interfaces (they maybe do internally, but I don't think i can tell them to use MySQLConnectionPoolDataSource, this is often the Driver class that is supposed to be declared). So my questions ar
I´m reading kick star your java apps. When I was doing a connection section, an error appeared in wasce console when I clicked Show plan with then error Unable to save connection pool. Anyone could help me?
I am quiet new to J2EE and WASCE so i started to make a very simple example on a WAR accessing a single class with java persistence. For this prupose I have created a connection pool with wasce administration console.I have followed all the tutorial instruction and i added all the depencies for the jdbc datasource like the follwoing:geronimo-web.xml:http://...<resource-ref><ref-name>jdbc/hbPriceSpy</ref-name><resource-link>hbPriceSpy</resource-link></resource-ref> http://...web.xml:http://...<resource-ref><res-ref-name>jdbc/hbPriceSpy</res-ref
I am trying to create database pool for IBM DB2 v9.7 in WASCE, but i am getting the following error saying "Unable to save connection pool" in the server log.I google the internet and found that the server path which includes space could be the issue.Kindly advise to overcome this issue without changing the server path.Issue: Space after program in the below urlD:\Program Files\IBM\WebSphere\AppServerCommunityEdition24143: 2010-09-11 13:09:27,935 ERROR DatabasePoolPortlet Unable to save connection pool 24206: 2010-09-11 13:10:45,055 ERROR [DBWizard] Servlet.service() for servlet DBWizard threw
i'm working on a platform Linux-RH-7.2 with a webserver using Apache + postgresql + php.my question is (i want) to make a connection pool under php but i haven't got any idea.do we need a class for that or is not possible under php?Thanx in advance.
I am not too worried about the connection pool but my understanding of it. This might not be a smart question to ask but here goes ...1. I tried catching the exception "Connection not available while invoking method createOrWaitForConnection for resource jdbc/AAAAA." but i never seem to be able to do that even with Throwable catch block2. I assumed that the connection pool exception should be thrown when running through datasource.getConnection(); but the exception is thrown when the following line is calleddataSource = bundle.getString("DB_SOURCE"); Any thoughts !!FYI - I fixed the connection
sometimes i get StaleConnectionException. as i understood WAS ConnectionPool does not try to get new connection if it gets a connection exceptioni think, i has to retry on a new connection before rise it to user. e.g for c3p0 acquireRetryAttempts prameter does this. but i did not find the exact paremeter for WAS cnnection pool. what is it ? how can i set the retry count and intervals for connection pool in order to prenvent StaleConnectionException ?
Hi, i'm thinking about what's the best way to make db connections in a web application.It's clear that persistent connections have better performance and improve the time of responses, because you don't have to make a new connection every time that a script runs. But i see a big problem here, if a have a site with a lot of concurrently visits, all those scripts use the same connection, then maybe will produce many collisions, that's a problem.I've seen in other languages, an interesting solution, a connection pool. Anybody knows if exist any implementation of a connection pool for PHP?
Hi, I am new to PHP, and I am trying to use php to build a site that could potentially have a large number of concurrent users. I always had the notion that making a connection and closing it is expensive,(1. takes time to create connection 2. when closing the connection, that connection won't be avaible for a time interval, but i could be wrong) so does anyone know if I need to create a connection pool, if so how would i create one in php? btw, I also read something on using pconnect instead of connect, not sure if this would solve my problem tho. :queasy: Larry
I'm looking for a way to be able to read the odbc connection pool active connections entries and its details such as the user requested the connection to the database, database session id associated with the connection regardless of the RDBMS as long as the user go through the ODBC.Any pointers, ideas would be highly appreciated.
I have created a connection pool with :maxconn = 10, minconn = 6, incrconn = 4is OK.call getOpenConnections() return 6.after I have restart database system , and when connection pool is auto reconnected ,I call getOpenConnections() but return 9 .why ?
How to detect connection status in OCCI Connection Pool ? O/S : Solaris I want to get Connection status in OCCI Connections Pool , so that i can re-connect if connections is broken.
I just heard about the "ndb_cluster_connection_pool" var in the mysqld-config (is this still in 7.0.6?). Is it safe to use? I'm wondering about not to see this var within the output of "SHOW VARIABLES" in my ndb-mysqld's...