file 1 « file « Java Database Q&A





1. Storing database data in files?    stackoverflow.com

I'm currently working on a school project, in java, and I'm coding a database application. Something like the MySQL Monitor where you type in queries and get results / whatever. In applications ...

2. Are flat file databases any good?    stackoverflow.com

Informed options needed about the merits of flat file database. I'm considering using a flat file database scheme to manage data for a custom blog. It would be deployed ...

3. Reading Microsoft Access files in Java    stackoverflow.com

How to read (and write) MS Access files (.mdb) in Java? Is there any open-source jdbc driver for MS Access?

4. Maintaining a database externally in a text file    stackoverflow.com

What is the simplest way of maintaining a txt based database file that allows the program the write in new or edit existing entry during execution time. to be specific, the ...

5. Load Java classes based on a classpath in a properties file    stackoverflow.com

My application uses JDBC database drivers. I load these from a jar file, db2jcc.jar in the case of DB2 which I'm currently working with. With this jar in the classpath, everything ...

6. java embedded database w/ ability to store as one file    stackoverflow.com

I need to create a storage file format for some simple data in a tabular format, was trying to use HDF5 but have just about given up due to some issues, ...

7. What is a good alternative to text files as Database for java 1.3?    stackoverflow.com

I know... you must be calling me nuts by now, for using text files as databases. If thats ok to you, certainly using java 1.3 will be enough to call me insane. Let ...

8. how to write huge data in text file using JDBC without running out of memory    stackoverflow.com

I am trying to create a dump file from a database using JDBC. The file should be round about 300 mb in size containing 1.2 to 1.5 millions records across ...

9. Importing Data from a Microsoft Access File on a Mac    stackoverflow.com

I have an MS-Access mdb file that I need to import data from into my mysql instance. I am on a mac, is there any free/OSS tools that allow me to ...





10. Is it possible to write files to a remote directory using java?    stackoverflow.com

I have the directory mapped on my machine so that I can browse and write to it via Windows explorer. I would like to write files via java. ...

11. checking an access file via java and mailing for a specific row    stackoverflow.com

Hello I need to write a program that checks a access .mdb file and when a specific row is added (say the "name" field column of the newly added a row that ...

12. Extract from Cache.db files on Mac OS X Leopard    stackoverflow.com

I am a Windows user, and I delete temp internet files from IE by URL visited (because the Java app has an embedded web browser tied to a web server). I ...

13. Closing db file when using Tokyo Cabinets Java bindings    stackoverflow.com

I'm writing a small Java-based server around Tokyo Cabinets JNI-bindings, and I am a bit confused regarding opening and closing of the db file. The server is multi-threaded, and I'm therefore ...

14. Issue with encoding UTF-8 when FTPing files    stackoverflow.com

I am able to have my application upload files via FTP using the FTPClient Java library. (I happen to be uploading to an Oracle XML DB repository.) Everything uploads fine unless the xml ...

15. Palm Database (PDB) files in Java?    stackoverflow.com

Has anybody written any classes for reading and writing Palm Database (PDB) files in Java? (I mean on a server, not on the Palm device itself.) I tried to google, ...

16. extract data from .xls file    stackoverflow.com

I want to extract data from a Excel file and store them into a access database, how to do this?





17. Can you port any kind of a Database into a J2ME application ?? or Is ther any jar file available to perform database operations in any type of phone?    stackoverflow.com

I was looking for some kind of a library that could perform database operations on my phone alongwith storing the database itself into my phone using J2ME. ( other than the ...

18. Which API in Java to use for file reading to have best performance?    stackoverflow.com

In my place where I work, used to have files with more than million rows per file. Even though the server memory are more than 10GB with 8GB for JVM, sometimes ...

19. Java (ME) library for fixed-length record files    stackoverflow.com

I am looking for a library that can run on Java ME (Foundation Profile 1.1, CDC) and allows me to basically do something along the lines of

FILE OF type;
in Pascal. Background: ...

20. How to execute sql-script file in java?    stackoverflow.com

I want to execute sql script file in java without reading all file contents to the big query and executing it. Is there is any standard way?

21. Is there an "embedded DBMS" to support multiple writer applications (processes) on the same db files?    stackoverflow.com

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.

22. Reading xls files in database using java    stackoverflow.com

Is there any way to import data from xls files to database(postgreSQL in my case) using java?

23. Read/Write xBASE (DBASE 3-5 /DBF) files    stackoverflow.com

Is there any good library for reading / writing DBF files in java or any other language ?

24. Setting classpath and installing database via batch file    stackoverflow.com

I want my classpath to be set via a batch file. I'm working on Windows XP. I have two questions:
My first question: I made a batch file in which I typed
"set classpath = ...

25. create jar file with images and database    stackoverflow.com

Hi I am using NetBeans IDE and I have my images (what I am using in my project) in a folder named Images. When I am building jar it doesn't take ...

26. Indexing File Names To a Database    stackoverflow.com

I have a folder with more than 2000 files and I need to index their file names on a database(MySQL) using Java, but how could I do this? PS: The MySQL connection ...

27. How to change database settings for a deployed war file?    stackoverflow.com

We have a WAR file that is deployed however we want to change the database settings. How do I get about doing that? I opened the WAR file in an IDE ...

28. Why is my WAR file still referencing data from the old database server?    stackoverflow.com

Possible Duplicate:
How to change database settings for a deployed war file?
OK I will outline the steps:
  1. I downloaded a perfectly functioning WAR fIle
  2. Uncompressed it
  3. Changed the ...

29. How to read .rpt files and load data to database    stackoverflow.com

I need to read .rpt files and load the data into MySQL or Oracle using Java. Can anyone help in this?

30. Java/Websphere/Oracle10g/PL/SQL implementting file system storage of images    stackoverflow.com

Newbie: I have an assignment as a Java/Websphere developer working with Oracle 10G DBA and a PL/SQL developer to implement file system storage of images and I need some guidelines on ...

31. File based database in Java    stackoverflow.com

Are there any libraries create programs in java that uses a file as a database and you don't have to install database services on the computer you are going to use ...

32. What is the most memory efficient way to write from a database to a (zip) file in Java?    stackoverflow.com

My program is fast enough, but I'd rather give up that speed for memory optimization since one user's maximum memory usage goes up to 300 MB meaning few of them could ...

33. How to overcome OutOfMemoryError during huge file write    stackoverflow.com

I am writing a full database extract program in java. Database is Oracle, and it is huge. Some tables have ~260 million records. The program should create one file per table ...

34. Storing XML Files in Database    stackoverflow.com

I have to create a desktop application in Java 6. Program should be able to communicate with other system using XML files (sending/receiving). Every single XML file is connected with its ...

35. How to get rid of Thumbs.db file in Windows NTFS file system?    stackoverflow.com

My web based java application storing files in Local Drive(E.g: D:/AppData). It's scanning a folder for files(String[] nameOfFiles = dirName.list();) and displays all the files in the folder. The Thumbs.db also ...

36. How to scan a database file for hex string in Java    stackoverflow.com

I have tried to find the answer to this but it's now 1am and I'm a little tired. Could someone point me in the right direction please, what I want to ...

37. How to write a xml database file efficiently?    stackoverflow.com

I want to build an XML file as a datastore. It should look something like this:

<datastore>
    <item>
        <subitem></subitem>
    ...

38. taking ha-jdbc config file out of the war    stackoverflow.com

i have a config file for ha-jdbc. i would like that the users change it according to their wish so it should be outside the .war file. so far i was ...

39. How to store audio files in server (during hosting)    stackoverflow.com

I was thinking of building an app to serve audio content. The first question I get is how to store it. Two obvious solutions that occur are:

  1. Dump in database as BLOB
  2. Dump ...

40. how to store a Jpeg file in a database?    stackoverflow.com

Is it possible to store a Jpeg file in a database using a Web Application? can you share some code on how to do it? or share some links for some tutorial regarding ...

41. Parse string literals from Java source files to find potential SQL-injections    stackoverflow.com

In our Java-project I need to find potential SQL-injections in the java source files. We use our own Java-SQL frontend class and all relevant SQL-queries are in the following form:

String someText = ...

42. Retriving a file from MS Server 2005 using Java    stackoverflow.com

What I'm trying to do is when a user hits a link with the correct parameters, the system will retrieve the file from the MS Server 2005 db and outputs it ...

43. Creating a database changelog xml file from an existing database (including stored procs) using Liquibase    stackoverflow.com

Is it possible to create an initial database changelog xml file from the existing state of the database? I believe I've generated the schema using generateChangeLog, but it doesn't seem to return ...

44. Difference between storing a DBUnit file in version control and using Liquibase for Database Version control?    stackoverflow.com

What is the difference between storing a DBUnit database-loadable xml file in version control, and using Liquibase for database version control? I'm relatively familiar with DBUnit ...

45. Operation failed on file due to file permissions,hos_clientfileio.cxx 142    stackoverflow.com

When i execute SQL "LOAD TABLE ...USING CLIENT FILE..." to Sybase IQ database in tomcat's apps, get this problem"Operation failed on file due to file permissions,hos_clientfileio.cxx 142". But when i run the piece ...

46. java.util.PropertyPermission file.encoding read for signed applet    stackoverflow.com

i have an applet that is called by javascript from an html page. the applet enters the value from the page to an access database. i have signed the applet but still ...

47. JDBC logging to file    stackoverflow.com

I need to log all the queries to an Oracle database in my project to a log file. What would be a good solution to achieve this? Some sample usage would be ...

48. Saving a database to a text file     stackoverflow.com

i have got a database which lists actors and movies, these essentially come from two different arrays. I now need to save these from the database into a text file. I ...

49. logrotate-like functionality for database tables/file system files    stackoverflow.com

tl;dr summary: Are there standard solutions for limiting the length of database tables and number of file system files based on number, disk space or time?


I have a Java web service ...

50. how to get the file path from the branches in svn    stackoverflow.com

I have an SQL file in my repository or branches in SVN which I want to read and execute it. Because if later that SQL file changes that should not ...

51. Advanced Java File I/O tutorials? Tips? Advice?    stackoverflow.com

I'm working on a project right now that will make use of Java File I/O that goes beyond the simple "write this string to a file" documentation and tutorials that I ...

52. Groovy not reading jar files in .groovy/lib    stackoverflow.com

I'm having a problem with jar files and groovy. For a few specific examples I'm trying to connect to a postgresql database and when using sql = Sql.newInstance("jdbc:postgresql://localhost", "user", "pass", ...

53. Can I read BerkeleyDB (non-Java-edition) files from Java?    stackoverflow.com

I need to read BerkeleyDB files from Java. Oracle has an official Java Edition of BerkeleyDB, but it seems that this uses its own, incompatible binary file format. What do I do?

54. I want to load an xml document into a database using just an xsd and a file (must use c#)    stackoverflow.com

I'm looking to load an xml document into a db using just an xsd and a file (must use c#) The java equivalents I've used is xsd2db and edu.lmu.xmlpipedb.util.engines.ImportEngine. Any suggestions on c# ...

55. storing a xml file data in DB    stackoverflow.com

I have a xml file and I want to store it contents in DB.How The format of my xml is not fixed 100% I have xml file as shown below

   ...

56. Java synchronization options for preventing duplicate orders (file, db locking?)    stackoverflow.com

I have two use cases for placing an order on a website. One is directly submitted from a web front end with a creditcard, and the other is a notification of ...

57. Loading properites file using    stackoverflow.com

Please look at the following code for a MSSQL Server 2005. Properties File

driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://127.0.0.1:1433;databaseName=LibMgmtSys
user=sa
password=passwrod
Connection File
public class DBConnection {

    static Properties dbproperties;

    public static Connection getConnection() throws Exception ...

58. Importing a CSV file in Java    stackoverflow.com

I'm currently working on a program that needs to read in a CSV file in Java. Now I've got the file to load properly, that's not a problem, and I want ...

59. For a simple application, should I be using XML files or a real database or something else?    stackoverflow.com

I'm currently working on a simple Java application that calculates and graphs the different types of profit for a company. A company can have many branches, and each branch can have ...

60. Upload files to database virus check    stackoverflow.com

As part of our requirements, we need to upload some files to database. Is there any way we can do virus scan on those files before saving them to database. ...

61. Is there a file size limit of the clover db at 2GB?    stackoverflow.com

We have 3 clover dbs, one for clienttests, integrationtests and unittests. For calculating the total coverage, we merge those databases into a new clover db: As you can see, this works as expected ...

62. how log files are created in berkelydb java edition db base api    stackoverflow.com

we are using berkeleydb java edition db base api, we have already read/write CDRFile of 9 lack rows with transaction and without transaction implementing secondary database concept the issues we are ...

63. How to store rules in database and access them in java files instead of using .drl files in Drools?    stackoverflow.com

I am using Drools project and want to store rules in database as they will be configurable, even when application is running. I have searched on internet but didn't find any ...

64. Finding good ways to transfer big files among Java servers    stackoverflow.com

There in the project is a major DB Server, and other servers installed at different places maintain their own local Databases. We have to allow every system to update its local ...

65. Adding the xml file to the database using arraylist in java    stackoverflow.com

I am able to read a XML file using the following code.I need to Know how to add the xml to the device database using the arraylist. Xml code:

    ...

66. BerkeleyDB database file opening (java)    stackoverflow.com

I have a BerkeleyDB database with a .tld extension (eBay Turbolister file). Linux command 'file' confirms this is a BerkeleyDB database. I am following the tutorial at http://download.oracle.com/docs/cd/E17277_02/html/collections/tutorial/opendbenvironment.html. The com.sleepycat.je.Environment constructor ...

67. Grant security permission to an applet compressed into an JAR file    stackoverflow.com

I have created a standalone java app that uses a MySQL DB. I need to give security permissions to the applet inside the jar file. How do i do it without ...

68. Pass a java array into a netcdf file    stackoverflow.com

My program reads ascii files and saves the data into a four dimensional NetCDF file. This is the code that creates the netcdf dimensions, variables, and variable attributes using the Climate ...

69. Importing big XML file (100k of records) into database    stackoverflow.com

I am facing the problem the problem while parsing the XML. Its cosuming 47% of CPU and its very slow. It seems like DOM loads the XML into the memory and ...

70. Not able to read xlsx file saved in postgres database (as bytea) using apache POI    stackoverflow.com

I am using apache POI to read a xlsx file and upload the data in the database. I have to do this work in a scheduler(at scheduled time) running on Jboss. ...

71. Where are Websphere database configuration files saved?    stackoverflow.com

When we create a configuration from Admin Console for database configuration, those details will be saved in resource.xml (i think). What is path of the that configuration file?

72. Is there a Java library to cache files?    stackoverflow.com

Is there are java library that will cache files to memory and disk? Basically, I would like the library to cache the file to memory. However, if the in ...

73. Read .data `ehcache` file and write to database    stackoverflow.com

How do I read data from the disk storage of ehcache .data file and write to the database and then clear the file using java ?

74. Java Unzip each file into Database    stackoverflow.com

I am attempting to write a java application that will unzip an archive and store it in a database. I would like to insert each file in the database after it has ...

75. I have to fetch 500K rows from the database and write that data into the file , Means perform the I/O operation    stackoverflow.com

I have to fetch 500K rows from the database and write that data into the file , Means perform the I/O operation . I have done for two steps .

  1. Write each ...

76. copying xml file while its open in Java    stackoverflow.com

I am connecting XML with odbc:jdbc from java and updating A.xml file. After the updating is done, I am copying A.xml to different location and renaming that file(lets say copy.xml). Everything works fine. But ...

77. properties file for JDBC    stackoverflow.com

So my question is related to my previous post: SQLException : No value specified for parameter 1 I have no idea what a properties file is. Can I create a properties ...

78. Opensource library to save tree of java objects to db or file    stackoverflow.com

I am looking for an opensource library which can be used to transparently save java objects(and their dependencies!) to file or db, a kind of snapshot. Sample use case: I have the ...

79. How can I use XML files as database and access it through JAX-B API?    stackoverflow.com

I want to build a lightweight, "database" backed application, where the data can be stored in XML--- and use jaxB to move data to and from the persistant state. However, I havent ...

80. Which one is Faster in Writing to a file?    stackoverflow.com

I have very less experience of working on large files and constraints about memory. Please note that I am using Java as programming language. I have to find records in file size ...

81. Is there a JavaScript that will randomly select files from a database?    bytes.com

This is what I am looking for. So I will basically have two databases. One with the questions and one with the answers. Each database will have several tables. For example ...

83. Create Entinity from Database -> Doesn't create any file    forums.netbeans.org

Hi guys, I wanted to learn something about Persistence and used in NetBeans 6.7.1 the wizard, to create Entinity classes from a existing database. Now I use NetBeans 6.8 and yesterday ...

84. Read file(xml format) from database    forums.netbeans.org

Hi, Our project is ported on Netbeans 5.0. The currently file (XML format) is held on the local network file system (tree structure) Now, we have moved these files to database ...

85. Read file(XML format) from database and nodes hierarchy    forums.netbeans.org

Hi, Our project is ported on Netbeans 6.8 The current file (XML format) is held on the local network file system (tree structure) Now, we have moved these files to database ...

87. adding access file as a database bye user    forums.netbeans.org

88. Database port read from file    jmeter.512774.n5.nabble.com

Variables are stored as strings. Most fields on JMeter samplers are text, even if the contents are expected to contain only certain characters ... The database URL is expected to be entered as text - but some parts of it are restricted to certain characters, e.g. the port should consist of digits. If the ${dbport} variable reference is not being replaced, ...

89. Storing files in a central place (other than the database)    coderanch.com

I need to be able to create a file from user entered input through a web-app and store it in a central file system. Storing it in the database as a CLOB/BLOB/VARBINARY is not an option. The web-app could possibly farm out the request to any one of the cluster JVMs, and I need to able to store the created file ...

90. Generating flat file from Database    coderanch.com

Ok... I'm trying to pull information from a database, concatenate (sp?) it and throw it into a flat (text) file as one line per record. Currently, to check my program I use a system.out.println() to make sure I'm pulling and putting together the proper stuff. Yep, that works, goes through the entire database table and it's fine. However, whenever I go ...

91. lading data from file into database    coderanch.com

92. trying to use a txt file like a database    coderanch.com

Is there an easy way to do this? Currently it looks like I will be doing this the messy way using a FileReader wrapped by a BufferedReader and going through it line by line, character by character with the String methods. My txt files will be uniform and predicatable so there will be no problem with the data.

93. reading db and creating a file    coderanch.com

94. storing binary files - file server or database    coderanch.com

Hi, I have a small reporting system that I have written, where I generate PDF, XML, CSV reports. Currently I am storing the generated reports as binaryarray in the LONG RAW field of Oracle. My system generates 30-35 reports that have an average size of 57K. The max report size to date has been 1.2 MB, although there are less than ...

95. Readin a txt file to populate into the database    coderanch.com

I suggest you to use some class of java.util.*; package. for example ArrayList You must have in mind that you can use a dynamic array to get and store your data (remember pointers?) but you have to separate your records of text file with a specific character or *nextline* mark. But if you wanna put these values to the right columns, ...

97. Writing Database output to a file    coderanch.com

98. JPGs from db and then deleting the files    coderanch.com

Hi, I have made a photo gallery. 1) First I read in the jpgs as Blobs. For each Blob value I convert it to a BinaryStream which I write to a file ( FileOutputStream ). 2) Then I preview the jpg in a browser with the HTML tag . I just make a reference to the directory and file... That ...

99. Reading of file contents and then outputting it into a database    coderanch.com

hey there, im required to read the contents of a file, extract it and then output it into a database. i have no problems reading the contents and extracting it. however, i have problems outputting it into a database. i can only output it to the command prompt or to a text file. is it possible to output it straight to ...

100. How to copy values from db to a file    coderanch.com

Hi All, I can retrive values from database and print in the command prompt.But I cant able to copy the db values to a file.Any body plz tell me the procedure.Thanks in advance!!Waiting for your reply. -Ravi Kumar [edited out "urgent" from subject] [ March 13, 2006: Message edited by: Jeanne Boyarsky ]