10 Replies Latest reply on Oct 27, 2003 6:25 AM by adrian.brock

    JBOSS's JDBC driver

    sameer

      Does JBOSS server provides full fledged JDBC driver to be used in production environment for MS-SQL DB ?

        • 1. Re: JBOSS's JDBC driver

          No. It provides a resource adapter for any jbdc driver you
          want to use.

          Regards,
          Adrian

          • 2. Re: JBOSS's JDBC driver
            jbrains

            [Please forgive my picking up a thread six weeks later.]

            Does this mean that I can drop any JDBC driver into JBoss and it will just work? I've been trying to get Mimer to work for the past hour or so and I'm flying kind of blind, so I don't know why I can't get anywhere. JBoss is always waiting for a deployer on the data source I'm trying to deploy.

            I would just like to know whether what I'm trying to do is possible: connect to a Mimer-database data source from JBoss. My original goal was to use CMP with Mimer, but I'd be happy to make a first step in that direction.

            • 3. Re: JBOSS's JDBC driver

              You'll need to post the deployment descriptor to get any help.
              It does end with -ds.xml doesn't it?

              Regards,
              Adrian

              • 4. Re: JBOSS's JDBC driver
                fral

                Hi

                If you want to use Mimer SQL with JBoss you can use the attached configuration files. Just modify the database URL, username and password in in mimersql-ds.xml and drop it in the deploy directory of you server.
                You should also change your standardjbosscmp-jdbc.xml to define how Mimer SQL works. I have done this in the attached standardjbosscmp-jdbc.xml as well.
                Just make sure you have the JDBC-driver in the classpath of your JVM.

                Regards,
                Fredrik

                • 5. Re: JBOSS's JDBC driver

                  I'm adding this to the jboss distribution.

                  Your comment about distributed transactions is incorrect.
                  Does mimer support XA?

                  Regards,
                  Adrian

                  • 6. Re: JBOSS's JDBC driver
                    fral

                    Adrian,

                    It would be great if you can add these files to the JBoss distribution.

                    Yes, Mimer SQL support distributed transactions with XA as of verison 9. You can find more information at http://developer.mimer.com if you want.

                    If you mean the comment in mimersql-ds.xml that says: "ConnectionManager setup for Mimer SQL for local and distributed", yes that's wrong. I have fixed this in the new attached file.

                    I have also attached a mimer-sql-xa.xml with the configuration for using Mimer SQL with XA.


                    Regards,
                    Fredrik

                    • 7. Re: JBOSS's JDBC driver
                      fral

                      Oops, the mimersql-xa-ds.xml contained the same comment error. Of course this file is for distributed transactions. Here are a new one.

                      Regards,
                      Fredrik

                      • 8. Re: JBOSS's JDBC driver

                        Done.

                        Regards,
                        Adrian

                        • 9. Re: JBOSS's JDBC driver
                          fral

                          Adrian,

                          Sorry about that, but the mimersql-xa.ds you got was errornous. It was a while I tested it, and somewhere on the road it got corrupted. Here is a new one that I have verified against Mimer SQL 9.2 and JBoss 3.2.1

                          Regards,
                          Fredrik

                          • 10. Re: JBOSS's JDBC driver

                            Ok thanks.

                            Regards,
                            Adrian