Unix Technical Forum

StaticSQL

This is a discussion on StaticSQL within the DB2 forums, part of the Database Server Software category; --> DB2 Version 7.1 and 8.X, Static SQL, SQLJ, BIND FILES Until now, in DB2 Version 7.1, I could use ...


Go Back   Unix Technical Forum > Database Server Software > DB2

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-26-2008, 10:00 AM
Michael Saladin
 
Posts: n/a
Default StaticSQL

DB2 Version 7.1 and 8.X, Static SQL, SQLJ, BIND FILES

Until now, in DB2 Version 7.1, I could use the following steps to
develop applications with static sql in Java:

1) SQLJ source files
2) JAVAC source files
3) db2profc with -prepoptions "bindfile using filename.bnd"

After these steps, I could create a JAR file with the .ser-file and
the classes and put those files onto the production server.
Afterwards, I could take the bind file filename.bnd onto the
production server and bind the new bindings. Every night, I could
rebind the filename.bnd file.

In DB2 UDB 8.X, I still have the command db2profc, but the command
line option -prepoptions is no longer available. In the DB2
documentation, I don't see any way to generate a bind file with
db2profc. I don't want to bind the packages automatically after
compiling. I want to make a clean deployment process with:

1) JAR-FILE (including .ser)
2) BIND-FILE

To deploy, I want to bind the BIND-FILE and afterwards I want to be
able to use the JAR-FILE. Is this no longer possible?

I found the DB2-command: PREP filename BINDFILE, but this seems not to
work with ".ser" file, only with C++ or Fortran files.

Any help would be greatly appreciated.
Michael Saladin
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-26-2008, 10:02 AM
Michael Saladin
 
Posts: n/a
Default Re: StaticSQL

I found it out: IBM has created new JBDC drivers for 8.1 (see IBM
paper http://www-3.ibm.com/software/data/pubs/papers/sqlj/).

So I have to go back to 7.2 on my development-machine. It's a pity.

Cheers
Michael Saladin
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:51 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com