Re: Does DBPATH work for JDBC connections to SE 7.x database?
Posted in 1998
Topics: Connectivity: ODBC / JDBC / .NET, Server Administration, Security, Permissions & Auditing, Networking & sqlhosts Configuration, Platform-Specific Issues, Java & JDBC Development
In article <memo.19980908190914.2923I@wfsoftware.compulink.co.uk>,
paulw@wfsoftware.co.uk wrote:
> 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.
[snip]
> > 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.)
Thanks, but I don't think that's the problem. I also have Online on the same
box. Connecting using the same Java program (just change database & port)
works without a problem. I'm pretty sure it's tied up with DBPATH. I've gone
through the docs and it *looks* OK, just doesn't work.
Peter Wiley
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum