Data 1 « Database « Java Database Q&A





1. Is there a Java equivalent for .Net System.Data?    stackoverflow.com

Is there a Java package providing funcionality like the .Net System.Data namespace ? Specificaly the DataSet and Adaptor classes ?

2. Application design for processing data prior to database    stackoverflow.com

I have a large collection of data in an excel file (and csv files). The data needs to be placed into a database (mysql). However, before it goes into the database ...

3. Strategy for Offline/Online data synchronization    stackoverflow.com

My requirement is I have server J2EE web application and client J2EE web application. Sometimes client can go offline. When client comes online he should be able to synchronize changes to ...

4. Efficiently sorting data from DB using Java?    stackoverflow.com

What we have:

3 MySQL DB tables: user, text, friend user: username, password, email, etc. text: username, text, date, etc. friend: username, friend_username, etc.

Task:

Write an algorithm (in Java) to show 10 latest texts from your ...

5. Process huge volume of data using Java    stackoverflow.com

As part of the requirement we need to process nearly 3 million records and associate them with a bucket. This association is decided on a set of rules (comprising of 5-15 ...

6. Web form data structure alternatives    stackoverflow.com

Once I created a form builder where user could select any number of fields for a web form. The tool then produced a code snippet which user could copy in the ...

7. How to handle huge data in java    stackoverflow.com

right now, i need to load huge data from database into a vector, but when i loaded 38000 rows of data, the program throw out OutOfMemoryError exception. What can i do to ...

8. Managing static data    stackoverflow.com

I'm looking for a Java (or Groovy) solution for managing static data i.e. data in infrequently changing tables such as a list of countries. I would like to keep the list of ...

9. Why do most people say that data services and the database are the most important parts of a system?    stackoverflow.com

Why do most people say that data services and the database are the most important parts of a system? From what I have seen, it is the front end development: GUI, WEBUI, ...





10. Cached data Synchronization to Database    stackoverflow.com

What are the best ways to keep data synchronized between in memory cache and the database when used in a web application? Specifically, I store large amounts of database data in ...

11. Easiest way to deal with sample data in Java web apps?    stackoverflow.com

I'm writing a Java web app in my free time to learn more about development. I'm using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst ...

12. High volume queryable and traversable data structure    stackoverflow.com

I'm building an application and need a data structure of interconnected objects that can be queried and traversed. The connections between objects can be arbitrary and not necessarily known before ...

13. Java handling large amounts of data    stackoverflow.com

I have a Java application that needs to display large amounts of data (on the order of 1 million data points). The data doesn't all need to be displayed at the ...

14. Scrape data from HTML pages using Java, output to database    stackoverflow.com

I need to know how to create a scraper (in Java) to gather data from HTML pages and output to a database...do not have a clue where to start so any ...

15. How to store data of java array in Hard Disk, so as i can use it later?    stackoverflow.com

Goodevening Sir/Mam, I am trying to make a small program that will be used for hotel room reservation, please tell me how to store the data of room's status on disk, as ...

16. Recommendations for an in memory database vs thread safe data structures    stackoverflow.com

TLDR: What are the pros/cons of using an in-memory database vs locks and concurrent data structures? I am currently working on an application that has many (possibly remote) displays that collect live ...





17. cached data base    stackoverflow.com

in my project i need a tow tables each of it has about 2000 row , i want my application to be speed so my db should load into memory (cached) when ...

18. Architecture of a secure application that encrypts data in the database    stackoverflow.com

I need to design an application that protects some data in a database against root attack. It means, that even if the aggressor takes control over the machine where data is ...

19. Want to pull data from DATABASE using Java And Flex    stackoverflow.com

I Am Completely novice in flex could you just let me know about it plz.I want to access data from a database residing on a particular ip address and also i ...

20. Continuously fetch data from database using Java    stackoverflow.com

I have a scenario where my Java program has to continuously communicate with the database table, for example my Java program has to get the data of my table when new ...

21. Validation - Data Integrity    stackoverflow.com

A table can only store 10 records in a particular state, 10 users over 30 years for example, the others must be less than 30 years. It is a business rule ...

22. What are best ways to implement a single functionality to store data in different databases based on configuration?    stackoverflow.com

I want to implement a sample in java that reads a configuration from some config file and, based on that, when user interacts with the page the application will store some ...

23. how to display data from database using java beans    stackoverflow.com

I need to display the data requested by the user from the database on my jsp page.How can I do it using java beans?

24. How to download data as csv from database using java?    stackoverflow.com

I need to download the csv file from database using database. I have jdbc connection and execute the query , get the data from database.Those values are download as csv format using ...

25. how to send a mail with data extracted from a database with javamail and smtp?    stackoverflow.com

i want to send emails to an address with a java program (using javamail) via smtp. it actually send the emails to the destination. the problem is the body of the ...

26. How to store the data in a object array, which is collected from the Database    stackoverflow.com

Possible Duplicate:
how to store the data in a object array, which collected from data base?
The Below code will retrieve data from the database. i ...

27. How to make data from a database accessible from other web applications    stackoverflow.com

I have a database from which I want to expose data. Ideally I would like to be able to just add a URL into some other web page and that URL would ...

28. New App Data Decision    stackoverflow.com

A group has been using a VB app for a while and it uses an access db as its data storage. I've been tasked with completely redoing this in java. ...

29. Storing data in Lucene or database    stackoverflow.com

I'm a Lucene newbie and am thinking of using it to index the words in the title and description elements of RSS feeds so that I can record counts of the ...

30. Optimizing a BerkeleyDB JE Database    stackoverflow.com

I plan to insert a large number of unique keys ( ~3E9 ) in a BerkeleyDB JE database. The keys will have a fixed length ( ~10 bytes ) ...

31. How can an index be added to an Object Database in Data Nucleus?    stackoverflow.com

I am using NeoDatis (DB4O is another similar Object DB) under DataNucleus. I see a post on the NeoDatis forums on how to add a unique index on a class property (shown ...

32. data structure for counting frequencies in a database table-like format    stackoverflow.com

i was wondering if there is a data structure optimized to count frequencies against data that is stored in a database table-like format. for example, the data comes in a (comma) ...

33. How do I "obtain" data for all bars/clubs in US to a database. Yelp API?    stackoverflow.com

What I am trying to do is create a database of all bars in the united states. I need this database to be updated semi-regularly (every week or so) to ...

34. What is the correct data structure to use in java?    stackoverflow.com

I want to save integers in a data structure, but without knowing the number of integers i might get. I want the database to be of FIFO kind. What is best for this purpose? ...

35. How do I use eclipse Data Tools wizards?    stackoverflow.com

I'm working on a small eclipse/RCP application, which will require some Database and Table management and was wondering, how I can use the Wizards and Views which are included in Eclipse ...

36. storage lucene index in database using data objects in java    stackoverflow.com

Is this possible? I cannot access the database directly--only through data objects. Would I be able to search the index if the items are returned in something like ArrayList? If this is ...

37. The Microsoft Jet database engine could not find the object 'G:\DATA\Sheet1$.XLS'    stackoverflow.com

I have got an error in executing the below code, it says The Microsoft Jet database engine could not find the object 'G:\DATA\Sheet1$.XLS'. Make sure the object exists and that ...

38. Protocol buffers for serializing several data objects of a post/comment into a single serialized piece of data    stackoverflow.com

I am developing a social application on top of Java and Cassandra database. I need to store posts/comments of the user's shared posts, in database for which I am looking to ...

39. How to get the byte[] from a protocol buffer serialized data for writing to database?    stackoverflow.com

I am trying to use Protocol buffers to store serialized data in Database for a web application built in java. I have created .proto files and compiled them to get the generated ...

40. Data structure for dictionary    stackoverflow.com

I have serbian-english words in .rtf format and I need to extract it from this document and put them into some datastructure. I know to work with databases but I don't know ...

41. Best way to store data securely?    stackoverflow.com

I am looking for way to store some data. I want to users of my program to be able to choose a way to store data. They can choose database (PostgreSQL, ...

42. Better way to store data in java?    stackoverflow.com

I am currently working on a videogame, and i want to have the user be able to save their character to a new file. I know how to use the file ...

43. get data from a Db display in combobox in java    stackoverflow.com

hi everyone i have this code but don't know why it doesn't work!

rset = stmt.executeQuery("SELECT categoryName FROM DB_Library.dbo.categories");
while (rset.next()) {
    String s = rset.getString("categoryName");
    jComboBox1.addItem(rset.getString(s).trim());
}
don't ...

44. Tree structure based on data from database + faster tree operations    stackoverflow.com

I would like to have a 'n' level tree on my website, that is based on the data from database. I have made my mind on my java data structure. But ...

45. how to index data from database using solr    stackoverflow.com

I configured Import Handler for fatching data from MySql data base. In the solr example which i downloaded from net in C:\apache-solr-1.4.0\example\example-DIH\solr\db\lib there is hsqldb-1.8.0.10.jar. I want to know:

since ...

46. How to fetch data from database on scroll?    stackoverflow.com

I am using CachedRowSet in the java application to pull data from database. Suppose, if a query return 10,000 rows, my app will hang till i got all the rows. Instead ...

47. data to be kept in in-memory cache or db    stackoverflow.com

I've got the following problem: I've got a web application and the functionality is : A user needs to review documents assigned to him. After the user reviews the doc he will ...

48. Problems casting a Collection when trying to display a database data    stackoverflow.com

Hey guys I am doing a Database Manager proyect and I am not able to display all the data that I get from a db on a JTable. The code is ...

49. which database and encoding scheme would be appropriate for audio data storage?    stackoverflow.com

I have experience of relational database systems storing text data, and building applications for them. I have heard that relational databases don't really work for audio(multimedia) databases and some encoding scheme ...

50. Storing database data in an array    stackoverflow.com

What is the best way to store database data in an array? I need to be able to search the array for specific things such as getByID, getByDate etc...

51. how to develop a visual general data transfer interface system    stackoverflow.com

i need to develop a visual data transfer system,the below are functions of the visual system:

  1. import the data and table structure to SQLSERVER's table from oracle.
  2. export the data to some kinds ...

52. Asynchronous continuous polling of data from DB pushed to Java-client    stackoverflow.com

Could someone suggest what’s the best approach to go about this: What I like to do is draw a continuous poll (or query) of a database table. And anytime a new update ...

53. Problem exporting a lot of data from database to .csv with java    stackoverflow.com

I, thank for your attention. I want to export a lot of data, really a lot of data (6 million of rows) to a .csv file using java. The app is a ...

54. Framework/application to have inmemory copy of DataBase data    stackoverflow.com

We have a requirement to have a In Memory copy of data from our different Relational DB servers. Also keep the memory image updated if data in Relational DB servers is changing. is ...

55. How to get data from database using reverse ajax    stackoverflow.com

I am new to DWR; I am trying to get data from database using reverse Ajax. But i am confuse how to do this. Can any one tell me the process with ...

56. Collect data in cache and writing to database    stackoverflow.com

I need some help in Caching. Here is my requirement : I am having an application which has millions of hits per day. Currently i am logging the information like session and ...

57. Do the database specific Types go in Domain Model or Data Access Layer?    stackoverflow.com

I have my entities such as Customer, Order etc. defined in my Domain Model. Now I want to define an interface called IRepository to represent my persistence layer, i will further have ...

58. What's the right term to describe frequency of data access operations?    stackoverflow.com

I had through the term "data access pattern" could be used to describe how frequently data is accessed in different operation, i.e frequent read, write, update. However, when using the ...

59. How to find data into the class database?    bytes.com

P: 4 electrical /** Database implements a database of records */ public class Database { private Record[] base; // the collection of records private int NOT_FOUND = -1; // int used ...

61. getting data from database    forums.netbeans.org

JAG Joined: 05 Jun 2009 Posts: 12 Posted: Wed Aug 26, 2009 3:09 pm Post subject: getting data from database I have mysql installed on my PC. I ...

62. add data to database in netbeans 6.8    forums.netbeans.org

i am making an project with netbeans 6.8 and i m using web application. my problem is that i am not able to insert data on my database (in which i ...

63. Capture data from database    jmeter.512774.n5.nabble.com

64. Pumping Data into the DB    jmeter.512774.n5.nabble.com

65. Getting database data using RMI    coderanch.com

Hello, i'm writing a program for a uni project where several clients may interact with a database which resides on a server. To do this i am using RMI. I have been updating tables and submitting queries on the database ok. To do this i have simply been passing string sql statements to the server and then returing an array/vector populated ...

66. Axis2 Anync Service - Fetching data from a database.    coderanch.com

I have to built a client, that is going to invoke a web service in order to get data from a database using a date arg. The communication is going to be async (fire and forget). The issue is that web services communicate using SOAP messages, but I have DB data. So I thought that I have to take those steps: ...

68. suncertify.db.Data    coderanch.com

suncertify.db.Data (I/O and Streams forum at JavaRanch) A friendly place for programming greenhorns! Register / Login Java Forums Java I/O and Streams suncertify.db.Data Post by: Seshan Parameswaran, Greenhorn on Nov 14, 2000 07:29:00 Hi, I am posting the code for Suncertify.db.Data package suncertify.db; import java.io.*; import java.util.*; /** * This class provides the basic database services. It uses two ...

69. how to solve the data problem when we don't have backend database support?    coderanch.com

if we do a stand-alone application without backend database support, we have to read from /write into a file.We have other options ? if we use a external file, the problem is speed. How we get the better speeed ? one way is to use multi-thread, another way is to load into all data into a build-in collection, such as linked-list, ...

70. Look up data from different databases    coderanch.com

Hi I have a situation where I need to look up data from different databases.This is the case : I have data on Oracle and also data on Informix. I have entire access to the data on Oracle but not on the other. The only thing I can do is read data. How do I frame my query to retrieve data. ...

71. Data Trafer one DB to anothert    coderanch.com

Generally I am using a modeling tool before creating the database, so I can use its scripting tool to create the DDL which creates the database. So I am unused to doing what you are trying. You can pull the statements from the various system tables but that will be a lot of hassle. What I suggest is use a modeling ...

73. how to get data from a db into an array?    coderanch.com

Hi, I am trying to get data from a db into my jsp page as an array.How do i do that? I am calling the returned value from my method.But if i give the return type as String only a single value is returned. I tried to use array. if i say public String [] x( ) throws SQLException { Connection ...

74. Cannot display data from database    coderanch.com

Hi, I wrote a very simple JSP code (weblogic server, mssql server 7.0). The problem is that i want to get value from the databse into a variable and display it on the page. sample code is : <%
Connection conn = null;
try {
Driver myDriver = (Driver)
Class.forName("weblogic.jdbc.pool.Driver").newInstance();
conn = myDriver.connect("jdbc:weblogic ool:sqlServerPool", null);
...

76. Accessing Data from MS-Access database    coderanch.com

77. put Data from Vector into DB.    coderanch.com

78. How to retrive data from database    coderanch.com

dear friend, i have 1000 records in one table. i want to retrive 20 records every time. when first time retriving data its start from 0'th position to 19'th position. next time position of the record should be 20'th to 39'th. how to do this? can any body give solution for this question? regards saran

79. storing data from database    coderanch.com

hi, I'm using a JSP page to call a servlet which accesses a database and retrieves some data. on my JSP pages, I want to show 5 sets of data on each page, where users can see the next set of data by clicking a button or a link to the net page. my question is that when I connect to ...

82. Writing data to a Database    coderanch.com

Originally posted by Frank Black: HI, I'm trying a simple write to a small database in a MS Excel file using the following; import java.sql.*; class Insert { public static void main(String args[]) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn = DriverManager.getConnection("jdbc dbc roject2"); String ins = "INSERT INTO logon VALUES(?,?,?)"; PreparedStatement pstmt = conn.prepareStatement(ins); pstmt.setString(1, "X"); pstmt.setString(2, "Y"); pstmt.setString(3, "Z"); pstmt.executeUpdate(); ...

84. how to use data of type XMLTYPE in database in java    coderanch.com

Hi Paul , We are using Oracle Database. Per our architecture, Stored procedure will return this COLUMN of type XMLTYPE, along with other values. I would like to retrieve it along with other values. I think i might have to parse the values from the XMLTYPE data. Again, any sample code will be helpful. Thanks for your response

85. Transferring Data without JDBC from DB    coderanch.com

Hi guys, I have been asked to comeup with an app which will transfer Data from MySQL DB from one Server to another Server but without using JDBC. the reason is both these Servers cannot access each other as they are behind firewall. OK, now im wondering if this is possible? I was thinking of having a Server App which will ...

86. best way to collect data and put it in db    coderanch.com

Hello everybody, I am working in a "questionair" which is a many steps wizard I need to collect all the data then make a confirmation page then put them in a mySql db with my normal way ( getParameter() for each one) it will be difficult . also which session way i can use Thanks very much

87. populate all data from old database to a new one.    coderanch.com

Hi all, here is the deal: I have installed a mySql db on my client server. He has asked for some improvments and that required me to add some new tables and columns to existing tables. Question: is there any way to take all the data in his db and populate it into the new db? Thanks peter

88. transfer data from one DB to another    coderanch.com

Hi, I need to select data from one database (AS400 or SQL) and insert into another database (Access) I have done this in VB but getting it to work with JDBC is more difficult. I think I need to load two drivers? I do not want to select the records I want and then scroll through each result and run an ...

89. Uploading data from one database to another    coderanch.com

Which Database are you using... in order to insert/select into different database you need to have a db link to remote database. for example if you have Oracle the you can create a job excute it at interval of one day to perform your task, for oracle you have also option of materialized view. Another option would be perform task in ...

90. Extract data from database    coderanch.com

hello there. i want to extract data from database and display it in a list whereby users can actually select from the list.how do i go about doing it? any help will be appreciated.thx.this is wat i did. String s = request.getParameter("select"); //get parameter from list // Load the JDBC driver. Class.forName("com.mysql.jdbc.Driver"); // Establish the connection to the database. String url ...

91. Writing data to DB asynchronously    coderanch.com

92. Fetching Data From Database    coderanch.com

Ekrem, The Resultset has get methods for native types like getString(column_number OR "name"). So you could do sonuc.getInt(1); or sonuc.getInt("sayi");. However this depends on your compiler error. If the error has something to do with your query you may want to use the escape sequence \' for ' . Hope this helps. Joe

93. problem in fetching data from database    coderanch.com

94. Export data from database    coderanch.com

Hi All, I am just writing a small application that takes the back up of the mysql database and write in a file in any format (most probably in the .txt format) After taking the backup , i want to retrive the data from that file and export the data in the mysql database If please someone suggest how to a ...

95. best approach to move data between 2 databases    coderanch.com

Hi All, I have a question on which approach to follow for Migration of data from one database to another. The scenario is something like this. The source & target databases are from differnt vendors. We have created an exact replica of the table & column structure in the Target database similar to the source database. I am thinkin of writing ...

96. Unable to display data from access database    coderanch.com

Hihi, This is my code... import java.net.URL; import java.sql.*; import java.lang.String; import java.lang.StringBuffer; public class SQLQuery { public static void main (String argv[]) { SQLQueryFormat a = new SQLQueryFormat(); System.out.println("\nEstablishing Connection - Pls Wait... \n"); try { //Connect to the database specified in the URL Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbcdbc:EG1"); System.out.println("Connection Established.\n"); //Create a SELECT statement object Statement statmt = con.createStatement(); ...

97. Change in Data Type in DB will effect java code?    coderanch.com

all, I have a Sybase DataBase with some Stored Procs and tables. the code/background processes are in Java & C. In one of the tables I have to modify the datatypes of the column from char to TEXT. What changes should i make in my Java Code?( as they are inserting/editing tables) Thanks Frank

98. automatic calculation of data in database.    coderanch.com

Hi All, I have a table that has a the following field DATE,ITEM_SOLD,QTY_SOLD , This table will have count of how many pieces of the items were sold on that particular DATE, i want to have an additional column that will hold how many items have been sold so far How can it be achieved , what are my options? I ...

99. Duplicating data from remote database to local databse    coderanch.com

Hi Currently I am accessing remote data base for my project. I am connecting it through VPN (cisco). Although its serving my purpose but I am facing some other performance issues. So I am planing to transfer the data I required from the remote data base to my local database. Can anybody help me in 'How to transfer data from remote ...

100. how to display data in dropdown box from database using java code    coderanch.com

hi all, i have a small issue to be solved.i am using mysql database and i have 6 tables.i need to retrieve data from database and i have to display that in dropdown for example i have to display all the states names in drop down like that cities,areas...so please help me in this issue