I am trying to use the TDK to create a demo application. I have downloaded
hypersonicSQL to be my database. I have completed all steps on my Windows
system using HypersonicSQL, and on a Linux system using Mysql or hsql. In
any case, I run into the same problem: while running "turbine-project init",
I get a java runtime error when it tries to fire the sql's (see the bottom
of this email).

(One problem I found was the sql's try to use "default=-1" while creating
the schedule table - apparently this is not supported by hypersonicSql. In
any case, I modified the turbine-schema.xml to remove these attributes, but
I still get the same error")

For completeness, here are the steps I followed:

I modified the newapp.props file
    - comment-out the "turbine.app.type=simple"
    - uncomment "turbine.app.type=peer"
    - set "turbine.app.name=clavin"
    - set "target.package=net.etoolbelt.clavin"
    - set "target.directory=net/etoolbelt/clavin"

I then run "newapp clavin"

As instructed, I modify the
webapps/clavin/WEB-INF/build/project/clavin.properties file to connect to my
database:
    database=hypersonic
    databaseUrl =
jdbc:HypersonicSQL:C:/developer/tdk/webapps/clavin/WEB-INF/database/clavin
    databaseDriver = org.hsql.jdbcDriver
    databaseUser = sa
    databasePassword =

I copied the hsql.jar to ../lib. I then modified the build-project.bat file
to find this jar file in the classpath. (This was not in the instructions,
but it fixed my "could not find suitable driver" error)

Now, when I run turbine-project init, I get this output:

create-database:
../src/sql/create-database.sh
     [exec] Result: 255

insert-sql:

insert-sql-file:
      [sql] Executing file:
/developer/tdk/webapps/clavin/WEB-INF/src/sql/turbin
e-schema.sql

BUILD FAILED

java.lang.NullPointerException
        at org.hsql.jdbcResultSet.getColumnName(jdbcResultSet.java:1962)
        at
org.apache.tools.ant.taskdefs.SQLExec.printResults(SQLExec.java:547)
        at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:512)
        at
org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:441)
        at
org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLE
xec.java:613)
        at
org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.
java:592)
        at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:377)
        at org.apache.tools.ant.Target.execute(Target.java:153)
        at org.apache.tools.ant.Project.runTarget(Project.java:898)
        at org.apache.tools.ant.Project.executeTarget(Project.java:536)
        at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:213)
        at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:103)
        at org.apache.tools.ant.Target.execute(Target.java:153)
        at org.apache.tools.ant.Project.runTarget(Project.java:898)
        at org.apache.tools.ant.Project.executeTarget(Project.java:536)
        at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:213)
        at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:103)
        at org.apache.tools.ant.Target.execute(Target.java:153)
        at org.apache.tools.ant.Project.runTarget(Project.java:898)
        at org.apache.tools.ant.Project.executeTarget(Project.java:536)
        at org.apache.tools.ant.Project.executeTargets(Project.java:510)
        at org.apache.tools.ant.Main.runBuild(Main.java:421)
        at org.apache.tools.ant.Main.main(Main.java:149)

Total time: 3 minutes 55 seconds
[root@linux build]#

Other info:
- I find that my database is created
- All the tables are created as defined in the turbine-schema.sql (but no
more)
- In the case of mysql on linux, I found that the password got changed by
the scripts (to what I do not know)

I searched the mail archive and could not find a previous solution.

If I do a clean download from a CVS-nightly-build, do I need both the
TDK.zip *AND* the Turbine.zip, or is one contained within the other?

Thankyou,

Steve B.




------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?:           [EMAIL PROTECTED]

Reply via email to