Need support for MySQL stored procedure
Dear team,
I am Working in MySQL 5.7.24 Version.
I need answers for following questions , Could you advise me?
==============================================================
By Default, MySQLdatabase not supported indexing concept in MySQL Views.
1.How to I use the Views in the MySQL Database ?
2.Shall I use the Storedprocedure instead of Views ?
3.Shall I use Dynamic SQl query to Storedprocedure ? Is it Recommended? or Not ?
4.I need to implement Connection pooling ? By default , JDBC Template have the connection pooling , therefore
Shall I use JDBC Template ? Is it Recommended? or Not ?
5.Which is the best one to retrieve the data , Views ? or Stored procedure ? or Both ? could you advice me ?
6.Actually I have one problem with MySQL query.
This is my query
Select json_arrayagg(json_object('Name',Name)) from tbl_test
My table contains arabic strings , When I query the arabic string from JAVA Code.
the result strings are not in readable format . Could you help for my problem ?
Subject
Views
Written By
Posted
Need support for MySQL stored procedure
1044
January 22, 2019 04:49AM
615
January 22, 2019 12:25PM
448
January 23, 2019 12:20AM
407
January 23, 2019 11:48AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.