You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Database login ?

5 replies [Last post]
Guest's picture
Guest

Hi all i am writing a peoplecode for my application. Here i need to Use PeopleCode to login to the source and target database(my local db's), issue error message if login to either of the databases fails. How to login to the db using pplcode ?

pls help !

Lepa's picture
User offline. Last seen 2 years 6 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Database login ?

Quote:
How to login to the db using pplcode ?

I would take a look at functions used by PeopleSoft. They are located in record FUNCLIB_LDAP

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Lepa's picture
User offline. Last seen 2 years 6 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Database login ?

Look at utilizing java to achieve database connection. I have done a peoplesoft database connection from a jsp page using Java, the same concept can be used with Peoplecode.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

yopym's picture
User offline. Last seen 10 years 47 weeks ago. Offline
Joined: 07/01/2008
Posts: 3
Re: Database login ?

Do you wanna connect directly to db from PeopleCode? or do you need to use either Java or another language to connect to db?

If the answer for the first question is yes, so you should use PeopleCode and Buffer Objects. If the second, so you can connect to db like another language, it only needs a user and pass with permissions on db.

An intermediate solution is invoke JDBC classes from PeopleCode.

Sorry for my English.

Lepa's picture
User offline. Last seen 2 years 6 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Database login ?

Quote:
Sorry for my English.

Not sure what you are talking about yopym, your English is fabulous! :)

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Guest's picture
Guest (not verified)
Re: Database login ?

Can you please elaborate both the steps any step wud be fine for me ......like how to login with peoplecode & JDBC ? I have no idea regarding it....so please make me started !