Re: JDBCR4 - Driver_ConnProp

Ok. It appears to cause by wrong ip being put into the url. Which
makes me wonder why it stucks when wrong ip is provided.

thanks

"hockchai Lim" <lim.hock-chai@xxxxxxxxxxxxxxx> wrote in message
news:<mailman.659.1251927276.1811.rpg400-l@xxxxxxxxxxxx>...

I'm having problem using JDBCR4 to connect to Oracle database and

hopefully

someone can help me with it. The problem I'm having is that the

process

seems to be stuck when my program calls the JDBC_ConnProp to get the
connection.
I debug, I see that JDBC_ConnProp ==calls==> Driver_ConnProp

==calls==>

CallConnectMethod. CallConnectMethod seems to be where it is stuck

at.

Has anyone has similar problem?

Below is what my code looks like:

********************************************************************

* connect to the MyAccount Database

********************************************************************

P setMyAcctDBConn...
P B

D myReply s 1
D myUID s 90 varying
D myPwd s 90 varying
D myJDBCDriver s 255 varying
D myURL s 255 varying
D myConnProp s like(properties)

/free

dow @ENDLESSLOOP;

myConnProp = JDBC_Properties();

exsr setMyConnProp;

myAcctDBConn = JDBC_ConnProp(myJDBCDriver :myURL

:myConnProp);

JDBC_freeProp(myConnProp);

exsr returnToCallerIfOK;

enddo;

//********************************************************
// set connection properties
//********************************************************
begsr setMyConnProp;

myUID = %trim(refGetCFG(@pgmNm :systemName :'UID'));
myPWD = %trim(refGetCFG(@pgmNm :systemName :'PWD'));
myJDBCDriver = %trim(refGetCFG(@pgmNm :systemName :'DRV'));
myURL = %trim(refGetCFG(@pgmNm :systemName :'URL'));

JDBC_setProp(myConnProp: 'user' :%trim(myUID) );
JDBC_setProp(myConnProp: 'password' :%trim(myPWD) );


endsr;
. . . .