Re: JDBC Problems with Informix SE on Linux

Jeff So wrote: > > Quote from the Informix JDBC Version 1.22 document : > > <------- > > To use Informix JDBC Driver to connect to an Informix database, you must use one > of the following Informix database servers: > > Informix Dynamic Server, Version 7.x > Informix Dynamic Server, Workgroup and Developer Editions, > Version 7.x > Informix Dynamic Server with Advanced Decision Support and > Extended Parallel Options, Version 8.x > Informix Dynamic Server with Universal Data Option, Version > 9.x > INFORMIX-OnLine, Version 5.x > > -----------> > > And SE - standard engine is not one of them. > Wait a little longer for the online available on Linux. That's not quite a quote, that's more of a paraphrase, here's a quote from the doc/release/JDBCREL.TXT file: The Informix database server and platform combinations listed below have been tested and certified with the Informix-JDBC Driver Version 1.22.JC1. Server/platform combinations not listed below have not been tested and certified, and the driver may or may not work correctly. These tests have been completed using the latest available level of the JDK, either 1.1.5 or 1.1.6 in all cases except AIX 4.2.1, which uses JDK 1.1.4. The following servers have been tested and certified on Solaris 2.5.1, NT 4.0, HP-UX 10.20 & 11.0, AIX 4.2.1 & 4.3, SGI 6.2, and DEC 4.0: Informix Dynamic Server, Version 7.x Informix Dynamic Server, Workgroup and Developer Editions, Version 7.x Informix Dynamic Server with Universal Data Option, Version 9.x The following servers have been tested and certified on Solaris 2.5.1 only: Informix Dynamic Server with Advanced Decision Support and Extended Parallel Options, Version 8.x INFORMIX-OnLine, Version 5.x INFORMIX-SE, Version 5.x INFORMIX-SE, Version 7.2x So, while it's only been certified to work on SE engines on Solaris it does actually work with SE engines on Linux. At least it does on my box when you use the correct URL form. > "Andreas M. Weiner" wrote: > > > > Hi, > > > > I've problems with connecting my Informix-SE 7.42 DBMS (running on > > SuSE Linux 5.2; JDK 1.1.3) to the JDBC driver (fourth category) > > accessible at the Informix Andreas, I'd be just as worried that your not using the JDK 1.1.6 as much as the form of your URL. > >"jdbc:informix-sqli://127.0.0.1:1536/testDB:INFORMIXSERVER= > >javastation_se user=;password=" > > The documentation has this to say about URLs: Format of Database URLs Informix JDBC Driver supports database URLs of the following format: jdbc:informix-sqli://{<ip-address>|<host-name>}:<port-number> [/<dbname>]:INFORMIXSERVER=<server-name>;user=<username>; password=<password>[;<name>=<value>[;<name>=<value>]...] In the preceding syntax: curly brackets ( {} ) together with vertical lines ( | ) denote more than one choice of variable. Angle brackets ( <> ) denote a variable value. Brackets ( [] ) denote an optional value. words or symbols not enclosed in either angle brackets or brackets are required (INFORMIXSERVER=, for example). Also note that the JDBCDOC.TXT gives and example of the kind of URL you need to use for the SE 7.2X engine, since the current JDBC driver does not support the DBPATH keyword: You can specify this database in a database URL in your Java program, as shown in the following example: "jdbc:informix-sqli://myhost:1525//tmp/mydb: informixserver=myserver_tli;user=rdtest;password=test" Note the full path to the database, preceeded by the doubled forward slash. Since the JDBC driver's not ceritified to work with SE except on Solaris there's no guarantee it will work, but I haven't had an problems connecting so far. Rob Z.