commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anthony Musyoki <anthony.musy...@gmail.com>
Subject Re: DBCP and informix issues!
Date Wed, 19 Aug 2009 06:10:00 GMT
Most of us place dummy usernames and passwords on mail that is seen
externally. Did u change the username password combination in this
mail(Check the data source code)?!? If not then u might have to change
ur actual ones as we all have ur username and password!!


On Tue, 2009-08-18 at 11:57 -0700, Gerardo Velez wrote:

> Hi!
> 
> I've been working around a web application using java + informix + tomcat
> 
> So my problem is at time I trieds to insert a row in some specific table and
> after that retrieve the serial number (autoincrement id) from informix.
> 
> This is the snipped of code I have and the error generated:
> 
> 
> [CODE]
> java.sql.Connection = conn = dataSource.getConnection();
> java.sql.Statement stmt = conn.createStatement();
> 
> stmt.executeUpdate(insertSQL);
> 
> int serial = ((IfmxStatement)stmt).getSerial();
> 
> [Error]
> java.lang.ClassCastException:
> org.apache.tomcat.dbcp.dbcp.DelegatingStatement cannot be cast to
> com.informix.jdbc.IfmxStatement
> 
> 
> My Connection pool, looks as follow:
> 
> <Resource name="jdbc/SIPDB" auth="Container" type="javax.sql.DataSource"
>                maxActive="100" maxIdle="30" maxWait="10000"
>                username="mgrnsip" password="prx217n"
> driverClassName="com.informix.jdbc.IfxDriver"
> 
> url="jdbc:informix-sqli://myhostname:myport/mydatabase:INFORMIXSERVER=dev"/>
> 
> 
> Thanks in advance!
> 
> -- Gerardo Velez

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message