Errors with 7.4 Beta

[john doed]

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.





_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail

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