The driver definition dialog hasn't changed in version 3.0.x. The URL
is a "template" that will be used as the initial value of "JDBC URL"
whenever you create a new alias. You must still specify a class name
- it is filled in for you though when you add a new jar via "Extra
classpath" and also if you happened to toss the jar file into the lib/
folder.
Rob
On Tue, Aug 18, 2009 at 3:09 PM, Lennon , Sam<slennon@...> wrote:
> Thanks for the input.
>
>
>
> At a prior job I experimented some with SQuirreL, probably version 2.6, and
> I don’t recollect any disconnect issues.
>
>
>
> However, SQuirreL version 3 is a big improvement over 2.6. Also the driver
> definition is a little bit different. Yes, I do have the Extra Class Path
> set to point to JT400.JAR, but you no longer specify a class name, you just
> specify a URL, for example, “jdbc:as400://DEVBOX/SLENNON;” Possibly there
> is some property that I should specify in the URL, but I don’t know what it
> is. And version 3 actually lets you specify driver properties in a nice
> GUI.
>
>
>
> I’m not sure whether it is something that has changed in JT400.JAR or in
> SQuirreL. I suspect if you upgrade to version 3 you may have the same
> disconnection issues, so keep a backup if you try.
>
>
>
> Sam
>
> ________________________________
>
> From: Harris, Bernard W [mailto:bharris@...]
> Sent: Tuesday, August 18, 2009 1:51 PM
> To: squirrel-sql-users@...
> Subject: Re: [Squirrel-sql-users] Constantly losing connection
> toAS/400(iSeries) Host
>
>
>
> We currently connect to 3 iSeries databases using Squirrel version 2.6.4 and
> we don’t have a disconnect problem. I do connect using the jt400.jar
> though. I changed the JTOpen Driver to use the Extra Class Path of the
> jt400.jar and Class Name com.ibm.as400.access.AS400JDBCDriver. This is free
> from IBM and you might have it already installed if you have IBM iSeries
> Access for Windows.
>
>
>
> Bernard Harris
>
> Applications Analyst
>
> Schield Family Brands
>
> 715-748-2100 ext. 3520
>
>
>
> This is a transmission from the Schield Family Brands and may contain
> information that is privileged and/or confidential. If you are not the
> intended addressee, note that any disclosure, copying, distribution, or use
> of the contents of this message is prohibited. If you have received this
> transmission in error, please destroy it and notify the sender immediately
> at the phone or address listed above.
>
>
>
> ________________________________
>
> From: rhill@... [mailto:rhill@...]
> Sent: Tuesday, August 18, 2009 12:28 PM
> To: squirrel-sql-users@...
> Subject: Re: [Squirrel-sql-users] Constantly losing connection to
> AS/400(iSeries) Host
>
>
>
> Hi.
>
> I have exactly the same problem, and have had to stick with the JDBC-ODBC
> bridge.
>
> I'd be grateful for a solution too.
>
> Regards
> Roger
>
> I’m running against a DB2 database on an AS/400 (iSeries) machine. I’m using
> the latest JTOPEN driver (6.5.1) and have tried both 3.0.1 and 3.0.2 of
> SQuirreL.
>
> I can connect, download the tables, and run statements. But if I leave the
> session idle for few seconds, say 30, the connection is lost. I have tried
> against two different hosts with the same results.
>
> Using the JDBC-ODBC bridge work fine, except that it seems to reports
> phantom errors after some statement complete correctly, and I think the JDBC
> driver would solve some of this.
>
> If anyone has any suggestions on how to fix this problem I sure would like
> to hear from you. SQuirreL is a great product at a marvelous price.
>
> ****************************************
> Roger Hill
> ****************************************
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>
|