You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-dev@db.apache.org by ma...@apache.org on 2003/02/04 23:42:45 UTC

cvs commit: db-ojb/profile mssqldb-ms.profile mssqldb-JSQLConnect.profile mssqldb.profile mssqldb-JNet.profile

mattbaird    2003/02/04 14:42:45

  Modified:    profile  mssqldb.profile
  Added:       profile  mssqldb-ms.profile mssqldb-JSQLConnect.profile
  Removed:     profile  mssqldb-JNet.profile
  Log:
  changes to platform stuff for MSSQL Server
  
  Revision  Changes    Path
  1.3       +136 -136  db-ojb/profile/mssqldb.profile
  
  Index: mssqldb.profile
  ===================================================================
  RCS file: /home/cvs/db-ojb/profile/mssqldb.profile,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- mssqldb.profile	13 Oct 2002 10:11:40 -0000	1.2
  +++ mssqldb.profile	4 Feb 2003 22:42:45 -0000	1.3
  @@ -1,136 +1,136 @@
  -# location of jar that you will be using for testing
  -# so that it can be copied into the dist/lib directory.
  -
  -torque.testDatabaseJar = ${lib.repo}/hsqldb.jar
  -torque.idMethod = idbroker
  -torque.defaultDatabase = OJB
  -
  -# -------------------------------------------------------------------
  -#
  -# T O R Q U E  C O N F I G U R A T I O N  F I L E
  -#
  -# -------------------------------------------------------------------
  -
  -project = ojbtest
  -
  -# -------------------------------------------------------------------
  -#
  -#  T A R G E T  D A T A B A S E
  -#
  -# -------------------------------------------------------------------
  -
  -database=mssql
  -database.manual.creation = true
  -
  -# -------------------------------------------------------------------
  -#
  -#  O B J E C T  M O D E L  I N F O R M A T I O N
  -#
  -# -------------------------------------------------------------------
  -# These settings will allow you to customize the way your
  -# Peer-based object model is created.
  -# -------------------------------------------------------------------
  -# addSaveMethod=true adds tracking code to determine how to save objects
  -#
  -# addGetByNameMethod=true adds methods to get fields by name/position
  -#
  -# complexObjectModel=true generates an om with collection support
  -#
  -# addTimeStamp=true puts time stamps in generated files
  -#
  -# addIntakeRetrievable=implement Intake's Retrievable interface
  -# -------------------------------------------------------------------
  -
  -targetPackage=org.apache.torque.test
  -basePrefix=Base
  -addSaveMethod=true
  -addGetByNameMethod=true
  -complexObjectModel=true
  -addTimeStamp=true
  -addIntakeRetrievable=false
  -useManagers=true
  -
  -# -------------------------------------------------------------------
  -#
  -#  D A T A B A S E  S E T T I N G S
  -#
  -# -------------------------------------------------------------------
  -# JDBC connection settings. This is used by the JDBCToXML task that
  -# will create an XML database schema from JDBC metadata. These
  -# settings are also used by the SQL Ant task to initialize your
  -# Turbine system with the generated SQL.
  -# -------------------------------------------------------------------
  -
  -dbmsName = MsSQLServer
  -databaseHost = localhost:1433
  -jdbcLevel = 2.0
  -urlProtocol = jdbc
  -urlSubprotocol = microsoft:sqlserver
  -databaseUser = sa
  -databasePassword = ce
  -urlDbalias = //localhost:1433;DatabaseName=OJB;SelectMethod=cursor;User=${databaseUser};Password=${databasePassword};
  -
  -#jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=OJB;SelectMethod=cursor;User=bill;Password=gates;
  -
  -createDatabaseUrl = ${urlProtocol}:${urlSubprotocol}:${urlDbalias}
  -buildDatabaseUrl = ${urlProtocol}:${urlSubprotocol}:${urlDbalias}
  -databaseUrl = ${urlProtocol}:${urlSubprotocol}:${urlDbalias}
  -databaseDriver = com.microsoft.jdbc.sqlserver.SQLServerDriver
  -
  -
  -# Tells JDBC task that javaName attribute for the tables and columns
  -# should be made same as SQL name.
  -sameJavaName=false
  -
  -# -------------------------------------------------------------------
  -#
  -#  D O C U M E N T A T I O N   S E T T I N G S
  -#
  -# -------------------------------------------------------------------
  -# These settings will allow you to customize the way your schema
  -# documentation is created.
  -# Valid formats are: html, anakia (for use with jakarta-site2)
  -# -------------------------------------------------------------------
  -documentationFormat=html
  -
  -# -------------------------------------------------------------------
  -# You should NOT have to edit anything below here.
  -# -------------------------------------------------------------------
  -
  -# -------------------------------------------------------------------
  -#
  -#  T E M P L A T E  P A T H
  -#
  -# -------------------------------------------------------------------
  -
  -templatePath = ../templates
  -
  -# -------------------------------------------------------------------
  -#
  -#  C O N T R O L  T E M P L A T E S
  -#
  -# -------------------------------------------------------------------
  -
  -SQLControlTemplate = sql/base/Control.vm
  -OMControlTemplate = om/Control.vm
  -idTableControlTemplate = sql/id-table/Control.vm
  -DataDTDControlTemplate = data/Control.vm
  -DataDumpControlTemplate = data/dump/Control.vm
  -DataSQLControlTemplate = sql/load/Control.vm
  -DocControlTemplate = doc/Control.vm
  -
  -# -------------------------------------------------------------------
  -#
  -#  O U T P U T  D I R E C T O R Y
  -#
  -# -------------------------------------------------------------------
  -
  -outputDirectory=src
  -
  -# -------------------------------------------------------------------
  -#
  -#  S C H E M A  D I R E C T O R Y
  -#
  -# -------------------------------------------------------------------
  -
  -schemaDirectory=schema
  +# location of jar that you will be using for testing
  +# so that it can be copied into the dist/lib directory.
  +
  +torque.testDatabaseJar = ${lib.repo}/hsqldb.jar
  +torque.idMethod = idbroker
  +torque.defaultDatabase = OJB
  +
  +# -------------------------------------------------------------------
  +#
  +# T O R Q U E  C O N F I G U R A T I O N  F I L E
  +#
  +# -------------------------------------------------------------------
  +
  +project = ojbtest
  +
  +# -------------------------------------------------------------------
  +#
  +#  T A R G E T  D A T A B A S E
  +#
  +# -------------------------------------------------------------------
  +
  +database=mssql
  +database.manual.creation = true
  +
  +# -------------------------------------------------------------------
  +#
  +#  O B J E C T  M O D E L  I N F O R M A T I O N
  +#
  +# -------------------------------------------------------------------
  +# These settings will allow you to customize the way your
  +# Peer-based object model is created.
  +# -------------------------------------------------------------------
  +# addSaveMethod=true adds tracking code to determine how to save objects
  +#
  +# addGetByNameMethod=true adds methods to get fields by name/position
  +#
  +# complexObjectModel=true generates an om with collection support
  +#
  +# addTimeStamp=true puts time stamps in generated files
  +#
  +# addIntakeRetrievable=implement Intake's Retrievable interface
  +# -------------------------------------------------------------------
  +
  +targetPackage=org.apache.torque.test
  +basePrefix=Base
  +addSaveMethod=true
  +addGetByNameMethod=true
  +complexObjectModel=true
  +addTimeStamp=true
  +addIntakeRetrievable=false
  +useManagers=true
  +
  +# -------------------------------------------------------------------
  +#
  +#  D A T A B A S E  S E T T I N G S
  +#
  +# -------------------------------------------------------------------
  +# JDBC connection settings. This is used by the JDBCToXML task that
  +# will create an XML database schema from JDBC metadata. These
  +# settings are also used by the SQL Ant task to initialize your
  +# Turbine system with the generated SQL.
  +# -------------------------------------------------------------------
  +
  +dbmsName = MsSQLServer
  +databaseHost = localhost:1433
  +jdbcLevel = 2.0
  +urlProtocol = jdbc
  +urlSubprotocol = JSQLConnect
  +databaseUser = sa
  +databasePassword = motiva
  +urlDbalias = //localhost/database=OJB/user=${databaseUser}/password=${databasePassword}
  +
  +#jdbc:JSQLConnect://ServerName:port/opt=value/opt=value
  +
  +createDatabaseUrl = ${urlProtocol}:${urlSubprotocol}:${urlDbalias}
  +buildDatabaseUrl = ${urlProtocol}:${urlSubprotocol}:${urlDbalias}
  +databaseUrl = ${urlProtocol}:${urlSubprotocol}:${urlDbalias}
  +databaseDriver = com.jnetdirect.jsql.JSQLDriver
  +
  +
  +# Tells JDBC task that javaName attribute for the tables and columns
  +# should be made same as SQL name.
  +sameJavaName=false
  +
  +# -------------------------------------------------------------------
  +#
  +#  D O C U M E N T A T I O N   S E T T I N G S
  +#
  +# -------------------------------------------------------------------
  +# These settings will allow you to customize the way your schema
  +# documentation is created.
  +# Valid formats are: html, anakia (for use with jakarta-site2)
  +# -------------------------------------------------------------------
  +documentationFormat=html
  +
  +# -------------------------------------------------------------------
  +# You should NOT have to edit anything below here.
  +# -------------------------------------------------------------------
  +
  +# -------------------------------------------------------------------
  +#
  +#  T E M P L A T E  P A T H
  +#
  +# -------------------------------------------------------------------
  +
  +templatePath = ../templates
  +
  +# -------------------------------------------------------------------
  +#
  +#  C O N T R O L  T E M P L A T E S
  +#
  +# -------------------------------------------------------------------
  +
  +SQLControlTemplate = sql/base/Control.vm
  +OMControlTemplate = om/Control.vm
  +idTableControlTemplate = sql/id-table/Control.vm
  +DataDTDControlTemplate = data/Control.vm
  +DataDumpControlTemplate = data/dump/Control.vm
  +DataSQLControlTemplate = sql/load/Control.vm
  +DocControlTemplate = doc/Control.vm
  +
  +# -------------------------------------------------------------------
  +#
  +#  O U T P U T  D I R E C T O R Y
  +#
  +# -------------------------------------------------------------------
  +
  +outputDirectory=src
  +
  +# -------------------------------------------------------------------
  +#
  +#  S C H E M A  D I R E C T O R Y
  +#
  +# -------------------------------------------------------------------
  +
  +schemaDirectory=schema
  
  
  
  1.1                  db-ojb/profile/mssqldb-ms.profile
  
  Index: mssqldb-ms.profile
  ===================================================================
  # location of jar that you will be using for testing
  # so that it can be copied into the dist/lib directory.
  
  torque.testDatabaseJar = ${lib.repo}/hsqldb.jar
  torque.idMethod = idbroker
  torque.defaultDatabase = OJB
  
  # -------------------------------------------------------------------
  #
  # T O R Q U E  C O N F I G U R A T I O N  F I L E
  #
  # -------------------------------------------------------------------
  
  project = ojbtest
  
  # -------------------------------------------------------------------
  #
  #  T A R G E T  D A T A B A S E
  #
  # -------------------------------------------------------------------
  
  database=mssql
  database.manual.creation = true
  
  # -------------------------------------------------------------------
  #
  #  O B J E C T  M O D E L  I N F O R M A T I O N
  #
  # -------------------------------------------------------------------
  # These settings will allow you to customize the way your
  # Peer-based object model is created.
  # -------------------------------------------------------------------
  # addSaveMethod=true adds tracking code to determine how to save objects
  #
  # addGetByNameMethod=true adds methods to get fields by name/position
  #
  # complexObjectModel=true generates an om with collection support
  #
  # addTimeStamp=true puts time stamps in generated files
  #
  # addIntakeRetrievable=implement Intake's Retrievable interface
  # -------------------------------------------------------------------
  
  targetPackage=org.apache.torque.test
  basePrefix=Base
  addSaveMethod=true
  addGetByNameMethod=true
  complexObjectModel=true
  addTimeStamp=true
  addIntakeRetrievable=false
  useManagers=true
  
  # -------------------------------------------------------------------
  #
  #  D A T A B A S E  S E T T I N G S
  #
  # -------------------------------------------------------------------
  # JDBC connection settings. This is used by the JDBCToXML task that
  # will create an XML database schema from JDBC metadata. These
  # settings are also used by the SQL Ant task to initialize your
  # Turbine system with the generated SQL.
  # -------------------------------------------------------------------
  
  dbmsName = MsSQLServer
  databaseHost = localhost:1433
  jdbcLevel = 2.0
  urlProtocol = jdbc
  urlSubprotocol = microsoft:sqlserver
  databaseUser = sa
  databasePassword = ce
  urlDbalias = //localhost:1433;DatabaseName=OJB;SelectMethod=cursor;User=${databaseUser};Password=${databasePassword};
  
  #jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=OJB;SelectMethod=cursor;User=bill;Password=gates;
  
  createDatabaseUrl = ${urlProtocol}:${urlSubprotocol}:${urlDbalias}
  buildDatabaseUrl = ${urlProtocol}:${urlSubprotocol}:${urlDbalias}
  databaseUrl = ${urlProtocol}:${urlSubprotocol}:${urlDbalias}
  databaseDriver = com.microsoft.jdbc.sqlserver.SQLServerDriver
  
  
  # Tells JDBC task that javaName attribute for the tables and columns
  # should be made same as SQL name.
  sameJavaName=false
  
  # -------------------------------------------------------------------
  #
  #  D O C U M E N T A T I O N   S E T T I N G S
  #
  # -------------------------------------------------------------------
  # These settings will allow you to customize the way your schema
  # documentation is created.
  # Valid formats are: html, anakia (for use with jakarta-site2)
  # -------------------------------------------------------------------
  documentationFormat=html
  
  # -------------------------------------------------------------------
  # You should NOT have to edit anything below here.
  # -------------------------------------------------------------------
  
  # -------------------------------------------------------------------
  #
  #  T E M P L A T E  P A T H
  #
  # -------------------------------------------------------------------
  
  templatePath = ../templates
  
  # -------------------------------------------------------------------
  #
  #  C O N T R O L  T E M P L A T E S
  #
  # -------------------------------------------------------------------
  
  SQLControlTemplate = sql/base/Control.vm
  OMControlTemplate = om/Control.vm
  idTableControlTemplate = sql/id-table/Control.vm
  DataDTDControlTemplate = data/Control.vm
  DataDumpControlTemplate = data/dump/Control.vm
  DataSQLControlTemplate = sql/load/Control.vm
  DocControlTemplate = doc/Control.vm
  
  # -------------------------------------------------------------------
  #
  #  O U T P U T  D I R E C T O R Y
  #
  # -------------------------------------------------------------------
  
  outputDirectory=src
  
  # -------------------------------------------------------------------
  #
  #  S C H E M A  D I R E C T O R Y
  #
  # -------------------------------------------------------------------
  
  schemaDirectory=schema
  
  
  
  1.1                  db-ojb/profile/mssqldb-JSQLConnect.profile
  
  Index: mssqldb-JSQLConnect.profile
  ===================================================================
  # location of jar that you will be using for testing
  # so that it can be copied into the dist/lib directory.
  
  torque.testDatabaseJar = ${lib.repo}/hsqldb.jar
  torque.idMethod = idbroker
  torque.defaultDatabase = OJB
  
  # -------------------------------------------------------------------
  #
  # T O R Q U E  C O N F I G U R A T I O N  F I L E
  #
  # -------------------------------------------------------------------
  
  project = ojbtest
  
  # -------------------------------------------------------------------
  #
  #  T A R G E T  D A T A B A S E
  #
  # -------------------------------------------------------------------
  
  database=mssql
  database.manual.creation = true
  
  # -------------------------------------------------------------------
  #
  #  O B J E C T  M O D E L  I N F O R M A T I O N
  #
  # -------------------------------------------------------------------
  # These settings will allow you to customize the way your
  # Peer-based object model is created.
  # -------------------------------------------------------------------
  # addSaveMethod=true adds tracking code to determine how to save objects
  #
  # addGetByNameMethod=true adds methods to get fields by name/position
  #
  # complexObjectModel=true generates an om with collection support
  #
  # addTimeStamp=true puts time stamps in generated files
  #
  # addIntakeRetrievable=implement Intake's Retrievable interface
  # -------------------------------------------------------------------
  
  targetPackage=org.apache.torque.test
  basePrefix=Base
  addSaveMethod=true
  addGetByNameMethod=true
  complexObjectModel=true
  addTimeStamp=true
  addIntakeRetrievable=false
  useManagers=true
  
  # -------------------------------------------------------------------
  #
  #  D A T A B A S E  S E T T I N G S
  #
  # -------------------------------------------------------------------
  # JDBC connection settings. This is used by the JDBCToXML task that
  # will create an XML database schema from JDBC metadata. These
  # settings are also used by the SQL Ant task to initialize your
  # Turbine system with the generated SQL.
  # -------------------------------------------------------------------
  
  dbmsName = MsSQLServer
  databaseHost = localhost:1433
  jdbcLevel = 2.0
  urlProtocol = jdbc
  urlSubprotocol = JSQLConnect
  databaseUser = sa
  databasePassword = motiva
  urlDbalias = //localhost/database=OJB/user=${databaseUser}/password=${databasePassword}
  
  #jdbc:JSQLConnect://ServerName:port/opt=value/opt=value
  
  createDatabaseUrl = ${urlProtocol}:${urlSubprotocol}:${urlDbalias}
  buildDatabaseUrl = ${urlProtocol}:${urlSubprotocol}:${urlDbalias}
  databaseUrl = ${urlProtocol}:${urlSubprotocol}:${urlDbalias}
  databaseDriver = com.jnetdirect.jsql.JSQLDriver
  
  
  # Tells JDBC task that javaName attribute for the tables and columns
  # should be made same as SQL name.
  sameJavaName=false
  
  # -------------------------------------------------------------------
  #
  #  D O C U M E N T A T I O N   S E T T I N G S
  #
  # -------------------------------------------------------------------
  # These settings will allow you to customize the way your schema
  # documentation is created.
  # Valid formats are: html, anakia (for use with jakarta-site2)
  # -------------------------------------------------------------------
  documentationFormat=html
  
  # -------------------------------------------------------------------
  # You should NOT have to edit anything below here.
  # -------------------------------------------------------------------
  
  # -------------------------------------------------------------------
  #
  #  T E M P L A T E  P A T H
  #
  # -------------------------------------------------------------------
  
  templatePath = ../templates
  
  # -------------------------------------------------------------------
  #
  #  C O N T R O L  T E M P L A T E S
  #
  # -------------------------------------------------------------------
  
  SQLControlTemplate = sql/base/Control.vm
  OMControlTemplate = om/Control.vm
  idTableControlTemplate = sql/id-table/Control.vm
  DataDTDControlTemplate = data/Control.vm
  DataDumpControlTemplate = data/dump/Control.vm
  DataSQLControlTemplate = sql/load/Control.vm
  DocControlTemplate = doc/Control.vm
  
  # -------------------------------------------------------------------
  #
  #  O U T P U T  D I R E C T O R Y
  #
  # -------------------------------------------------------------------
  
  outputDirectory=src
  
  # -------------------------------------------------------------------
  #
  #  S C H E M A  D I R E C T O R Y
  #
  # -------------------------------------------------------------------
  
  schemaDirectory=schema