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_01C04DE3.EF6718C0 Content-Type: text/plain; charset="iso-8859-1" Hi, I've been working with Informix's JDBC 1.40 and SE 7.24 on POX 10.20, and I'm having problems with connecting to our databases... completely unrestricted on the database and unrestricted on the file system. (as far as I can tell anyway) 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 think I can rule this out by the fact that I was able to connect with esql c against this tcp socket service. does anyone have any suggestions? I'm baffled... 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_01C04DE3.EF6718C0 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 face=Arial size=2><SPAN class=689272402-14112000>Hi, </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=689272402-14112000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=689272402-14112000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=689272402-14112000>I've been working with Informix's JDBC 1.40 and SE 7.24 on POX 10.20, and I'm having problems with connecting to our databases... completely unrestricted on the database and&nbsp;unrestricted on the file system.&nbsp; (as far as I can tell anyway)</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=689272402-14112000></SPAN></FONT>&nbsp;</DIV> <DIV> <DIV><FONT 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><SPAN class=593211006-10112000></SPAN><FONT face=Arial size=2>&nbsp;</FONT></DIV> <DIV><FONT 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. (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><SPAN class=593211006-10112000></SPAN><FONT face=Arial size=2>&nbsp;</FONT></DIV> <DIV><FONT 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><SPAN class=593211006-10112000></SPAN><FONT face=Arial size=2>&nbsp;</FONT></DIV> <DIV><FONT 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&nbsp;<SPAN class=689272402-14112000>think I can </SPAN>rule this out by&nbsp;<SPAN class=689272402-14112000>the&nbsp;</SPAN><SPAN class=689272402-14112000>fact that I was able to </SPAN>connect with esql c against this&nbsp;<SPAN class=689272402-14112000>tcp soc</SPAN><SPAN class=689272402-14112000>ket </SPAN>service.</SPAN></FONT></DIV> <DIV><SPAN class=593211006-10112000></SPAN>&nbsp;</DIV> <DIV><SPAN class=593211006-10112000></SPAN>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=593211006-10112000><SPAN class=689272402-14112000>does anyone have any suggestions? I'm baffled...</SPAN></SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=593211006-10112000><SPAN class=689272402-14112000></SPAN></SPAN></FONT>&nbsp;</DIV> <DIV>&nbsp;</DIV> <DIV><FONT color=#0000ff><SPAN class=593211006-10112000></SPAN></FONT><FONT face=Arial size=2>&nbsp;</FONT></DIV></DIV><CODE><FONT SIZE=3><BR> <BR> NOTICE: CONFIDENTIAL COMMUNICATION<BR> This e-mail message and any accompanying files may contain<BR> information that is confidential and subject to privilege. If you<BR> are not the intended recipient, and have received the e-mail<BR> in error, you are notified that any use, dissemination,<BR> distribution, forwarding, printing or copying of the message <BR> and any attached files is strictly prohibited. If you have<BR> received this e-mail message in error please immediately <BR> advise the sender by return e-mail, or telephone, listed below.<BR> You must destroy the original transmission and its contents. <BR> Any views expressed within this communication are those of<BR> the individual sender, except where the sender specifically<BR> states them to be the views of Ramsay Health Care. <BR> This communication should not be copied or disseminated <BR> without permission.<BR> ------------------------------------------------------------------------<BR> </FONT></CODE><CODE><FONT SIZE=3><BR> <BR> "Greenslopes Private Hospital" a member of Ramsay Health Care <BR> Telephone: 61 7 3394 7111<BR> Facsimile: 61 7 3394 7322<BR> </FONT></CODE></BODY></HTML> ------_=_NextPart_001_01C04DE3.EF6718C0--