|
copec wrote: find out as it opens if the db was already opened by another instance of the program
For Access you could check for the existence of a .ldb file in the same directory as the .mdb. This would tell you that the db is in use (the .ldb is used by Access to control locking and removed when the last user closes the db).
For SQL Server I think you could query the master..syslogins table but I'm not absolutely certain. There may be easier ways to do this.
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
|
|
|
|
|
|
Hi,
I am managing a large project which has mainly two parts. one ia an application being developed in JSF and Java and the other is a client server application in C#. At the end of the day the the project developed by JSF and Java will be using the second project. I don't have any idea how I can integrate the two so that they will work together. any body who can guide me in the design of the interface between the two projects and the technology I can use(if any)
|
|
|
|
|
The answer, as so often, is "It depends".
There are several options available: web services, commercial Java/.NET bridges, messaging queues (for example, MQ Series can exchange data between Java and .NET), data exchange over TCP sockets, or even something as simple and basic as a shared database.
The best option depends on your exact requirements and what you mean when you say that you want these applications to "work together".
There is plenty of information on Google about this for you to do your research and make a decision on the basis of your own requirements.
|
|
|
|
|
thanks, but let me make the thing more clear. the client application to be called by the web based application is to be windows forms application(for the sake of performance). in that case how can i use webservices? further, the web based application is to call the user interface of the client application, fill data and then wait for response.Actually, i am new to this area and may be writing simple things.
|
|
|
|
|
So, if I understand correctly:
You have a JSF web application. The user connects to this application, and then the web page they are currently viewing in the browser communicates with a .NET application running on the local machine to enter data directly into one of the forms, trigger some sort of functionality and receive some data back as a response.
If that is what you want, I think you may be out of luck. I don't think that you will be able to get a web page running in a browser to interact with a client desktop application in that way. I'm pretty sure the browser security will prevent that but there might be some way round it.
I did find this page which might be of help as it seems to be addressing the same problem:
http://stackoverflow.com/questions/126048/how-to-interact-between-web-app-and-windows-form-application[^]
|
|
|
|
|
Ok, what about using a smart client, will that work?
I think I should think of another architecture. I couldn't change the JSF web application. But I can try another means for the desktop client.
The client application is a biometric authentication application(uses face and fingerprint). The JSF web application uses this application for avoiding double registration in some system. there is also some data exchange between the two applications.
Can I develop it in ASP.net? I think it may be very slow as there is scanner and cammera interface and other computation.
Or what should i do?
The importtant thing is that the two projects should be deployed as one project(there should be some integration)
|
|
|
|
|
I am afraid, this is not going to work. From inside the web application you will not be able to access the client windows application and perform certain set of activities and data transaction. Where as the reverse is possible.
|
|
|
|
|
As a rule of thumb i would try to couple both projects as loose as possible. This makes that most future changes in one will not influence the other. So this leaves you with 2 questions for every way you can connect those projects:
1. Will it give you max. independance for both projects?
2. Gives the solution enough performance?
The technology that answers on both questions Yes is the one you're searching for...
Rozis
|
|
|
|
|
Please suggest for following issues for a web based application in ASP.NET 3.5:
1.
There is requirement for approx 10 to 20 million records entry in the database daily, or we can say that there would be around entry of 10 lakh records per table on daily basis. What would be the best Database Design, Model & Architecture in MySQL database. Need proper optimization for quick retrieval, insertion, updates & deletion. Also provide the hardware detail that would required to handle such a large database in long term.
2.
There is a scenario of inventory management of advertisements on daily basis, if there are 100,000 locations and user booked these locations for 1 year then I need to insert/update 100,000 x 365 = 36500000 records/rows in the table to maintain daily inventory. Please suggest better solution & table structures.
[Database Design, Model & Architecture for Large number of storage / insertion of records in MySQL]
|
|
|
|
|
It's part of the design. Consider this as an example;
If you have a Location -table like this;
Location Name
---------- -------
21 Floor
22 Cellar
23 Roof and a User -table;
Id Name
----- -----------
64 ajitsunny
66 E. Codd
67 Don Quichotte , with a Bookings table like this;
Id BookedByUserId BookedLocationById BookingStart BookingEnd
----- ------------------- ---------------------- -------------- -----------
1 64 21 11.11.2011 12.11.2011
2 64 21 14.11.2011 16.11.2011
3 67 23 11.11.2011 13.11.2011
5 66 21 23.12.2012 31.12.2013
Then you can encode a booking with a single command, providing start and end-dates as parameters
(e.g., like;)
INSERT
INTO Booking
VALUES ( 64, 21, '2011-11-11T00:00:00.000', '2011-11-12T00:00:00.000' )
|
|
|
|
|
If you need quick retrieval of data, a de-normalized database is often a good practise, as if you have normalized dB, there would be lots of joins,which are actually costly in terms of perfomance of queries.
On the other hand, if the preference of the application is user filling up form data and you dont want any redundancy in the database, then you should normalize the database tables.
It totally depends on the application need.
|
|
|
|
|
I my case we need to optimize two tables to stores very large number of records (in millions / billions) - just change the table structure and apply horizontal partitions on date range or no. of records. The new table structure should be able to minimize the records required to store.
1.
location_BookedAdvertisement (loc_id, advt_id, start_date, end_date, inventory_text)
And data would be like this for location_BookedAdvertisement table:
(12, 132, 2009-07-20, 2009-07-25, '1000~2000~5000~8900~3000')
This structure reduces the number of rows required to store 100,000 location's date wise assigned inventory by 364 times. Now I only need to store 100,000 rows instead of 100,000 x 365. So I am giving this table structure OK DONE. Also partition this table on no. of records such as 10 millions rows per partition.
2.
Now change the structure of tinventory table..
location_ inventory (loc_id, date, Total_available_inventory, booked_inventory)
.. to
location_ inventory (loc_id, year, Jan1, Jan2, Jan3, Jan4 ,.. ..., Dec29, Dec30, Dec31)
And data would be like this for location_ inventory table:
(12, 2009, '5000~2000', '10000~8900',... ...,'12000~2000','12000~2000','12000~2000')
Here within date column we have 'Total_available_inventory~booked_inventory'.
I know there would be 366 column in one table... but today I tested it.... SELECT / INSERT / UPDATE works very very fast as compared to in the earlier table structure. I'll partition this table year-wise i.e based on year column. And this table structure again reduces the required number of records by 364 time... i.e. to store one year inventory of 100,000 locations I would need to store only 100,000 rows.
This solution is acceptable.
|
|
|
|
|
Hello guys,
What was the name of the coding style used a lot in Hibernate?
I mean, where you would have several calls in one single instruction, as in:
SomeType obj = SomeClass.createInstance()
.SomeMethod()
.SomeOtherMethod()
.OneLastMethod();
I remember reading an article somewhere on the internet, but i can't find it back.
Thanks!
|
|
|
|
|
Nevermind, the term I'm looking for is "Method chaining"
|
|
|
|
|
If the chain reads like natural language, then the term for it now-a-days is "fluent programming."
"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty
|
|
|
|
|
Wow man, you are right that was the exact term I was looking for!
|
|
|
|
|
Glad I could help!
"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty
|
|
|
|
|
Im looking for documents(programming languages) that would guide me in creating an interface that reads network data. So i guess i should start by creating the interface or finding out how to read network data and input database.
|
|
|
|
|
What???
CodingYoshi
Artificial Intelligence is no match for Human Stupidity.
|
|
|
|
|
trying to use System.Net.NetworkInformation in the .netframe work to read network traffic
|
|
|
|
|
Tag: BeijingIT & WebFull Time
reply to: leowang@renbenmg.com Tel: 86-20-38109789
Job description:
GENERAL SUMMARY
As a senior member of the Celerra File System and Data Protection development team in NAS Engineering, you will work on complex design problems and provide highly innovative solutions.
Desirable core technical skills include file systems, distributed file systems, clustering, operating systems, and network protocols.
Strong communication skills are required for interaction with team members, senior members of the staff and other organizations. Candidate must have a broad knowledge of Linux and/or UNIX operating system technology and experience with contemporary software engineering principles. The ideal candidate will also have the ability to provide technical leadership to teams of software engineers.
Ideal candidate will enjoy a fast paced, technically challenging environment working with an expert on the core subsystems of NAS products.
Experience and Education
• BS, MS, or PhD in Computer Science or closely related field, plus at least 10, 8, or 6 years relevant experience, depending on degree
• Strong UNIX and/or Linux operating system knowledge base
o Windows knowledge a plus
• Excellent C and/or C++ programming skills
• Have multi-threaded programming experience
• Strong problem solving skills
• Expert knowledge of network and/or disk-based file systems
o Knowledge of additional storage protocols, I/O subsystems, and/or device drivers a plus
o Knowledge of distributed and/or cluster files systems a plus
• Candidate should possess excellent spoken and written communications skills.
• Ability to effectively work with and lead a team and to influence others
o Comfortable working in a highly distributed international team
|
|
|
|
|
There is a jobs board here on Code Project. Please use this instead, as I and others will be voting to remove this message.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Pete O'Hanlon wrote: as I and others will be voting to remove this message
Awww damn, looks like I was too late to vote on it
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Welcome back Paul - I haven't seen you around for a while.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|