agora inbox for pljava-dev@postgresql.orghelp / color / mirror / Atom feed
[Pljava-dev] Limitation in statement parameters 3+ messages / 0 participants [nested] [flat]
* [Pljava-dev] Limitation in statement parameters @ 2004-08-11 09:23 2004-08-11 09:31 ` [Pljava-dev] Limitation in statement parameters 2004-08-17 06:03 ` [Pljava-dev] Limitation in statement parameters 0 siblings, 2 replies; 3+ messages in thread From: @ 2004-08-11 09:23 UTC (permalink / raw) Hi Thomas, We are very interested on your pl/java product. We've succesfully imported our Oracle java stored procedure into Postgresql pl/java. We found noly some limitation on your code, not very critical since it is open-source. I will get straight to the problem. In SPIconnection the translation from JDBC statement to postgresql statement can't have more than 10 paramenters due to the use of single char. You will get "$:" instead of "$10" and so on. Another little thing, in Oracle we use "jdbc:default:connection:" not "jdbc:default:connection". It's similar but not the same. It wasn't simple to notice this "little" difference due to the "No suitable driver" error. Of course i was using the latest CVS version since we succesfully compiled and installed it. But we commented out the EOXactregister/unregister reference since it was unreferenced in resulting libpljava.so. We use use RH9, Postgresql 7.4.3 and JSDK1.4.2. We look forward for the new release and appreciate your good work. regards Mario Pandolfi Octotelematics Srl Via Veneto, 7 Rome Italy ^ permalink raw reply [nested|flat] 3+ messages in thread
* [Pljava-dev] Limitation in statement parameters 2004-08-11 09:23 [Pljava-dev] Limitation in statement parameters @ 2004-08-11 09:31 ` 1 sibling, 0 replies; 3+ messages in thread From: @ 2004-08-11 09:31 UTC (permalink / raw) Hi Mario, > We are very interested on your pl/java product. > We've succesfully imported our Oracle java stored procedure into > Postgresql > pl/java. > Cool. This is good news. > In SPIconnection the translation from JDBC statement to postgresql > statement > can't have more than 10 paramenters due to the use of single char. > You will get "$:" instead of "$10" and so on. > Ouch! I'll fix that promptly. > Another little thing, in Oracle we use "jdbc:default:connection:" not > "jdbc:default:connection". > It's similar but not the same. > Ok, it will be easy enough to allow both. I'll fix that too. > But we commented out the EOXactregister/unregister reference since it was > unreferenced in resulting libpljava.so. > Yes, I discovered that yesterday evening. The latest CVS contains work that is intended for 8.0. I will fix it for 7.4 soon. Meanwhile, if you want to play around with the latest and greatest, you need a PostgreSQL 8.0 beta. Using it, you will benefit from new features such as the ability to configure the JVM from the postgresql.conf or via SET commands (through custom configuration variables). It also has much improved exception handling. > We use use RH9, Postgresql 7.4.3 and JSDK1.4.2. > > We look forward for the new release and appreciate your good work. > Thanks a lot. It's always encouraging to hear positive news. Regards, Thomas Hallgren ^ permalink raw reply [nested|flat] 3+ messages in thread
* [Pljava-dev] Limitation in statement parameters 2004-08-11 09:23 [Pljava-dev] Limitation in statement parameters @ 2004-08-17 06:03 ` 1 sibling, 0 replies; 3+ messages in thread From: @ 2004-08-17 06:03 UTC (permalink / raw) Mario, You reported three problems: 1. Parameter limitation due to the use of single char (entered as bug #907) 2. Default connection string cannot have ending colon (entered as bug #908) 3. Unreferenced symbols when using PostgreSQL 7.4.3 Since I know that you compiled from CVS HEAD earlier, I though I'd inform you that I've delivered fixes to all your issues. Please let me know if you run into any other problems. Regards, Thomas Hallgren ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-08-17 06:03 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-08-11 09:23 [Pljava-dev] Limitation in statement parameters 2004-08-11 09:31 ` 2004-08-17 06:03 `
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox