Java Gateway Wizard jdbc connection to Ingress DB

[Noel Sharrock]

Hi,

I'm trying to connect via Studio to InterSystems Vital (pmi)
application. This app uses the Ingress database.

I have a connection string similar to: jdbc:ingres://11.12.10.186:II7/
servux02::serv;TZ=GMT10

I can connect to the Db using the java based SQurriL client that uses
the string and the ingress jdbc iijdbc.jar file.

In Studio the "Java Gateway Wizard" can see the iijdbc.jar file but
won't say if it is valid

The Java Gateway server name. IP addess: would be 11.12.10.186

The Java Gateway server port: Now that has get me stumped. is it II7
or a number.
What about the path and time zone? servux02::serv;TZ=GMT10. Where
would that data go?

All I get from the wizard is "Gateway did not respond!"; even if
enter the path of a corrupt jar file.

Any and all help would be appreciated.

Noel

[Alex Schaefer]

Hi Noel,

 

You are actually mixing up two things here.  You have two possibilities:

 

·         Use the SQL Gateway / SQL adapters with a JDBC connection to link tables, migrate data or simply execute commands against the database

·         Use the Java Gateway to generate proxy classes from your .jar file and execute commands available through the Java application.  The Java Gateway is an Ensemble component that will not use your database connection string.  If you look at the documentation for the Java Gateway it explains how to start up the Java Gateway and connect to it from the wizard.  In this case you are not talking straight to the database but just to the java app.

 

Hope that helps,

-- Alex

--

You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare Community" group.

To post to this group, send email to Ensemble-in...@googlegroups.com

To unsubscribe from this group, send email to Ensemble-in-Healt...@googlegroups.com

For more options, visit this group at http://groups.google.com/group/Ensemble-in-Healthcare?hl=en

[Noel Sharrock]

Thanks Alex,
I got to the "Java Gateway Wizard" because I was having no luck
connectiong to the database using the Gateway Connection.
As I said before I can connect using a third party JDBC application
(SQuirreL) using the same connection data without difficulty

Use the form below to edit a gateway connection:
Type of connection: JDBC
Connection name: JDBCConnection
User: hrhaens01
Password: ****************
Driver name: com.ingres.jdbc.IngresDriver
URL: jdbc:ingres://11.12.10.186:II7/servux02::serv
Class path: C:\InterSystems\Ensemble\JDBC\iijdbc.jar
Properties: TZ=GMT10

All I get (even if parameters are deliberately wrong) is "Connection
failed".
How could I debug this connection. Is there any log info I can look
up....anything

[Randy Stewart]

Is it just the font or does the port number in the URL string have alpha characters in it instead of numbers? It looks like I’s are used instead of 1’s  -  II7 when it should be 117?

--
Randy L Stewart
Sales Engineer
InterSystems Corporation

Randy....@intersystems.com
214-551-5781

[Noel Sharrock]

Hi Randy,
Yes the port identifier is alphanumeric. Don't ask my why Ingress went
for symbolic port identifiers.
In this particular case ucase ii + 7

http://docs.huihoo.com/ingres/ingres2006r2-guides/Connectivity%20Guide/933.htm
.....
portName
Symbolic port ID (required). A port ID must be provided either
numerically or symbolically.

[Noel Sharrock]

The problem went away.
The gateway now works.
Why it started working I have no idea