Question on ERXJDBCConnectionAnalyzer

Larry Mills-Gahl <[email protected]> Mon, 27 Oct 2014 15:29:09 -0400
Newsgroups gmane.comp.web.webobjects.wonder-disc
Message-ID <[email protected]>
--===============0451478900539258762==
Content-Type: multipart/signed;
	boundary="Apple-Mail=_FD9D832A-76A7-4C56-A0AF-FFA5C221F841";
	protocol="application/pgp-signature"; micalg=pgp-sha1


--Apple-Mail=_FD9D832A-76A7-4C56-A0AF-FFA5C221F841
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=windows-1252

I have a new and (so far) unexplained db connection failure and I=92m =
hoping someone has suggestions about where to look.

I know the usual culprit is bad connection dictionary or db-side =
connection configuration. To rule those out I logged out the connection =
dictionary just before =
targetAdaptor().assertConnectionDictionaryIsValid() in =
ERXJDBCConnectionAnalyzer. The output of the connection dictionary was =
what I expected to see.

To check the database permissions/configuration, I inserted a raw JDBC =
connection and dummy query in the static method of the framework that I =
use for models.  I used ERXProperties to grab all of the same values =
used for the connection dictionaries (url, user, pass)

The jdbc connection gives me a connection and a result set so I=92m =
pretty confident that I can connect from the app.
Since I=92m using the properties that make up the connection dictionary =
to make that jdbc connection, I=92m pretty confident that those values =
are right too.

Still when I get to targetAdaptor().assertConnectionDictionaryIsValid(), =
I get =93No Connection."

I=92m still digging but does anybody have any thoughts on where I might =
look next?


Larry Mills-Gahl
[email protected]







--Apple-Mail=_FD9D832A-76A7-4C56-A0AF-FFA5C221F841
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
	filename=signature.asc
Content-Type: application/pgp-signature;
	name=signature.asc
Content-Description: Message signed with OpenPGP using GPGMail

-----BEGIN PGP SIGNATURE-----
Comment: GPGTools - http://gpgtools.org

iQEcBAEBAgAGBQJUTp0FAAoJEH6+KDQxPmwvHgUH/2Sr8Wao7V3C2SNI4usLW4DS
i/72SamQLmgcKxg3Fjkq5zUNpWMUQYQh9gO1BEvdXg8YJ190jI8F8nLAaegs+c5i
/ZEjoon3RsGmPXvndFXzUzOX0KuFT27Mnf4lDGCVIQrZPP3vDrHx7sQ0mcYkGarh
cKXwTm9Y4l4rW2EHCoMtP+lsEMsc7rDJ86TTlgRmItHUbGvOESStzunL0gQY13ux
XstzR5/1ixwXBcN/cikguki0sHexD3Y2wZeXqTSJiOV+04mH75B64E11w3kLgkiq
JdUju/HCetFrOcM6+La6pGG3fNcype3Vm1/auJP2x38LgfLUrimqs1fK5u50v/4=
=hvsz
-----END PGP SIGNATURE-----

--Apple-Mail=_FD9D832A-76A7-4C56-A0AF-FFA5C221F841--


--===============0451478900539258762==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

--===============0451478900539258762==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Wonder-disc mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wonder-disc

--===============0451478900539258762==--