HI!
This is mehul savalia from Asite Solutions.
now i am not getting the above problem.
Please follow the steps in addtion to the jars stettings.
1.Entery in MS-SQL DS
<local-tx-datasource>
<jndi-name>dmsdb</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://servname:1433;;ServerName=servername;PortNumber=1433;DatabaseName=databasename;User=sa;Password=password;SelectMethod=cursor</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>sa</user-name>
5q154
<prepared-statement-cache-size>50</prepared-statement-cache-size>
<new-connection-sql>SELECT COUNT(*) FROM sysusers WHERE 1 =
-1</new-connection-sql>
<!-- sql to call when connection is created
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>
-->
<min-pool-size>25</min-pool-size>
<max-pool-size>31000</max-pool-size>
<idle-timeout-minutes>15</idle-timeout-minutes>
<track-statements>false</track-statements>
</local-tx-datasource>
2. I have modified the files from \jboss\server\default\config directory
a) standardjaws.xml
java:/dmsdb
<type-mapping>MS SQLSERVER2000</type-mapping>
false
b) standardjbosscmp-jdbc.xml
java:/dmsdb
<datasource-mapping>MS SQLSERVER2000</datasource-mapping>
3. I have added the following xml info in login-config.xml file from
\jboss\server\default\config
<application-policy name = "MSSQLDbRealm">
<login-module code =
"org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required">
<module-option name = "principal">sa</module-option>
<module-option name = "userName">sa</module-option>
<module-option name = "password">5q154</module-option>
<module-option name =
"managedConnectionFactoryName">jboss.jca:service=XaTxCM,name=dmsdb</module-option>
</login-module>
</application-policy>
4 download msvcp71.dll and msvcr71.dll and copy it in system32 folder of window dir.
Hope that it works for you.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3854020#3854020
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3854020
-------------------------------------------------------
This SF.Net email is sponsored by:
Sybase ASE Linux Express Edition - download now for FREE
LinuxWorld Reader's Choice Award Winner for best database on Linux.
http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
