Hemanth.Satkuri

Am trying to add a constant column to the select query which is quering an inner query. Need your help with the query. select *,'1' as flag from ( select ROW_NUMBER() OVER (PARTITION BY e_id ORDER BY birth_date DESC) as rn,wh.birth_date,e.*, xy.m_id from employee e inner join table2 xy on …

I am calling a Stored Proc in Oracle using Hibernate. Procedure: create or replace procedure GetStocks(email in VARCHAR2) is BEGIN execute immediate 'SELECT * FROM stock WHERE email=email'; END; Java Code Query query = session.createSQLQuery("CALL GetStocks(:email)").addEntity(Stock.class).setParameter("email", "abc@xyz.com"); System.out.println("QUERY:"+query.toString()); System.out.println("QUERY SIZE:"+query.list().size()); List result = query.list(); for(int i=0; i<result.size(); i++){ Stock st …

Hi, I have a desktop app in Swing. Now i want a javascript function like mailto when I click a JButton. Please help or provide any suggestion on my approach. Thanks in Advance. :)

I am able to insert the document with attachments in it as blob into Oracle DB. I am able to download the same document with the same attachments. But When I open it(blob) with Document Builder and write some lines of text in it and convert back to Blob and …

Hi, I have a file uploaded in DB. Can i download it from Swing application. By Download I mean with options like Open,Save,Cancel and set the response type based on the file's extension. Thanks in Adv. :)

String testHTMLContent = testhtml+productlogo; Message message = new MimeMessage(session); message.setFrom(new InternetAddress(usern)); message.setRecipients(Message.RecipientType.TO,InternetAddress.parse(to)); message.setRecipients(Message.RecipientType.CC,InternetAddress.parse(ccaddr)); message.setSubject(sub); //message.setText(body); // setDebugMsg("Attempting to send..."); Transport transport = session.getTransport("smtps"); MimeMultipart mimeMultipart = new MimeMultipart(); MimeBodyPart msgContent = new MimeBodyPart(); msgContent.setContent(testcontent, "text/plain"); mimeMultipart.addBodyPart(msgContent); MimeBodyPart query = new MimeBodyPart(); query.setHeader("Content-Type", "text/plain"); query.setContent(queryString, "text/plain"); mimeMultipart.addBodyPart(query); MimeBodyPart htmlPart = new …

Help me in constructing a MySql Query to retrieve the rows based on datetime column. Below are the conditions: 1)The date difference between today and date in that column sholud be =>2 days. 2)If the day of the date in DB column is Thursday/ Friday then the date difference between …

I have a Date Picker code. Can you help me in constructing the Time Picker . Or can you suggest me some websites/materials to refer Thx in Advance

Hi, When i communicate with user first time recent_date will be of that date , I want to query all the rows based on recent_date>= 2 and if day of recent_date is Thursday then recent_date >=4 and if it is friday then recent_date>=4 Basically I dont want to count Saturday …

Hi, I have created a table with first column as checkbox. Using the below Code.. TableColumn tc = constructedTable.getColumnModel().getColumn(0); tc.setCellEditor(constructedTable.getDefaultEditor(Boolean.class)); tc.setCellRenderer(constructedTable.getDefaultRenderer(Boolean.class)); tc.setHeaderRenderer(new CheckBoxHeader(new MyItemListener())); I sometimes get stackoverflow exception. Is This beacause of the above code..?

Hi , Is it possible to have loaders in Swing. By Loaders i mean, showing a loader image with masking on the application till the data is retrieved from DB and displayed in TextArea. Just like we have ajax loaders Not allowing to access other screens in the application with …

FIRST: String str = queryTextArea.getText(); final JTextArea textArea = new JTextArea(); textArea.setFont(new Font("Sans-Serif", Font.PLAIN, 12)); textArea.setText(str); textArea.setCaretPosition(0); JScrollPane scrollPane = new JScrollPane(textArea); scrollPane.setPreferredSize(new Dimension(350, 150)); int res = JOptionPane.showConfirmDialog(null,scrollPane,"Query", JOptionPane.OK_CANCEL_OPTION, JOptionPane.PLAIN_MESSAGE); System.out.println( "showInputDialog: " + res ); if(res==0) queryTextArea.setText(textArea.getText()); Using this I'm unable to resize the document-modal SECOND: String str …

Hi , I have a java string like: From: someuser.ha@domain.comDate: 8/7/2012 5:20:39 PMTo: abcd@domain.comCc: abcd.efg@domain.comSubject: This is the suject line Hi,I would like to recover all my money from the bank. Would you be able to send me them?Regards,Farooq. Actually above is the email content which is read as a …