Thanks for your tips!
1) I cannot use the old Version 3.2.3, because of another bug in this version, which
is fixed in my 3.2.4 RC1, but I will try the new 3.2.4 RC2 this evening. May'be this
helps!
2) I use the SelectMethod=Cursor in my connection String, this would not be the
solution :(
3. + 4.) JDBC XA and read-ahead with fixed page-size:
I'm relatively new to JBoss and don't know exactly what you mean by these things. I
use the SQL Server 2000 SP3a and JDBC Driver SP2.
Are there any further entries in the configuration files needed?
My configuration-files are:
-------------------------------
datasource:
<!-- $Id: mssql-ds.xml,v 1.1.2.1 2003/09/05 16:38:24 patriot1burke Exp $ -->
<local-tx-datasource>
<jndi-name>MSSQLDS</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ProMtDB;SelectMethod=Cursor</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>PmDBUser</user-name>
xyzyx
<min-pool-size>2</min-pool-size>
<max-pool-size>20</max-pool-size>
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->
<!-- sql to call on an existing pooled connection when it is obtained from
pool
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->
</local-tx-datasource>
standardjaws.xml:
<!-- $Id: standardjaws.xml,v 1.30 2002/06/27 19:26:28 dsundstrom Exp $ -->
java:/MSSQLDS
<type-mapping>MS SQLSERVER2000</type-mapping>
<!--
java:/DefaultDS
<type-mapping>Hypersonic SQL</type-mapping>
-->
standardjbosscmp-jdbc.xml:
<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.41 2004/02/06 15:04:09 loubyansky Exp $
-->
<jbosscmp-jdbc>
java:/MSSQLDS
<datasource-mapping>MS SQLSERVER2000</datasource-mapping>
<!--
java:/DefaultDS
<datasource-mapping>Hypersonic SQL</datasource-mapping>
-->
<create-table>true</create-table>
<remove-table>false</remove-table>
<read-only>false</read-only>
<read-time-out>300000</read-time-out>
<row-locking>false</row-locking>
<pk-constraint>true</pk-constraint>
<fk-constraint>false</fk-constraint>
<preferred-relation-mapping>foreign-key</preferred-relation-mapping>
<read-ahead>
on-load
<page-size>1000</page-size>
<eager-load-group>*</eager-load-group>
</read-ahead>
<list-cache-max>1000</list-cache-max>
<unknown-pk>
<key-generator-factory>UUIDKeyGeneratorFactory</key-generator-factory>
<unknown-pk-class>java.lang.String</unknown-pk-class>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(32)</sql-type>
</unknown-pk>
<entity-command name="default"/>
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835739#3835739
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3835739
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
