Problems connecting to remote informix from NetBea
Dear colleagues: I am developing a web application with Java and NetBeans 8.0.2, which will connect to a remote informix engine, but within the same intranet. I use frameworks are Hibernate 4.3.1 and Java Server Faces + PrimeFaces, which I liked a lot when I learned, but unfortunately, most of the examples are made with MySQL installed locally. When I try to connect to remote informix engine, it rejects the connection me. The connection string I'm using is: jdbc:informix-sqli://192.168.40.97:1526/pruebas:INFORMIXSERVER=ol_develop I've checked everything several times, and the user and password (not listed in the post), they are correctly entered. So notorious, it is that if the connection string will remove the name of the base, leaving this way: jdbc:informix-sqli://192.168.40.97:1526:INFORMIXSERVER=ol_develop NetBeans is connected to the engine and shows me the sysmaster, sysutils, and pruebas bases. But fails more than that, it can't show the structure of the base. The JDBC I am using is the JDBC 3.70.JC6. Anyone has happened something similar? I would appreciate any help you can give me. Regards! Gustavo Echenique
Hola Gustavo, yo lo tengo configurado así jdbc:informix-sqli://10.40.50.53:9088/pruebas:INFORMIXSERVER=ol_local Con este driver IBM Informix JDBC Driver 3.00.JC2. Sin problemas 2016-04-28 19:45 GMT-03:00 GUSTAVO ECHENIQUE <gustavo.echenique@cemdo.com.ar >: > Dear colleagues: > > I am developing a web application with Java and NetBeans 8.0.2, which will > connect to a remote informix engine, but within the same intranet. > > I use frameworks are Hibernate 4.3.1 and Java Server Faces + PrimeFaces, > which > I liked a lot when I learned, but unfortunately, most of the examples are > made > with MySQL installed locally. > > When I try to connect to remote informix engine, it rejects the connection > me. > > The connection string I'm using is: > jdbc:informix-sqli://192.168.40.97:1526/pruebas:INFORMIXSERVER=ol_develop > > I've checked everything several times, and the user and password (not > listed > in the post), they are correctly entered. > > So notorious, it is that if the connection string will remove the name of > the > base, leaving this way: > jdbc:informix-sqli://192.168.40.97:1526:INFORMIXSERVER=ol_develop > NetBeans is connected to the engine and shows me the sysmaster, sysutils, > and > pruebas bases. But fails more than that, it can't show the structure of the > base. > > The JDBC I am using is the JDBC 3.70.JC6. > > Anyone has happened something similar? > > I would appreciate any help you can give me. > > Regards! > > Gustavo Echenique > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Damián Javier Solalinde --f46d04289e0bf2b2d0053194167b
So are you saying you can connect and see your database names using=20 jdbc:informix-sqli://192.168.40.97:1526:INFORMIXSERVER=3Dol=5Fdevelop ? Yet putting the database name into the URL wouldn't connect you -=20 yielding which error ? If so, I'd say this is not a problem connecting to the database server,=20 but rather one opening a database when already connected. Andreas From: "GUSTAVO ECHENIQUE" <gustavo.echenique@cemdo.com.ar> To: ids@iiug.org Date: 29.04.2016 00:46 Subject: Problems connecting to remote informix from NetBea [37061] Sent by: ids-bounces@iiug.org Dear colleagues:=20 I am developing a web application with Java and NetBeans 8.0.2, which will = connect to a remote informix engine, but within the same intranet.=20 I use frameworks are Hibernate 4.3.1 and Java Server Faces + PrimeFaces,=20 which=20 I liked a lot when I learned, but unfortunately, most of the examples are=20 made=20 with MySQL installed locally.=20 When I try to connect to remote informix engine, it rejects the connection = me.=20 The connection string I'm using is:=20 jdbc:informix-sqli://192.168.40.97:1526/pruebas:INFORMIXSERVER=3Dol=5Fdevel= op=20 I've checked everything several times, and the user and password (not=20 listed=20 in the post), they are correctly entered.=20 So notorious, it is that if the connection string will remove the name of=20 the=20 base, leaving this way:=20 jdbc:informix-sqli://192.168.40.97:1526:INFORMIXSERVER=3Dol=5Fdevelop=20 NetBeans is connected to the engine and shows me the sysmaster, sysutils,=20 and=20 pruebas bases. But fails more than that, it can't show the structure of=20 the=20 base.=20 The JDBC I am using is the JDBC 3.70.JC6.=20 Anyone has happened something similar?=20 I would appreciate any help you can give me.=20 Regards!=20 Gustavo Echenique=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20