My postgresql.profile file. I was using hibernate,
another relational mapper in the past with
Postgres so I attempted to use the same URL
String (jdbc:postgresql://dargo:5432/test) which
worked with Hibernate. Note I added the default
postgres port number 5432.. Please know that
changing "databaseHost = dargo:5432" to
"databaseHost = dargo.com" does not help me...
Thanks for your time and help in advance... ray
ah sorry for the long email...
# -------------------------------------------------------------------
#
# D A T A B A S E S E T T I N G S
#
# -------------------------------------------------------------------
# JDBC connection settings. This is used by the JDBCToXML task that
# will create an XML database schema from JDBC metadata. These
# settings are also used by the SQL Ant task to initialize your
# Turbine system with the generated SQL.
# -------------------------------------------------------------------
# from my hibernate example jdbc:postgresql://dargo:5432/test
dbmsName = postgresql
jdbcLevel = 1.0
urlProtocol = jdbc
urlSubprotocol = postgresql
urlDbalias = test
databaseDriver = org.postgresql.Driver
databaseUser = user1
databasePassword = ray1lukas
databaseHost = dargo:5432
databaseUrl =
${urlProtocol}:${urlSubprotocol}://${databaseHost}/${urlDbalias}
createDatabaseUrl = ${databaseUrl}
buildDatabaseUrl = ${databaseUrl}
=====================> Next I tried to run the ant build with
prepare-testdb and this is what I got...
First Attempt at prepare-testdb
project-sql-classpath:
[echo] +--------------------------------------------------------+
[echo] | |
[echo] | Generating SQL for OJB Testsuite! |
[echo] | enJoy! |
[echo] | |
[echo] +-------------------------------------------------------+
[torque-sql] Using contextProperties file:
D:\Downloads\OJBMappingSystem\jakarta-ojb-0.9.7\build.properties
[torque-sql] Using classpath
[torque-sql] Generating to file
D:\Downloads\OJBMappingSystem\jakarta-ojb-0.9.7\target\src\sql\report.oj
btest.sql.generation
[torque-sql] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[torque-sql] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[torque-sql] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[torque-sql] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
BUILD FAILED
file:D:/Downloads/OJBMappingSystem/jakarta-ojb-0.9.7/build-torque.xml:44
8: Exception thrown
by 'generator.parse'. For more information consult the velocity log, or
invoke ant with the -debug flag.
Total time: 5 seconds
D:\Downloads\OJBMappingSystem\jakarta-ojb-0.9.7>
=====================> OKay I am game.. NEXT ATTEMPT WITH DEBUG..
=====================> I got a lot of output, this is only the tail end
of it...
+Task: torque-sql
[torque-sql] Using contextProperties file:
D:\Downloads\OJBMappingSystem\jakarta-ojb-0.9.7\build.properties
[torque-sql] Using classpath
[torque-sql] Generating to file
D:\Downloads\OJBMappingSystem\jakarta-ojb-0.9.7\target\src\sql\report.oj
btest.
sql.generation
fileset: Setup scanner in dir
D:\Downloads\OJBMappingSystem\jakarta-ojb-0.9.7\src\schema with
patternSet{ incl
udes: [*-schema.xml] excludes: [] }
[torque-sql] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[torque-sql] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[torque-sql] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[torque-sql] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
BUILD FAILED
file:D:/Downloads/OJBMappingSystem/jakarta-ojb-0.9.7/build-torque.xml:44
8:
Exception thrown by 'generator.parse'. For more information consult the
velocity log, or invoke ant with the -debug flag.
at
org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.java:564)
at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:166)
at org.apache.tools.ant.Task.perform(Task.java:317)
at org.apache.tools.ant.Target.execute(Target.java:309)
at org.apache.tools.ant.Target.performTasks(Target.java:334)
at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:371)
at org.apache.tools.ant.Task.perform(Task.java:317)
at org.apache.tools.ant.Target.execute(Target.java:309)
at org.apache.tools.ant.Target.performTasks(Target.java:334)
at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
at
org.apache.tools.ant.Project.executeTargets(Project.java:1250)
at org.apache.tools.ant.Main.runBuild(Main.java:610)
at org.apache.tools.ant.Main.start(Main.java:196)
at org.apache.tools.ant.Main.main(Main.java:235)
--- Nested Exception ---
org.apache.velocity.exception.MethodInvocationException: Invocation of
method 'chop' in class org.apache.velo
city.util.StringUtils threw exception class
java.lang.ArrayIndexOutOfBoundsException : null
at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java
:308)
at
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReferenc
e.java:207)
at
org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference
.java:250)
at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94
)
at
org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfState
ment.java:109)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.jav
a:271)
at org.apache.velocity.Template.merge(Template.java:296)
at org.apache.velocity.texen.Generator.parse(Generator.java:425)
at org.apache.velocity.texen.Generator.parse(Generator.java:361)
at java.lang.reflect.Method.invoke(Native Method)
at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java
:259)
at
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReferenc
e.java:207)
at
org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference
.java:250)
at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94
)
at
org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfState
ment.java:109)
at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94
)
at
org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:344)
at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective
.java:153)
at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94
)
at
org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:344)
at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective
.java:153)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.jav
a:271)
at org.apache.velocity.Template.merge(Template.java:296)
at org.apache.velocity.texen.Generator.parse(Generator.java:451)
at
org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.java:552)
at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:166)
at org.apache.tools.ant.Task.perform(Task.java:317)
at org.apache.tools.ant.Target.execute(Target.java:309)
at org.apache.tools.ant.Target.performTasks(Target.java:334)
at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:371)
at org.apache.tools.ant.Task.perform(Task.java:317)
at org.apache.tools.ant.Target.execute(Target.java:309)
at org.apache.tools.ant.Target.performTasks(Target.java:334)
at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
at org.apache.tools.ant.Project.executeTargets(Project.java:1250)
at org.apache.tools.ant.Main.runBuild(Main.java:610)
at org.apache.tools.ant.Main.start(Main.java:196)
at org.apache.tools.ant.Main.main(Main.java:235)
Total time: 11 seconds
==============================>
Here is the tail end of the velocity.log file
2002-11-14 11:03:48,545 - Default ResourceManager initialization
complete.
2002-11-14 11:03:48,545 - Loaded System Directive:
org.apache.velocity.runtime.directive.Literal
2002-11-14 11:03:48,555 - Loaded System Directive:
org.apache.velocity.runtime.directive.Macro
2002-11-14 11:03:48,555 - Loaded System Directive:
org.apache.velocity.runtime.directive.Parse
2002-11-14 11:03:48,565 - Loaded System Directive:
org.apache.velocity.runtime.directive.Include
2002-11-14 11:03:48,565 - Loaded System Directive:
org.apache.velocity.runtime.directive.Foreach
2002-11-14 11:03:48,835 - Created: 20 parsers.
2002-11-14 11:03:48,835 - Velocimacro : initialization starting.
2002-11-14 11:03:48,835 - Velocimacro : adding VMs from VM library
template : VM_global_library.vm
2002-11-14 11:03:48,835 - ResourceManager : unable to find resource
'VM_global_library.vm' in any resource loader.
2002-11-14 11:03:48,845 - Velocimacro : error using VM library template
VM_global_library.vm :
org.apache.velocity.exception.ResourceNotFoundException: Unable to find
resource 'VM_global_library.vm'
2002-11-14 11:03:48,845 - Velocimacro : VM library template macro
registration complete.
2002-11-14 11:03:48,845 - Velocimacro : allowInline = true : VMs can be
defined inline in templates
2002-11-14 11:03:48,845 - Velocimacro : allowInlineToOverride = false :
VMs defined inline may NOT replace previous VM definitions
2002-11-14 11:03:48,845 - Velocimacro : allowInlineLocal = false : VMs
defined inline will be global in scope if allowed.
2002-11-14 11:03:48,845 - Velocimacro : messages on : VM system will
output logging messages
2002-11-14 11:03:48,845 - Velocimacro : autoload off : VM system will
not automatically reload global library macros
2002-11-14 11:03:48,845 - Velocimacro : initialization complete.
2002-11-14 11:03:48,845 - Velocity successfully started.
2002-11-14 11:03:49,476 - ResourceManager : found sql/base/Control.vm
with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2002-11-14 11:03:49,496 -
org.apache.velocity.runtime.exception.ReferenceException: reference :
template = sql/base/Control.vm [line 1,column 1] :
$generator.TemplatePath is not a valid reference.
2002-11-14 11:03:49,546 - ResourceManager : found
sql/base/postgresql/table.vm with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2002-11-14 11:03:49,556 - ResourceManager : found
sql/base/postgresql/drop.vm with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2002-11-14 11:03:49,606 - ResourceManager : found
sql/base/postgresql/columns.vm with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2002-11-14 11:03:49,646 - ResourceManager : found
sql/base/postgresql/primarykey.vm with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2002-11-14 11:03:49,646 - ResourceManager : found
sql/base/postgresql/unique.vm with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2002-11-14 11:03:49,656 - ResourceManager : found
sql/base/postgresql/index.vm with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2002-11-14 11:03:49,656 - Method chop threw exception for reference
$strings in template sql/base/postgresql/table.vm at [17,25]
2002-11-14 11:03:49,656 - Method parse threw exception for reference
$generator in template sql/base/Control.vm at [17,7]
