db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <fisc...@seitenbau.net>
Subject AW: Torque and OJB, Error creating database
Date Thu, 04 Aug 2005 15:44:11 GMT




Hi,

The file should come with Torque. Its is strange that it is not packaged,
but I have no experience with pre-3.1-versions.
You can get a recent distribution of the torque generator and get the file
from there. For example, you can download torque-gen-templates-3.2-rc1.jar
and unpack it, you should find the file at the path which the error log
says.

    Thomas

Stephan Brüssermann <stephan.bruessermann@db-e.de> schrieb am 04.08.2005
17:28:58:

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


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