Pete Kazmier wrote:
>
> I should be done with the tutorial in the next few days. Hopefully that
> will answer your question. In the meantime, the save() method
> eventually calls doInsert() or doUpdate() (depending if the object has
> been modified), so its redundant to call the doInsert() yourself.
>
> Check out the tutorial again, I have a lot of it done, if you follow
> those configuration tasks I outlined, then you should not have a problem
> with your application. I have been able to run my sample appliaction
> (the one that will be included in the tutorial).
>
> If you still can't get it working, feel free to mail me your
> build.properties file, Torque.properties file, and your schema and I'd
> be happy to take a peek.
>
> Thanks,
> Pete
I followed the steps in your email to save the data in my table. I also
checked
out the tutorial. But it still doesn't work. So here are my files:
My test class DBTest.java:
package org.openscience.nmrshiftdb;
import org.apache.torque.Torque;
import org.apache.torque.util.Criteria;
import java.util.Vector;
public class DBTest
{
public static void main(String args[])
{
Contributor con = new Contributor();
con.setFirstName("firstname");
con.setLastName("lastname");
try
{
Torque.init("/home/stefan/dev/nmrshiftdb/schema/Torque.properties");
con.save();
}
catch (Exception exc)
{
}
}
}
It compiles without errors. By running I get this error message:
run:
[java] log4j:ERROR Could not instantiate class
[org.apache.log4j.FileAppender,org.apache.log4j.FileAppender].
[java] java.lang.ClassNotFoundException:
org/apache/log4j/FileAppender,org/apache/log4j/FileAppender
[java] at java.lang.Class.forName0(Native Method)
[java] at java.lang.Class.forName(Class.java:120)
[java] at
org.apache.log4j.helpers.OptionConverter.instantiateByClassName(OptionConverter.java:301)
[java] at
org.apache.log4j.helpers.OptionConverter.instantiateByKey(OptionConverter.java:116)
[java] at
org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:612)
[java] at
org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:595)
[java] at
org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfigurator.java:502)
[java] at
org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:410)
[java] at
org.apache.log4j.PropertyConfigurator.configure(PropertyConfigurator.java:341)
[java] at
org.apache.torque.Torque.configureLogging(Torque.java:306)
[java] at org.apache.torque.Torque.init(Torque.java:177)
[java] at org.apache.torque.Torque.init(Torque.java:156)
[java] at org.openscience.nmrshiftdb.DBTest.main(DBTest.java:27)
[java] log4j:ERROR Could not instantiate appender named "default".
[java] log4j:ERROR Could not instantiate class
[org.apache.log4j.FileAppender,org.apache.log4j.FileAppender].
[java] java.lang.ClassNotFoundException:
org/apache/log4j/FileAppender,org/apache/log4j/FileAppender
[java] at java.lang.Class.forName0(Native Method)
[java] at java.lang.Class.forName(Class.java:120)
[java] at
org.apache.log4j.helpers.OptionConverter.instantiateByClassName(OptionConverter.java:301)
[java] at
org.apache.log4j.helpers.OptionConverter.instantiateByKey(OptionConverter.java:116)
[java] at
org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:612)
[java] at
org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:595)
[java] at
org.apache.log4j.PropertyConfigurator.parseCatsAndRenderers(PropertyConfigurator.java:522)
[java] at
org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:412)
[java] at
org.apache.log4j.PropertyConfigurator.configure(PropertyConfigurator.java:341)
[java] at
org.apache.torque.Torque.configureLogging(Torque.java:306)
[java] at org.apache.torque.Torque.init(Torque.java:177)
[java] at org.apache.torque.Torque.init(Torque.java:156)
[java] at org.openscience.nmrshiftdb.DBTest.main(DBTest.java:27)
[java] log4j:ERROR Could not instantiate appender named "default".
The build.properties file:
project = nmrshiftdb
database = mysql
targetPackage=org.openscience.nmrshiftdb
basePrefix=Base
addSaveMethod=true
addGetByNameMethod=true
complexObjectModel=true
addTimeStamp=true
addIntakeRetrievable=false
createDatabaseUrl = jdbc:mysql://127.0.0.1/mysql
databaseUrl = jdbc:mysql://127.0.0.1/nmrshiftdb
databaseDriver = org.gjt.mm.mysql.Driver
databaseUser = turbine
databasePassword = turbine
databaseHost = 127.0.0.1
sameJavaName=false
documentationFormat=html
templatePath = templates
SQLControlTemplate = sql/base/Control.vm
OMControlTemplate = om/Control.vm
idTableControlTemplate = sql/id-table/Control.vm
DataDTDControlTemplate = data/Control.vm
DataDumpControlTemplate = data/dump/Control.vm
DataSQLControlTemplate = sql/load/Control.vm
DocControlTemplate = doc/Control.vm
outputDirectory=src
schemaDirectory=schema
The torque.properties file:
log4j.category.default = ALL, default
log4j.appender.default = org.apache.log4j.FileAppender
log4j.appender.default.file = ./torque.log
log4j.appender.default.layout = org.apache.log4j.PatternLayout
log4j.appender.default.layout.conversionPattern = %d [%t] %-5p %c - %m%n
log4j.appender.default.append = false
log4j.category.org.apache.torque = ALL, org.apache.torque
log4j.appender.org.apache.torque = org.apache.log4j.FileAppender
log4j.appender.org.apache.torque.file = ./turbine.log
log4j.appender.org.apache.torque.layout = org.apache.log4j.PatternLayout
log4j.appender.org.apache.torque.layout.conversionPattern = %d [%t] %-5p
%c - %m%n
log4j.appender.org.apache.torque.append = false
log4j.category.sql = DEBUG, sql
log4j.appender.sql = org.apache.log4j.FileAppender
log4j.appender.sql.file = ./sql.log
log4j.appender.sql.layout = org.apache.log4j.PatternLayout
log4j.appender.sql.layout.conversionPattern = %d [%t] %-5p %c - %m%n
log4j.appender.sql.append = false
log4j.rootCategory = DEBUG, default
log4j.appender.default = org.apache.log4j.FileAppender
log4j.appender.default.file = ./torque.log
log4j.appender.default.layout = org.apache.log4j.SimpleLayout
log4j.rootCategory = DEBUG, default
log4j.appender.default = org.apache.log4j.FileAppender
log4j.appender.default.file = ./torque.log
log4j.appender.default.layout = org.apache.log4j.SimpleLayout
torque.database.default=nmrshiftdb
torque.earlyInit = true
torque.database.default=nmrshiftdb
torque.database.nmrshiftdb.driver = org.gjt.mm.mysql.Driver
torque.database.nmrshiftdb.url = jdbc:mysql://127.0.0.1/nmrshiftdb
torque.database.nmrshiftdb.username = turbine
torque.database.nmrshiftdb.password = turbine
torque.database.default.maxConnections=80
torque.database.default.expiryTime=3600000
torque.database.default.connectionWaitTimeout=10000
torque.database.logInterval=0
torque.database.adapter=DBOdbc, DBMM
torque.database.adapter.DBOdbc=sun.jdbc.odbc.JdbcOdbcDriver
torque.database.adapter.DBMM=
torque.database.adapter.DBMM=org.gjt.mm.mysql.Driver
torque.database.idbroker.cleverquantity=true
The nmrshiftdb-schema.xml file:
<?xml version="1.0" encoding="ISO-8859-1" standalone="no" ?>
<!DOCTYPE database SYSTEM
"http://jakarta.apache.org/turbine/dtd/database.dtd";>
<database name="nmrshiftdb" defaultIdMethod="idbroker">
<table name="CONTRIBUTOR">
<column name="CONTRIBUTOR_ID" required="true" primaryKey="true"
type="INTEGER" javaName="Id"/>
<column name="FIRST_NAME" required="true" type="LONGVARCHAR"/>
<column name="LAST_NAME" required="true" type="LONGVARCHAR"/>
</table>
<table name="CHEMICALNAME">
<column name="CHEMICALNAME_ID" required="true" primaryKey="true"
type="INTEGER"/>
<column name="NAME" required="true" type="LONGVARCHAR"/>
</table>
</database>
I would be grateful for an advice.
Thanks in advance.
Stefan
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
