Re: AW: Torque and OJB, Error creating database

[Thomas Fischer]

Hi Stephan,

I do not think this is the cause for the error. Velocity complains about 
not being able to find the file, not about its contents. Did you check 
that the exact path given in the log files is correct ?
Also, in Torque 3.1, there is a property torque.useClasspath, which 
controls whether Torque looks for the templates in the classpath or in an 
external directory. Perhaps this property is also there in 3.0.2, if yes, 
make sure it is set to true and that the torque jar is in the classpath of 
the ant build.
Sorry I cannot be more specific, but as I said, I have no experience with 
pre 3.1-versions of Torque

    Thomas


On Thu, 4 Aug 2005, [iso-8859-1] Stephan Brüssermann wrote:

Hello Thomas,

Now I found the files. They are in the .jar-File of Torque (even in 3.0.2). I found that 
the creatdb.vm contains only the text "ECHO Not implemented". Could this cause 
the error I got? And do you now where I get such a file?
Otherwise I have to explore the documentation and edit the file by myself.

Stephan

_________________________________________________
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
[EMAIL PROTECTED]
___________________________________________


-----Ursprüngliche Nachricht-----
Von: Thomas Fischer [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 4. August 2005 17:44
An: Apache Torque Users List
Betreff: AW: Torque and OJB, Error creating database





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 <[EMAIL PROTECTED]> 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
[EMAIL PROTECTED]
___________________________________________

-----Ursprüngliche Nachricht-----
Von: Thomas Fischer [mailto:[EMAIL PROTECTED]
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 <[EMAIL PROTECTED]> 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

[EMAIL PROTECTED]

___________________________________________





---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]





---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]





---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]