1 Reply Latest reply on Oct 22, 2002 3:57 AM by joelvogt

    java.sql.SQLException: Server configuration denies access to

      we r using jboss-3.0.3_tomcat-4.1.12.when trying to connect to database we are getting the following error.

      what is the reason.the verion of mysql is 3.23.46 and driver we r using is mm.mysql-2.0.11-bin.jar

      pls. help!!!.

      java.sql.SQLException: Server configuration denies access to data source
      11:45:02,638 ERROR [STDERR] at org.gjt.mm.mysql.MysqlIO.init(Unknown Source)
      11:45:02,639 ERROR [STDERR] at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
      11:45:02,639 ERROR [STDERR] at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown Source)
      11:45:02,639 ERROR [STDERR] at org.gjt.mm.mysql.Driver.connect(Unknown Source)
      11:45:02,639 ERROR [STDERR] at java.sql.DriverManager.getConnection(DriverManager.java:512)
      11:45:02,640 ERROR [STDERR] at java.sql.DriverManager.getConnection(DriverManager.java:171)
      11:45:02,640 ERROR [STDERR] at expmeet.expmeetbean.expmeetTempid(expmeetbean.java:33)
      11:45:02,640 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      11:45:02,640 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
      )
      11:45:02,640 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
      .java:25)
      11:45:02,641 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
      11:45:02,641 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Stateles
      sSessionContainer.java:660)
      11:45:02,641 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(Cach
      edConnectionInterceptor.java:186)
      [root@webex1 logs]# pwd

        • 1. Re: java.sql.SQLException: Server configuration denies acces
          joelvogt

          this will be an access permissions thing. Make sure you have granted privileges to the right user and password and the ip/host you are connecting from. It might take a few grants till you work out the right one. Just run a 'flush privileges' after each. I don't think it is actually required anymore, but is good luck.