Record 1 « Record « Java Database Q&A





1. How do you robustly implement a REST service that retrieves DB records then purges them before returning?    stackoverflow.com

Scenario Imagine a REST service that returns a list of things (e.g. notifications) Usage A client will continually poll the REST service. The REST service retrieves records from the database. If records ...

2. suggestion on batch processing db records    stackoverflow.com

I am working on developing a webapp (visual jsf, ejb3, hibernate on glassfish/mysql) that works with an existing legacy system. I have an 'employee' table (with fields such as name (String), location ...

3. Sort DB records with JdbcTemplate    stackoverflow.com

How to Sort DB records in DB table with JdbcTemplate? What is the best solution, should execute method be used?

4. How to get a random range of 10 records from a database without overlapping the end boundary?    stackoverflow.com

I need to get a List of 10 consecutive database records from a random offset in the database each time. The problem I see with this is overlapping the end boundary. For example: Let's ...

5. Indexing database records in lucene    stackoverflow.com

I wish to index data across few databases of our application in the lucene. how to structure the index? index per table such that the columns are the fields and data ...

6. How to estimate proper batch size number when processing DB records    stackoverflow.com

So let's say I have a processor that takes records from one table transforms and place them into another table. I'm trying to figure how many records I can load into ...

7. recording cpu usage of java applications    stackoverflow.com

At present I have a set of benchmark tests for recording the speed at which a Java application connects submits and returns data from varying RDBMS housed on varying server platforms. ...

8. java code fore crating 2 progress bar,which showing the % of db migration and % of record migration    stackoverflow.com

I have a java application,which used to migrate data from java db to mysql.And the migration % will show in a progress bar.how it will do ie. depends upon migrtion process ...

9. Problem in writing more record to berkeleyDB    stackoverflow.com

i am using berkeley DB JE 4.1.10
i have use the secondary database concept and I want to insert 10,00,000 rows to the database .

i am getting following error

Exception in thread "main" ...





10. Retrieving a million records from a database    stackoverflow.com

There is a database it contains 2 million records approx in a table . and i ran the query from my java code like this " select * from table" . ...

11. Best practice to implement: supervisor can search records of his subordinates?    stackoverflow.com

By implement a method in DAO layer(or Data Access Layer) like this:
getRecordsBySupervisor(String staffid)?
What is the best practice to control this kinds of access ? It seems that most of the ...

12. How to add/update records and save records to database    forums.netbeans.org

Hi, I am a beginner and still learning about Netbeans and java language. I'm currently doing a project that allows user to add attributes through a webbrowser, so far, I am able to add attributes, but I cannot save the records to the database. This is my code for the save button in my project: Code: public String save_action() { ...

13. Is there any way of doing JDBC recording    jmeter.512774.n5.nabble.com

Hi, I am trying to load test an application (client - server) - thick client. Now most of the requests sent are JDBC and SOAP. Is there any way of recording these requests? If so can anyone please tell me how? Are there any other 3rd party tools that can help me record the jdbc requests?? Can I sent multiple SQL ...

14. JDBC sampler overhead and the number of records returned    jmeter.512774.n5.nabble.com

Hoi, for testing Oracle JDBC responsetimes of "not-very-short" running queries I recognized, that the size of the resultset (i.e. number of records) impacts the measured time somehow exponentially when exceeding e.g. 1000 records. Example: Query X with a result of 1000 records needs 2 seconds Query X with a result of 2000 records needs 4 seconds Query X with a result ...

15. Why didnt see 10 records in database ?    jmeter.512774.n5.nabble.com

I use JMeter to test my web application. and my test case is to add a record in database. and then I set the "number of thread user" to 20, it means that it will simulate 20 users work at the same time. and then I run the test case. But finally i found the system didn't create 20 records in ...

16. problem insering a record in database    coderanch.com





17. Adding a record to a database-new to JDBC    coderanch.com

Could someone Please help me - I am able to read data from a MS Access database and display it in my GUI - w/first and next buttons - how do I add-- take input from a user and write this information back to the database? Then be able to look it up. (save it) I'm trying to make an address ...

18. How to do Bulk Emailing when u have Millions of records????    coderanch.com

Please don't take anything personally, but I have a very strong moral/philosophical problem with helping a spammer conduct business. Exactly how many mail servers are you trying to crash with this application? How much space are you trying to take up on machines that don't belong to you? Do you have permission from all 4,000,000 recipients to store your data on ...

19. get a limited no of records    coderanch.com

20. Retrieving Records from database    coderanch.com

hi i have say 50 records to be displayed as 10 per page. now since i am displaying only 10 on one page i would like to fetch only the first 10, then 2nd 10 and so on... right now i am fetching all 50 and showing 10 per page which slows up the speed considerably. so is there any way ...

21. Printing Database Records to an external printer/paper?    coderanch.com

I'm very new to java... How do you print information on paper (e.g. a record from a database) through java. Is there any method to print the info directly to the printer without writing it in to a file first. I would like to be able to send reports to a printer based on the data that I have in my ...

22. Large no. of Records problem    coderanch.com

Unfortunately you don't give any information on the crash (A Java exception? If so, what's the stack trace? An OS exception? If so, what type and is it the database or the application server? A hang? Database or application server?) Also please give some more technical detail. 500,000 records - are you doing all of it in one transaction? Are you ...

23. How to determine the number of Result set records.    coderanch.com

I am using MySql if that matters in answering my question. I have written my first program using MySql and can display information from an SQL query. Question: What is the best way to determine the number of records returned by the result set. . . ResultSet RS = Stmt.executeQuery(theSQLQuery); while (RS.next()) { System.out.println(RS.getString(1)); } I know I can put my ...

24. Paging the records    coderanch.com

25. How to determine Primary Key of New Record    coderanch.com

I'm looking for advice. I have a table whose primary key is an auto-incrementing field. I can use "INSERT INTO tablename (Field1, Field2) VALUES (123, 456);" and that works, but how do I determine the primary key of that record I just entered? I tried playing with updatable recordsets, but they really don't work. (See 'Error When Entering Data') And, yes, ...

26. Record Level Un/Locking.. URGENT !!!    coderanch.com

Hello folks, I am working on a project wherein recrod level locking is been already implemented using a Hash Table. To unlock the particular record, the onUnload() method is used. (I don't have any idea why HashTable...)Due to some reasons, this onUnload() solution has become very unreliable. So, I'm to provide a better solution for this. Solutions though of so far... ...

27. Adding Record Problem in JDBC ?    coderanch.com

28. Problem in viewing records ?    coderanch.com

Hello to everyone; I have a problem viewing my existing 2 tables in my database, in which the fields will be displayed in the JTextFields.. A book gave me an idea like this : try { Statement statement = connect.createStatement(); String query = "SELECT * FROM Records " + "WHERE Lastname = '" + t1.getText() + "'"; ResultSet rs = statement.executeQuery( ...

29. How to extract current month and year's records alone    coderanch.com

Hi All, Can anyone let me know , how to fetch the current month and years records alone from an Table.(my database is Oracle). Here are the sample of records: TSKID TSTAMP T1 20-MAR-2002 T2 21-JAN-2003 T3 22-MAR-2001 T4 23-APR-2003 T5 12-MAR-2001 T6 27-MAR-2000 T7 12-MAR-2002 T8 09-APR-2003 T9 08-APR-2003 T10 22-MAR-2003 T11 23-MAR-2003 T12 24-JAN-2003 so i want to take ...

30. rownum is always 1 for all records!    coderanch.com

Hi Guys, I am trying to access rownum (predefined column for all tables in Oracle) from java code and for some reason it is always 1 (number) for all the records in the resultset. Here is the query I am tring... import java.sql.*; public class testcon{ public static void main(String[] args) { try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url = "jdbc :-o ...

31. How to check record exists    coderanch.com

Hi, I would think that if(rs != null){ // code block } would send you into the code block ... isnt there always a resultset returned even if there are no records. but i would also think that if (rs.next()){ // code block } SHOULD not let you into the code block if you have no results.

32. Child Records - When to load?    coderanch.com

Say I've got two tables with matching Java Beans. We'll call them Order and OrderItem. The Order bean contains a Collection which holds all OrderItem beans of that order which is modeled in the DB as a One to Many. My question is should not the developer know exactly when they will need only the Order bean and when they will ...

33. can anyone guide me in browsing records.    coderanch.com

Iam trying to browse 5 records per page.. and have a next and previous button to scroll through the page. Got to know that there is a tag lib for the same. can anyone give me a brief view for the same.. iam using Vectors to store my records. bt iam fairly new to the same .. i would be thankful ...

34. iterating thru records    coderanch.com

35. Store login record in database    coderanch.com

Hi, im currently working on a project on jsp. i am required to keep track of the user's details when they log in successfully. for example, when the user log in to the system, i have to keep record of the user's login name and time (system's time) and store the record into a table (table's name: log) in the database. ...

36. JDBC - number of records fetched    coderanch.com

Narasimha, If you can employ any more filtering in the where clause, do that. But it sounds like you already tried. Another thing to suggest is to do your logic check in a stored procedure. That way all the data doesn't need to be transmitted. If you don't have control over the remote database or the network, there isn't much you ...

37. Matching a String with a certain record    coderanch.com

Thanks for the help! But here's another question along the same lines. Why does it have to be in a loop to work. I have tried this: while(myResultSet.next()){ id = myResultSet.getInt("id"); firstname = myResultSet.getString("firstname"); lastname = myResultSet.getString("lastname"); System.out.println(this); }//end while loop //this pulls the last record from the while loop "John" why? if (firstname.equals("Chris")){ System.out.println("Chris is cool"); } //I tried this ...

40. too many records    coderanch.com

42. Determining how many records have same field    coderanch.com

I am trying to get a count of how many records in a table have the same date field. I want to do something like this: SELECT count(*) from auction where contactID = 360 and date = date; Problem is the above gets all records. Is this something I need to do programatically in Java or can this be done in ...

43. Database record change identification    coderanch.com

Hi Is there any way of intimating a program automatically when a record in a database is changed by the database administrator without the program's knowledge. And is there any way to check whether a record is changed since previous visit and to load that data only if that record has been changed.

44. doubt about master details relation and JDBC manner about retrieving details record    coderanch.com

Q. I have a SQL (the language) question where should I ask it? There are a vast number of SQL references, primers and tutorials available on the internet. It is recommended that you use Google to find an appropriate syntax guide for your database because databases do tend to have their own specific SQL dialects and what works on one system ...

45. Data Record to Database    coderanch.com

46. Large Records Problem    coderanch.com

47. Looping through records while looping through record    coderanch.com

I have 2 tables. I look through the first table to find all the records that have the users email and display them, but part of the information is in the table 2. so I need to compare id (item) in table one with the one in table 2 so I can get the items description from table 2. hope this ...

48. SQLexception-duplicate records    coderanch.com

I am creating an application which reads data from an external source and places it into a DB2 table on the users workstation for further processing. Depending on the selection criteria used the data read could contain the some of same records that are already in the database which results in an SQL exception (-803) because the primary key already exists. ...

49. Record Export?    coderanch.com

You've got a number options with Excel. You could export your data using whatever tools your particular database provides (such as DTS with SQL Server or exp with Oracle) in a format you can import into Excel, CSV being the most obvious one. Or you could write some VBA control in Excel to connect to the database and query the data ...

50. editing records    coderanch.com

I have an access database, in which I have a table customers. There are columns - customer id, first name, last name, address line 1, address line 2, city, state, and zip code. The records are identified by the primary key, which is customer ID. I need to be able to access a record using the customer ID and change any ...

51. Unable to Iterate over large number of records    coderanch.com

Hi All, Please take some time out and give your views/comments on the following use case. There are 300000 records in the database table. But when I query this table for all records I get 99999 records only. Seems there is limitation on number of records that can be fetched from result set. Is it related to driver restriction? Database:- Sybase ...

52. Getting random records    coderanch.com

I don't understand how selecting random records through java is going to be effective. With java you need to - Generate the Random numbers (What numbers?, How is it going to be used? You need to find out the domain boundary (max row or max value of numeric column) - Bind these values to the SQL Query using IN operator. (Define ...

53. VARCHAR2 TO CHAR - not records returned.    coderanch.com

Hi All, I changed a oracle table column types from varchar2 to char for making the job of other teams easy since they have legacy systems. I was using the prepared statements to query on the table and was using setString(1,pnum) to pass the part number as parameter. After the varchar2 to char change prepared statements stopped working. If I query ...

54. Getting random records    coderanch.com

Kudret, I haven't used MSSQL, but there are two approaches I can think of. You'll need to check whether they are supported. 1) If the database supports random number generation, do an "order by" on that function and then use ROWNUM to return the first 20 rows. 2) Generate 20 random #s in Java between 1 and 600. Then add a ...

55. caching of database records    coderanch.com

57. Retrieve record from DB?    coderanch.com

58. records modified by more than one users    coderanch.com

Hello: I have a method to modify a record in an Oracle database using JDBC. Chances are that one record can be opened and updated by more than one person, certainly whoever modified the last will get his/her modification into the DB. how would I pop a message to let others know that the record has changed and please reload or ...

59. Trying to grab the last record.    coderanch.com

I can grab all sql and put them in desc order. Then I try to run the code through until it gets to the last Admin key in the series and hold that record and write to transaction file. Except it gives me all the records not just the 07D one. It gives me all records in the series not just ...

60. Is there anything close to Active Record for Java?    coderanch.com

It might be a pointless question, since Java is so different then Ruby. For those not familiar with Active Record it is a wonderful tool for Ruby on Rails. It abstracts SQL statements into Ruby method calls. Ruby is flexible enough to handle creating new methods for a class dynamically. As an example: Message.new(params[:message]).save creates and saves a new row in ...

61. not insering all the records (please help!!)    coderanch.com

Hi all, i am creating a tableA with a few records in one connection. With another connection i am inserting all the records from tableB into tableA In short i append the tableA with tableB using the execute statement below. st2.executeUpdate("insert into FormulaQ1Q2 select * from FormulaQ1") The prblem is not all the records are being inserted. After appen i should ...

62. Handling massive number of records    coderanch.com

Hey, In our application we have read one day record from MySQL database, make a little change on each retrieved record and then save the records to a new database. Please note that each day holds a massive number of records (could be a million records). What is the best strategy to implement this? I'm thinking to use MySQL limit keyword ...

63. compare records    coderanch.com

Hi , actually it's not aa replication process we already got a replication tools but some times the data after replication are not the same so what i need is a tool to compare the data in both tables and mad any necessary update or insert process so after that the both tables will be identical. Got me ?

64. how to implement Concurrent access to records..Please help me URGENTLY    coderanch.com

Hi All, I have a scenario as below Please help me out to implement this ;-) ------------------- Scenario ------------------- 1> 2 users are accessing a single record (in a web based J2EE App) at the same time 2> 1 user should be able to see one of the records in READ ONLY MODE and the other user in WRITE ONLY MODE ...

65. handling zero records found    coderanch.com

Hi All, In a database intensive application where there is lot of retrieval happening there could be every possibility of "no records found" scenario may be due to missing data. Typically in java we indulge in a lot of paranoid programming where in we always have something like (if results != null or !results.empty()). But this is really not a complete ...

66. Putting records into the database with a java application    coderanch.com

Hello, I need your help, i need the actual code to create an application that reads a file of values of different fields with any delimiter and sends all the values to the required fields in the database Example a bible database has three columns chapter, verse and message a file in this format genesis, 1, In the beginning God created ...

67. retrieving a record from a database    coderanch.com

hi, If I click on a link of an ID that relates to a record of an entry in a remote database, how do I retrieve the record? For example,on my browser I'm providing a link to an id called 9657715, by clicking on which I've to connect to "http://us.expasy.org/cgi-bin/sprot-search-ful?makeWild=&SEARCH=aaf95915.1" and from the result page(not display this page on the browser), ...

68. Java Objects and Database Records    coderanch.com

Can anyone suggest suitable reading material to guide me in designing class's which specifically map to database tables and provide a "standard" approach to record manipulation. For example I find myself unsure as to the best practice for creating a new record in a table. Do I create a new instance of an object, passing the primary key to the constructor ...

69. Populate LDAP with DB records    coderanch.com

Hi all, I'm setting up some performance testing, and to do so, I need to set up a lot of dummy users and user groups. I've got a SQL script that does this quite well in our database, but our system checks against a SunOne LDAP server and when something is in the database but not in LDAP, it automatically disables ...

70. Comparing a java object and a database record    coderanch.com

I dont know is the ready to use code available. But you can always write own framework for 1.Parse the file for records and create java object with getter/setter method (like Java Bean) 2.Create mapping file to store mapping between record and hibernate object. 3.Read mapping file and compare record object values with hibernate object (need to handle casting properly, it ...

71. database records transfer    coderanch.com

72. Threading and Unique Record Question    coderanch.com

I have a struts action "CreateUserAction" which calls a DAO method "createUser" method which contains two SQL statements: SELECT * FROM USERS WHERE USER_NAME=? (if it does not exist) INSERT INTO USERS .... My question is, couldn't the DAO method "createUser" thread stop (sleep whatever) right after the "SELECT * FROM USERS WHERE USER_NAME=?" for a brief moment before running the ...

73. Form binary tree in java based on database records    coderanch.com

Hi, I have following table structure. CUST_ID | PARENT | LEFT | RIGHT | REC_ID =========================================----- | | | | MLM1 | | MLM2 | MLM3 | 1 ------------------------------------------------------------------------ MLM2 | MLM1 | MLM4 | MLM5 | 2 -------------------------------------------------------------------- MLM3 | MLM1 | MLM6 | | 3 ----------------------------------------------------------------------- MLM6 | MLM3 | MLM11 | 4 ------------------------------------------------------------------ MLM4 | MLM2 | MLM7 ...

74. Need Help in One to Many Records.    coderanch.com

75. Getting First n Records    coderanch.com

Thanks for the reply Bil. I know that this can be easily achieved thru queries, where as we can get the records for a particular limit. Ex: in DB2 we can use FETCH FIRST N RECORDS to do this. But i just wanted to know, is the same is possible on a reselt set , where we already got the full ...

76. is exist any multi record catalogue? or better to use DB? or array?    coderanch.com

Dear All, Im trying to write a book trading project. where buyer and sellers are trading some books. here, I need to use a catalogue (or sth like that)to save the list of available books with their details in it . like for examle an array for book : "JAVA PROGRAMMING BOOK", 100,10 ,25,5 ,7,2. which shows book title, book price, ...

77. creating an employee records program    coderanch.com

hi i have a problem i need to create a employee program in GUI link with SQL database that can add, delete sort and retrieve employee from the database, i need to use the linear and binary search method including sorting method. Can any one tell me how to go about this!

78. Show only one record instead of specific record when onclick    coderanch.com

Hey guys, i am facing a huge problem in my update form Like when I click on 1101, it show the records of 1101 to be updated. But when I click on 1102, it still show the 1101 record instead of 1102. Which mean whatever product I click on it will still be the same 1101 record My servlets codes are: ...

79. How to search record on (firstname+lastname) or (lastname+firstname)? please help me    coderanch.com

public List getEmployeeSearchDetails(Integer teamId, String empname) throws DataAccessException, ServiceException { Connection con = null; CallableStatement cstmt = null; ResultSet rs = null; java.util.ArrayList employeesearchDetailsList = null; try { con = super.getReadOnlyConnection(); String str[]= empname.trim().split("\\s"); cstmt = con.prepareCall(qryforEmployeeSearch_fullname); DBHelper.bindString(cstmt, 1,str[0]+ "%"); DBHelper.bindString(cstmt, 2,str[1]+ "%"); } rs = cstmt.executeQuery(); catch() {} }[/color][/b] DBHelper class is as [b][color=blue] public final class DBHelper { public ...

81. Sequencing Records    coderanch.com

82. Record Set closing    coderanch.com

83. records between sequence numbers    coderanch.com

84. How to show results as zero if no record exists?    coderanch.com

Hello, I have a problem. For every day of a month (lets say February) I want to show records from a PhoneCall table stored in a MySQL database. The PhoneCall table looks like this: Record No. Date PhoneNumber ------------- --------------------- ----------------- 1 2010-02-01 10:04 491111111 2 2010-02-03 08:35 492222222 3 2010-02-03 08:40 491234567 You see for the 2nd February NO phone ...

85. question about multi user work on record    coderanch.com

I have customer table. In that table, I want to update some field which are null or invalid. for ex. in Customer table, I have 1000 record. In GUI, I have next, previous and update button. If more than one user will work to update that record, How it will work. Is it possible, if first user open 1st record then ...

86. Saving database records problem    coderanch.com

I have 3 tables (MySQL). Invoice, product and JoinTable InvoiceItems. When I have new Invoice, I select one ore more products from Product table. I need insert one row in Invoice table and one or more rows in InvoiceItems table. Product table not change. I geting error that column 'idinvoice' cannot be null. Can somebody help me please please please. You ...

87. Get records by database row number    coderanch.com

88. Active/Inactive a record    coderanch.com

I dont think any DB has any in built flag to mark a record as active/inactive. Its something the DB user has to do. Either you have to flag your record as inactive, or end date a record or design some way to mark a record as active/inactive. But in any of these cases, you have to take care of marking ...

89. Checking if a record exists    coderanch.com

Hello : ) I've been having trouble writing this code that should be relatively simple. I'm wanting to check if a record exists, if it does then it is deleted, if not then a JOptionPane shows up. My experience in SQL is limited but I don't think this should require much SQL knowledge in the first place to execute. I've spent ...

90. Check if record exists in database    coderanch.com

I know a similar thread already exists, but it doesn't fully match my problem. I esstentially want to run a count query which counts how many times a username appears in database (should be either 1 or 0). From there I'm wanting to perform a few more commands if the record exists. My problem lies with not knowing how to execute ...

91. selecting only those records with the largest value in a column    coderanch.com

Consider this Oracle database table with this data: create table responses_v5 ( user_id varchar2(20), hw_id number(38), pb_id number(38), tries number(38), grade number(3,2), response varchar2(20), primary key(user_id, hw_id, pb_id, tries) ); insert into responses_v5 values ( 'bob', 4540, 1, 1, 0.0, 'response1' ); insert into responses_v5 values ( 'bob', 4540, 1, 2, 0.0, 'response2' ); insert into responses_v5 values ( 'bob', 4540, ...

92. how can i take 1st record from database??    java-forums.org

Still won't matter. rownum is (usually) simply a tag onto a query. It's not a physical thing. Consequently, as I said, the concept of "first record" is meaningless without an order by...there's no guarantee (in SQL) that you'll get the rows back in the same order for the next time you run the query. So the OP needs to figure out ...

93. How to get Record Names?    java-forums.org

Hi Darryl what is wrong in my question most important is how to get that solution man, always you bang on English, you cant expect everyone to be like you, i am weak at English, your are a moderator man you should understand our problem and try giving solution and then recommend us to read, not just always give us link ...

95. How to manage large database records in enterprise application    forums.oracle.com

Hi All, I am working on a large enterprise application relating to Capital Market. I am working in Java and with its extended technology. I am facing one critical problem which needs solution from your side. I have a database table which contains approximately more than 5 millions of records, I want to display the records with proper pagination. Here I ...

96. java project database and student records.    forums.oracle.com

here is what i have so far. [code] J Ogunsakin 4:14pm April 22nd Yo, this project is really hard. This should help with part A. Well, we can all see that you've put in a good effort so far... If you're having difficulty with the bubble sort, you should start by spec'ing it out: What attribute are you sorting on? (name, ...

97. Database returns no records and code breaks.    forums.oracle.com

I've found out that the compiler is throwing a NORECORDFOUNDEXCEPTION. Now can anyone tell me what should I do make sure that the statement after the query execute even when the query throws an exception. Should I place the next statements in the catch block? Or Should I place the next statement int he finally block? OR Should I just put ...

98. DB Record DML Style - Where should the DML go?    forums.oracle.com

Situation: I have a class that represents a record in the DB. I have another class, potentially many classes, that instantiates the "record" class. Q1: When inserting a record object into the DB, should the insert code be in the record class or the class that instantiates the record class? Q2: Where should the JDBC/connection details be? Thanks, Gregory

99. Comparing value in a vector to a primary key value in db and get the record    forums.oracle.com

Put a println in the listener code to see if that event is even firing properly. Also, you don't need the check on the result set for null (can't hurt, but it should not be null). In your println, show which index is being passed. Check if that is in fact in the database. Proceed methodically. - Saish

100. Make binary tree form database records    forums.oracle.com

public void setRightChildNode(MLMTreeNode rightChildNode) { this.rightChildNode=rightChildNode; } /** * @return the customerId */ public String getCustomerId() { return customerId; } /** * @param customerId the customerId to set */ public void setCustomerId(String customerId) { this.customerId = customerId; } /** * @return the ownPoint */ public double getOwnPoint() { return ownPoint; } /** * @param ownPoint the ownPoint to set */ public ...