Re: Does DBPATH work for JDBC connections to SE 7.x database?

In article <6t2ia5$b4m$1@nnrp1.dejanews.com>, peterwiley@my-dejanews.com () wrote: > Hi. > > I've been experimenting with the Weblogic type 4 JDBC driver against a > SE > 7.24.UC5 engine on Solaris 2.5/SPARC. > > I set up a startup script in /etc/rc3.d that includes a DBPATH > environment > variable and starts the server. > > ------------------------------------------------------------------------ > --- > # > # Start/stop processes required for Informix SE 7.x server > # > INFORMIXDIR=/export/home2/informix_se7; export INFORMIXDIR > PATH=$PATH:$INFORMIXDIR/bin; export PATH > INFORMIXSERVER=wendy_se; export INFORMIXSERVER > DBPATH=/tmp:/export/home/peter; export DBPATH > INFORMIXSQLHOSTS=$INFORMIXDIR/etc/sqlhosts; export INFORMIXSQLHOSTS> cd /tmp > > case "$1" in > 'start') > echo " Informix SE Server starting..\\n" > $INFORMIXDIR/lib/sqlexecd wendy_se > ;; > > 'stop') > echo " Informix SE Server stopping...\\n" > > ;; > esac > > ------------------------------------------------------------------------ > ------ > > Using dbaccess and connecting to wendy_se server (defined in sqlhosts > as a > tcpip service) the DBPATH environment var seems to be used; both test > databases are visible. > > Connecting via the Weblogic drivers, they aren't. If I give the full > path to > the database ("jdbc:weblogic:informix4:/tmp/test@my_toy:1525", "user", > "password") the connection goes through. If I just use the database > name, I > get error -329. Same user/password as connecting via dbaccess. My > conclusion > is that either the DBPATH variable in my startup script is being > ignored or > I'm missing something bleeding obvious. Or there's a bug in the Weblogic > driver working with SE, but this isn't likely as it looks like a SE > problem; > the driver finds the service OK. > > Anyone got any ideas? > > cc: peter_wil@antdiv.gov.au > > TIA, > > Peter Wiley > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum > If this was Online I'd be looking at the informix .rc files to ensure that the inbound connections are getting the correct environment, but not being a fan of SE I don't know if SE uses these files (but I suspect it does.) Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 #