• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

References to a function (UDF) in SQL Server

 
Ranch Hand
Posts: 102
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello,
I am working on a project which is currently heavily db based and I want to pull out some of the processing from DB side to the Java side. I am trying to understand as to how should I start the work. I am planning to first start identify UDF (user defined function ) which are there in the db and move the logic to Java side if possible.
However I need to also correct the dependent object (which use these UDFs). Is there a way to identify where and all a UDF is getting used (something similar to reference menu in Eclipse) . I am using SQL server for my work.

Regards,
 
Rancher
Posts: 989
9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I don't see why you need to. If a function called another function then you need to replace the calling function first unless if you are suggesting that you want to be calling the Java layer solution from the SQL functions?
 
nitinram agarwal
Ranch Hand
Posts: 102
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have no intention to call the Java layer from Sqls. The idea is to move the business logic away from db side. For this, I am trying to pick up those units which can be migrated easily. A UDF and references to it , is the first point I want to start with. For example, if a UDF is called from 2 pl-sql routine and the logic in UDF can be replaced by Java code then modify the pl-sql routine so as to remove the reference to UDF and do some application rewrite on Java (kind of util ) which mimics the behavior of UDF. As a second stage , check if we can replace pl-sql routine with Java code. Please let me know if you need any other details.
reply
    Bookmark Topic Watch Topic
  • New Topic