You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Stephan Brüssermann <st...@db-e.de> on 2005/08/01 17:43:41 UTC
Torque and OJB, Error creating database
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
___________________________________________
RE: Torque and OJB, Error creating database
Posted by Thomas Fischer <fi...@seitenbau.net>.
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 <st...@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