Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Use <b>appfog</b> environment variable called VCAP_SERVICES to automatically detect your MySQL database credentials and connection info. You can take advantage of this to display all the info which will be in JSON format and use it to connect your app to MySQL database. You may try this.</p> <ul> <li><p>First create a servlet and retrieve your database connection using a context attribute as follows:</p> <pre><code>public class DbInfoServlet extends HttpServlet { public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException { request.setAttribute("jsonContent", java.lang.System.getenv("VCAP_SERVICES")); request.getRequestDispatcher("/index.jsp").view.forward(request, response); } } </code></pre></li> <li><p>Then create a index.jsp file to display you DB connection info as follows:</p> <pre><code>&lt;body&gt; &lt;p&gt; &lt;!-- Click here to display DB info --&gt; &lt;a href="/DbInfoServlet"&gt;&lt;/a&gt; &lt;!-- Display of your DB connection and credentials info is here. This will show in JSON document format --&gt; &lt;c:out value="${jsonContent}" /&gt; &lt;/p&gt; &lt;/body&gt; </code></pre></li> <li><p>Use hostname(i.e. IP), port, name(i.e. database name), username, password parameters from JSON document content to modify your JDBC connection code as follows:</p> <pre><code>try { String connectionURL = "jdbc:mysql://hostname:3306/name"; Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection(connectionURL, username, password); statement = conn.createStatement(); } </code></pre></li> <li><p>If the above doesn't work, simply ensure that you are using the latest version of MySQL-connector-java jar file.</p></li> </ul> <p>Have fun!</p>
    singulars
    1. This table or related slice is empty.
    1. POhow to configure connection to the database in clouds services
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USLekhobola Tsoeunyane
    1. USLekhobola Tsoeunyane
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POhow to configure connection to the database in clouds services
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COwoooooow thanks a lot.... amazing !!!! *dancing*
      singulars
      1. PO
      1. USkholofelo Maloma
    2. COPeace bra... I remember you from Liesbeek (IT Rep).
      singulars
      1. PO
      1. USLekhobola Tsoeunyane
    3. COLekhobolo, on what project did you use Appfog, because me and this boy of mine Kholofelo, Appfog showed us flames. Been a while, hope you all good long time . nice simple solution.
      singulars
      1. PO
      1. USRaymond Nakampe
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload