|
This can be a lot of fun if you have to work with that 
Cheers
You have the thought that modern physics just relay on assumptions, that somehow depends on a smile of a cat, which isn’t there.( Albert Einstein)
|
|
|
|
|
SELECT [SELECT], [FROM], [TO], [WHERE], [ORDER] FROM [WHERE] WHERE [WHERE]='GROUP BY OR HAVING'
This blanket smells like ham
|
|
|
|
|
 This same schema just caught me again, as I have a policy of naming all my DAL parameters the exactly the same as the column names, which works Ok until a column that is called IsNew in a view is actually called 'new' in the table.
|
|
|
|
|
That reminds me of some fun I used to have (aeons ago) in Coral-66:
'FOR' FOR = 0 'TO' TO 'STEP' STEP 'UNTIL' UNTIL
'BEGIN'
BEGIN;
END;
'END'
something like that anyway - I can't remember the exact syntax
Phil
The opinions expressed in this post are not necessarily those of the author, especially if you find them impolite, inaccurate or inflammatory.
|
|
|
|
|
Database designers who don't have to write any SQL.
|
|
|
|
|
I also deal with gems like Tax%. Hey, 'like Tax%'...
|
|
|
|
|
I myself just created a table named Group. I also have a table named Parameter. And a field named When. But (so far) only I need to deal with them.
|
|
|
|
|
PIEBALDconsult wrote: But (so far) only I need to deal with them.
So you still have the chance to fix this foolishness before it gets into the real world... 
-------------------------------------------
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Just bugger off and leave me alone!!
|
|
|
|
|
PIEBALDconsult wrote: And a field named When
And a field named "Poof"?
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
I once had to deal with a database that had dashes in the field names. That was the first time we ever had to lookup how to quote identifiers and were horrified to find that there was no standard. What worked on one system just made it a quoted string on another. 
Meddle not in the affairs of dragons, for you are crunchy and taste good with catchup.
|
|
|
|
|
Not yet, waiting to hear back from the manufacturer.
|
|
|
|
|
Any advances on SET, DATE, YEAR and CLASS?
|
|
|
|
|
I had a chance to walkin to Axis Bank branch in the Chennai suburb on Saturday afternoon. The connectivity to the server seemed to be weak and hence the personal bankers attending to the customers even warned to each customer of the little delay and then were trying to maximum solve the queries as much as possible.
When my turn to the Personal Banker came and she was about to logon to the Menu Interface to my account in the application, she got a message
'java.lang.IllegalStateException' and that seemed to be an indication of Connection dropped again. Isn't it a true WTF that without quality testing the banking product has come into deployments? And interestingly, after a few tries it logged on to present a 'Maximum License Reached' but the app was still functioning.  The logon was showing the name of the application as Finacle.
This comes close to the heels when we discussed another Banking Issue [^]
sometime back regarding a bad database design of storing customer data in multiple tables.
-- modified at 6:01 Monday 29th October, 2007
|
|
|
|
|
Vasudevan Deepak Kumar wrote: Axis Bank branch
OOPS. I thought they have a good system. Their Iconnect facilities are fair enough.
|
|
|
|
|
N a v a n e e t h wrote: they have a good system
They do. They have a good customer care too. It is that WTF Finacle which is screwing things all along. Even in ICICI bank infinity which is powered by Finacle, when you logout it gives a JavaScript error since they use a ExecWB (Web Browser Object) to close the browser window, which is no longer supported.
|
|
|
|
|
Vasudevan Deepak Kumar wrote: It is that WTF Finacle
By infosis Right ? My friend is into it's implementation department, and he said it's a superb product.
|
|
|
|
|
N a v a n e e t h wrote: he said it's a superb product
Not to offend. But as long as the product or the application is in our cosy comfortable lap, it would sound and resemble that way. But there are integration paranoia, which any application should pass this litmus test to prove itself of its capabilities to the world. 
N a v a n e e t h wrote: infosis
Infosys and its Stock Symbol is INFY right?
|
|
|
|
|
When I belive a system is good tested and more or less secure, than it should be a bank system, shouldn't it?
So seems to be my fault .
Cheers
You have the thought that modern physics just relay on assumptions, that somehow depends on a smile of a cat, which isn’t there.( Albert Einstein)
|
|
|
|
|
Fatbuddha 1 wrote: system is good tested and more or less secure, than it should be a bank system
True. That would be a very optimistic view.
Fatbuddha 1 wrote: seems to be my fault
Not necessarily. But those developers who brought out the buggy system had thier thought process the other way around -- Banking system is one of the systems. 
|
|
|
|
|
One of our ASP.NET web applications is supposed to use a java web service developed by another team. However, the service returns session errors about 50% of the time in development environment (credit to the jave team, at least it is failing at a consistent rate ). But it works fine in formal test and production environments.
Stupidity: As it turns out, when this java web service is called, it makes two calls to another java web service to do the work, and the second java web service is load balanced. The first call establishes a session with the second java web service on one of the two load balanced physical servers, the second call tries to use the established session, but 50% of the time the request landed on a different physical server, hence the session error. In formal test and production environments, back-doors are open to ensure that request to the second java web service is made directly to one physical server and that's why it does not have the session error.
Stuburnness: We requested that if the java web service can't be fixed to work properly, a similar back-door should be open in development environment so that we can get some work done. The answer is NO, instead we get a lecture about design principles, best practices, and beans/factories/containers/layers, etc. In other words, we are not worthy of using the java web service.
To this day, we are disabling the code to call to the java web service in development environment, hoping everything will be fine in formal test and production environments.
-- modified at 10:16 Wednesday 24th October, 2007
|
|
|
|
|
That’s nuts, whatever one group needs to make it work, so does the other group. If the management does not agree, then they should insure that the group responsible fixes the problem so the second group never sees it. In other words, they should have tested it under the conditions which group 2 requires before passing it on to them. That is best practices and et cetera, as not doing so waste everybody’s time and cost the company time and money.
I hope it works out, but not being able to test properly during the development phase is a very bad thing.
INTP
"Program testing can be used to show the presence of bugs, but never to show their absence."Edsger Dijkstra
|
|
|
|
|
nice problem
it is not big problem i have a great solution for this problem.
use Entry exit point when it call another web service.when it'll call load balance service then use Exit point and here save all information regards to the session.
when it connect previous one then use entry point here invoke all information regards to the session. useing above idea where the session started.it'll save on user M/c then we dont need to maintain session in server end.
|
|
|
|
|
[rant]
Here's the setup of an "unidentified" application:
For some reason, the developer didn't want to code in the language to which he was assigned, so the first thing that he did was create an entire generator that allowed him to generate the "other" language so that he could continue to program in the language of his choice. The resulting application is so "objectified" that the object model is several layers deep, and in order to find a "Save" command, I have to wade through 20+ pages of documentation describing his monolithic object model. The irony of it all is that it's nicely structured, it has all of its unit tests, and it also has plenty of documentation. In all, I'd say the codebase is about 30k lines, which isn't too terribly large.
There is, however, just one problem: I did the same project in less than 2k lines of code!
It's a bloated masterpiece!
[/rant]
Has anyone else ever run into this scenario?
|
|
|
|
|
Philip Laureano wrote: Has anyone else ever run into this scenario?
MFC?
|
|
|
|
|
J2SE?
I kid, I kid! 
Please don't bother me... I'm hacking right now. Don't look at me like that - doesn't anybody remember what "hacking" really means? 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
