my dog learned polymorphism*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: multiple SQL statements for InitSQL (JDBC pool)
 
Similar Threads
Requesting help in connecting a DataSource(DSSDEV)
how we should return a connection to connectio pool
DBF Alter Table
Resultset order issue
DATE and sysdate