1 2 Previous Next 22 Replies Latest reply on Dec 12, 2008 5:01 AM by jaikiran Go to original post
      • 15. Re: JBoss Bootstrap Environment config
        peterj

        When you switched to MySQL, did you remember to copy the mysql-connector-xxx.jar file to the server/default/lib directory?

        Also, use of the org.gjt.mm.mysql.Driver has been deprecated, you should use com.mysql.jdbc.Driver instead.

        Yes, since Coyote (Tomcat) is using port 9002, you should open that port in the firewall.

        • 16. Re: JBoss Bootstrap Environment config
          johnson4

          No I didn't know anything about the mysql-connector-xxx.jar file.
          Where can I find it?
          Or were you refering to the file I included in my last post, with the db config info?

          • 17. Re: JBoss Bootstrap Environment config
            peterj

            The connector jar file is available from the mysql web site. Look for Connctor/J on the Drivers tab in the products download page.

            • 18. Re: JBoss Bootstrap Environment config
              johnson4

              cool thanks a million, Ill go check that out
              sj

              • 19. Re: JBoss Bootstrap Environment config
                johnson4

                Hi
                Ive been able to access the jmx-console and the webbased admin for my app (tambur.org) but Im still having issues getting the mysql database to connect.
                I receive "Access denied for user: " concerning the connection to the database.
                Again I've updated www.nettechglobal.ca/putty.log with my later run.sh output
                and heres my db configfile (mysql-ds.xml)

                <?xml version="1.0" encoding="UTF-8"?>
                
                <!-- $Id: mysql-ds.xml,v 1.3.2.3 2006/02/07 14:23:00 acoliver Exp $ -->
                <!-- Datasource config for MySQL using 3.0.9 available from:
                http://www.mysql.com/downloads/api-jdbc-stable.html
                -->
                
                <datasources>
                 <local-tx-datasource>
                 <jndi-name>DefaultDS</jndi-name>
                 <connection-url>jdbc:mysql://localhost:3306/jbossdb</connection-url>
                 <driver-class>com.mysql.jdbc.Driver</driver-class>
                 <user-name>dbjbossca</user-name>
                 <password>some_word</password>
                 <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
                 <!-- should only be used on drivers after 3.22.1 with "ping" support
                 <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
                 -->
                 <!-- 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 - MySQLValidConnectionChecker is preferred for newer drivers
                 <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
                 -->
                
                 <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
                 <metadata>
                 <type-mapping>mySQL</type-mapping>
                 </metadata>
                 </local-tx-datasource>
                </datasources>
                
                


                Thanks again for aany help with this.
                sj

                • 20. Re: JBoss Bootstrap Environment config
                  peterj

                  I assume that the text "some_word" in your posted -ds.xml file is the actual password for dbjbossca? :-)

                  Run mysql, and enter the following:

                  use mysql
                  select user,host from user where user='dbjbossca';


                  What are the hosts that show up? Are any of them 'thecyprusgroup.ca.servermatrix.com'? If not, then you need to grant that user/host combination access to the database. The MySQL documentation is pretty good on explaining this (see the MySQL User Account Management section).

                  • 21. Re: JBoss Bootstrap Environment config

                    even i got the same error ....
                    its just random ....i have got sick of this
                    so can anyone tell me the way to solve this problem
                    i m using JBoss 4.0.0RC1
                    and java version is jdk1.4
                    and if some one can provide me the solution for configuring oracle9i with jboss
                    till now i changed my oracle-ds.xml,login-config.xml,standardjaws.xml and even standardjbosscmp-jdbc.xml
                    so do i need to make some other changes ??
                    after declaring this to my oracle-ds.xml <jndi-name>OracleDs</jndi-name>
                    i get the error saying that OracleDS not bound

                    • 22. Re: JBoss Bootstrap Environment config
                      jaikiran

                      sachin1506,
                      This is a 2 year old thread and discusses various issues. Its better to open a separate thread and provide more details about the issue you are running into.

                      1 2 Previous Next