Re: JDBC connectivity

First error is security 
lotus.notes.AgentSecurityManager.checkConnect(AgentSecurityManager.java:172)

Check your Server Document, Security TAB for "run unrestricted methods and 
operations".
Make sure you sign the agent with an id that has proper access by adding 
that name to this group.
Restart the server and retry the connection. 

Also did you set all of the properties correctly?
I see several null values to could be set. 

Good Luck.

Sean 




domino400-request@xxxxxxxxxxxx 
Sent by: domino400-bounces+seanmurphy=bedbath.com@xxxxxxxxxxxx
01/09/2006 03:15 PM
Please respond to
domino400@xxxxxxxxxxxx


To
domino400@xxxxxxxxxxxx
cc

Subject
Domino400 Digest, Vol 4, Issue 6






Send Domino400 mailing list submissions to
                 domino400@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
                 http://lists.midrange.com/mailman/listinfo/domino400
or, via email, send a message with subject or body 'help' to
                 domino400-request@xxxxxxxxxxxx

You can reach the person managing the list at
                 domino400-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Domino400 digest..."


Today's Topics:

   1. JDBC connectivity (Robert Laing)
   2. Re: JDBC connectivity (rob@xxxxxxxxx)
   3. Re: JDBC connectivity (Walter Scanlan)
   4. Re: i5/OS Single Logon (GKern@xxxxxxxxxxxxxxxx)


----------------------------------------------------------------------

message: 1
date: Mon, 9 Jan 2006 14:03:00 -0500
from: Robert Laing <rlaing@xxxxxxxxx>
subject: JDBC connectivity

This question might not be quite appropriate for this forum but I'm 
running
out of ideas and thought the collective iSeries knowledge on this forum 
may
have some ideas...

Domino server 6.5.4 running on a W2K box.  iSeries v5r3 with the latest
CUM, HiPer, DB2 & Java ptf's.

I've created an agent that reads from an iSeries PF and updates a Domino
database.  The agent uses the AS/400 for Java JDBC driver.  I can run this
agent from my Notes client on a Win XP box and it runs fine.  I set this
same agent to run scheduled on the server and it blows up without being
able to connect to the iSeries.  Domino server, iSeries and desktop are on
the same subnet with no firewall in the picture anywhere.  Below is the
trace information.  If anyone has any suggestions please let me know...

import LNPCQ100 into products.nsf agent started
as400: Properties (1910243863) : access = "all".
as400: Properties (1910243863) : block size = "32".
as400: Properties (1910243863) : block criteria = "2".
as400: Properties (1910243863) : date format = "".
as400: Properties (1910243863) : date separator = "".
as400: Properties (1910243863) : decimal separator = "".
as400: Properties (1910243863) : errors = "basic".
as400: Properties (1910243863) : extended dynamic = "false".
as400: Properties (1910243863) : libraries = "".
as400: Properties (1910243863) : naming = "sql".
as400: Properties (1910243863) : package = "".
as400: Properties (1910243863) : package add = "true".
as400: Properties (1910243863) : package cache = "false".
as400: Properties (1910243863) : package clear = "false".
as400: Properties (1910243863) : package error = "warning".
as400: Properties (1910243863) : package library = "".
as400: Properties (1910243863) : password = "".
as400: Properties (1910243863) : prefetch = "true".
as400: Properties (1910243863) : prompt = "".
as400: Properties (1910243863) : remarks = "system".
as400: Properties (1910243863) : sort = "job".
as400: Properties (1910243863) : sort language = "ENU".
as400: Properties (1910243863) : sort table = "".
as400: Properties (1910243863) : sort weight = "shared".
as400: Properties (1910243863) : time format = "".
as400: Properties (1910243863) : time separator = "".
as400: Properties (1910243863) : trace = "false".
as400: Properties (1910243863) : transaction isolation = "read
uncommitted".
as400: Properties (1910243863) : translate binary = "false".
as400: Properties (1910243863) : user = "xxxxxxxx".
as400: Properties (1910243863) : package criteria = "default".
as400: Properties (1910243863) : lob threshold = "32768".
as400: Properties (1910243863) : secure = "false".
as400: Properties (1910243863) : data truncation = "true".
as400: Properties (1910243863) : proxy server = "".
as400: Properties (1910243863) : secondary URL = "".
as400: Properties (1910243863) : data compression = "true".
as400: Properties (1910243863) : big decimal = "true".
as400: Properties (1910243863) : thread used = "true".
as400: Properties (1910243863) : cursor hold = "true".
as400: Properties (1910243863) : lazy close = "false".
as400: Properties (1910243863) : driver = "toolbox".
as400: Properties (1910243863) : bidi string type = "".
as400: Properties (1910243863) : key ring name = "".
as400: Properties (1910243863) : key ring password = "".
as400: Properties (1910243863) : full open = "false".
as400: Properties (1910243863) : server trace = "0".
as400: Properties (1910243863) : database name = "".
as400: Properties (1910243863) : extended metadata = "false".
as400: Properties (1910243863) : cursor sensitivity = "asensitive".
as400: Properties (1910243863) : behavior override = "0".
as400: Properties (1910243863) : package ccsid = "13488".
as400: Properties (1910243863) : minimum divide scale = "0".
as400: Properties (1910243863) : maximum precision = "31".
as400: Properties (1910243863) : maximum scale = "31".
as400: Properties (1910243863) : translate hex = "character".
as400: Properties (1910243863) : toolbox trace = "".
as400: Properties (1910243863) : qaqqinilib = "".
as400: Properties (1910243863) : login timeout = "".
as400: Properties (1910243863) : true autocommit = "false".
as400: Properties (1910243863) : bidi implicit reordering = "true".
as400: Properties (1910243863) : bidi numeric ordering = "false".
as400: Properties (1910243863) : hold input locators = "true".
as400: Properties (1910243863) : hold statements = "false".
as400: Properties (1910243863) : rollback cursor hold = "false".
as400: Properties (1910243863) : variable field compression = "true".
as400: Properties (1910243863) : query optimize goal = "0".
as400: Driver AS/400 Toolbox for Java JDBC Driver (1789510167) : Using IBM
Toolbox for Java JDBC driver implementation.
Getting system property: 'com.ibm.as400.access.AS400.proxyServer'
Value found in jt400.properties file: 'null'
Value not found.
Detected os.name: Windows 2000 (unknown)
Getting system property: 'com.ibm.as400.access.AS400.signonHandler'
Value found in jt400.properties file: 'null'
Value not found.
Getting NLV.
NLV Locale: en_US
NLV for Locale: en, NLV: 2924
Constructing AS400 object, system name: '15.15.15.40' user ID: 'xxxxxxxx'
Getting system property: 'com.ibm.as400.access.AS400.proxyServer'
Value found in jt400.properties file: 'null'
Value not found.
Checking for multiple Toolbox versions.
Connecting service: 4
Checking for multiple Toolbox versions.
Setting up AS400 implementation object:
Enable SSL connections: null
Native optimizations allowed: false
Use threaded communications: true
User specified CCSID: 0
NLV: 2924
Socket properties: com.ibm.as400.access.SocketProperties@2cac4217
DDM RDB: null
User ID: 'xxxxxxxx'
Validate security...
Signing-on without prompting...
Opening a socket to verify security...
Connecting to port mapper...
error message: java.lang.SecurityException: 15.15.15.40,449
error message: at
lotus.notes.AgentSecurityManager.checkConnect(AgentSecurityManager.java:172)

error message: at java.net.Socket.<init>(Socket.java:283)
error message: at java.net.Socket.<init>(Socket.java:121)
error message: at
com.ibm.as400.access.PortMapper.getServerSocket(PortMapper.java:141)
error message: at
com.ibm.as400.access.AS400ImplRemote.signonConnect(AS400ImplRemote.java:1849)

error message: at
com.ibm.as400.access.AS400ImplRemote.signon(AS400ImplRemote.java:1749)
error message: at
com.ibm.as400.access.AS400.sendSignonRequest(AS400.java:2534)
error message: at com.ibm.as400.access.AS400.promptSignon(AS400.java:2126)
error message: at com.ibm.as400.access.AS400.signon(AS400.java:3336)
error message: at 
com.ibm.as400.access.AS400.connectService(AS400.java:853)
error message: at
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:2789)

error message: at
com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:1212)

error message: at
com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:1103)

error message: at
com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:355)
error message: at
java.sql.DriverManager.getConnection(DriverManager.java:543)
error message: at
java.sql.DriverManager.getConnection(DriverManager.java:194)
error message: at
ConnectionManager.getConnection(ConnectionManager.java:21)
error message: at JavaAgent.NotesMain(JavaAgent.java:50)
error message: at lotus.domino.AgentBase.runNotes(Unknown Source)
error message: at lotus.domino.NotesThread.run(NotesThread.java:218)
import LNPCQ100 into products.nsf agent completed.



------------------------------

message: 2
date: Mon, 9 Jan 2006 14:11:50 -0500
from: rob@xxxxxxxxx
subject: Re: JDBC connectivity

Not Domino related, per se, however we contracted Joe Pluta to do some 
JDBC work for us (updating SQL Server data with DB2 data using RPG to call 

JDBC).  He might be able to determine the JDBC issue.  He frequents 
midrange-l and the rpg list.

Rob Berendt