Re: Eclipse Data Tools Project
Jean Georges Perrin wrote: > > -----Original Message----- > > From: informix-list-bounces@iiug.org [mailto:informix-list- > > bounces@iiug.org] On Behalf Of Zachi > > Sent: Tuesday, January 02, 2007 15:02 > > To: informix-list@iiug.org > > Subject: Re: Eclipse Data Tools Project > > > ... > > > > > > > > >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. > > > > > > > > Would it help if I posted the way I set up connections? > > > Please do! > For an existing SQL file: Right click on the editor (not on the explorer). Choose "set connection info". You will be asked for a connection profile type and name. Assuming this is the first time, you will need to create on, so click on the [Create...] button. A new dialog will appear - click on "SQL Model-JDBC Connection" and then [Next>]. Give your new connection a name (say, "xtz") and an optional description. (You may also choose auto-connect at this stage). Then [Next>]. You need to select a driver. Assuming this is the first time, you will need to create one - click on [...]. A new dialog "Driver Definitions" will open. Scroll to Informix, choose appropriate version and click [Add...] A new dialog "New Driver Definition" will open. Choose "Informix JDBC Driver" template, give a name, set "Edit New Driver Immediately" and [OK]. Point to the location of the ifxjdbc.jar file. In the URL line you must set the host, port, database (important!) and INFORMXISERVER. you may also set a user id, password and database name in the following lines. Click [OK]. Now choose the driver you just created and [OK]. You will now have the details filled in, and you can change them at will - and always remember to [Test Connection]!. If you get "Ping succeeded!", you are fine, and click [Finish]. You can now hook up to the database and do other useful stuff. If you get "Ping Failed", look at [details]. Here are some easy problems: Wrong hostname or port: java.sql.SQLException: com.informix.asf.IfxASFException: Attempt to connect to database server (<INFORMIXSERVER>) failed. Wrong database name (or no connect permission): java.sql.SQLException: Database not found or no system permission. Wrong username: java.sql.SQLException: Incorrect password or user com.informix.asf.IfxASFRemoteException: user@host.domain is not known on the database server. As an exercise for the reader, figure out what this error message means: java.sql.SQLException: User (com.informix.asf.IfxASFRemoteException: informix@host.domain)'s password is not correct for the database server. I hope this helps, Zachi
Thanks Zachi, that's what I did to connect to the DB trying to browse it ;-)... and failed. I have not tried to execute a direct query. I will try that ;-)... ServerStudio is still better for the job! > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of Zachi > Sent: Wednesday, January 03, 2007 15:48 > To: informix-list@iiug.org > Subject: Re: Eclipse Data Tools Project > > Jean Georges Perrin wrote: > > > -----Original Message----- > > > From: informix-list-bounces@iiug.org [mailto:informix-list- > > > bounces@iiug.org] On Behalf Of Zachi > > > Sent: Tuesday, January 02, 2007 15:02 > > > To: informix-list@iiug.org > > > Subject: Re: Eclipse Data Tools Project > > > > > ... > > > > > > > > > > > >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. > > > > > > > > > > > Would it help if I posted the way I set up connections? > > > > > Please do! > > > > For an existing SQL file: > Right click on the editor (not on the explorer). Choose "set > connection info". > You will be asked for a connection profile type and name. Assuming this > is the first > time, you will need to create on, so click on the [Create...] button. > A new dialog will appear - click on "SQL Model-JDBC Connection" and > then [Next>]. > Give your new connection a name (say, "xtz") and an optional > description. (You may > also choose auto-connect at this stage). Then [Next>]. > You need to select a driver. Assuming this is the first time, you will > need to create > one - click on [...]. A new dialog "Driver Definitions" will open. > Scroll to Informix, choose appropriate version and click [Add...] > A new dialog "New Driver Definition" will open. Choose "Informix JDBC > Driver" template, > give a name, set "Edit New Driver Immediately" and [OK]. > Point to the location of the ifxjdbc.jar file. > In the URL line you must set the host, port, database (important!) and > INFORMXISERVER. > you may also set a user id, password and database name in the following > lines. > Click [OK]. > Now choose the driver you just created and [OK]. > You will now have the details filled in, and you can change them at > will - and always > remember to [Test Connection]!. > If you get "Ping succeeded!", you are fine, and click [Finish]. You can > now hook up > to the database and do other useful stuff. > > If you get "Ping Failed", look at [details]. Here are some easy > problems: > > Wrong hostname or port: > java.sql.SQLException: com.informix.asf.IfxASFException: Attempt to > connect to database server (<INFORMIXSERVER>) failed. > > Wrong database name (or no connect permission): > java.sql.SQLException: Database not found or no system permission. > > Wrong username: > java.sql.SQLException: Incorrect password or user > com.informix.asf.IfxASFRemoteException: user@host.domain is not known > on the database server. > > As an exercise for the reader, figure out what this error message > means: > java.sql.SQLException: User (com.informix.asf.IfxASFRemoteException: > informix@host.domain)'s password is not correct for the database > server. > > I hope this helps, > > Zachi > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list