Skip to main content

How to access metadata in MySql from Java application (User does not have access to metadata ,SQLException)



When you get an error message like:
java.lang.Exception: java.sql.SQLException: User does not have access to metadata required to determine stored procedure parameter types. If rights can not be granted, configure connection with "noAccessToProcedureBodies=true" to have driver generate parameters that represent INOUT strings irregardless of actual parameter types.

Ans:

Please use the below connection string settings:

 private Connection con;

 String connectionURL = "jdbc:mysql://<ip address>:3306/<database name>?user=<username>&password=<password>&noAccessToProcedureBodies=true";

con = DriverManager.getConnection(connectionURL);

Comments

Post a Comment

Popular posts from this blog

How to Connect mysql through JDBC connector through Tomcat or externally.

Solution: This can happen for a variety of reasons. I just saw it myself a few weeks ago but I can't remember what the fix was for me. 1) Verify the address mysql is bound to, it's probably 127.0.0.1 (only) which I believe is the default (at least on standard Ubuntu server). You'll have to comment out the bind-address parameter in my.cnf to bind to all available addresses (you can't choose multiple, it's one or all). 2) If it is bound to 127.0.0.1 and you can't connect using "localhost", make sure it's not resolving to the IPv6 localhost address instead of IPv4. (or just use the IP address) 3) Double and triple-check the port that mysql is listening on. 4) Make sure you're using the right JDBC connector for your JDK. 5) Make sure you're not doing something really silly like starting mysql with --skip-networking.
Post a Comment
Read more

Re-programming Ubislate 7C+

Re-Programming / Flashing Ubislate 7c+ This procedure of flashing / re-programming will help you to solve many problems as below... Tablet Stuck at home screen, Freezed Any Software related bug, developed later on which can't be solved with Factory reset. Since this is the procedure from Datawind itself, so you don't need to worry before doing any step. You need 1 tool & 1 image file before starting the process. Phoenix Card SW Any Micro SD Memory Card Image file - SW for Ubislate, 281 Mb  Steps:- 1)    Kindly download the Phoenix card software from here.         https://mega.co.nz/#!coc0HTQJ!WpZmCGRdGwXnzCOaUInqpBzMfDtFjCwEqVWfPg16N20 2)    Extract PhoenixCard.rar by using Winzip or Winrar. 3)    Then download the image file which is SW for your tablet from below link (281 Mb) https://mega.co.nz/#!Iwt1SLhL!eSTrg0vtswcZBUszaeSSmyHjt6QlD2U1LJE0MDV5qOc 4)    And ...
25 comments
Read more

Enable Wifi (if not working) in Ubislate / Aakash Tablet

After doing below commands the wifi works in Ubislate 7c+: a)  Install "terminal emulator" in the device (copy the apk to device using memory card or data cable connection). b) Open terminal emulator type the following two commands & press enter after each > su > insmod /vendor/modules/8192cu.ko c) Open wifi in the settings and on/off wifi d) It works!!! WiFi will be worked till reboot. After reboot/restart device you need to run the command again Terminal Emulator.
Post a Comment
Read more