aspose file tools*
The moose likes BEA/Weblogic and the fly likes multiple SQL statements for InitSQL (JDBC pool) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "multiple SQL statements for InitSQL (JDBC pool)" Watch "multiple SQL statements for InitSQL (JDBC pool)" New topic
Author

multiple SQL statements for InitSQL (JDBC pool)

R. Heydenreich
Greenhorn

Joined: Nov 20, 2006
Posts: 13
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?

TIA,
Ralf.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: multiple SQL statements for InitSQL (JDBC pool)
 
Similar Threads
how we should return a connection to connectio pool
Resultset order issue
DATE and sysdate
DBF Alter Table
Requesting help in connecting a DataSource(DSSDEV)