I created the xml from the sql statement and the database element attribute name was set to default:
<database name="default">
I forgot to change this to be
<database name="satprod">.
I'm not sure why this difference would cause an error. The only other place that satprod is a value is in the build.properties file as torque.project. Oh and also in Torque.properties as torque.database.default.
I should probably enter this in scarab.
-Trav
CP Lim wrote:
Travis,
Can you send us the (XML) satellite_instrument table definition? Also have a look at your generated SQL file to make sure your table was generated correctly as well.
cheers,
CP
Travis Stevens wrote:
I'm creating the db-schema.xml file with an sql file that has a series of sql statements. The xml file looks good, but the TablenamePeer.retreiveByPk is not being created. Each table, in the xml, has a primary key defined.
Because of this, when I compile i get errors such as:
[javac] /home/tns/java/torque-3.0-satprod/src/java/gov/noaa/gdsg/satprod/BaseSatelliteInstrument.java:296: cannot resolve symbol
[javac] symbol : method retrieveByPK (org.apache.torque.om.SimpleKey)
[javac] location: class gov.noaa.gdsg.satprod.InstrumentPeer
[javac] aInstrument = InstrumentPeer.retrieveByPK(SimpleKey.keyFor(this.instrument_id));
and indeed in InstrumentPeer, there is not a single retrieveBy method.
any ideas? -Trav
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
