Hi all, I have the connection pool configured so that it changes the DB session. Additionally, I want to put another statement. But I don't know how I can do this. Which separator char is needed? At the moment it looks like the following:
(Init SQL SQL ALTER SESSION SET CURRENT_SCHEMA=anotherschema; SQL ALTER SESSION SET CURSOR_SHARING=SIMILAR
This does *NOT* work! If I remove the second statement and the semicolon it works fine. How can I write it correctly?
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: multiple SQL statements for InitSQL (JDBC pool)