I gave up getting the tutorial running with Sybase since I do not have the
priviledge to create tables. I had to sit with someone and guide him
through the process. He got very frustrated about all the problems. So I
had him created the internal tables for me and started prototyping with our
existing database tables. Everything seems to be working so far.
Good luck,
Jane
oliver.matz@pp
i.de To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
11/11/2002 Subject: OJB 0.9.7 Tutorials with Sybase
06:43 AM
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>
