Just an update. I took the problem off line and tried it command line. I am able to get multiple clients with both SQL Server and Oracle. Perhaps it is something with JBoss?
Any suggestions welcome. Tim -----Original Message----- From: Cobble, Tim Sent: Thursday, November 06, 2003 1:30 PM To: OJB Users List Subject: SQL Server and Oracle problems. All, I am trying to compare different RDBMs. I can get all three (MySQL, MS SQL, and Oracle) working with one client. When I try to test the scaling abilities, MS SQL and Oracle choke. I can only get a few simultaneous connections. Seems unlimited with MySQL. I know this is not a DB problem since I am comparing this with EJB's and they scale as expected. I am able to use 50 clients with all three DBs. I have been using the MS Driver, JTDS, and JSQL for MS SQL; and the Oracle released driver. Complete failure with JTDS = "Rollback on the underlying connection failed". And "you cannot rollback during a managed transaction". This is deployed on JBoss. Only doing a simple SELECT * from table_name; Any clues? Thanks in advance! Tim Will provide any requested code/xml files. Pertinent snippets attached. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]