SEO

Hi,

Was anyone able to connect to an Informix database using the Eclipse
platform? I tried using generic JDBC driver (set to use the Informix
JDBC driver), but it didn't work. I was able to connect from
applications using JDBC within the Eclipse environment. Any ideas?

thanks,

Zachi

We develop using Eclipse but I think we mostly use squirrel to do ad
hoc queries on the database. Can you be more specific with your
problem? I might be able to get a developer to look at the issue you
are having. I don't use the tool myself so I can't be helpful.

Zachi wrote:
> Hi,
>
> Was anyone able to connect to an Informix database using the Eclipse
> platform? I tried using generic JDBC driver (set to use the Informix
> JDBC driver), but it didn't work. I was able to connect from
> applications using JDBC within the Eclipse environment. Any ideas?
>
> thanks,
>
> Zachi

The Eclipse Data Tools project has a database connection, which allows
for SQL queries,
looking at tables and so on. They currently have a "Generic JDBC", DB2,
Derby and Sybase
drivers. I was trying to connect to Informix 10 db using the "Generic
JDBC" driver with the
same parameters I use for the Informix JDBC applications. I then
received this exception:

java.sql.SQLException: com.informix.asf.IfxASFException: Attempt to
connect to database server (dbzk) failed.
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliCon nect.java:1026)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native
Method)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown
Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown
Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java :254)
at
org.eclipse.datatools.connectivity.db.generic.JDBC Connection.createConnection(JDBCConnection.java:88 )
at
org.eclipse.datatools.connectivity.DriverConnectio nBase.internalCreateConnection(DriverConnectionBas e.java:103)
at
org.eclipse.datatools.connectivity.DriverConnectio nBase.open(DriverConnectionBase.java:53)
at
org.eclipse.datatools.connectivity.db.generic.JDBC Connection.<init>(JDBCConnection.java:48)
at
org.eclipse.datatools.connectivity.db.generic.JDBC ConnectionFactory.createConnection(JDBCConnectionF actory.java:51)
at
org.eclipse.datatools.connectivity.internal.Connec tionFactoryProvider.createConnection(ConnectionFac toryProvider.java:85)
at
org.eclipse.datatools.connectivity.internal.Connec tionFactoryProvider.createConnection(ConnectionFac toryProvider.java:69)
at
org.eclipse.datatools.connectivity.internal.Connec tionProfile.createConnection(ConnectionProfile.jav a:304)
at org.eclipse.datatools.connectivity.ui.PingJob.run( PingJob.java:57)
at org.eclipse.core.internal.jobs.Worker.run(Worker.j ava:58)

which doesn't really make it clear as to the nature of the problem. I
currently use
ServerStudio and dbaccess for database connection, and I would rather
work directly
from Eclipse and not have to copy and paste.

thanks,

Zachi

bozon wrote:
> We develop using Eclipse but I think we mostly use squirrel to do ad
> hoc queries on the database. Can you be more specific with your
> problem? I might be able to get a developer to look at the issue you
> are having. I don't use the tool myself so I can't be helpful.
>
> Zachi wrote:
> > Hi,
> >
> > Was anyone able to connect to an Informix database using the Eclipse
> > platform? I tried using generic JDBC driver (set to use the Informix
> > JDBC driver), but it didn't work. I was able to connect from
> > applications using JDBC within the Eclipse environment. Any ideas?
> >
> > thanks,
> >
> > Zachi