JBoss 3.0 Connection Pool - very urgent

Discussions

EJB programming & troubleshooting: JBoss 3.0 Connection Pool - very urgent

  1. JBoss 3.0 Connection Pool - very urgent (2 messages)

    Hi all,
       I am using JBoss 3.0 with Tomcat 4.0 and SQL Server 2000. All my EJB's are stateless. When I try to insert a record I am getting the following exception
    "[Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode."
    But I am able to modify and delete.
    Before inserting I am generating the primary key by querying a table. I am using transaction attribute required. Is this anything to do with the connection pool configuration? If so please let me know the exact configuration as soon as possible.

    Thanks in advance,
    Prasanna
  2. dude.. i had the same problem with win2k.. but once using BMP i am ok (wtf!)... my db url like this:

    jdbc:microsoft:sqlserver://localhost;DatabaseName=DBPaPa;SelectMethod=cursor;
  3. Hi,
      Thanks for ur reply. It worked. I think there was problem in URL. I was not specifying SelectMethod.

    Thanks,
    Prasanna