db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephan Brüssermann <stephan.bruesserm...@db-e.de>
Subject AW: Torque and OJB, Error creating database
Date Thu, 04 Aug 2005 15:28:58 GMT
Hello,

I was on a business trip for two days so I can answer just now.
I use Torque 3.0.2. I didn't change any template. I use the eclipse ant plug-in to execute
the torque build file of ojb. 
I searched for the sql/db-init/mssql/createdb.vm file, but I didn't found it on my local PC.
The SQL-Server runs on a server named //srv001. How the .vm file is created? By the application
or comes it with the distribution of Torque?

Stephan

The error occurred at the <torque-data-model> statement list below.
<!-- ================================================================ -->
  <!-- C R E A T E  T A R G E T  D A T A B A S E                        -->
  <!-- ================================================================ -->
  <!-- Create the target database by executing a generated script       -->
  <!-- that is capable of performing the task.                          -->
  <!-- ================================================================ -->

  <target name="create-db-check">
    <condition property="torque.internal.manualCreation">
      <equals arg1="${torque.database.manualCreation}" arg2="true"/>
    </condition>
  </target>

  <target
    name="create-db"
    unless="torque.internal.manualCreation"
    depends="create-db-check"
    description="==> generates the target database">

    <torque-data-model
      controlTemplate="${torque.template.sqlDbInit}"
      outputDirectory="${torque.sql.dir}"
      outputFile="create-db.sql"
      targetDatabase="${torque.database}"
      templatePath="${torque.templatePath}"
      useClasspath="${torque.useClasspath}">
      <fileset dir="${torque.schema.dir}"
        includes="${torque.schema.create-db.includes}"
        excludes="${torque.schema.create-db.excludes}"
      />
    </torque-data-model>

_________________________________________________
Dr. Brüssermann Entwicklungs-GmbH & Co. KG
Dr. Stephan Brüssermann
 
Harthauser Strasse 17
89081 Ulm
 
Tel.  +49(731)37 935 953
Fax  +49(731)37 935 954 
Mobil +49(171)81 55 894
stephan.bruessermann@db-e.de
___________________________________________
 
>>-----Ursprüngliche Nachricht-----
>>Von: Thomas Fischer [mailto:fischer@seitenbau.net]
>>Gesendet: Dienstag, 2. August 2005 10:03
>>An: Apache Torque Users List
>>Betreff: RE: Torque and OJB, Error creating database
>>
>>
>>
>>
>>
>>Hi,
>>
>>It looks like one of the templates is not found (
>>sql/db-init/mssql/createdb.vm). This is strange as this template is there
>>since Torque 3.0.1 according to CVS and the other templates (e.g. the
>>different Control.vm) can be found. Which Torque version are you using,
>>and
>>did you modify the templates yourself, and if no, how do you access the
>>templates ? Via the classpath or in an extra directory ?
>>
>>        Thomas
>>
>>Stephan Brüssermann <stephan.bruessermann@db-e.de> schrieb am 01.08.2005
>>17:43:41:
>>
>>> Hello,
>>>
>>>
>>>
>>> I had installed the ojb-blank project for testing the O/R-Bridge.
>>> I'm thinking of using OJB in a development project.
>>>
>>> I established the connection to an MSSql-Server 2000. Now I try to
>>> create the database of the ojb-blank-project using Torque. I get the
>>> error described next.
>>>
>>>
>>>
>>> Buildfile: C:\SvnWorkspace\inJobs\ojb-blank\build.xml
>>>
>>> compile:
>>>
>>> xdoclet:
>>>
>>> [ojbdoclet] (XDocletMain.start                   47  ) Running
>>> <ojbrepository/>
>>>
>>> [ojbdoclet] (XDocletMain.start                   47  ) Running
>><torqueschema/>
>>>
>>> setup-db:
>>>
>>> check-use-classpath:
>>>
>>> check-run-only-on-schema-change:
>>>
>>> sql-check:
>>>
>>> sql:
>>>
>>>      [echo] +------------------------------------------+
>>>
>>>      [echo] |                                          |
>>>
>>>      [echo] | Generating SQL for YOUR Torque project!  |
>>>
>>>      [echo] | Woo hoo!                                 |
>>>
>>>      [echo] |                                          |
>>>
>>>      [echo] +------------------------------------------+
>>>
>>> sql-classpath:
>>>
>>> [torque-sql] Using contextProperties file: C:
>>> \SvnWorkspace\inJobs\ojb-blank\build.properties
>>>
>>> [torque-sql] Using classpath
>>>
>>> [torque-sql] Generating to file C:\SvnWorkspace\InJobs\ojb-
>>> blank\build\database\report.ojb_blank.sql.generation
>>>
>>> [torque-sql] Parsing file: 'ojbcore-schema.xml'
>>>
>>> [torque-sql] (transform.DTDResolver               128 ) Resolver:
>>> used database.dtd from org.apache.torque.engine.database.transform
>>package
>>>
>>> [torque-sql] Parsing file: 'project-schema.xml'
>>>
>>> [torque-sql] (transform.DTDResolver               128 ) Resolver:
>>> used database.dtd from org.apache.torque.engine.database.transform
>>package
>>>
>>> sql-template:
>>>
>>> create-db-check:
>>>
>>> create-db:
>>>
>>> [torque-data-model] Using classpath
>>>
>>> [torque-data-model] Generating to file C:\SvnWorkspace\InJobs\ojb-
>>> blank\build\database\create-db.sql
>>>
>>> [torque-data-model] Parsing file: 'ojbcore-schema.xml'
>>>
>>> [torque-data-model] (transform.DTDResolver               128 )
>>> Resolver: used database.dtd from org.apache.torque.engine.database.
>>> transform package
>>>
>>> [torque-data-model] Parsing file: 'project-schema.xml'
>>>
>>> [torque-data-model] (transform.DTDResolver               128 )
>>> Resolver: used database.dtd from org.apache.torque.engine.database.
>>> transform package
>>>
>>>
>>>
>>> BUILD FAILED
>>>
>>> C:\SvnWorkspace\inJobs\ojb-blank\build.xml:180: The following error
>>> occurred while executing this line:
>>>
>>> C:\SvnWorkspace\inJobs\ojb-blank\src\schema\build-torque.xml:300:
>>> Exception thrown by 'generator.parse'. For more information consult
>>> the velocity log, or invoke ant with the -debug flag.
>>>
>>>
>>>
>>> Total time: 18 seconds
>>>
>>>
>>>
>>> The velocity log for this error is:
>>>
>>>
>>>
>>> .........
>>>
>>> .........
>>>
>>> 2005-08-01 16:56:00,328 - ResourceManager : found
>>> sql/base/mssql/unique.vm with loader org.apache.velocity.runtime.
>>> resource.loader.ClasspathResourceLoader
>>>
>>> 2005-08-01 16:56:00,338 - ResourceManager : found
>>> sql/base/mssql/index.vm with loader org.apache.velocity.runtime.
>>> resource.loader.ClasspathResourceLoader
>>>
>>> 2005-08-01 16:56:00,348 - ResourceManager : found
>>> sql/base/mssql/tablefk.vm with loader org.apache.velocity.runtime.
>>> resource.loader.ClasspathResourceLoader
>>>
>>> 2005-08-01 16:56:00,358 - ResourceManager : found
>>> sql/base/mssql/foreignkey.vm with loader org.apache.velocity.
>>> runtime.resource.loader.ClasspathResourceLoader
>>>
>>> 2005-08-01 16:56:03,873 - SimpleLog4JLogSystem initialized using
>>> logfile 'velocity.log'
>>>
>>> 2005-08-01 16:56:03,873 -
>>> **************************************************************
>>>
>>> 2005-08-01 16:56:03,873 - Starting Jakarta Velocity v1.3.1
>>>
>>> 2005-08-01 16:56:03,873 - RuntimeInstance initializing.
>>>
>>> 2005-08-01 16:56:03,873 - Default Properties File:
>>> org\apache\velocity\runtime\defaults\velocity.properties
>>>
>>> 2005-08-01 16:56:03,873 - Trying to use logger class org.apache.
>>> velocity.runtime.log.AvalonLogSystem
>>>
>>> 2005-08-01 16:56:03,873 - Couldn't find class org.apache.velocity.
>>> runtime.log.AvalonLogSystem or necessary supporting classes in
>>> classpath. Exception : java.lang.NoClassDefFoundError:
>>> org/apache/log/format/Formatter
>>>
>>> 2005-08-01 16:56:03,873 - Trying to use logger class org.apache.
>>> velocity.runtime.log.SimpleLog4JLogSystem
>>>
>>> 2005-08-01 16:56:03,873 - Using logger class org.apache.velocity.
>>> runtime.log.SimpleLog4JLogSystem
>>>
>>> 2005-08-01 16:56:03,893 - Default ResourceManager initializing.
>>> (class org.apache.velocity.runtime.resource.ResourceManagerImpl)
>>>
>>> 2005-08-01 16:56:03,913 - Resource Loader Instantiated: org.apache.
>>> velocity.runtime.resource.loader.ClasspathResourceLoader
>>>
>>> 2005-08-01 16:56:03,913 - ClasspathResourceLoader : initialization
>>starting.
>>>
>>> 2005-08-01 16:56:03,913 - ClasspathResourceLoader : initialization
>>complete.
>>>
>>> 2005-08-01 16:56:03,933 - ResourceCache : initialized. (class org.
>>> apache.velocity.runtime.resource.ResourceCacheImpl)
>>>
>>> 2005-08-01 16:56:03,933 - Default ResourceManager initialization
>>complete.
>>>
>>> 2005-08-01 16:56:03,943 - Loaded System Directive: org.apache.
>>> velocity.runtime.directive.Literal
>>>
>>> 2005-08-01 16:56:03,953 - Loaded System Directive: org.apache.
>>> velocity.runtime.directive.Macro
>>>
>>> 2005-08-01 16:56:03,963 - Loaded System Directive: org.apache.
>>> velocity.runtime.directive.Parse
>>>
>>> 2005-08-01 16:56:03,973 - Loaded System Directive: org.apache.
>>> velocity.runtime.directive.Include
>>>
>>> 2005-08-01 16:56:03,983 - Loaded System Directive: org.apache.
>>> velocity.runtime.directive.Foreach
>>>
>>> 2005-08-01 16:56:04,253 - Created: 20 parsers.
>>>
>>> 2005-08-01 16:56:04,253 - Velocimacro : initialization starting.
>>>
>>> 2005-08-01 16:56:04,253 - Velocimacro : adding VMs from VM library
>>> template : VM_global_library.vm
>>>
>>> 2005-08-01 16:56:04,263 - ResourceManager : unable to find resource
>>> 'VM_global_library.vm' in any resource loader.
>>>
>>> 2005-08-01 16:56:04,263 - Velocimacro : error using  VM library
>>> template VM_global_library.vm : org.apache.velocity.exception.
>>> ResourceNotFoundException: Unable to find resource
>>'VM_global_library.vm'
>>>
>>> 2005-08-01 16:56:04,263 - Velocimacro :  VM library template macro
>>> registration complete.
>>>
>>> 2005-08-01 16:56:04,263 - Velocimacro : allowInline = true : VMs can
>>> be defined inline in templates
>>>
>>> 2005-08-01 16:56:04,263 - Velocimacro : allowInlineToOverride =
>>> false : VMs defined inline may NOT replace previous VM definitions
>>>
>>> 2005-08-01 16:56:04,263 - Velocimacro : allowInlineLocal = false :
>>> VMs defined inline will be  global in scope if allowed.
>>>
>>> 2005-08-01 16:56:04,263 - Velocimacro : messages on  : VM system
>>> will output logging messages
>>>
>>> 2005-08-01 16:56:04,263 - Velocimacro : autoload off  : VM system
>>> will not automatically reload global library macros
>>>
>>> 2005-08-01 16:56:04,263 - Velocimacro : initialization complete.
>>>
>>> 2005-08-01 16:56:04,263 - Velocity successfully started.
>>>
>>> 2005-08-01 16:56:05,044 - ResourceManager : found sql/db-
>>> init/Control.vm with loader org.apache.velocity.runtime.resource.
>>> loader.ClasspathResourceLoader
>>>
>>> 2005-08-01 16:56:05,085 - ResourceManager : unable to find resource
>>> 'sql/db-init/mssql/createdb.vm' in any resource loader.
>>>
>>> 2005-08-01 16:56:05,085 - Method parse threw exception for reference
>>> $generator in template sql/db-init/Control.vm at  [2,1]
>>>
>>>
>>>
>>> I use Eclipse 3.1.0, JDK 1.5.0 04 and ANT 1.6.5. I tried for hours
>>> to find the error, but I failed.
>>>
>>> Can someone help me? Thanks for your help in advance.
>>>
>>>
>>>
>>> Stephan Brüssermann
>>>
>>>
>>>
>>> _________________________________________________
>>>
>>> Dr. Brüssermann Entwicklungs-GmbH & Co. KG
>>>
>>> Dr. Stephan Brüssermann
>>>
>>>
>>>
>>> Harthauser Strasse 17
>>>
>>> 89081 Ulm
>>>
>>>
>>>
>>> Tel.  +49(731)37 935 953
>>>
>>> Fax  +49(731)37 935 954
>>>
>>> Mobil +49(171)81 55 894
>>>
>>> stephan.bruessermann@db-e.de
>>>
>>> ___________________________________________
>>>
>>>
>>>
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>For additional commands, e-mail: torque-user-help@db.apache.org
>>
>>
>>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message