Object Is closed

[Suraj Panicker]

Hello,

I'm using connection pooling to get logical connections to the DB, and I get
the following error quite frequently :

Sap DBTech: Object is closed

I think this happens because the resultset object is closed. Why is this
happening ?

Following is the code in my SapDBConnection class, that is used to get the
connection :



        static ConnectionPoolDataSourceSapDB sapDBCpds;
        static PooledConnection conpooled;
        private static String mode = MODE_ORACLE;

        public static Connection getConnection(ServiceContext sc)
          throws Exception
        {
                Connection con = null;

                if(sapDBCpds == null)
                {
                        sapDBCpds = (ConnectionPoolDataSourceSapDB)Class.forName
("com.sap.dbtech.jdbcext.ConnectionPoolDataSourceSapDB").newInstance();

                        sapDBCpds.setServerName(sc.getDBServerName());
                        sapDBCpds.setDatabaseName(sc.getDBName());
                        sapDBCpds.setUser(sc.getDBUserName());
                        sapDBCpds.setSqlMode(mode);
                        sapDBCpds.setTimeout(0);
                        sapDBCpds.setPassword(sc.getDBPassword());

                        conpooled = sapDBCpds.getPooledConnection();
                }

                con = conpooled.getConnection();

                return con;
        }


regards,

Suraj.


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]