Re: Linux JDBC connection wont

Kyle Dansie wrote: > > I have a very short java program to test out the JDBC driver I just > downloaded from informix. Just trying to connect to the stores > database. > I can access the database with dbaccess and with esqlc and all looks > good. This is on a SuSE 5.3 Linux machine. > > The java program will connect to the database server if, I leave out > the database name (stores7). If I put the database name in the > program it pukes with a 329 error. The DBAPTH variable is set to > /home/informix/data and this is where the stores7.dbs directory is > located. <snip> > SQLException: SQLState(IX000) vendor code(-329) > java.sql.SQLException: Database not found or no system permission. <snip> The JDBC driver does not look at your environment variables, look at the online documentation about connection URLs. It states in there that the jdbc driver can only see environment variables if you pass them thru the connection url. It also lists environment variables that it accepts. You can see from that list in doc/release/program.fm1. html#108471, that DBPATH is not an environment variable it knows. Which means the 1.22 JDBC driver can only work with SE databases in the connecting user's home directory. Rob Z.