Mike, if it was that easy I guess Zachi or me could have done it ;-).

NetBeans -- what's that? The pale imitation of Eclipse done by Sun?

The Data Tools within Eclipse are a little weirdo to configure and I am
pretty sure they have a great way to build the connection URL which is not
compatible with Informix. It might not be a lot of work, but they do not
provide much debugging information besides the exception stack.

Java is my friend and has been for quite some years now ;-).


Which reminds me... during IDUG 2007, I will have a half day hands-on
seminar on Java, how to build your first app, etc. Heavily using Eclipse,
IDS (probably Cheetah, I cant use something else) and Java 6.

I'll also speak of EJB 3, XML, etc. But I will not be the only one speaking
of Java at the conference.

2 min ad ;-)

> -----Original Message-----
> From: informix-list-bounces@iiug.org [mailto:informix-list-
> bounces@iiug.org] On Behalf Of Ian Michael Gumby
> Sent: Tuesday, January 02, 2007 05:37
> To: jgp@iiug.org; zklopman@gmail.com; informix-list@iiug.org
> Subject: RE: Eclipse Data Tools Project
>
>
> Jean,
>
> I believe this is a dead issue.
>
> You can set it up to add the Informix JDBC drivers to the path and then
> use
> them for a connection.
> I did this with NetBeans so it should be similar in Eclipse.
>
> -Mike
> PS. Remember Java and JDBC are your friends! ;-)
>
> >
> >Have u made any progress?
> >
> > > -----Original Message-----
> > > From: informix-list-bounces@iiug.org [mailto:informix-list-
> > > bounces@iiug.org] On Behalf Of Zachi
> > > Sent: Thursday, November 02, 2006 17:11
> > > To: informix-list@iiug.org
> > > Subject: Re: Eclipse Data Tools Project
> > >
> > > 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.JDB CConnection.createConnec
> t
> > > ion(JDBCConnection.java:88)
> > > at
> > >
> >org.eclipse.datatools.connectivity.DriverConnecti onBase.internalCreateCon
> n
> > > ection(DriverConnectionBase.java:103)
> > > at
> > >
> >org.eclipse.datatools.connectivity.DriverConnecti onBase.open(DriverConnec
> t
> > > ionBase.java:53)
> > > at
> > >
> >org.eclipse.datatools.connectivity.db.generic.JDB CConnection.<init>(JDBCC
> o
> > > nnection.java:48)
> > > at
> > >
> >org.eclipse.datatools.connectivity.db.generic.JDB CConnectionFactory.creat
> e
> > > Connection(JDBCConnectionFactory.java:51)
> > > at
> > >
> >org.eclipse.datatools.connectivity.internal.Conne ctionFactoryProvider.cre
> a
> > > teConnection(ConnectionFactoryProvider.java:85)
> > > at
> > >
> >org.eclipse.datatools.connectivity.internal.Conne ctionFactoryProvider.cre
> a
> > > teConnection(ConnectionFactoryProvider.java:69)
> > > at
> > >
> >org.eclipse.datatools.connectivity.internal.Conne ctionProfile.createConne
> c
> > > tion(ConnectionProfile.java: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
> > >
> > > _______________________________________________
> > > Informix-list mailing list
> > > Informix-list@iiug.org
> > > http://www.iiug.org/mailman/listinfo/informix-list
> >
> >_______________________________________________
> >Informix-list mailing list
> >Informix-list@iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list
>
> __________________________________________________ _______________
> Find sales, coupons, and free shipping, all in one place! MSN Shopping
> Sales & Deals
> http://shopping.msn.com/content/shp/...rid6,ptnrdata 0639

Jean Georges Perrin wrote:
> Mike, if it was that easy I guess Zachi or me could have done it ;-).
>
> NetBeans -- what's that? The pale imitation of Eclipse done by Sun?
>
> The Data Tools within Eclipse are a little weirdo to configure and I am
> pretty sure they have a great way to build the connection URL which is not
> compatible with Informix. It might not be a lot of work, but they do not
> provide much debugging information besides the exception stack.
>
> Java is my friend and has been for quite some years now ;-).
>
>
> Which reminds me... during IDUG 2007, I will have a half day hands-on
> seminar on Java, how to build your first app, etc. Heavily using Eclipse,
> IDS (probably Cheetah, I cant use something else) and Java 6.
>
> I'll also speak of EJB 3, XML, etc. But I will not be the only one speaking
> of Java at the conference.
>
> 2 min ad ;-)
>
> > -----Original Message-----
> > From: informix-list-bounces@iiug.org [mailto:informix-list-
> > bounces@iiug.org] On Behalf Of Ian Michael Gumby
> > Sent: Tuesday, January 02, 2007 05:37
> > To: jgp@iiug.org; zklopman@gmail.com; informix-list@iiug.org
> > Subject: RE: Eclipse Data Tools Project
> >
> >
> > Jean,
> >
> > I believe this is a dead issue.
> >
> > You can set it up to add the Informix JDBC drivers to the path and then
> > use
> > them for a connection.
> > I did this with NetBeans so it should be similar in Eclipse.
> >
> > -Mike
> > PS. Remember Java and JDBC are your friends! ;-)
> >
> > >
> > >Have u made any progress?
> > >
> > > > -----Original Message-----
> > > > From: informix-list-bounces@iiug.org [mailto:informix-list-
> > > > bounces@iiug.org] On Behalf Of Zachi
> > > > Sent: Thursday, November 02, 2006 17:11
> > > > To: informix-list@iiug.org
> > > > Subject: Re: Eclipse Data Tools Project
> > > >
> > > > 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.JDB CConnection.createConnec
> > t
> > > > ion(JDBCConnection.java:88)
> > > > at
> > > >
> > >org.eclipse.datatools.connectivity.DriverConnecti onBase.internalCreateCon
> > n
> > > > ection(DriverConnectionBase.java:103)
> > > > at
> > > >
> > >org.eclipse.datatools.connectivity.DriverConnecti onBase.open(DriverConnec
> > t
> > > > ionBase.java:53)
> > > > at
> > > >
> > >org.eclipse.datatools.connectivity.db.generic.JDB CConnection.<init>(JDBCC
> > o
> > > > nnection.java:48)
> > > > at
> > > >
> > >org.eclipse.datatools.connectivity.db.generic.JDB CConnectionFactory.creat
> > e
> > > > Connection(JDBCConnectionFactory.java:51)
> > > > at
> > > >
> > >org.eclipse.datatools.connectivity.internal.Conne ctionFactoryProvider.cre
> > a
> > > > teConnection(ConnectionFactoryProvider.java:85)
> > > > at
> > > >
> > >org.eclipse.datatools.connectivity.internal.Conne ctionFactoryProvider.cre
> > a
> > > > teConnection(ConnectionFactoryProvider.java:69)
> > > > at
> > > >
> > >org.eclipse.datatools.connectivity.internal.Conne ctionProfile.createConne
> > c
> > > > tion(ConnectionProfile.java: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 doad
> > > > > 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
> > > >
> > > > _______________________________________________
> > > > Informix-list mailing list
> > > > Informix-list@iiug.org
> > > > http://www.iiug.org/mailman/listinfo/informix-list
> > >
> > >_______________________________________________
> > >Informix-list mailing list
> > >Informix-list@iiug.org
> > >http://www.iiug.org/mailman/listinfo/informix-list
> >
> > __________________________________________________ _______________
> > Find sales, coupons, and free shipping, all in one place! MSN Shopping
> > Sales & Deals
> > http://shopping.msn.com/content/shp/...rid6,ptnrdata 0639

I will say something OT:
Eclipse (and WSAD based on it) may be considered as being pale
comparing to OTI's previous product: VisuaAge (Smalltalk etc) in many
important aspects. If I compare the productivity of our programmers
using WSAD with the one I had with VAST, well, VAST was at least 2-3x
more productive (unless todays Java/J2EE programmers are that much
worse than Smalltalk ones; which I doubt). SCM and CM with ENVY was
superior to file based tools, and simple to manage. GUI was superior...
Hmm... perhaps it's that Smalltalk (or some other dynamic typing
languages like Ruby) is more (developer wise) productive than Java, but
such a statement could only start flame war and I am completely OT, so
I should better stop.

Also, I am not sure if NetBeans was not available before the Eclipse,
so it could hardly be desigated as imitation. Anyway, NetBeans seems to
be nice tool for those that don't need or like to deal with many addons
in Eclipse style. Just install it and use it, if it suits your needs. I
am yet to see fast Java development environment.

Informix support would be very nice to see in Eclipse as well as in
other development tools. Besides the convenience for developers, it
improves the impression that Informix is alive and going furher. What
worries me is that some administration tools like Embarcadero's suite
of products support Sybase and don't support Informix. Does it mean
that Sybase is ahead of IDS in the market?

Your topics for IDUG (IIUG?) 2007 are very welcome. Do you have any
online materials available now?

Darko Krstic

Embarcadero as a general rule is nothing to get excited about.

It's big in SQL-Server shops and since Sybase and SQL-Server are/were
pretty much the same kind of engine, they really didn't have to do much
to make things work. I wouldn't worry about Sybase or Embarcadero, these
products aren't really going anywhere. Sybase will continue to be relevant
for a little while longer, but MySQL can easily fill its space now with the
5.x releases.

darko wrote:

> Informix support would be very nice to see in Eclipse as well as in
> other development tools. Besides the convenience for developers, it
> improves the impression that Informix is alive and going furher. What
> worries me is that some administration tools like Embarcadero's suite
> of products support Sybase and don't support Informix. Does it mean
> that Sybase is ahead of IDS in the market?
>
> Your topics for IDUG (IIUG?) 2007 are very welcome. Do you have any
> online materials available now?
>
> Darko Krstic
>