I have downloaded a SOLR release, and sun JDK. I have installed SUN now... I am using wampserver on my computer, to test SOLR out first, and learn how it works... I don't understand how to install it and use it though... I am completely new to it and java as well, so I need some help on this one... After downloading it, and unzipping i...
Last month I had to reinstall Windows and I've moved the WAMP folder to another partition. Now I've installed WAMP again but I need the old database. How can I take the old MySQL database from the saved WAMP folder on the safe partion? In the wamp/bin/mysql/../data/ I have my old databases. If I copy the database folder only, in phpMyA...
I need to know if there is any embedded DBMS (preferably in Java and not necessarily relational) which supports multiple writer applications (processes) on the same set of db files. BerkeleyDB supports multiple readers but just one writer. I need multiple writers and multiple readers. UPDATE: It is not a multiple connection issue. I ...
(Note that this situation isn't exactly how it is, but I made this as an example) I have an entity in a table with data that is updated every 5 seconds (Kinematic Data: Speed, Heading, Lat, Long, and PositionTime), and other data that is updated hardly at all, if ever (Color, Make, OriginTime). Now my boss wants me to partition this ...
I need to read one record from a database (determined by the url's querystring), and take one field from it ("Cost"). The SQL currently in my datasource for it is just: SELECT [Cost] from [Cars] WHERE ([RegistrationNumber] = @RegistrationNumber) ...then @RegistrationNumber is defined as coming from the QueryString. I'm very much stil...
I have understood how to add xml files to SOLR and be able to search them via the SOLR ADMIN interface... I need to know however, how to make SOLR work with PHP, and index MYSQL records... This is what I want to do: I have a mysql table, which I would like to add to SOLR (index it), so that instead of searching the MYSQL table directly...
I haven't got any experience with databases, but intends to learn it and use it on a web project I'm planning. Though, I've got advice from a pal of mine that the use of databases should be quite more extensive than I planned. He believes in keeping almost all of the data in databases, where I find that databases are most convenient reg...
You see it a lot in examples and I've done itt on some small projects, but for a larger project with multiple developers, does it really work well to put the database file (.mdf) in the project? What is your "workflow" like with your database? Do you put the file in your project and check it in like everything else, or do you have a cen...
If a programming language allowed the creation of database tables, but only allowed one field to be used as an index ... how limiting would that be? I am not a real database programmer, so I'm wondering if such a system could be used as the basis for serious databases, or would be only a toy. ...
At the moment i'm busy to implement a website, database and software which will fill this database. The website is placed at an external hosting company, the software is running at out local netwerk. The website needs to read the information in the database, the local software will put its results (these data) in the database. Question:...
Hi.... I've created a program that send's a data to a webserver. I used the NSURLConnection to send the data to the web server. I've created a php file on my server to handle all the POST request from the iPhone. My question was are there any other ways to send the data to a web Server besides using wifi connection. I just only need to s...
Hi, I'm using NetBeans and I need to connect to Oracle Database. I set up the driver and the connection and it all works fine. I can run queries on this connection just fine (through the IDE). The problem is this- The tables I want to work with are not defined on the same schema that I use for the connection, although, my schema does ...
what is the difference between database drivers and database dialects? ...
Hi all, I have a question related to some guidances to solve a problem. I have with me an xml file, I have to populate it into a database system (whatever, it might be sqlite, mysql) using scripting language: Python. Does anyone have any idea on how to proceed? Which technologies I need to read further? Which environments I have to i...
I am trying to store a dependency tree in a PostgreSQL database. There are about 20,000 software items, each item can depend on several other items. There are several types of dependencies (some are run-time dependencies, some are build-time dependencies and some are test-dependencies). The dependency is recursive and each item only kn...
My auto-incrementing primary keys are getting too high. I'd like to reset it. 1, 2, 3, 4, 5, 6. If I reset it to 0, the next inserted row will be 7, right? How do I reset the autoincrement? ...
Thanks for all your help, I now have add, update, and delete functions on my database manipulation program. But I'm having difficulty on searching for records in mysql database. Please help me in correcting my codes, and if you know a site that I can use as my reference please do tell. Thanks, here is my search code: <?php ...
If I have an SPFarm object in the WSS 3.0 API, how can I get the Server\Instance details of the config database? ...
is it possible to store more than one value in database column. if yes which type i should use? and through my java code how can i insert the values. for example i want to have a column "language" which can store values like java, c++, c# etc. for a single row. EDIT : i want to have a table called student with all the information about...
I'm trying to get at the best way to seperate the concerns of my domain logic and my persistence logic. I'm using Linq-2-Sql for the data access and I've been following the NerdDinner tutorial. If you look at page 40, you can see they are using partial classes to business rules to their Linq generated classes. To me, that feels wrong (is...