tag:blogger.com,1999:blog-34020393.post1310486893380897486..comments2024-03-27T10:59:38.307-07:00Comments on Jim's PeopleSoft Journal: Accessing the PeopleSoft Database in JavaJim Marionhttp://www.blogger.com/profile/12995110203807924786noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-34020393.post-58962200103059883372013-08-07T20:45:32.192-07:002013-08-07T20:45:32.192-07:00@Rakesh, absolutely. There are a couple of ways. T...@Rakesh, absolutely. There are a couple of ways. The easiest and most common is at the database level using DB links (or whatever your database platform supports). Other options include using JDBC (as documented <a href="http://jjmpsj.blogspot.com/2009/03/using-oracle-jdbc-from-peoplecode.html" rel="nofollow">here</a>), web services, etc.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-22005691543535844532013-08-07T20:30:51.051-07:002013-08-07T20:30:51.051-07:00Is there a way to access non-peoplesoft Database f...Is there a way to access non-peoplesoft Database from a PeoplSoft page? May be a SQL View connecting tables from a different DB?<br />Anonymoushttps://www.blogger.com/profile/13317330258047487174noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-47892548920786187262012-02-08T18:00:05.367-08:002012-02-08T18:00:05.367-08:00@Linne, yes, absolutely! Replace
String[] result...@Linne, yes, absolutely! Replace<br /><br /> String[] result = new String[10];<br /><br />With<br /><br />ArrayList<String> result = new ArrayList<String>();<br /><br />And<br /><br /> result[row++] = (String)descr[0];<br /><br />With<br /><br /> result.add((String)descr[0]);Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-86104435908619433312012-02-08T02:10:38.357-08:002012-02-08T02:10:38.357-08:00Hi Jim,
I read your book about 'Using SQL Obj...Hi Jim, <br />I read your book about 'Using SQL Objects', for the example 'FirstTenOperateors', the array is initialised to 10, i wonder if any possible using Arraylist (likes resultSet)<br /><br />Thanks a lot!<br />LineLinnehttps://www.blogger.com/profile/16076097155504818576noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-41390294271801803212008-08-13T11:40:00.000-07:002008-08-13T11:40:00.000-07:00A PeopleSoft Java book... that is a good idea.As f...A PeopleSoft Java book... that is a good idea.<BR/><BR/>As for the process scheduler setup, etc... if you want to use the PeopleCode data objects to access the PeopleSoft database from Java within the process scheduler, then you will need to run your Java from an AppEngine PeopleCode step using the GetJavaClass or CreateJavaObject functions. Therefore, there is no process scheduler server setup. From the process scheduler's perspective, you are just running a regular AppEngine.<BR/><BR/>I started looking at using the PeopleCode data objects for the same reason you specify, I wanted to write my batch programs in Java, not AE, SQR, or Cobol. I wanted to use something that would be supported by fusion apps. I actually wrote a database access abstraction layer containing two implementations, a JDBC implementation and a PeopleCode implementation. Using a <A HREF="http://martinfowler.com/articles/injection.html" REL="nofollow">dependency/IoC</A> framework like <A HREF="http://code.google.com/p/google-guice/" REL="nofollow">Guice</A>, <A HREF="http://www.springframework.org/" REL="nofollow">Spring</A>, or <A HREF="http://www.picocontainer.org/" REL="nofollow">PicoContainer</A>, it was actually possible for me to run the same code from the app server using the PS database session and from the command line.<BR/><BR/>I should write up a complete example showing the AppEngine steps, etc. Thanks for the idea!<BR/><BR/>By the way, nice last name ;)Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-67468128656874532902008-08-13T07:38:00.000-07:002008-08-13T07:38:00.000-07:00Hi Jim,I have developed several file extracts from...Hi Jim,<BR/><BR/>I have developed several file extracts from PeopleSoft H/R tables using Java, SQL and JDBC. They generate .txt files which are then FTP-ed to a local server for PGP encryption and FTPing out to health care benefit carriers. These processes run completely outside of PeopleSoft. While it is working flowlessly, it does require a MS-SQL Sever user id and password, something we would like to avoid. For now, it is using trusted connection which is enough for our security administrator, since programmers do need to have a production userid/password. I also had the issue of scheduling the job, for which I ended up using MS-SQL Server, but no log/visibility to operations.<BR/><BR/>I wonder if you could expand on this topic by providing a complete Java example including the set up on the Process Scheduler. In general, I would like to program in Java what I used to do in SQR.<BR/><BR/>We really need a book on Java-PeopleSoft integration. If you ever decide to write one, please count me in as volunteer for reviewing and testing code.<BR/><BR/>Thank you,<BR/><BR/>Luis<BR/>http://www.mariontech.comLuis Marionhttps://www.blogger.com/profile/09741882792308107326noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-28291462201505244532007-06-06T16:10:00.000-07:002007-06-06T16:10:00.000-07:00Nice post Jim. I agree that the Pbooks doc on thi...Nice post Jim. I agree that the Pbooks doc on this topic sucks. I'm glad you posted this.<BR/><BR/>RichRichhttps://www.blogger.com/profile/06704140698593086124noreply@blogger.com