db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "CG Monroe (JIRA)" <j...@apache.org>
Subject [jira] Commented: (TORQUE-74) Targets sql and datasql can't find required files
Date Wed, 06 Dec 2006 18:13:22 GMT
    [ http://issues.apache.org/jira/browse/TORQUE-74?page=comments#action_12456151 ] 
            
CG Monroe commented on TORQUE-74:
---------------------------------

>From the error messages, this is probably not a bug but due to the fact you seem to be
trying to run with the setting:

torque.database = firebird

This is not correct for using firebird.  The actual setting should be:

torque.database = interbase

(Firebird's a spin off of interbase).

The new code does not fail if it can't find a db platform during generation, but instead tries
to use the default implimentation (which looks for the non-existant firebird templates.  This
is so it's easy to add in a custom implimentation.  FWIW, there is a warning printed out in
the logs somewhere, but it's not too easy to find.

If you use the interbase value, this should allow your sql task to complete.  This will generate
the sqldb.map and let your other tasks work.

Try this and see if that "fixes" it.

FYI - The sqldb.map is generated to map an SQL file to the assocated database.  A complex
schema can have multiple *-schema.xml files that use different database connections. It looks
like:

#Sqlfile -> Database map
#Tue Dec 05 11:38:10 EST 2006
bookstore-schema.sql=bookstore
bookstore-data.sql=bookstore


> Targets sql and datasql can't find required files
> -------------------------------------------------
>
>                 Key: TORQUE-74
>                 URL: http://issues.apache.org/jira/browse/TORQUE-74
>             Project: Torque
>          Issue Type: Bug
>          Components: Generator
>    Affects Versions: 3.3
>         Environment: Windows XP, JDK 1.5
>            Reporter: Joerg Friedrich
>
> I like to create an sql file from an XML data file I dumped using the following sequence
(%ANT_HOME% points to ant 1.6.4):
> CALL %ANT_HOME%\bin\ant  -f build-torque.xml jdbc %1 %2 %3
> mv .\src\schema\schema.xml .\src\schema\track-schema.xml
> CALL %ANT_HOME%\bin\ant -f build-torque.xml datadtd %1 %2 %3
> CALL %ANT_HOME%\bin\ant -f build-torque.xml datadump %1 %2 %3
> mv .\src\track-theUser-all-data.xml .\src\schema\track-data.xml
> (Yes, the moves are necessary since there are some precoded file names in build-torque.xml).
> The following error appears:
> --- Nested Exception ---
> java.io.FileNotFoundException: D:\torque-gen-3.3-RC1\src\sql\sqldb.map (Das System kann
den angegebenen Pfad nicht finden)
>         at java.io.FileInputStream.open(Native Method)
> I can't find the file anywhere in the source code (btw.: the source code links at http://www.apache.org/dyn/closer.cgi/db/torque/torque-3.3/source/torque-gen-3.3-src.zip
are broken today).
> When I run the "sql" target, I get the following messages:
>         at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
> Caused by: org.apache.velocity.exception.ResourceNotFoundException: Unable to find resource
'sql/base/firebird/table.vm'
>         at org.apache.velocity.runtime.resource.ResourceManagerImpl.loadResource
> (ResourceManagerImpl.java:501)
> And last but not least, beside these little problems, thanks for the superb work, guys!

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

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


Mime
View raw message