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.
SQL SERVER REPOSITORY_DATABASE.XML:
<jdbc-connection-descriptor
jcd-alias="default"
default-connection="true"
platform="MsSQLServer"
jdbc-level="2.0"
jndi-datasource-name="java:PeerReviewDS"
username="sa"
password=""
eager-release="false"
batch-mode="false"
useAutoCommit="0"
ignoreAutoCommitExceptions="false"
>
#####################################################
JBOSS DATASOURCES FOR MS SQL:
MS DRIVER:
<datasources>
<local-tx-datasource>
<jndi-name>PeerReviewDS</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://myIPaddress:1433;SelectMethod
=Cursor;database=peer_review_db</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class
>
<user-name>sa</user-name>
<password></password>
</local-tx-datasource>
</datasources>
#####################################################
JSQL:
<datasources>
<local-tx-datasource>
<jndi-name>PeerReviewDS</jndi-name>
<connection-url>jdbc:JSQLConnect://myIPAddress:1433/database=master</con
nection-url>
<driver-class>com.jnetdirect.jsql.JSQLDriver</driver-class>
<user-name>sa</user-name>
<password></password>
</local-tx-datasource>
</datasources> #####################################################
JTDS:
<datasources>
<local-tx-datasource>
<jndi-name>PeerReviewDS</jndi-name>
<connection-url>jdbc:jtds:sqlserver://myIPAddress;SelectMethod=C
ursor;DatabaseName=peer_review_db</connection-url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
<user-name>sa</user-name>
<password></password>
</local-tx-datasource>
</datasources>
#####################################################
ORACLE REPOSITORY_DATABASE.xml:
<jdbc-connection-descriptor
jcd-alias="default"
default-connection="true"
platform="Oracle9i"
jdbc-level="2.0"
jndi-datasource-name="java:PeerReviewDS"
username="prdatauser"
password="password"
eager-release="false"
batch-mode="false"
useAutoCommit="0"
ignoreAutoCommitExceptions="false"
#####################################################
JBOSS DATASOURCE FOR ORACLE:
<datasources>
<local-tx-datasource>
<jndi-name>PeerReviewDS</jndi-name>
<connection-url>jdbc:oracle:thin:@myIPAddress:1521:prdata</connection-ur
l>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>prdatauser</user-name>
<password>password</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.Orac
leExceptionSorter</exception-sorter-class-name>
</local-tx-datasource>
</datasources>
#####################################################
CONNECTIONFACTORYCLASS=org.apache.ojb.broker.accesslayer.ConnectionFacto
ryManagedImpl
#####################################################
TYPICAL REPOSITORY_USER.XML ENTRY
<class-descriptor class="perlgen.TDefectType" table="T_Defect_Type">
<field-descriptor name="defect_type_id" column="Defect_Type_ID" jdbc-type="INTEGER"
primarykey="true"/>
<field-descriptor name="severity" column="Severity" jdbc-type="VARCHAR"/>
<field-descriptor name="description" column="Description" jdbc-type="VARCHAR"/>
</class-descriptor>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
