WOLips and Database Connections
WOLips and Database Connections
- Subject: WOLips and Database Connections
- From: Ron Lift <email@hidden>
- Date: Tue, 10 Feb 2009 14:36:20 -0500
We are migrating from Xcode to Eclipse and WOLips. When we connect to our iSeries database, I get 2 connections. 1 connection is labeled JDBC plugin and 1 is labeled JDBC info. I have created a new application in Eclipse w/o project wonder and with one database fetch and without any connection dictionary overrides. I have 2 connection in the log and on the server
3327 [WorkerThread5] DEBUG NSLog - Using JDBCPlugIn 'com.webobjects.jdbcadaptor.As400PlugIn' for JDBCAdaptor@5906027
3328 [WorkerThread5] DEBUG NSLog - connecting with dictionary: {username = " deleted "; driver = "com.ibm.as400.access.AS400JDBCDriver"; password = "<password deleted for log>"; URL = "" href="http://iSeries.campbell-ewald.com">iSeries.campbell-ewald.com;transaction isolation=none;libraries=##pfprod,pdpfprod,pdppprod,acpfacc,utpfutilty,acppacc,qtemp;prompt=false;date format=iso;time format=iso;"; }
3476 [WorkerThread5] DEBUG NSLog - fetching JDBC Info with JDBCContext@3669284
3476 [WorkerThread5] DEBUG NSLog - connecting with dictionary: {username = " deleted "; driver = "com.ibm.as400.access.AS400JDBCDriver"; password = "<password deleted for log>"; URL = "" href="http://iSeries.campbell-ewald.com">iSeries.campbell-ewald.com;transaction isolation=none;libraries=##pfprod,pdpfprod,pdppprod,acpfacc,utpfutilty,acppacc,qtemp;prompt=false;date format=iso;time format=iso;"; }
3788 [WorkerThread5] DEBUG NSLog - === Begin Internal Transaction
3788 [WorkerThread5] DEBUG NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.JDBCExpression: "SELECT t0.UGAPPGRP, t0.UGCOMPANY, t0.UGDESC, t0.UGGRPLR, t0.UGSEQ FROM UTPFUTILTY.UTBADGRP t0 WHERE (t0.UGCOMPANY = ? AND t0.UGGRPLR = ?) ORDER BY t0.UGSEQ ASC" withBindings: 1:30(ugcompany), 2:"C"(uggrplr)>
3982 [WorkerThread5] DEBUG NSLog - 0 row(s) processed
I connect to a MSSQL database and get this in my log
[2009-02-10 13:55:55 EST] <WorkerThread0> Using JDBCPlugIn 'com.webobjects.jdbcadaptor.MicrosoftPlugIn' for JDBCAdaptor@1837942
[2009-02-10 13:55:55 EST] <WorkerThread0> connecting with dictionary: {password = "<password deleted for log>"; username = " deleted "; URL = "" }
[2009-02-10 13:55:55 EST] <WorkerThread0> fetching JDBC Info with JDBCContext@9666080
[2009-02-10 13:55:55 EST] <WorkerThread0> connecting with dictionary: {password = "<password deleted for log>"; username = " deleted "; URL = "" }
[2009-02-10 13:55:55 EST] <WorkerThread0> fetched MS SQL Server (Microsoft) JDBC Info = {NON_NULLABLE_COLUMNS = "T"; DRIVER_NAME = "SQLServer"; DBMS_NAME = "Microsoft SQL Server"; typeInfo = {money = {defaultJDBCType = ("DECIMAL"); createParams = "0"; maxScale = "4"; minScale = "4"; isNullable = "T"; isSearchable = "T"; precision = "19"; }; binary = {createParams = "1"; isNullable = "T"; isSearchable = "T"; precision = "8000"; defaultJDBCType = ("BINARY"); }; smalldatetime = {defaultJDBCType = ("TIMESTAMP"); createParams = "0"; maxScale = "0"; minScale = "0"; isNullable = "T"; isSearchable = "T"; precision = "16"; }; smallint = {defaultJDBCType = ("SMALLINT"); createParams = "0"; maxScale = "0"; minScale = "0"; isNullable = "T"; isSearchable = "T"; precision = "5"; }; bit = {defaultJDBCType = ("BIT"); createParams = "0"; maxScale = "0"; minScale = "0"; isNullable = "T"; isSearchable = "T"; precision = "1"; }; decimal = {defaultJDBCType = ("DECIMAL"); createParams = "2"; maxScale = "38"; minScale = "0"; isNullable = "T"; isSearchable = "T"; precision = "38"; }; numeric = {defaultJDBCType = ("NUMERIC"); createParams = "2"; maxScale = "38"; minScale = "0"; isNullable = "T"; isSearchable = "T"; precision = "38"; }; char = {createParams = "1"; isNullable = "T"; isSearchable = "T"; precision = "8000"; defaultJDBCType = ("CHAR"); }; sysname = {createParams = "0"; defaultJDBCType = ("VARCHAR"); isNullable = "F"; isSearchable = "T"; precision = "128"; }; smallmoney = {defaultJDBCType = ("DECIMAL"); createParams = "2"; maxScale = "4"; minScale = "4"; isNullable = "T"; isSearchable = "T"; precision = "10"; }; image = {createParams = "0"; isNullable = "T"; isSearchable = "F"; precision = "2147483647"; defaultJDBCType = ("LONG VARBINARY"); }; float = {createParams = "0"; isNullable = "T"; isSearchable = "T"; precision = "53"; defaultJDBCType = ("FLOAT"); }; tinyint = {defaultJDBCType = ("TINYINT"); createParams = "0"; maxScale = "0"; minScale = "0"; isNullable = "T"; isSearchable = "T"; precision = "3"; }; real = {createParams = "0"; isNullable = "T"; isSearchable = "T"; precision = "24"; defaultJDBCType = ("REAL"); }; timestamp = {createParams = "0"; isNullable = "F"; isSearchable = "T"; precision = "8"; defaultJDBCType = ("BINARY"); }; int = {defaultJDBCType = ("INTEGER"); createParams = "0"; maxScale = "0"; minScale = "0"; isNullable = "T"; isSearchable = "T"; precision = "10"; }; varbinary = {createParams = "1"; isNullable = "T"; isSearchable = "T"; precision = "8000"; defaultJDBCType = ("VARBINARY"); }; text = {createParams = "0"; isNullable = "T"; isSearchable = "F"; precision = "2147483647"; defaultJDBCType = ("LONG VARCHAR"); }; bigint = {defaultJDBCType = ("BIGINT"); createParams = "0"; maxScale = "0"; minScale = "0"; isNullable = "T"; isSearchable = "T"; precision = "19"; }; uniqueidentifier = {createParams = "1"; isNullable = "T"; isSearchable = "T"; precision = "36"; defaultJDBCType = ("CHAR"); }; datetime = {defaultJDBCType = ("TIMESTAMP"); createParams = "0"; maxScale = "3"; minScale = "3"; isNullable = "T"; isSearchable = "T"; precision = "23"; }; varchar = {createParams = "1"; isNullable = "T"; isSearchable = "T"; precision = "8000"; defaultJDBCType = ("VARCHAR"); }; }; IDENTIFIER_QUOTE_STRING = """; ANSI92_CONFORMANCE = "ANSI92EntryLevel"; DRIVER_VER = "2.2.0029"; STRING_FUNCTIONS = "ascii,concat,difference,left,length,lcase,ltrim,repeat,right,rtrim,soundex,space,substring,ucase,char"; }
[2009-02-10 13:55:55 EST] <WorkerThread0> === Begin Internal Transaction
[2009-02-10 13:55:55 EST] <WorkerThread0> evaluateExpression: <com.webobjects.jdbcadaptor.MicrosoftPlugIn$MicrosoftExpression: "SELECT t0.Application, RTRIM(t0.BWOMedium), t0.BWONumber, RTRIM(t0.CampaignCode), t0.CompanyNumber, t0.Content, t0.EmployeeCompany, t0.EmployeeNumber, t0.Extension, t0.FileName, t0.FilePath, t0.FileSize, t0.ID, t0.IsciCreateDate, RTRIM(t0.ISCINumber), t0.LastUpdateDate, RTRIM(t0.LastUpdateID), t0.LastUpdateTimestamp, t0.WorkOrderNumber FROM dbo.BWOScripts t0">
[2009-02-10 13:55:55 EST] <WorkerThread0> === Rollback Internal Transaction
[2009-02-10 13:55:55 EST] <WorkerThread0> connection disconnected.
[2009-02-10 13:55:55 EST] <WorkerThread0> connection disconnected.
[2009-02-10 13:55:55 EST] <WorkerThread0> connecting with dictionary: {password = "<password deleted for log>"; username = "user"; URL = "" }
[2009-02-10 13:55:55 EST] <WorkerThread0> === Begin Internal Transaction
[2009-02-10 13:55:55 EST] <WorkerThread0> evaluateExpression: <com.webobjects.jdbcadaptor.MicrosoftPlugIn$MicrosoftExpression: "SELECT t0.Application, RTRIM(t0.BWOMedium), t0.BWONumber, RTRIM(t0.CampaignCode), t0.CompanyNumber, t0.Content, t0.EmployeeCompany, t0.EmployeeNumber, t0.Extension, t0.FileName, t0.FilePath, t0.FileSize, t0.ID, t0.IsciCreateDate, RTRIM(t0.ISCINumber), t0.LastUpdateDate, RTRIM(t0.LastUpdateID),
The MSSQL connection is getting the database info and disconnecting. I do not see this in the log for the iSeries connection. The iSeries is our application database. If I run the same code in WebObjects on OSX 10.4, WO 5.3, I only have 1 connection. These extra connections will add up for the number of applications and users we have. How can I have the application only create one connection
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden