Auto-generating SQLJ source code

Has anyone out here tried auto-generating sqlj source code , from oracle pl/sql packages or procedure开发者_开发知识库s ?

You can use JPublisher to automatically generate java classes for sqlj based on Oracle PL/SQL stored procedures. Below is the setup I typically use, you might want to experiment with *types flags (setting them either to oracle or jdbc).

sqlj/bin/jpub --user db_user -case=mixed -compile=false -omit_schema_names -sql=package_name -usertypes=oracle -numbertypes=jdbc -lobtypes=oracle -builtintypes-jdb -package=namespace -plsql-file=package_name_wrapper.sql,package_name_dropper.sql -plsqlpackage=package_name_jpubwrapper