Hello,

I am currently trying to let the tutorial examples run against a Sybase
backend.
I have seen a similar posting by mailto:jane_jiang@;freddiemac.com, but no
reply.

Here are my problems:

1. the target project-datasql-classpath results in

   [torque-datasql] Error Line: 128 Row: 11 Msg: The content of element type
"dataset" must match
"(Article*,Books*,Cds*,ProductGroup*,OrderPosition*,Tree*,Treegroup*,AbTable
*,Product*,Person*,Project*,Task*,PersonProject*,FamilyMember*,LockedByVersi
on*,LockedByTimestamp*,BlobTest*,MdtestMaster*,MdtestDetailFkinpk*,MdtestDet
ailFknopk*,GraphNode*,GraphEdge*,Point*)".

2. the target torque-insert-sql fails because the column "Einzelpreis" in
src/sql/ojbtest-schema.sql
   misses a datatype. I tried to modify the file
src/schema/ojbtest-schema.xml and made those columns type "NUMERIC". 
   Then that target fails because of 3.

3.  the column "TIMESTAMP_" in table "OJB_LOCKENTRY" misses a datatype.

4. (also with the above modifcation):
 
[torque-insert-sql] Failed to execute: INSERT INTO Artikel
(Artikel_Nr,Artikelname,Lieferanten_Nr,Kategorie_Nr,Liefereinheit,Einzelprei
s,Lagerbestand,BestellteEinheiten,MindestBestand,Auslaufartikel) VALUES
1,'Chai',1,1,'10 boxes x 20 bags',18.53,39,0,10,0)
[torque-insert-sql] com.sybase.jdbc2.jdbc.SybSQLException: Scale error
during im
plicit conversion of NUMERIC value '18.53' to a NUMERIC field.


Can anybody help me?  Thank you in advance.

Oliver

-- 
  Dr. Oliver Matz
  ppi Media GmbH
  Deliusstra�e 10
  D-24114 Kiel
  phone +49 (0) 43 1-53 53-422
  fax           +49 (0) 43 1-53 53-2 22
  email mailto:oliver.matz@;ppi.de
  web   www.ppi.de



--
To unsubscribe, e-mail:   <mailto:ojb-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>

Reply via email to