Home > Archive > SQL Anywhere database > August 2005 > Re: My Java application will not connect to SQL Anywhere 9 on Pocket









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: My Java application will not connect to SQL Anywhere 9 on Pocket
Greg Fenton

2005-08-24, 3:23 am

Tim wrote:
> 8. Get following error:
> java.sql.SQLExcpetion: JZ00L:Login failed. Examine the
> SQLWarnings chained to this exception for the reasons(s).


Try starting the database engine with the "-z" and "-zo" options to log
communication information to a logfile and then seeing the contents of
that file after a failed login attempt. This will indicate whether the
client is even hitting the server or not.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
Greg Fenton

2005-08-27, 8:23 pm

Tim wrote:
> I. 08/27 11:29:08. Connection ID 1: connection "DBA"
> terminated abnormally


This indicates that the client connection simply "went away". Has the
client app crashed? Or is there possibly a stack trace on the client
you could chase down?

> I notice that the TCP listener is listening on 0.0.0.0:2638
> even though I thought I had forced it with the “–x
> tcip” parameter.


To force the IP the server listens on, you need to use the "MyIP" parameter.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com