3 Replies Latest reply: Sep 17, 2013 7:55 PM by Pgleghorn-Oracle RSS

    Connect JSK & Sql Developer

    BSR

      Hi,

       

      Did someone try connecting JSK to SQL Developer? I tried doing it using DB credentials I could see in server.xml but with no success.

       

      Thanks!

        • 1. Re: Connect JSK & Sql Developer
          QfLee

          JSK用的是hsqldb,去查这方面的知识吧

          • 2. Re: Connect JSK & Sql Developer
            BSR

            Hi QfLee,

             

            Thanks for your reply. I'm aware that JSK used HSQL DB & I'm unable to connect to it using Sql developer tool. I would like to hear from someone who tried connecting successfully. Please share db credentials. Thanks!

            • 3. Re: Connect JSK & Sql Developer
              Pgleghorn-Oracle

              Typically the HSQLDB that JSK uses runs using in-memory mode, not server mode - see "Server modes" at http://hsqldb.org/doc/guide/running-chapt.html. This means that it's not possible to use a tool like SQL Developer, TOAD, Squirrel etc to connect into it. You can manually write a script to startup the DB in server mode, you will need to change the jdbc connection string in server.xml appropriately. Then you should be able to use an external tool to reach the DB using the same jdbc connection string.

               

              If you just need to make a simple few queries then you can try the query tool that comes with HSQLDB. It's very basic, but has the advantage that you don't need to change the DB mode, it can connect to an in-memory DB of a running JSK. To run it, locate the hsqldb.jar within the JSK and run:


              java -cp hsqldb.jar org.hsqldb.util.DatabaseManagerSwing

               

              Phil