7 Replies Latest reply on Jul 15, 2008 11:32 AM by peterj

    Error 8. Lost connection to server

    benitojuarez
    benitojuarez Jul 14, 2008 3:38 AM

      Hello,

      in my application i perform several queries to an odbc database. After 10 or 11 queries, i get the "Error 8. Lost connection to server" and jboss restarts. If i do the same in an java desktop application, it works.
      I've no idea, what the error means or how to solve it.

      thx for help
      BJ

      • 3109 Views
      • Tags:
        • 1. Re: Error 8. Lost connection to server
          peterj
          peterj Jul 14, 2008 11:54 AM (in response to benitojuarez)

          Please post the full stack trace for this error.

          Also, what database are you using? And by saying "odbc database" are you implying that you are using the JDBC-to-ODBC driver to access the database?

            • Actions
          • 2. Re: Error 8. Lost connection to server
            benitojuarez
            benitojuarez Jul 15, 2008 3:50 AM (in response to benitojuarez)

            the 1st and 2nd rows are debug prints. You see the statement which causes the error ... stmt.executeQuery(sql)
            The next lines are the usualy printed debuggings from jboss startup.

            09:37:22,436 INFO [STDOUT] SearchTools.executeQuery() connection.createStatement()
            09:37:22,436 INFO [STDOUT] SearchTools.executeQuery() stmt.executeQuery(query)
            Error 8. Lost connection to server
            09:37:25,272 INFO [Server] Starting JBoss (MX MicroKernel)...
            09:37:25,272 INFO [Server] Release ID: JBoss [Trinity] 4.2.2.GA (build: SVNTag=JBoss_4_2_2_GA date=
            200710221139)


              • Actions
            • 3. Re: Error 8. Lost connection to server
              benitojuarez
              benitojuarez Jul 15, 2008 5:52 AM (in response to benitojuarez)

              the database is an odbc datasource connection to an external GIS application (it's quite special, i know) .
              The driver is sun.jdbc.odbc.JdbcOdbcDriver.
              The thing i wonder about is that the same code running as desktop app is working well (even the same java version). There seems to be some kind of influence between the jboss threads an the ODBC-connection.

                • Actions
              • 4. Re: Error 8. Lost connection to server
                peterj
                peterj Jul 15, 2008 11:26 AM (in response to benitojuarez)

                I do not recognize the class "SearchTools". I scanned through the classes provided with JBossAS 4.2.2 (and even the classes in jDK 1.5) and no such class exists. What package or library contains this class?

                  • Actions
                • 5. Re: Error 8. Lost connection to server
                  peterj
                  peterj Jul 15, 2008 11:27 AM (in response to benitojuarez)

                  Oh, and you will have to ask the owners of this class what the error means and how to correct the problem.

                    • Actions
                  • 6. Re: Error 8. Lost connection to server
                    peterj
                    peterj Jul 15, 2008 11:31 AM (in response to benitojuarez)

                    OK, I think I get it now. SearchTools is your class and it is printing out debug statements.

                    Are you using JDBC to get a database connection, or are you using a data source? If you are using JDBC, I suggest you switch to using a data source.

                      • Actions
                    • 7. Re: Error 8. Lost connection to server
                      peterj
                      peterj Jul 15, 2008 11:32 AM (in response to benitojuarez)

                      Also, does the server.log file give any more information about what is going on?

                        • Actions