RE: Informix SE - JDBC problem
This is a multi-part message in MIME format.
------=_NextPart_000_0040_01C04B2E.2B6CBFE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Who created the database and tables? You should be able to connect as that
user. grant connect to {user-id}
Check out the grant statement.
MW
-----Original Message-----
From: owner-informix-list@iiug.iiug.org
[mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Gooley, Simon
Sent: Friday, November 10, 2000 2:39 PM
To: 'informix-list@iiug.org'
Subject: Informix SE - JDBC problem
I have JDBC for informix SE installed on HPUX 10.20.
When i use the JDBC to connect to a database, the only user i am able to
connect to a database with is a super user (root) - permissions right? i
can't find where....
- the c-isam files are read/write world
- in the DB engine i can connect to DBserver/database specifically as
user/password over the sesoctcp service (from dbaccess).
- java is able to read and write files using normal file permission.
If i use a connect string with username and password, then the JDBC fails
to connect to the database, even if the username and password in the connect
string is the same as that of the superuser running the JDBC app from
command line. But if i run the same program with no username/password, i
can get a connection (but only as a superuser).
Versions:
Java jdk1.1.8
JDBC 1.40
Informix SE 7.24.UC1
sqlexed is running as sesoctcp
does anyone have any information that might help?
NOTICE: CONFIDENTIAL COMMUNICATION
This e-mail message and any accompanying files may contain
information that is confidential and subject to privilege. If you
are not the intended recipient, and have received the e-mail
in error, you are notified that any use, dissemination,
distribution, forwarding, printing or copying of the message
and any attached files is strictly prohibited. If you have
received this e-mail message in error please immediately
advise the sender by return e-mail, or telephone, listed below.
You must destroy the original transmission and its contents.
Any views expressed within this communication are those of
the individual sender, except where the sender specifically
states them to be the views of Ramsay Health Care.
This communication should not be copied or disseminated
without permission.
------------------------------------------------------------------------
"Greenslopes Private Hospital" a member of Ramsay Health Care
Telephone: 61 7 3394 7111
Facsimile: 61 7 3394 7322
------=_NextPart_000_0040_01C04B2E.2B6CBFE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D300105002-10112000>Who=20
created the database and tables? You should be able to connect as =
that=20
user. grant connect to {user-id}</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D300105002-10112000>Check=20
out the grant statement.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D300105002-10112000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D300105002-10112000>MW</SPAN></FONT></DIV>
<BLOCKQUOTE>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B>=20
owner-informix-list@iiug.iiug.org=20
[mailto:owner-informix-list@iiug.iiug.org]<B>On Behalf Of </B>Gooley,=20
Simon<BR><B>Sent:</B> Friday, November 10, 2000 2:39 PM<BR><B>To:</B>=20
'informix-list@iiug.org'<BR><B>Subject:</B> Informix SE - JDBC=20
problem<BR><BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D234550700-10112000>I =
have JDBC for=20
informix SE installed on HPUX 10.20.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D234550700-10112000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D234550700-10112000>When =
i use the=20
JDBC to connect to a database, the only user i am able to connect =
to a=20
database with is a super user (root) - permissions right? i can't find =
where....</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D234550700-10112000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D234550700-10112000>- =
the c-isam files=20
are read/write world</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D234550700-10112000>- in =
the DB engine=20
i can connect to DBserver/database specifically as user/password over =
the=20
sesoctcp service (from dbaccess).</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D234550700-10112000>- =
java is able to=20
read and write files using normal file permission.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D234550700-10112000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D234550700-10112000>If i =
use a connect=20
string with username and password, then the JDBC fails to connect to =
the=20
database, even if the username and password in the connect string is =
the same=20
as that of the superuser running the JDBC app from command =
line. =20
But if i run the same program with no username/password, i can =
get a=20
connection (but only as a superuser).</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D234550700-10112000>Versions:</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D234550700-10112000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D234550700-10112000>Java =
jdk1.1.8</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D234550700-10112000>JDBC =
1.40</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D234550700-10112000>Informix SE=20
7.24.UC1</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D234550700-10112000>sqlexed is running=20
as sesoctcp</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D234550700-10112000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D234550700-10112000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D234550700-10112000>does =
anyone have=20
any information that might help?</SPAN></FONT></DIV><CODE><FONT=20
size=3D3><BR><BR>NOTICE: CONFIDENTIAL COMMUNICATION<BR>This e-mail =
message and=20
any accompanying files may contain<BR>information that is confidential =
and=20
subject to privilege. If you<BR>are not the intended recipient, and =
have=20