Eclipse Data Tools Project

Posted in 2006

Topics: Connectivity: ODBC / JDBC / .NET, Java & JDBC Development

Zachi — 1 Nov 2006 16:52:10 -0800 — source: Usenet: comp.databases.informix

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

↪ replying to Zachi

bozon — 2 Nov 2006 05:57:57 -0800 — source: Usenet: comp.databases.informix

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

↪ replying to bozon

Zachi — 2 Nov 2006 08:11:03 -0800 — source: Usenet: comp.databases.informix

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.createConnection(JDBCConnection.java:88) at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:103) at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:53) at org.eclipse.datatools.connectivity.db.generic.JDBCConnection.<init>(JDBCConnection.java:48) at org.eclipse.datatools.connectivity.db.generic.JDBCConnectionFactory.createConnection(JDBCConnectionFactory.java:51) at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:85) at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:69) at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(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