All Downloads are FREE. Search and download functionalities are using the official Maven repository.

m.sql2java-generator.3.31.0.source-code.sql2java.properties Maven / Gradle / Ivy

#
# PROPERTIES FILE FOR SQL2JAVA
#

# alias of manager instance which connect database
#manager.alias=

# 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=gu.sql2java.demo

# 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 
# jackson annotation support for bean
#jackson.annotation.bean = true
# generate codegen annotation  if true
#codegen.annotation.bean = true 
#generate @ExcelSheet,@ExcelColumn annotation if true
#excel.annotation.bean = true  
#generate @SchemaComponent,@SchemaConstantSupplier annotation if true
#constant.annotation = 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
# JSON Serialize Type for Date type can be:
# Long system time milliseconds
# String ISO8601 date time format string
# used when swift or jackson annotation enable
codewriter.bean.dateSerializeType = Long
# date format while dateSerializeType is String,default ISO8601 format
codewriter.bean.dateStringFormat=yyyy-MM-dd'T'HH:mm:ss.SSSZ
# getter/setter method type of Geometry data filed can be:
#  STRING ---- WKT String
#  JTS      ---- JTS Class com.vividsolutions.jts.geom.Geometry
codewrite.bean.geometry.serial.type=STRING
# package of bean super class
# if not empty,the super class of bean is $package.$beanClass 
# otherwise :gu.sql2java.BaseRow
codewrite.bean.superClassPackage=
# table name of bean super class
codewrite.bean.superClassTables=
# same prefix of super class tables
codewrite.bean.samePrefixOfSuperClassTables=
# modified,initialized field type
bitstate.type = int

# byte array mapping can be:
#  byte[]
#  java.nio.ByteBuffer
# default byte[] if not specialized
#binary.type = byte[]
#binary.ByteBuffer.asString=false

# add @JsonRawValue @JsonDeserialize annotation for JSON field 
#json.jackson.rawvalue = false
# add @JsonDeserialize annotation for defining jackson JSON deserializer of  Class 
json.jackson.class.deserializer = true
# add @JSONType annotation for defining fastjson JSON deserializer of  Class 
json.fastjson.class.deserializer = true

#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

# invalid value of number type
#invalidvalue.number=-1
# invalid value of date type
#invalidvalue.number=0
# size threshold for prealloc of String 
prealloc.string.limit=128
# size threshold for prealloc of binary 
prealloc.binary.limit=128


# 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=%
# force use ${jdbc.tablenamepattern} prefix as same prefix if  ${jdbc.tablenamepattern} not %
jdbc.tablenamepattern.force=false

# 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   
# 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