I have to generate PL/SQL using Java. Most of the procedures are common. Only a few keeps changing.

Posted by blog on Stack Overflow See other posts from Stack Overflow or by blog
Published on 2009-11-13T06:53:52Z Indexed on 2010/06/17 7:33 UTC
Read the original article Hit count: 200

Filed under:

java

|

design-patterns

|

templates

|

plsql

I have to generate PL-SQL code, with some common code(invariable) and a variable code. I don't want to use any external tools.

Some ways that I can think:

Can I go and maintain the common code in a template and with markers, where my java code will generate code in the markers and generate a new file.
Maintain the common code in static constant String and then generate the whole code in StringBuffer and at last write to file.

But, I am not at all satisfied with both the ideas. Can you please suggest any better ways of doing this or the use of any design patterns or anything?

Thanks in Advance.

© Stack Overflow or respective owner

Related posts about java

Tomcat 6: Access Control Exception?

as seen on Server Fault - Search for 'Server Fault'
I'm trying to setup a tomcat6 server, and I'm trying to match another setup someone else established. However, my deployment (default Ubuntu install) uses a policy.d/ directory structure, and the established server just uses a catalina.policy file. I've tried setting every entry in policy.d to match… >>> More
Problem in creation MDB Queue connection at Jboss StartUp

as seen on Stack Overflow - Search for 'Stack Overflow'
I am not able to create a Queue connection in JBOSS4.2.3GA Version & Java1.5, as I am using MDB as per the below details. I am putting this MDB in a jar file(named utsJar.jar) and copied it in deploy folder of JBOSS, In the test env. this MDB works well but in another env. [ env settings and… >>> More
failing to establish connection between Postgres db and gwt

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am using Postgres and gwt 2.0 for one of my applications. I am facing problem connecting to the database. When I try to connect it gives "ClassNotFoundException". Here is what I get when I try to connect to database: java.lang.ClassNotFoundException: org.postgresql.Driver at java.net… >>> More
failing to establish connection between postgre db and gwt

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, For i am using postgre and gwt 2.0 for one of my applications. I am facing problem connecting to the database. When i try to connect it gives "ClassNotFoundException". Here is what i get when i try to connect to database: java.lang.ClassNotFoundException: org.postgresql.Driver at java.net… >>> More
Migration and deployement problems JBoss 4.2.2.GA to JBoss 6.0.0.M2

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm trying to migrate an application running on JBoss 4.2.2.GA to JBoss 6.0.0.M2 I give you some log to explain my problem : boot.log : 2010-03-16 09:59:29,406 ERROR [org.jboss.system.server.profileservice.ProfileServiceBootstrap] (Thread-2) Failed to load profile: Summary of incomplete deployments… >>> More

Related posts about design-patterns

Should universities put more emphasis on teaching their students about design patterns?

as seen on Programmers - Search for 'Programmers'
While I've heard about design patterns being mentioned in a few courses at uni, I know of only a single course which actually teaches design patterns. In almost all other areas (algorithms, parallelism, architecture, dynamic languages, paradigms, etc), there are several, often a basic course and an… >>> More
Podcasts on GoF design patterns

as seen on Stack Overflow - Search for 'Stack Overflow'
Anyone know of a good podcast on design patterns? >>> More
How often are design patterns used in the workplace using PHP

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey everyone, I read a book awhile back called PHP Design Patterns and Practice, and ever since then I have been using design patterns whenever I think they are needed. However it just occurred to me that maybe most companies do not use design patterns very often for PHP, or at all. What I was wondering… >>> More
Who benefits from the use of Design Patterns?

as seen on DotNetBlocks - Search for 'DotNetBlocks'
Who benefits from the use of design patterns is like asking who benefits from clean air or a good education. All of the stakeholders of a project benefit from the use of design patterns. Project Sponsor Project sponsors benefit from the use of design patterns because they promote reduced development… >>> More
Architect: "Collaborating on Design Patterns"

as seen on Oracle Technology Network - Search for 'Oracle Technology Network'
It takes an architect community to raise a collection of SOA design patterns. >>> More