RE: JDBC Type2 to DB2 UDB OS/390
I successfully established a JDBC Type4 connection to DB2 UDB OS/390 using the driver supplied with CFMX. Now I'm trying to set up a JDBC Type2 connection. I added the class path for the JDBC driver files in CFMX Admin. I selected 'Other' from the Driver drop down list in the Add New Data Source box in CFMX Administrator. I entered the JDBC URL, the Driver Class, the Username and the Password following the example of other (non-CF) connections, but I keep getting a 'String index out of range: -1' JDBC error when I try to verify the connection. I don't have anything helpful to offer, so pardon me in advance for asking, but why would you want to use a Type 2 driver if you have a working Type 4 driver? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JDBC Type2 to DB2 UDB OS/390
Earl, George wrote: I successfully established a JDBC Type4 connection to DB2 UDB OS/390 using the driver supplied with CFMX. Now I'm trying to set up a JDBC Type2 connection. I added the class path for the JDBC driver files in CFMX Admin. I selected 'Other' from the Driver drop down list in the Add New Data Source box in CFMX Administrator. I entered the JDBC URL, the Driver Class, the Username and the Password following the example of other (non-CF) connections, but I keep getting a 'String index out of range: -1' JDBC error when I try to verify the connection. Can anyone confirm that I am at least on the right track with my approach? Yes. Am I correct in selecting 'Other' from the driver drop down list (since selecting DB2 Universal Database gets me the CFMX Type4 driver)? Does the 'String index out of range: -1' JDBC error raise any particular flags? I have seen it a few times with CF MX and charset bugs, but not with JDBC. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
