RE: Eclipse Data Tools Project
Posted in 2007
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>(IfxSqliConnect.java:1026)
> > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> > > Method)
> > > at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
> > > Source)
> > > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(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.JDBCConnection.createConnec
> t
> > > ion(JDBCConnection.java:88)
> > > at
> > >
> >org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateCon
> n
> > > ection(DriverConnectionBase.java:103)
> > > at
> > >
> >org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnec
> t
> > > ionBase.java:53)
> > > at
> > >
> >org.eclipse.datatools.connectivity.db.generic.JDBCConnection.<init>(JDBCC
> o
> > > nnection.java:48)
> > > at
> > >
> >org.eclipse.datatools.connectivity.db.generic.JDBCConnectionFactory.creat
> e
> > > Connection(JDBCConnectionFactory.java:51)
> > > at
> > >
> >org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.cre
> a
> > > teConnection(ConnectionFactoryProvider.java:85)
> > > at
> > >
> >org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.cre
> a
> > > teConnection(ConnectionFactoryProvider.java:69)
> > > at
> > >
> >org.eclipse.datatools.connectivity.internal.ConnectionProfile.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.java: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/?ctid8,ptnrid6,ptnrdata 0639