# $Id: sql2java.properties,v 1.55 2007/09/10 13:51:22 kameleono Exp $ # # PROPERTIES FILE FOR SQL2JAVA # #______________________________________________ # # (1/8) CONFIGURE YOUR DATABASE ACCESS #______________________________________________ jdbc.type=hsql jdbc.driver=org.hsqldb.jdbcDriver jdbc.url=jdbc:hsqldb:hsql://localhost jdbc.username=sa jdbc.password= jdbc.schema=null #jdbc.type=mysql #jdbc.driver=com.mysql.jdbc.Driver #jdbc.url=jdbc:mysql://localhost:3306/tienda #jdbc.username=root #jdbc.password=me #jdbc.schema=tienda # you need to provide the classes12.jar #jdbc.type=oracle #jdbc.driver=oracle.jdbc.driver.OracleDriver #jdbc.url=jdbc:oracle:thin:@10.110.206.152:1521:educacio #jdbc.username=e13_poe #jdbc.password=313p03 #jdbc.schema=E13_POE #retrieving remarks on oracle is very long ... do you need it right now ? #jdbc.oracle.retrieve.remarks=false # you need to provide the sapdbc.jar #jdbc.type=oracle #jdbc.driver=com.sap.dbtech.jdbc.DriverSapDB #jdbc.url=jdbc:sapdb://CMABCN1:7210/SIGMA?sqlmode=ORACLE #jdbc.username=SIGMAOWN #jdbc.password=SIGOWN01 #jdbc.schema=SIGMAOWN # - with DB2 Universal JDBC Driver # you need to get db2jcc.jar and db2jcc_license_cu.jar in sql2java's classpath # - By: peddu (pavanpeddu) - 2006-02-02 16:47 #jdbc.type=db2 #jdbc.driver=com.ibm.db2.jcc.DB2Driver #jdbc.url=jdbc:db2: #jdbc.username= #jdbc.password= #jdbc.schema= # - jars needed: derby.jar, derbyclient.jar, derbytools.jar, derbynet.jar # (the requirements may be different for network or embedded use) # the and must be set to can log into the database #jdbc.type=derby #jdbc.driver=org.apache.derby.jdbc.ClientDriver #jdbc.url=jdbc:derby://:/ #jdbc.username= #jdbc.password= #jdbc.schema=APP # if you let the 'jdbc.schema' propery blank you would not get any class generated # you need to provide the postgresql-8.x-xxx.jdbc3.jar #jdbc.type=postgresql #jdbc.driver=org.postgresql.Driver #jdbc.url=jdbc:postgresql://localhost:5432/sql2java #jdbc.username=postgres #jdbc.password=postgres #jdbc.schema=public #______________________________________________ # # (2/8) CONFIGURE RETRIEVAL OF AUTO GENERATED KEY #______________________________________________ # For those who do not want to read below, please simply pick up the # configuration associated with your database. # # More explanation: # When you save a bean whose primary key is numeric and has no value set, # we assume that you want sql2java to retrieve a key's value generated # on the database side. # # generatedkey.retrieve can take 4 values: # # auto - the standard approach when you have a JDBC 3.0 driver. # # before - the key's value is retrieved before inserting the record. # # after - the key's value is retrieved after inserting the record # # none - the key's value is never retrieved, frankly I doubt you # want this configuration # # If you set it to before or after you also need to configure the # autogeneratedkey.statement properties. # is replaced at code generation time by the table name. # is replaced at code generation time by the column name. # You may adjust this properties to fit your own naming convention. # # PICK THE CONFIGURATION ASSOCIATED WITH YOUR DATABASE # (or create one, but in that case let us know so we can add it here... :-) # #-- HSQL ------ generatedkey.retrieve=after generatedkey.statement=CALL IDENTITY() # #-- ORACLE 8i ------ #generatedkey.retrieve=before #generatedkey.statement=SELECT SEQ_
.nextval FROM DUAL # #-- MaxDB (SapDB) ------ #generatedkey.retrieve=before #generatedkey.statement=SELECT SEQ_
_.nextval FROM DUAL # #-- IF YOU USE A JDBC 3.0 DRIVER (works with mysql, ORACLE 9, etc..) ------ #generatedkey.retrieve=auto #generatedkey.statement= # #-- MYSQL (without jdbc 3.0 driver) ------ #generatedkey.retrieve=after #generatedkey.statement=SELECT last_insert_id() # #-- SQL SERVER, SYBASE ------ #generatedkey.retrieve=after #generatedkey.statement=SELECT @@IDENTITY # #-- POSTGRESQL ------ #generatedkey.retrieve=before #generatedkey.statement=SELECT nextval('
__SEQ') # #-- INFORMIX ------ #generatedkey.retrieve=after #generatedkey.statement=SELECT dbinfo('sqlca.sqlerrd1') FROM systables WHERE tabid=1 # #-- FIREBIRD ------ # - need to create "sequence" number table first "create generator SEQ_
" # - the 1 is how much to increment the sequence #generatedkey.retrieve=before #generatedkey.statement=SELECT GEN_ID(SEQ_
, 1) FROM RDB$DATABASE # #-- DB2 ------ #generatedkey.retrieve=auto # #-- DERBY ------ #generatedkey.retrieve=after #generatedkey.statement=VALUES IDENTITY_VAL_LOCAL() #______________________________________________ # # (3/8) GENERATED SOURCE CODE #______________________________________________ # Package name for the generated source code codewriter.package=org.acme.sample # Destination of the generated source code (package hierarchy is preserved) codewriter.destdir=src/ # Property file to use when initializing Velocity #codewriter.velocityprops=somefile # loading path velocity.templates.loadingpath=.;src/templates/velocity/includes # folders named pertable will be rendered for each tables # folders named perschema will be rendered once velocity.templates=src/templates/velocity/ # static files static.templates=src/templates/static # sets a prefix to prepend to all generated classes # useful if you are worried about namespace collision with reserved words # or java.lang classes codewriter.classprefix= #______________________________________________ # # (4/8) FILTER OUT CERTAIN TABLES #______________________________________________ # # COMMA SEPARATED list of table types to be mapped # Commonly seen types are TABLE, VIEW, SYSTEM TABLE, SYNONYM jdbc.tabletypes=TABLE, VIEW # Table name pattern of tables to be mapped to classes. # available wildcard: % # defaults to % # You can specify several patterns separated by commas. jdbc.tablenamepattern=% # SPACE SEPARATED list of tables to include or exclude. If you specify both, # the include list will take priority. If these fields are left commented out, # all tables in the specified schema will get mapped to classes tables.include= tables.exclude= # SPACE SEPARATED list of templates to include or exclude. If you specify both, # the include list will take priority. If these fields are left commented out, # all templates in the selected folders will get generated template.file.exclude= template.file.include= # SPACE SEPARATED list of templates folders to include or exclude. If you specify both, # the include list will take priority. If these fields are left commented out, # all folders will get selected template.folder.exclude= template.folder.include=java cache factory db #______________________________________________ # # (5/8) ORGANISE YOUR SUBPACKAGES #______________________________________________ subpackage.1.name=users subpackage.1.tables=signon profile account supplier subpackage.2.name=catalog subpackage.2.tables=product category item inventory subpackage.3.name=order subpackage.3.tables=lineitem orders orderstatus subpackage.4.name=utils subpackage.4.tables=sequence bannerdata #______________________________________________ # # (6/8) WHAT SHOULD BE DISPLAYED/NOT DISPLAYED ON THE FRONTEND ? # empty means all fiels #______________________________________________ # that section was intented for some feature that never went on stage #table.product.in.list.exclude=product_insertiondate, product_description #table.product.in.display.exclude=product_id, product_insertiondate #table.product.in.form.exclude=product_id, product_insertiondate #table.product.in.searchform.exclude=product_id, product_insertiondate #table.manufacturer.in.list.exclude=manufacturer_description #table.manufacturer.in.display.exclude=manufacturer_id #table.manufacturer.in.form.exclude=manufacturer_id #table.manufacturer.in.searchform.include=manufacturer_description #table.customer.in.searchform.exclude=customer_name, customer_description #table.delivery.in.searchform.include=product_id, customer_id #______________________________________________ # # (7/8) JDBC TYPES Mapping #______________________________________________ # # jdbc DATE mapping can be: # java.sql.Date # java.util.Date jdbc2java.date=java.util.Date # jdbc TIME mapping can be: # java.sql.Time # java.util.Date jdbc2java.time=java.util.Date # jdbc TIMESTAMP mapping can be: # java.sql.Timestamp # java.util.Date jdbc2java.timestamp=java.util.Date #______________________________________________ # # (8/8) CONFIGURE OPTIMISTIC LOCK #______________________________________________ # optimisticlock.type can take 2 values: # none - the optimistic lock mechanism is disabled (default). # timestamp - the optimistic lock column contains the System.currentTimeMillis() value. # # optimisticlock.column takes the column name used by optimistic lock mechanism in your database. # If this column is not present in some table the optimistic lock is not applied there. # the column mapping can be java.lang.Long or java.lang.String. # (jdbc type size >= 13 characters) optimisticlock.type=timestamp optimisticlock.column=version_time