1 2 Previous Next 21 Replies Latest reply on Jul 23, 2012 4:56 AM by rajendra85 Go to original post
      • 15. Re: Problems with JBoss 7 + SQL Server
        chufaca

        I have a question about that: What if inside the folder "jtds" we don't want to use the default folder "main" and we want to call the folder as the version of the driver (in this case: "1.2"). Do you know how to config the JBoss for this change?

        Thank you in advance!

        Facu

        • 16. Re: Problems with JBoss 7 + SQL Server
          ctomc

          hi,

           

          it is also posible, that "version" is called slot. so you configure it something like this:

           

          <driver name="JTDS" module="com.microsoft.sqlserver" slot="name-of-your-slot">

           

          cheers,

          tomaž

          • 17. Re: Problems with JBoss 7 + SQL Server
            chufaca

            I did that, but I still have the same error. It works fine if I use the default folder "main" and <driver name="JTDS" module="com.microsoft.sqlserver">.

             

            Do you know if I have to config another file appart from "standalone.xml"? Like the "module.xml" inside the "slot" folder?

             

            Thank you very much!

             

            Facu

            • 18. Re: Problems with JBoss 7 + SQL Server
              ctomc

              Hi,

               

              yes you need module.xml also inside every slot so for instance for slot named "1.2" you would need module xml in folder like this

               

              com/microsoft/sqlserver/1.2/module.xml

               

              then you have to define in that module.xml that your slot is slot="1.2"

               

              for reference look how jsf 1.2 module is defined in JBOSS_HOME\modules\com\sun\jsf-impl\1.2

               

              cheers,

              tomaz

              • 19. Re: Problems with JBoss 7 + SQL Server
                chufaca

                I made what you told me, but it still doesn't work. I added the slot=1.2 in the standalone.xml, then I created the new folder with that name inside the folder "jtds", then I copied the .jar and module.xml inside that new folder taking as a reference the jsf you mention. But JBoss is working with the .jar inside the MAIN folder. I tested it deleting the main folder and in that case it didn't work.

                 

                Do you know if have to "say" to JBoss not to take that default folder, and to take the folder I define in the slot attribute? Because I saw that when JBoss finished the deploy, it overwrites my standalone.xml and it deletes the slot attribute... As if it doesn't kinow what does it mean...

                 

                Thanks!!!

                 

                Facu

                • 20. Re: Problems with JBoss 7 + SQL Server
                  ctomc

                  hi,

                   

                  you are right, from looking into code, functionality is partly there but it does not work as it should.

                  Handling of slot attribute is not done correctly.

                   

                  please create jira for this so it can be addressed.

                   

                   

                  cheers,

                  tomaz

                  • 21. Re: Problems with JBoss 7 + SQL Server
                    rajendra85

                    HI guys,

                     

                       I am facing the problem in configuring the MS Sql server Data source in JBoss AS 7.0

                     

                       I am getting the following error :

                     

                      

                    New missing/unsatisfied dependencies:

                          service jboss.jdbc-driver.sqlserver (missing)

                     

                     

                      Here am mentioning my data source configuration. Please correct me if am wrong anywhere

                     

                     

                     

                     

                    Step 1  :  JBoss AS 7.0 final \ standalone \ configuration \ standalone.xml ,   I added the following content.

                     

                     

                    <datasource jndi-name="java:jboss/datasources/MSSqlDS" pool-name="MSSqlDS" enabled="true" jta="true" use-java-context="true" use-ccm="true">

                                        <connection-url>

                                            jdbc : sqlserver : // IP Address : 1433 / DBNAME

                                        </connection-url>

                                        <driver>

                                           sqlserver

                                        </driver>

                                        <transaction-isolation>

                                            TRANSACTION_READ_COMMITTED

                                        </transaction-isolation>

                                        <pool>

                                            <min-pool-size>

                                                10

                                            </min-pool-size>

                                            <max-pool-size>

                                                100

                                            </max-pool-size>

                                            <prefill>

                                                true

                                            </prefill>

                                            <use-strict-min>

                                                false

                                            </use-strict-min>

                                            <flush-strategy>

                                                FailingConnectionOnly

                                            </flush-strategy>

                                        </pool>

                                        <security>

                                            <user-name>

                                                XXXXX

                                            </user-name>

                                            <password>

                                               XXXXXXXXX

                                            </password>

                                        </security>

                                    </datasource>

                                   <driver name="sqlserver" module="com.microsoft.sqlserver.jdbc">

                                            <driver-class>

                                                com.microsoft.sqlserver.jdbc.SQLServerDataSource

                                            </driver-class>

                                    </driver>

                     

                         Step 2 :  JBoss AS 7.0 final \ modules \ com \ microsoft \ sqlserver \ jdbc \ main\ module.xml   ( Inside the module.xml )  Added the following content

                     

                    <?xml version="1.0" encoding="UTF-8"?>

                    <module xmlns="urn:jboss:module:1.0" name="com.microsoft.sqlserver.jdbc">

                      <resources>

                        <resource-root path="sqljdbc4.jar"/>  

                        <resource-root path="msutil.jar"/>

                        <resource-root path="msbase.jar"/>

                      </resources>

                      <dependencies>

                        <module name="javax.api"/>

                        <module name="javax.transaction.api"/>

                      </dependencies>

                    </module>

                     

                    Step 3 :  JBoss AS 7.0 final \ modules \ com \ microsoft \ sqlserver \ jdbc \ main ,  I added the following jars.

                     

                    1. sqljdbc4.jar

                    2. msutil.jar

                    3. msbase.jar

                     

                     

                    Still am facing the above mentioned : problem


                    New missing/unsatisfied dependencies:

                          service jboss.jdbc-driver.sqlserver (missing)

                     

                    What should i need to change ? Can any one tell the step by step datasource configuration  for SQLServer ? Its very urgent for me...

                     


                     

                    Thanks in advance

                    Rajendra J

                     


                     


                    1 2 Previous Next