file « Operation « Java Database Q&A





1. Bundle a database in an API    stackoverflow.com

I am currently working on a project where in which I need to package a database along with a JAVA API. The database should be secured in a sense , no ...

2. how to create database using java code?    stackoverflow.com

I want to create a database using java code, I have the database script file, I will read in a string and I will execute it but I want to know ...

3. How can I query a DBF file in java    stackoverflow.com

I have a rather large DBF file, about 40 megs, that I need to be able to query. Right now I am reading the DBF, it's just tabular text, into ...

4. insert values from a csv file into database    stackoverflow.com

hi i want to insert values from excel file(axd.csv) into database.Whatever field and contents are there in excel file that should go to database which exists. I am using SQL Server management ...

6. File Parsing and DB update    coderanch.com

Hello everyone, I have a small program that parses text files and update an access database, the number of records in the file do not exceed 2000. But the process is really slow. I parse each line, store the field values into an array, pass that array to another object which updates the database.... Is there a better and faster method ...

7. reading a very complex file and inserting in database    coderanch.com

can anybody tell me how to read these three types of text files:- first file format is:- SERIAL NUMBER : 0 ADJ TIME : 5.5 [sec] MODE AL ITEM READ / ADJ / WRITE DATA SPEC MEASURE ETC 2 H_CENTER 135 135 135 0.0 +1.1 -1.1 0.4 3 V_SIZE 147 147 147 0.0 +2.2 -2.2 -0.9 4 V_CENTER 67 67 67 ...





11. help with inserting a csv file into a database    coderanch.com

i need to read in a csv file , which is no problem . but i need to retrive every first word of each line and then the second word of each line and so on then i need to send that information to a sql database i have no problems with the connection to the database. but what i need ...

12. Updating if file exists...    coderanch.com

14. problem in inserting pdf file    coderanch.com

You should look up tutorials on blobs, inserting them can be tricky. Last I recall in some systems it requires two passes for an insert. The first insert without the blob creates the db record and makes available a pointer to the blob. Then an update is performed using that pointer. That would seem to support the error, it doesn't want ...

15. regarding inserting any file    coderanch.com

16. Insert file as Attachment in Access 2007    coderanch.com

hi...thank you. yeah, i was hoping that i wouldn't have to stream it back out of binary when the users use the database. it's essentially an archive for a mail file and i wanted to store the metadata in access text fields and then the attachment from the email body as an access 2007 attachment...then just give them the access db. ...





17. read large CSV file and update the database    coderanch.com

HI, In my project i need to write a batch(java) which will read a CSV file from FTP location consisting more than 5 lakhs records and update a table in my database (Oracle 10g). My concerns here are : - processing Time - garbage collection(Stack overflow problem etc.) - DB handling Can anybody tell me how can i achieve this, so ...

18. Input file parsing to insert into DB    java-forums.org

Hi, I have a sample input file as follows: ++++++++++ 2009-09-28 15:10:58 ++++++++++++++ ++++++++ DAILY SCORES +++++++++++++++++ 2009-09-28 15:10:58|AAAA|0 2009-09-28 15:10:58|BBBBB|0 2009-09-28 15:10:58|ACCCC|0 ++++++++ MONTHLY SCORES +++++++++++++++++ 2009-09-28 15:10:58|AAAA|30 2009-09-28 15:10:58|BBBBB|50 2009-09-28 15:10:58|ACCCC|60 I should ignore first line and then look for "DAILY SCORES" or "MONTHLY SCORES"string. This determines which MySql table has to be used. Then read the following lines ...

19. Uploading file in file system or inserting it in database?    forums.oracle.com

Dear All, I am developing an application which will upload the files and store the information about file in database. I have a question that which is good practice? Uploading file in hard disk of server or inserting the file in database as BLOB? File size varies from 1 MB to 100 MB. Please suggest me good idea.

20. Input file parsing to insert into DB    forums.oracle.com

21. Update an AS400 file using jdbc jt400.jar    forums.oracle.com