Hi Ivan, I can say for SQL-Server that there is a default schema but this might not necessarily be the database schema you want to work with. Hence you need to select the database using USE [xyz] in order to access the correct database schema. This might not be necessary if the default schema for the connecting user has already been set correctly.
Also the date format is set to make sure, that the order of day, month and year corresponds to our internal representation, in case it differs. This needs to be done for every connection unless you can make sure, that the connections already has all required settings. So the best way would be to check your user settings in the database first and check whether when you connect you already access the correct db schema. If this is the case, then there is no need to execute the statements. You might derive your own class from your preferred database driver and then use this to skip this or implement your own logic. Regards, Rainer ------------------------------------------------------------------- > from: Ivan Nemeth [mailto:[email protected]] > to: [email protected] > re: DBDatabase.open() question > > Hi guys, > > I have a question about DBDatabase.open() method. It sets the driver for the > db and calls the driver's attachDatabase method which in most cases does > nothing . But in case of MSSQL and MySql driver it executes some > initialization SQL (*). We use a connection pool and a singleton DBDatabase > instance, which is opened only once when the app is initialized. So this > initialization script is executed only for the first connection. > > So what is the purpose of this initialization SQL? Is it necessary, and if > yes, in case of a connection pool the DBDatabase should be open for every new > connection? > > Regards, > Ivan > > * it sets the database to use (USE DATABASE...) and the date format
