Errors with 7.4 Beta

[john doed]

An added note to problem #1. I have tried playing with the SELECT statement to remove possible ambiguities and still the same problem. I finally started listing the fields 1 by 1 (instead of *), and on the 11th field I get the error (-9111 System Error Move Error). It doesn't matter which field is the 11th field.

I also use UNICODE for many string fields if that helps.


----
I am running into two problems currently with JBDC + 7.4 Beta.

(I am using connection pool also).

1)
This SELECT produces a -9111 System Error - Move Error
--
SELECT * FROM FOOTPRINTS_ONLINE WHERE (updated>'2003-01-10 00:29:00.061') AND (fpo_id IN (SELECT fpo_id FROM OPS_FPO_WORKLOAD WHERE op_id=1 AND master_id=1)) ORDER BY created ASC
--
As you can see I am using 2 WHERE conditions. If I only have 1 condition (it doesnt matter which one) it will work. If I substitute one condition with ANY other field in that table it will work. But having those exact two conditions causes this error. Why?

2)
When executing my app, it's first session with the SAPDB produces SQLExceptions errors (this is normal because the SQL has not been converted from Postgresql), however the 2nd attempt by my App will give me a "connection refused error". I have to restart the database before I can try again.

Now I have commented out my code so I only produce 1 Exception, and I dont have to restart the database.

Your feedback is appreciated, thanks.





_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general