Databases
StackOverflow2013
Postsdbo
POJava application deployed on Tomcat doesn't connect to jdbc-mysql
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POJava application deployed on Tomcat doesn't connect to jdbc-mysql
    primarykey
    data
    text
    <p>I'm trying to restore our tomcat server, but there's this application that doesn't connect to MySQL properly.</p> <p>Here's what is happening:</p> <p>I had an Java + Flex application. The entire application was placed into a directory (not a .war file).</p> <pre><code>$TOMCAT_WEBAPP/myflex_app/WEB-INF/lib/ -&gt; JDBC mysql driver goes here. </code></pre> <p>Here's my application config:</p> <pre><code> &lt;database&gt; &lt;rpgByMoodle user="moodle" password="moodle"&gt; &lt;url&gt;jdbc:mysql://localhost:3306/rpgbymoodle&lt;/url&gt; &lt;/rpgByMoodle&gt; &lt;moodle user="moodle" password="moodle"&gt; &lt;url&gt;jdbc:mysql://localhost:3306/moodle&lt;/url&gt; &lt;/moodle&gt; &lt;/database&gt; </code></pre> <p>So, I'm able to connect mysql through the command line client, but the application don't.</p> <p>I found on the internet people telling to "add new connection" using some Netbeans (or Eclipse) menus.. but, I haven't access to the source code of the application.</p> <p>I'm running tomcat on Linux. I've checked the tomcat log file at <code>/var/log/tomcat6/</code> and found nothing about jdbc.</p> <p>My catalina log:</p> <pre><code>Aug 4, 2011 9:24:25 AM org.apache.catalina.core.StandardEngine start INFO: Starting Servlet Engine: Apache Tomcat/6.0.20 Aug 4, 2011 9:24:26 AM org.apache.coyote.http11.Http11Protocol start INFO: Starting Coyote HTTP/1.1 on http-8080 Aug 4, 2011 9:24:26 AM org.apache.catalina.startup.Catalina start INFO: Server startup in 977 ms </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USLucas Vasconcelos
    1. USLucas Vasconcelos
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POJava application deployed on Tomcat doesn't connect to jdbc-mysql
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POJava application deployed on Tomcat doesn't connect to jdbc-mysql
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POJava application deployed on Tomcat doesn't connect to jdbc-mysql
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhat is the stacktrace? Consider using JNDI and DataSource rather than creating your own connection management.
      singulars
      1. POJava application deployed on Tomcat doesn't connect to jdbc-mysql
      1. USMichael-O
    2. CO@Michael-O sorry, I don't have access to the source code. All that I know is that when I run the application there's an user message "Connection failed, contact the administrator". If you could help me to find the stacktrace or any log file that helps...
      singulars
      1. POJava application deployed on Tomcat doesn't connect to jdbc-mysql
      1. USLucas Vasconcelos
    3. COCheck the catalina.out and other files in `logs`. If there is nothing, you are out of luck :-( This seems to be a black box.
      singulars
      1. POJava application deployed on Tomcat doesn't connect to jdbc-mysql
      1. USMichael-O
 

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