Eclipse SQL Client Plug-In for Caché?

Atelier Users:

Has anyone found an Eclipse plug-in that provides the capability to connect to a Caché server and give the user a way to write SQL queries using the tables from that server? I'm picturing something like a "WinSQL"-client built as an Eclipse plugin.

I've found and tried the following, but I couldn't get it to connect to my local Caché instance.

http://eclipsesql.sourceforge.net/

I do a lot of SQL query building with the SQL tool on the Management Portal or $system.SQL.Shell() from terminal before moving the queries into my COS code. A plugin that lets me do that building right from the Eclipse workbench would be handy.

Thank you,

Jean

Vote up!
Vote down!

Rating: 2

4 answers

Answer

Hi Jean,

I tried out the Eclipse SQL Explorer and was able to connect to my local instance just fine. I installed the plug-in using the update site from the link you provided, http://eclipsesql.sourceforge.net/.

Then I opened the associated perspective by going to Window > Perspective > Open Perspective Other > SQL Explorer. I right-clicked in the Connections view and hit New Connection Profile. I had to select Add/Edit Drivers to add the Caché JDBC driver with these settings:

The keys were to 1) select the Extra Class Path tab and Add JARs to pick the JDBC driver from my Caché install directory and 2) to add the correct Driver Class Name, com.intersys.jdbc.CacheDriver.

Once I had that configured I selected it in the Connection Profile Wizard, entered my JDBC connection URL, jdbc:Cache://localhost:56773/SAMPLES, and selected the authentication information:

This also worked for me when I unselected "Username is not required", checked "Auto Logon" and entered my Caché credentials.

I right-clicked the connection and hit Connect. Then double-clicking the connection (listed as "Connected since <timestamp>") opened the connection in the Editor where I could enter my SQL statement:

Where are you running into problems?

Vote up!
Vote down!

Rating: 5

Answer

Hi Nicole,

This is perfect! Thank you. The step I was missing was finding/including the Caché JDBC driver jar files. I've got it up and running and all looks good.

Thanks again for the prompt reply.

Best,

Jean

Vote up!
Vote down!

Rating: 0

Answer

It's not about Atelier, but I would also promote Caché Web Terminal which has the very handy internal sql tool, which you can enter with /sql:

 

@Nikita Savchenko can provide more info.

 

Vote up!
Vote down!

Rating: 3

Answer

Thank you Evgeny; I was looking for something that was built into Atelier, but this Cache Web Terminal looks like a tool I can use too.

Vote up!
Vote down!

Rating: 0

Log in to answer