You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Brent Hale <bh...@eventronix.com> on 2002/07/03 22:24:51 UTC

Please update the following document for us Newbies

Hi,

As a Turbine newbie I have found it very difficult to get up and going.  I
offer the following changes to be made.  If not...at least these things are
in the archive for other newbies to come across.

I downloaded tdk-2.2-b1.zip from
<http://jakarta.apache.org/builds/jakarta-turbine/tdk/release/2.2-b1/>

GETTING_STARTED.txt: Change the link from
http://jakarta.apache.org/turbine/howto/tdk-howto.html to
http://jakarta.apache.org/turbine/tdk/tdk-howto.html.  It would also be nice
to just include that html document in the distribution.

tdk-howto.html:
	for the 2.2-b1 version, step 1 needs to include a directive to add
"tdk.home=<tdk home>" entry to the build.properties file.  Note to Windows
users: specify "\\" for all path delimiters.

	Step 4.  The default build.properties file doesn't provide default values
like I saw on an earlier version of the TDK (which I never got working).  I
had to do the following:

I added:
tdk.home = C:\\devtools\\tdk

I changed:
database.name = newapp
database = mysql
createDatabaseUrl = jdbc:mysql://localhost/newapp
buildDatabaseUrl = jdbc:mysql://localhost/newapp
databaseUrl = jdbc:mysql://localhost/newapp
databaseDriver = org.gjt.mm.mysql.Driver
databaseUser = root
databasePassword = admin
databaseHost = localhost



	Step 5.  Though I ran "ant init" and it was successful I noticed several
errors that are documented below.  It appears to be OK since I can now
access the app with my browser.  But it made me nervous.  Here are the error
snippets:

ant target: project-create-db-classpath:
...
[torque-create-db] Resolver: used database.dtd from
org.apache.torque.engine.dat
abase.transform package
      [sql] Executing file:
C:\devtools\tdk\webapps\newapp\WEB-INF\src\sql\creat
e-db.sql
      [sql] Failed to execute: drop database if exists default
      [sql] java.sql.SQLException: Syntax error or access violation: You
have an
 error in your SQL syntax near 'default' at line 1
      [sql] Failed to execute: create database default
      [sql] java.sql.SQLException: Syntax error or access violation: You
have an
 error in your SQL syntax near 'default' at line 1
      [sql] 6 of 8 SQL statements executed successfully


----------------

ant target: project-insert-sql:

[torque-insert-sql] Our new url -> jdbc:mysql://localhost/newapp
[torque-insert-sql] Executing file:
C:\devtools\tdk\webapps\newapp\WEB-INF\src\s
ql\third-schema.sql
[torque-insert-sql] Executing file:
C:\devtools\tdk\webapps\newapp\WEB-INF\src\s
ql\third-schema-idtable-init.sql
[torque-insert-sql] Failed to execute: insert into ID_TABLE (id_table_id,
table_
name, next_id, quantity) VALUES (121, 'RDF3', 100, 10)
[torque-insert-sql] java.sql.SQLException: General error: Table
'newapp.ID_TABLE
' doesn't exist
[torque-insert-sql] 2 of 3 SQL statements executed successfully
[torque-insert-sql] Our new url -> jdbc:mysql://localhost/newapp
[torque-insert-sql] Executing file:
C:\devtools\tdk\webapps\newapp\WEB-INF\src\s
ql\second-schema.sql
[torque-insert-sql] Executing file:
C:\devtools\tdk\webapps\newapp\WEB-INF\src\s
ql\second-schema-idtable-init.sql
[torque-insert-sql] Failed to execute: insert into ID_TABLE (id_table_id,
table_
name, next_id, quantity) VALUES (111, 'RDF2', 100, 10)
[torque-insert-sql] java.sql.SQLException: General error: Table
'newapp.ID_TABLE
' doesn't exist
[torque-insert-sql] 4 of 6 SQL statements executed successfully
[torque-insert-sql] Our new url -> jdbc:mysql://localhost/newapp
[torque-insert-sql] Executing file:
C:\devtools\tdk\webapps\newapp\WEB-INF\src\s
ql\id-table-schema.sql
[torque-insert-sql] 6 of 8 SQL statements executed successfully
[torque-insert-sql] Our new url -> jdbc:mysql://localhost/newapp
[torque-insert-sql] Executing file:
C:\devtools\tdk\webapps\newapp\WEB-INF\src\s
ql\turbine-schema.sql
[torque-insert-sql] Executing file:
C:\devtools\tdk\webapps\newapp\WEB-INF\src\s
ql\newapp-schema.sql
[torque-insert-sql] Executing file:
C:\devtools\tdk\webapps\newapp\WEB-INF\src\s
ql\newapp-schema-idtable-init.sql
[torque-insert-sql] Executing file:
C:\devtools\tdk\webapps\newapp\WEB-INF\src\s
ql\turbine-schema-idtable-init.sql
[torque-insert-sql] Executing file:
C:\devtools\tdk\webapps\newapp\WEB-INF\src\s
ql\turbine-security.sql
[torque-insert-sql] 41 of 43 SQL statements executed successfully


---------------------

Broken link on the page:
http://jakarta.apache.org/turbine/tdk/tdk-howto.html.
Where it says "More information on building sites with Velocity is available
here."
Change the link on "here" from
http://jakarta.apache.org/turbine/tdk/howto/velocity-site-howto.html to
http://jakarta.apache.org/turbine/turbine-2/howto/velocity-site-howto.html


I also second the motion of an earlier post to add some better download
links to the site.


I think that's it.  I hope this helps someone.  It would have helped me.
Brent


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>