Re: [Info-Ingres] jdbc connection problem
- From: "Paul White" <shift7solutions@xxxxxxxxx>
- Date: Tue, 11 Sep 2007 22:09:21 +1000
Hi Marty,
The scripting worked very well for OR41sp3 and for OR2006. The installation
script worked similarly for Ingres net but I can't find an example.
Initially you run a setup on a clean machine with the script recording
option turned on. Then distribute the script with a DOS batch file and the
regular install package.
Record the script.
x:\or2006\setup -r -f1c:\or2006.rsp
Replay the script on a clean machine.
x:\or2006\setup -n -s -f1c:\script1.rsp
Our DOS install wrapper includes commands to set ingres environment, copying
and registering DLLS, install dotnet framework, creating vnodes and copying
icons to the desktop. vnode.exe is compiled to hide the password from
users. It uses standard netutil command line functions.
I obtained mixed results where there was already an installation present
because the script did not expect upgrade prompts. When doing an re-install,
we often had to uninstall and reboot to clear memory. We created a simple
script to popup a "press anykey to reboot" message, then auto reboot and run
the installation script automatically on startup so the tech staff could go
and get coffee.
There was a limitation that the script had to reside on the C:\ directory.
We did not have a script for patches.
Here are two top level scripts. It should give you something to start on.
--- InstallPeercore.bat ----------------
c:\
@echo starting OpenROAD installation
@echo map network drives
net use x: \\myserver\peercore
@echo copy script files
copy x:\ing\s2006.rsp c:\script1.rsp
@echo run installations
x:\or2006\setup -n -s -f1c:\script1.rsp
@echo set system paths
set
"PATH=%path%;C:\IngresII\ingres\bin;C:\IngresII\ingres\utility;C:\IngresII\i
ngres\vdba "
@echo set system variable
set "II_SYSTEM=c:\ingresII"
@echo call ing.bat
call x:\ing\ing.bat
--- ing.bat inserted here for readability --------------------------
@echo copy custom keyboardmap and colour tables
copy x:\ing\files\*.* %II_SYSTEM%\ingres\files
@echo Set ingres environment variables
ingsetenv II_LIBU3GL
"kernel32.dll;user32.dll;gdi32.dll;advapi32.dll;comdlg.dll;ntdll.dll;msvcrt.
dll"
rem %II_SYSTEM%\ingres\bin\ingsetenv II_W4GL_CACHE_LIMIT "16000000"
ingsetenv II_DATE_CENTURY_BOUNDARY "50"
ingsetenv II_DATE_FORMAT MULTINATIONAL
ingunset II_COLORTABLE_FILE
ingsetenv II_COLORTABLE peerless
ingunset II_KEYBOARD_FILE
ingsetenv II_KEYBOARD w4gl3acc
ingsetenv II_W4GLRUN_LICENSE SERVER
ingsetenv ING_SET "set lockmode session where readlock = nolock, timeout =
30"
@echo timezone patch
iizic -v %installdir%\ing\files\australasia.txt
ingsetenv II_TIMEZONE_NAME AUSTRALIA-VICTORIA
--- back to InstallPeercore.bat --------------
@echo start ingres
ingstart -client
@echo copy shortcuts
copy "x:\shortcuts\*.*" "c:\Documents and Settings\All users\desktop\"
@echo install .NET framework (sorry not so quiet)
x:\dotnetfx /q
@echo install dotnet routines used by Peercore not detailed here.
call x:\DLLS\install_tbc.bat
@echo Create vnodes
call x:\ing\vnode.exe
@echo Cleanup
call x:\ing\cleanup.bat
@echo Installation successful
pause
-----Original Message-----
From: Martin Bowes [mailto:martin.bowes@xxxxxxxxxxxxx]
Sent: Tuesday, 11 September 2007 6:03 PM
To: Paul White
Cc: info-ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
Subject: RE: [Info-Ingres] jdbc connection problem
Hi Paul,
Care to cut up a trivial example of what you mean? Something that points
me in the right direction would be nice. I'm going to have to confess
that I'm a Unix/Linux man and I'm not 100% sure how to spell PC. And
friggen VMS is a complete mystery.
Marty
-----Original Message-----
From: Paul White [mailto:shift7solutions@xxxxxxxxx]
Sent: 11 September 2007 08:59
To: Martin Bowes
Cc: info-ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
Subject: RE: [Info-Ingres] jdbc connection problem
Hi Martin,
I'm pretty sure you could automate it with the installation scripting
right
down to vnode creation.
Paul
-----Original Message-----
From: info-ingres-bounces@xxxxxxxxxxxxxxxxxxxxxxxxx
[mailto:info-ingres-bounces@xxxxxxxxxxxxxxxxxxxxxxxxx]On Behalf Of
Martin Bowes
Sent: Tuesday, 11 September 2007 5:27 PM
To: John Dennis
Cc: info-ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
Subject: Re: [Info-Ingres] jdbc connection problem
Hi John,
Your absolutely right.
I'm currently contemplating the thought of upgarding a lot of PCs from
II2.6 to Ingres2006 Client installations. Not a pretty thought!
Marty
-----Original Message-----
From: info-ingres-bounces@xxxxxxxxxxxxxxxxxxxxxxxxx
[mailto:info-ingres-bounces@xxxxxxxxxxxxxxxxxxxxxxxxx] On Behalf Of John
Dennis
Sent: 11 September 2007 03:53
To: info-ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
Subject: Re: [Info-Ingres] jdbc connection problem
Marty,
I don't believe the 2.6 version of the JDBC driver supports the VNODE
property/attribute in the connection string. It's certainly not listed
in the somewhat sparse JDBC doco for 2.6
John
Martin Bowes wrote:
Hi Everyone,It
I'm struggeling with a JDBC connection string and could use some
ideas...
The java client is running on the same host as a JDBC server (II2.6).
wishes to use a vnode (called spam) to access a database on a remote
host. The vnode is a global vnode, and it uses user account
authentication on the remote host and it works perfectly well in SQL.
The connection string we chose was:
jdbc:ingres://localhost.II7/spam::bethan_dev;VNODE=login
Sadly this fails to connect.
_______________________________________________
Info-Ingres mailing list
Info-Ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
_______________________________________________
Info-Ingres mailing list
Info-Ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
.
- Prev by Date: Re: [Info-Ingres] Ingres SQL question
- Next by Date: Re: [Info-Ingres] jdbc connection problem
- Previous by thread: Re: [Info-Ingres] jdbc connection problem
- Next by thread: Re: [Info-Ingres] jdbc connection problem
- Index(es):
Relevant Pages
|
