How should I configure 2 different datasources for MSSQL Server connection,

[chaitanya kiran pvn]

[B]Hi,
How should I configure 2 different datasources for MSSQL Server connection, in the same standardjbosscmp-jdbc.xml, mssql-ds.xml, login-config.xml and other config files?

I've tried this but it doesn't work...
<defaults>
<datasource>java:/MSSQLDS</datasource>
<datasource>java:/MSSQLDSRep</datasource>
<datasource-mapping>MS SQLSERVER2000</datasource-mapping>
....
and in login-config .xml i maped like this

 
[B]
 
 
<application-policy name = "MSSQLDbRealm"> 
<authentication> 
<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required"> 
<module-option name = "principal">sa</module-option> 
<!-- For Cleebo Setup -->
<!--<module-option name = "userName">sa_Cleebo</module-option> 
<module-option name = "password">redim04</module-option>  -->
<module-option name = "userName">sa_hogaming</module-option> 
<module-option name = "password">123456</module-option>
 
<module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MSSQLDS</module-option> 
</login-module> 
</authentication> 
</application-policy> 
 
 
 
<application-policy name = "MSSQLRepDbRealm"> 
<authentication> 
<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required"> 
<module-option name = "principal">sa</module-option> 
<module-option name = "userName">sa_hogaming</module-option> 
<module-option name = "password">123456</module-option> 
<module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MSSQLDSRep</module-option> 
</login-module> 
</authentication> 
</application-policy> 
   

so hear mssqlds for normal connection and mssqldsRep is for report generation in my app mssqlds is connected to datbase it give results .but from jsp it is not getting the result from database and it throws

  
 
javax.servlet.ServletException: Unable to get connection, DataSource invalid: "No suitable driver"
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.admin.casino.accounts.viewAccount_jsp._jspService(org.apache.jsp.admin.casino.accounts.viewAccount_jsp:1358)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
com.casinocasino.security.RequiresSecureFilter.doFilter(RequiresSecureFilter.java:58)
com.casinocasino.security.CheckloginFilter.doFilter(CheckloginFilter.java:65)
com.casinocasino.security.CasinoFilter.doFilter(CasinoFilter.java:81)
com.casinocasino.security.SecureSiteFilter.doFilter(SecureSiteFilter.java:77)
com.casinocasino.util.LanguageSelectionFilter.doFilter(LanguageSelectionFilter.java:79)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
  

 
 
javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "No suitable driver"
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(QueryTagSupport.java:276)
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(QueryTagSupport.java:159)
org.apache.jsp.admin.casino.accounts.viewAccount_jsp._jspx_meth_sql_query_0(org.apache.jsp.admin.casino.accounts.viewAccount_jsp:2261)
org.apache.jsp.admin.casino.accounts.viewAccount_jsp._jspx_meth_c_if_7(org.apache.jsp.admin.casino.accounts.viewAccount_jsp:1985)
org.apache.jsp.admin.casino.accounts.viewAccount_jsp._jspService(org.apache.jsp.admin.casino.accounts.viewAccount_jsp:896)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
com.casinocasino.security.RequiresSecureFilter.doFilter(RequiresSecureFilter.java:58)
com.casinocasino.security.CheckloginFilter.doFilter(CheckloginFilter.java:65)
com.casinocasino.security.CasinoFilter.doFilter(CasinoFilter.java:81)
com.casinocasino.security.SecureSiteFilter.doFilter(SecureSiteFilter.java:77)
com.casinocasino.util.LanguageSelectionFilter.doFilter(LanguageSelectionFilter.java:79)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
 
   

so can you tell me what was the problem .
how can i declare two datasource to connect my application and is there any option for connectionpool in jboss if yes? how to declare that. pleace explain me

thanks in advance .
chaitanya
[/B]
[ November 05, 2007: Message edited by: chaitanya kiran pvn ]

[Jaikiran Pai]

You can configure more than one datasource in a single -ds.xml file. Like this:

<datasources>
  <local-tx-datasource>
    <jndi-name>MyAppDS1</jndi-name>
<!-- All other properties for MyAppDS1 go here-->
  </local-tx-datasource>
 
  <local-tx-datasource>
    <jndi-name>MyAppDS2</jndi-name>
<!-- All other properties for MyAppDS2 go here-->
  </local-tx-datasource>
 
</datasources>

That's it. You can then use java:/MyAppDS1 and java:/MyAppDS2 as you wish. For more details have a look at ConfigDataSources

By the way, the exception that you are getting:

javax.servlet.ServletException: Unable to get connection, DataSource invalid: "No suitable driver"

Make sure that the connection URL that you have specified in the -ds.xml file is correct and also the jar file containing driver class is present in the server/< serverName>/lib folder of JBoss.