You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by "Joerg Friedrich (JIRA)" <ji...@apache.org> on 2006/12/06 15:46:24 UTC
[jira] Created: (TORQUE-74) Target datasql can't find
src/sql/sqldb.map file
Target datasql can't find src/sql/sqldb.map file
------------------------------------------------
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).
And last but not least, 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
[jira] Commented: (TORQUE-74) Targets sql and datasql can't find
required files
Posted by "CG Monroe (JIRA)" <ji...@apache.org>.
[ 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
[jira] Updated: (TORQUE-74) Targets sql and datasql can't find
required files
Posted by "Joerg Friedrich (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/TORQUE-74?page=all ]
Joerg Friedrich updated TORQUE-74:
----------------------------------
Summary: Targets sql and datasql can't find required files (was: Target datasql can't find src/sql/sqldb.map file)
Description:
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!
was:
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).
And last but not least, thanks for the superb work, guys!
> 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
[jira] Commented: (TORQUE-74) Targets sql and datasql can't find
required files
Posted by "Thomas Fischer (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/TORQUE-74?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12493918 ]
Thomas Fischer commented on TORQUE-74:
--------------------------------------
Does Greg's suggestion fix this issue? Please let us know if this has not worked, otherwise I'll close this issue.
> Targets sql and datasql can't find required files
> -------------------------------------------------
>
> Key: TORQUE-74
> URL: https://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.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
[jira] Closed: (TORQUE-74) Targets sql and datasql can't find
required files
Posted by "Thomas Fischer (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/TORQUE-74?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Fischer closed TORQUE-74.
--------------------------------
Resolution: Cannot Reproduce
Did not receive any feedback whether Greg's suggestions have fixed this.
> Targets sql and datasql can't find required files
> -------------------------------------------------
>
> Key: TORQUE-74
> URL: https://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.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
[jira] Commented: (TORQUE-74) Targets sql and datasql can't find
required files
Posted by "Thoralf Rickert (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/TORQUE-74?page=comments#action_12456094 ]
Thoralf Rickert commented on TORQUE-74:
---------------------------------------
I think, the sqldb.map file is generated when you call the "sql" ant-task. But I don't know why this file is necessary for the datadump task because it contains the files that are needed for the insert-sql task.
> 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