You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by "Cobble, Tim" <ti...@lmco.com> on 2003/11/06 19:29:34 UTC

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.

PhillyJug OJB (and Spring) Presentation

Posted by Brian McCallister <mc...@forthillcompany.com>.
Thomas Risberg (Spring developer) and I have been asked to do a 
combined presentation on OJB and Spring at an upcoming PhillyJUG 
meeting and we need to figure out what exactly we are going to present.

Anyone have any suggestions?

-Brian



---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org