m.sql2java-generator.1.0.0.source-code.sql2java.properties Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of sql2java-generator Show documentation
Show all versions of sql2java-generator Show documentation
executable jar of sql2java generator
#
# PROPERTIES FILE FOR SQL2JAVA
#
# semicolon-separated list of library directory include extensive tool class
#extension.tools.libdirs=ext_lib
# semicolon-separated classpath include extensive tool class
# ${jdk_tools_jar} representation of $java_home/lib/tools.jar
#extension.tools.classpath=
#______________________________________________
#
# (1/8) CONFIGURE YOUR DATABASE ACCESS
#______________________________________________
jdbc.driver=org.hsqldb.jdbcDriver
jdbc.url=jdbc:hsqldb:hsql://localhost
jdbc.username=sa
jdbc.password=
jdbc.schema=null
#jdbc.driver=com.mysql.jdbc.Driver
#jdbc.url=jdbc:mysql://localhost:3306/tienda
#jdbc.username=root
#jdbc.password=me
#jdbc.schema=tienda
#jdbc.driver=net.sourceforge.jtds.jdbc.Driver
#jdbc.url=jdbc:jtds:sqlserver://est-dv77:1433/proto
#jdbc.username=sql2java
#jdbc.password=sql2java
#jdbc.schema=proto
# you need to provide the classes12.jar
#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
# you need to provide the sapdbc.jar
#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.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.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.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 3 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
#
# 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... :-)
#
#-- IF YOU USE A JDBC 3.0 DRIVER (works with mysql, ORACLE 9, jtds etc..) ------
#generatedkey.retrieve=auto
#generatedkey.statement=
#______________________________________________
#
# (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/main
# Destination for extensive template
#codewriter.destdir.extension=
# package for extensive tempate
#codewriter.package.extension=
# field list which be ignored by bean.converter.utils.java.vm template
#general.beanconverter.tonative.ignore=create_time,update_time
# facebook/swift annotation support for bean
# generate annotation for swift if true
#swift.annotation.bean = true
# swagger annotation support for bean
#swagger.annotation.bean = true
# generate primitive type setter for type which has primitive type
codewriter.bean.primitiveSetter = true
# generate Long setter for Date type
codewriter.bean.dateLongSetter = true
# modified,initialized field type
bitstate.type = int
# byte array mapping can be:
# byte[]
# java.nio.ByteBuffer
# default byte[] if not specialized
#binary.type = java.nio.ByteBuffer
#set properties file name for database
database.properties.env=config_folder
database.properties.isdebug=false
database.properties.dir=resources/conf
database.properties=database.properties
#flag for compatible with axis2
#bean.compatible_axis2=true
# Property file to use when initializing Velocity
#codewriter.velocityprops=somefile
# loading path
velocity.templates.loadingpath=/templates/velocity/includes
# extensive loading path
#velocity.templates.loadingpath.extension=
# folders named pertable will be rendered for each tables
# folders named perschema will be rendered once
velocity.templates=/templates/velocity/
# extensive tempate folder
#velocity.templates.extension =
# 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=
# Whether to generate the default value defined in the database or not
codewriter.generate.defaultvalue=true
#______________________________________________
#
# (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=
# extensive part for bean template (bean.include.vm)
#template.extension.bean=
# 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=java5g cache_guava
# cache_guava: cache implementation base guava
# java5g : general bean & manager templates for java5
#______________________________________________
#
# (6/8) WHAT SHOULD BE DISPLAYED/NOT DISPLAYED ON THE FRONTEND ?
# empty means all fields
#______________________________________________
# 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
© 2015 - 2025 Weber Informatics LLC | Privacy Policy