I think so mate. Thanks for the help!
Chirag "OFlaherty, Colm" wrote: > Chirag, > > I may be coming in late on this one, but heres what I know on the issue u're > experiencing.. > > When u use most native (or ODBC) Sybase drivers, they go through the Sybase Open > Client (CTLIB or DBLIB), doing a translation of the logical server name to the > physical server name (and port number) though the SQL.INI file, as stored in > %sybase%\ini\sql.ini. > > Funnily enough though, when u use the Sybase Jconnect drivers (which u seem to be, > based on the JDBC URL below), they do <strong>NOT<strong> seem to do the > logical-physical server translation thing, using the SQL.INI... why this is, I'm not > sure, but that's my experience with it. U can prove this using a non-Struts POJO > which just uses the driver to connect to the database using the physical server name. > > The upshot of this (unless there is a way around it, which I'm not aware of) is that > <strong> u have to pass the physical server name and port number in the JDBC > connection URL, instead of just the local server name </strong> > > If u really wanted to use the __logical__ server name, u could do the translation > yourself before connecting, by looking up the %sybase%/ini/sql.ini file, and parsing > it to produce the physical server name and port number. This would certainly help > maintenance (at the cost of some loss of DBMS independence), given that SQL.INI is > the traditional method of naming and maintaining Sybase servers. > > Hope this helps u understand your issue a little better.. > > Colm > -----Original Message----- > From: Chirag Mehta [mailto:[EMAIL PROTECTED] > Sent: 01 August 2003 09:22 > To: Struts Users Mailing List > Subject: Re: Logical Server Name > > I cannot do that though because the port and the physical server is resolved > automatically from the interface file. > > Any more suggestions? > > Thanks for help anyway > > Chirag > > Jimmy Emmanual wrote: > > > try adding the port # and a database name. > > > > <set-property property="url" value="jdbc:sybase:Tds:LNT_MAST:4100/testdb"/> > > > > -----Original Message----- > > From: Chirag Mehta [mailto:[EMAIL PROTECTED] > > Sent: Thursday, July 31, 2003 1:40 PM > > To: struts-user > > Subject: Logical Server Name > > > > Hello, > > > > Can anyone help? > > > > I am using a BasicDataSource config in my config.xml file to reference a > > sybase database. Using a logical server name, the code gives me a > > IOException. > > > > in my config.xml: > > <set-property property="url" value="jdbc:sybase:Tds:LNT_MAST"/> > > exception:: > > javax.servlet.ServletException: java.sql.SQLException: JZ003: Incorrect > > URL format. URL: LNT_MAST > > > > But if I use the physical server name I have no problems setting up the > > DB Connection. (Well I haven't got any exceptions so far) > > > > Has anyone got any idea of any code I may have to change for my app to > > resolve from the logical server name? (The logical server name resolves > > from a interface file which is on my network server) > > > > Thanks a million > > > > Chirag > > -- > > NOTICE: If received in error, please destroy and notify sender. Sender > > does not waive confidentiality or privilege, and use is prohibited. > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > -- > NOTICE: If received in error, please destroy and notify sender. Sender does > not waive confidentiality or privilege, and use is prohibited. > > ********************************************************************** > This message is sent in confidence for the addressee > only. The contents are not allowed to be disclosed to > anyone other than the addressee. Unauthorised > recipients must preserve this confidentiality and should > please advise the sender immediately of any error in > transmission. > ********************************************************************** > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
