JDBC Connection error

[Arturo Henry Torres Zenteno]

Hi all,

I have trouble creating JDBC connection to oracle database. I'm using the "Java Gateway Wizard", e.g.:

  Type of connection: JDBC

  Connection name:   JDBCConnection

  User:   user

  Password:   ****************

  Driver name: oracle.jdbc.driver.OracleDriver

  URL:   jdbc: jdbc:oracle:thin:@//localhost:1521/XE

  Class path: c:\ojdbc6.jar

  Properties: oracle.jdbc.V8Compatibility=true; includeSynonyms=false;restrictGetTables=true

My operating system is Windows 7 64 bit.

The really peculiar thing is that with the same operating system configuration, the connection does work on another computer.

Any ideas?

Regards.

[Heloisa Ramalho]

Hi Arturo,

What is the error message, when does it happen and which Ensemble version are you using?

Perhaps you need to open this port on the firewall?

Thanks,

Heloisa

--
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
---
You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare" group.
To unsubscribe from this group and stop receiving emails from it, send an email to Ensemble-in-Healt...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Arturo Henry Torres Zenteno]

Thanks Heloisa,

The connection test indicates failed connection. The Ensemble version is 2010.2.2.600.0.

I can confirm that there is no firewall issue. I suspect it may be related to the JDK version, although I can not confirm.

Regards.

2013/8/27 Heloisa Ramalho <heloisa...@intersystems.com>

[Heloisa Ramalho]

You need a supported version of Java properly configured, which for 2010.2 could be Java 1.5 or 1.6, as long as the version is compatible with this .jar file you are using for the connection.

Besides the connection page, please also check the JDBC settings page to ensure the settings are correct.

It looks like the path may be incorrect for c:\ojdbc6.jar, please ensure this is the correct directory.

I've found out that after installing the Oracle client driver, usually I have to reboot the computer.

Another suggestion that I recommend is to try to configure a loopback connection to namespace SAMPLES, from another namespace such as USER.  For this, check the JDBC settings and create another connecting pointing back to Ensemble and ensure you can successfully connect within your own machine and see the tables in SAMPLES from another namespace.  After defining the connection and ensuring it is successful, you may run a SQL query in the Portal using the SQL page such as "select * from cinema.film" from namespace USER and see the rows fetched from namespace SAMPLES.

I think that in this version there was no detailed error shown in the Portal page yet; we added it later.  Also in 2013.1 we added detailed errors logging to the JDBC Gateway Server page which replaced the JDBC Settings page.  If you can install this version, or 2013.2 beta, you may try JDBC out to see if you can get better diagnosis messages.  For this version you must use Java 1.6.

If all fails, consider calling the WRC, they have a lot of experience in assisting users with this kind of problem.

Regards,

Heloisa

[Crístofer Mateos Vicente]

Greetings,

I am experiencing exactly the same problem that Arturo has mentioned (long time ago). I have followed the guide that InterSystem provides for configuring a Gateway Conection and also I have checked everything that has been mentioned here, but the conexion cannot be stablished to my database. 

I am trying to do it in an Windows 7 Enterprise x64 bits. The Java version I have installed and setted is the 1.6. At this point, the Gateway configuration looks like this:

 Type of connection: JDBC

  Connection name:   LocalConnection

  User:   LocalUser

  Password:   ****************

  Driver name: oracle.jdbc.driver.OracleDriver

  URL:   jdbc: jdbc:oracle:thin:@//localhost:1521/XE

  Class path: d:\ojdbc\ojdbc6.jar

  Properties: oracle.jdbc.V8Compatibility=true; includeSynonyms=false;restrictGetTables=true

This precise configuration works in an XP virtual machine, but this is not a solution for us. It must work in Windows 7 and there is not chance at all of upgrading to 2013 version.

Can anyone help me to solve this? Thank you very much.

Regards,

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

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

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

---

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

To unsubscribe from this group and stop receiving emails from it, send an email to Ensemble-in-Healthcare+unsub...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--

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-i...@googlegroups.com

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

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

---

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

To unsubscribe from this group and stop receiving emails from it, send an email to Ensemble-in-Healthcare+unsub...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
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-Healthcare-unsub...@googlegroups.com

For more options, visit this group at http://groups.google.com/group/Ensemble-in-Healthcare?hl=en
---
You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare" group.

To unsubscribe from this group and stop receiving emails from it, send an email to Ensemble-in-Healthcare+unsub...@googlegroups.com.

[Heloisa Ramalho]

You might try uninstalling and reinstalling the same JDBC driver or getting a newer version.

You may also install 2013.1 or 2014.1 on the same box -- it will use separate ports -- and repeat the steps with that version, to make it easier to debug.

Heloisa

At 10/21/2014 12:03 AM, Crístofer Mateos Vicente wrote:

Greetings,

I am experiencing exactly the same problem that Arturo has mentioned (long time ago). I have followed the guide that InterSystem provides for configuring a Gateway Conection and also I have checked everything that has been mentioned here, but the conexion cannot be stablished to my database.

I am trying to do it in an Windows 7 Enterprise x64 bits. The Java version I have installed and setted is the 1.6. At this point, the Gateway configuration looks like this:

 Type of connection: JDBC
  Connection name:   LocalConnection
  User:   LocalUser
  Password:   ****************
  Driver name: oracle.jdbc.driver.OracleDriver
  URL:   jdbc: jdbc:oracle:thin:@//localhost:1521/XE
  Class path: d:\ojdbc\ojdbc6.jar
  Properties: oracle.jdbc.V8Compatibility=true; includeSynonyms=false;restrictGetTables=true

This precise configuration works in an XP virtual machine, but this is not a solution for us. It must work in Windows 7 and there is not chance at all of upgrading to 2013 version.

Can anyone help me to solve this? Thank you very much.

Regards,

El martes, 27 de agosto de 2013 20:43:08 UTC+2, Heloisa Ramalho escribió:

Regards,

Heloisa

Thanks Heloisa,

Regards.

2013/8/27 Heloisa Ramalho < heloisa...@intersystems.com>

Hi Arturo,

Thanks,

Heloisa

Hi all,

  Type of connection: JDBC

  Connection name:   JDBCConnection

  User:   user

  Password:   ****************

  Driver name: oracle.jdbc.driver.OracleDriver

  Class path: c:\ojdbc6.jar

  Properties: oracle.jdbc.V8Compatibility=true; includeSynonyms=false;restrictGetTables=true

Any ideas?

Regards.

--

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

---

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

To unsubscribe from this group and stop receiving emails from it, send an email to Ensemble-in-Healt...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--

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-i...@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

---

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

To unsubscribe from this group and stop receiving emails from it, send an email to Ensemble-in-Healt...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--

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

---

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

To unsubscribe from this group and stop receiving emails from it, send an email to Ensemble-in-Healt...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
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
---
You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare" group.

To unsubscribe from this group and stop receiving emails from it, send an email to Ensemble-in-Healt...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.