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 jdbcadap...@5906027
3328 [WorkerThread5] DEBUG NSLog - connecting with dictionary: {username =
" deleted "; driver = "com.ibm.as400.access.AS400JDBCDriver"; password =
"<password deleted for log>"; URL =
"jdbc:as400://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
jdbccont...@3669284
3476 [WorkerThread5] DEBUG NSLog - connecting with dictionary: {username =
" deleted "; driver = "com.ibm.as400.access.AS400JDBCDriver"; password =
"<password deleted for log>"; URL =
"jdbc:as400://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 jdbcadap...@1837942
[2009-02-10 13:55:55 EST] <WorkerThread0> connecting with dictionary:
{password = "<password deleted for log>"; username = " deleted "; URL =
"jdbc:microsoft:sqlserver://womssql.campbell-ewald.com:1433;databaseName=BWO;SelectMethod=cursor";
}
[2009-02-10 13:55:55 EST] <WorkerThread0> fetching JDBC Info with
jdbccont...@9666080
[2009-02-10 13:55:55 EST] <WorkerThread0> connecting with dictionary:
{password = "<password deleted for log>"; username = " deleted "; URL =
"jdbc:microsoft:sqlserver://womssql.campbell-ewald.com:1433;databaseName=BWO;SelectMethod=cursor";
}
[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 =
"jdbc:microsoft:sqlserver://womssql.campbell-ewald.com:1433;databaseName=BWO;SelectMethod=cursor";
}
[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 (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
