1. How do you robustly implement a REST service that retrieves DB records then purges them before returning? stackoverflow.comScenario 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.comI 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.comHow 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.comI 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.comI 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.comSo 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.comAt 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.comI 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.comThere 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.comBy implement a method in DAO layer(or Data Access Layer) like this: |
12. How to add/update records and save records to database forums.netbeans.orgHi, 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.comHi, 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.comHoi, 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.comI 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.comCould 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.comPlease 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.comhi 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.comI'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.comUnfortunately 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.comI 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.comI'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.comHello 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.comHello 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.comHi 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.comHi 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.comHi, 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.comSay 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.comIam 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.comHi, 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.comNarasimha, 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.comThanks 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 ... |
38. Clone a record in the database or element in an arrayList coderanch.com |
39. Loading a large records from database to htm select control coderanch.com |
40. too many records coderanch.com |
41. What would be returned when the record is empty? coderanch.com |
42. Determining how many records have same field coderanch.comI 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.comHi 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.comQ. 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.comI 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.comI 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.comYou'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.comI 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.comHi 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.comI 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.comHi 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.comKudret, 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 |
56. limitation of retrieving the records from the database coderanch.com |
57. Retrieve record from DB? coderanch.com |
58. records modified by more than one users coderanch.comHello: 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.comI 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.comIt 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.comHi 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.comHey, 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.comHi , 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.comHi 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.comHi 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.comHello, 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.comhi, 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.comCan 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.comHi 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.comI 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.comI 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.comHi, 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.comThanks 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.comDear 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.comhi 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.comHey 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.compublic 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 ... |
80. 2 lakh record from db to List object out of memory problem coderanch.com |
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.comHello, 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.comI 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.comI 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.comI 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.comHello : ) 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.comI 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.comConsider 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.orgStill 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.orgHi 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 ... |
94. JDBC records retrieve in primitive type as 2D array to be store in excel forums.oracle.com |
95. How to manage large database records in enterprise application forums.oracle.comHi 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.comhere 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.comI'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.comSituation: 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.comPut 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.compublic 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 ... |