RE: Informix SE - JDBC problem

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C04AE2.02301506 Content-Type: text/plain; charset="iso-8859-1" I created the database and tables, while I've been setting up and testing. So its just a very small "testDB" in a publicly accessible area. I can connect to the database through dbaccess, isql or even esql c with other users... but not JDBC. (unless i run implicitly with a super user - that is without explicitly using the user/password argument in the connection string.) I was hoping to get rid of the problem by complete opening up this database, and then slowly placing restrictions back on the database until i find the error so i used... "grant dba to public" on my test database. This didn't help, which lead me to believe that if its a database restriction its not coming from the engine itself, but maybe network (because of using the tcp service)... i ruled this out however by connecting with esql c against this service. ... thanks Murray, i double checked. ... -----Original Message----- From: Murray Wood [mailto:murray@quanta.co.nz] Sent: Friday, 10 November 2000 12:52 PM To: informix-list@iiug.org Subject: RE: Informix SE - JDBC problem 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_001_01C04AE2.02301506 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content="MSHTML 5.00.3103.1000" name=GENERATOR></HEAD> <BODY> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=593211006-10112000>I created the database and tables, while I've been setting up and testing.&nbsp; So its just a very small "testDB" in a publicly accessible area.</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=593211006-10112000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=593211006-10112000>I can connect to the database through dbaccess, isql or even esql c with other users...&nbsp; but not JDBC.&nbsp; (unless i run implicitly with a super user - that is without explicitly using the user/password argument in the connection string.)</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=593211006-10112000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=593211006-10112000>I was hoping to get rid of the problem by complete opening up this&nbsp;database, and then slowly placing restrictions back on the database until i find the error so i used... "grant dba to public" on my test database.</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=593211006-10112000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=593211006-10112000>This didn't help, which lead me to believe that if its a database restriction its not coming from the engine itself, but maybe network (because of using the tcp service)... i ruled this out however by connecting with esql c against this service.</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=593211006-10112000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=593211006-10112000>...</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=593211006-10112000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=593211006-10112000>thanks Murray,&nbsp; i double checked.</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=593211006-10112000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=593211006-10112000>...</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=593211006-10112000></SPAN></FONT>&nbsp;</DIV> <DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Murray Wood [mailto:murray@quanta.co.nz]<BR><B>Sent:</B> Friday, 10 November 2000 12:52 PM<BR><B>To:</B> informix-list@iiug.org<BR><B>Subject:</B> RE: Informix SE - JDBC problem<BR><BR></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=300105002-10112000>Who created the database and tables?&nbsp; You should be able to connect as that user.&nbsp; grant connect to {user-id}</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=300105002-10112000>Check out the grant statement.</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=300105002-10112000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT color=#0000ff face=Aria