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 ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| ||||
| 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 |