Suhas Mohamedali

You mean run configuration?
I can not pass actual arguments there as in the batch file.

I have a batch file in which following parameters are passed

-f .\server_test.cfg -jdbc oracle.jdbc.driver.OracleDriver -exec com.slmsoft.hcs.database.DBSchema init schema.oic.txt schema.common.txt custom.txt -end %1 %2 %3 %4 %5 %6 start


how can I make this parameters in eclipse run configuration.

Please download odbc14.jar (for 1.4 and 1.5) from

webpage

Copy it into JBOSS_HOME\server\default\lib.

And try to restart the server again.

I have two tables

master_table : 'BenefitFileHdr ' and child_table: BenefitFileDtl

PK of master table is FK of child table.

One column start_date is getting updated from the GUI and needs to to be updated in DB.

Please check the code below.

Query query; StringBuffer headerUpdateQry = new StringBuffer( "UPDATE BenefitFileHdr hdr SET hdr.status =?1"); if (aggLimit != null) headerUpdateQry.append(" , hdr.aggLimit =?2"); if (effDate != null && effDate.trim().length() != 0) headerUpdateQry.append(" , hdr.id.startDate =?3"); headerUpdateQry.append(" , hdr.updatedBy =?4"); headerUpdateQry .append(" WHERE hdr.id.policyShortNo =?5 AND hdr.id.categoryCode =?6 AND hdr.id.startDate =?7"); query = entityManager.createQuery(headerUpdateQry.toString()); if (status) { query.setParameter(1, "Y"); } else { query.setParameter(1, "N"); } if (aggLimit != null) query.setParameter(2, new BigDecimal(aggLimit)); if (currentEffDt != null) query.setParameter(3, currentEffDt); query.setParameter(4, loggedInUser); query.setParameter(5, policy); query.setParameter(6, categoryCode); query.setParameter(7, effTempDt); if (detailsList != null && !detailsList.isEmpty()) { for (Iterator itr = detailsList.iterator(); itr.hasNext();) { DetailsDTO detailsDTO = (DetailsDTO) itr.next(); String bktCvrg = null; if (detailsDTO.getBcktCvrg()) { bktCvrg = "Y"; } else { bktCvrg = "N"; } Query detailsUpdateQry; StringBuffer upateQry = new StringBuffer( "UPDATE BenefitFileDtl dtls SET"); upateQry.append(" dtls.bucketCoverage =?1"); // if (detailsDTO.getBenSubLimit() != null) upateQry.append(", dtls.sublimit =?2"); // if (detailsDTO.getCopayFlat() != null) upateQry.append(", dtls.copayFlat =?3"); // if (detailsDTO.getCopayPerc() != null) upateQry.append(", dtls.copayPerc =?4"); // if (detailsDTO.getCopayMax() != null) upateQry.append(", dtls.copayMax =?5"); if ("MWP".equals(detailsDTO.getBcktCd()) && detailsDTO.getBcktCvrg()) { upateQry.append(", dtls.waitingPeriodEnd =?6"); } if ("MWP".equals(detailsDTO.getBcktCd()) && !detailsDTO.getBcktCvrg() && detailsDTO.getWtngPrd() != null) { upateQry.append(", dtls.waitingPeriodEnd =?7"); } upateQry.append(", dtls.id.startDate =?8"); upateQry.append(" WHERE dtls.id.policyShortNo =?9 AND dtls.id.categoryCode =?10 AND dtls.id.bucketCode =?11 AND dtls.id.startDate =?12"); detailsUpdateQry = entityManager.createQuery(upateQry .toString()); detailsUpdateQry.setParameter(1, bktCvrg); if (detailsDTO.getBenSubLimit() != null) detailsUpdateQry.setParameter(2, new BigDecimal(detailsDTO.getBenSubLimit())); else detailsUpdateQry.setParameter(2, null); if (detailsDTO.getCopayFlat() != null) detailsUpdateQry.setParameter(3, new BigDecimal(detailsDTO.getCopayFlat())); else detailsUpdateQry.setParameter(3, null); if (detailsDTO.getCopayPerc() != null) detailsUpdateQry.setParameter(4, new BigDecimal(detailsDTO.getCopayPerc())); else detailsUpdateQry.setParameter(4, null); if (detailsDTO.getCopayMax() != null) detailsUpdateQry.setParameter(5, new BigDecimal(detailsDTO.getCopayMax())); else detailsUpdateQry.setParameter(5, null); if ("MWP".equals(detailsDTO.getBcktCd()) && detailsDTO.getBcktCvrg()) { /*Calendar cal = Calendar.getInstance(); cal.setTime(Util.stringToDate(detailsDTO.getWtngPrd();)); cal.add(Calendar.DATE, +280);*/ detailsDTO.getWtngPrd(); log.info("\n The waiting period :::" +detailsDTO.getWtngPrd()); detailsUpdateQry.setParameter(6, detailsDTO.getWtngPrd()); } if ("MWP".equals(detailsDTO.getBcktCd()) && !detailsDTO.getBcktCvrg() && detailsDTO.getWtngPrd() != null) { detailsUpdateQry.setParameter(7, null); } detailsUpdateQry.setParameter(8, currentEffDt); detailsUpdateQry .setParameter(9, detailsDTO.getPolicyShortNum()); detailsUpdateQry.setParameter(10, detailsDTO.getCategory()); detailsUpdateQry.setParameter(11, detailsDTO.getBcktCd()); detailsUpdateQry.setParameter(12, effTempDt); detailsUpdateQry.executeUpdate(); } } query.executeUpdate(); // } entityManager.flush();

when try to save the code i get following exception.

Caused by: java.sql.SQLException: ORA-02291: integrity constraint (SLMTEST.FK_BENEFIT_HDR_DTL) violated - parent key not found

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:75)

I tried to save the parent first. Still i got error mentioning children are there.

Mapping has been done as

@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY, mappedBy = "benefitFileHdr") public Set<BenefitFileDtl> getBenefitFileDtls() { return this.benefitFileDtls; }

Please suggest a solution for update

Please help to call a stored procedure

get_ubpi(p_policy_short_no in varchar2, p_category_code in varchar2) with 2 in params and no out param.

The code i used to call the proc is

Query procCallQry = entityManager.createNativeQuery(" CALL get_ubpi(?1, ?2) "); procCallQry.setParameter(1, headerDto.getPolicyShrtNum()); procCallQry.setParameter(2, headerDto.getCategoryCode()); procCallQry.getResultList();

which gave me

15:00:58,989 WARN [JDBCExceptionReporter] SQL Error: 900, SQLState: 42000
15:00:58,989 ERROR [JDBCExceptionReporter] ORA-00900: invalid SQL statement

Please help

I want to prevent selecting another row of JTable if the ' mainAction ' is equal to Actions.CHILDCHANGED OR Actions.MODIFIED
I am able to show the Error Dialog while selecting another row but once the dialog is closed it is selecting the pointed row.
I want to select the edited row once the error dialogue is closed.

Please help.



class HdrListSelectionHandler implements ListSelectionListener { public void valueChanged(ListSelectionEvent e) { // PbmDataEntryFrame = new PbmDataEntryFrame(); ListSelectionModel lsm = (ListSelectionModel) e.getSource(); // lblSavedStatus = new JTextField(); // lblSavedStatus.setText(""); btnStatus.setEnabled(false); if (!lsm.isSelectionEmpty()) { logger.info("\n Entering is selection empty"); logger.info("\n main action :::"+mainAction); if(mainAction == Actions.CHILDCHANGED || mainAction == Actions.MODIFIED){ JOptionPane .showMessageDialog( new PbmDataEntryFrame(logonDto), "Please save the edited data first", "Error", JOptionPane.ERROR_MESSAGE); } else{ ************************************** \\ I'm doing the rest }

Hi,

Please help to make the selected row non editable if the check box in the row is unchecked and editable otherwise.

In simple words

how to display components dynamically at same co-ordinates???

Hi the requirement is
Enter emails separated by comma.
Save the data and Show the emails in a combo box while retrieving (spiting the mails separated by comma).

I made the textbox invisible and made the combo box visible after the search is performed.
But the no component is visible after the search is performed.

Kindly help to solve the issue

Thank you all for your suggestions.

The requirement is,

While starting up the server ( our own TCP \IP server) , the data from some tables are fetched and it will be stored in the list \vector.
It will act as a virtual table thought out the user session. So the application will not hit DB after server initialization.

I know there are better implementation available but we need to use this approach only as the architecture demands (it is a pretty old application) .
We dont have time to re implement this using JBoss and EJB.
It is a java swing application (coded in 2002).

Please help to solve this

Dear Pal,

Thanks for your reply

I tried it already and there is no effect.

Hi,

My requirement is to improve the iteration time on the result set fetched.
The query fetches 1 million records.
The code snippet

ResultSet result = stmt.executeQuery( sql );

takes less than 1 second to execute.

But the iteration of the result set and converting it to the list of POJOs takes around 90 seconds.
The code snippet is
while (result.next()) { // Added by Suhas rec = new CProcedureFeeRec(); rec.setCfeegd_id(result.getLong(1)); rec.setBenefit_type(result.getString(2)); rec.setBenefit(result.getString(3)); rec.setArea_cd(result.getString(4)); rec.setEff_dt(result.getDate(5)); rec.setExp_dt(result.getDate(6)); rec.setBenefit_fee(result.getDouble(7)); cprocedureFee.add( rec ); }

Please help to reduce the execution time.

Please find my JNLP below located at ROOT folder of apache tomcat.

<?xml version="1.0" encoding="utf-8"?> <jnlp spec="1.0+" codebase="http://localhost:8080/" href="Test.jnlp"> <information> <title>HCS TESTING</title> <vendor>SUHAS</vendor> <homepage href="http://localhost:8080/" /> <description>Testing Testing</description> </information> <security> <all-permissions/> </security> <resources> <property name="jnlp.packEnabled" value="true"/> <j2se version="1.6+ 1.5+ 1.4+ 1.3+"/> <jar href="test.jar" main="true" download="eager"/> <jar href="tableLayout.jar"/> <jar href="log4j.jar"/> <jar href="ojdbc14.jar"/> <jar href="xml4j.jar"/> <jar href="jcert.jar"/> <jar href="jnet.jar"/> <jar href="jsse.jar"/> <jar href="mail.jar"/> <jar href="commons-collections.jar"/> <jar href="commons-logging.jar"/> <jar href="dom4j.jar"/> <jar href="ehcache.jar"/> <jar href="cglib.jar"/> <jar href="jta.jar"/> </resources> <application-desc main-class="com.admin.desktop.MainFrm"> <argument>-f</argument> <argument>Client.cfg</argument> </application-desc> </jnlp>


When I launch the application directly by invoking the JNLP file the application starts perfectly.
But when I tried to launch the application using an HTML file

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html lang="en-US">
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<h1>Custom Progress Bar Demo in a Java Web Start Application</h1>
<script src="http://www.java.com/js/deployJava.js"></script>
<script>
var url = "http://localhost:8080/Test.jnlp";
deployJava.createWebStartLaunchButton(url, '1.6.0');
</script>
<noscript>JavaScript is required for this page.</noscript>

</body>
</html>


Is is showing an error message like the client.cfg file is not found at C:\User\Desktop.
Currently the cfg file is located at the ROOT folder.

Please suggest how to resolve this issue.

Dear Michael,

Thanks for your reply.

Yeah we need to open the pop up using double click only as the existing application is so.
In the existing application the following code is used.

Could you please suggest???

column.setCellEditor(new MyEditor(new JTextField()))

final private class MyEditor extends DefaultCellEditor { public MyEditor(JTextField t) { super(t); t.getDocument().addDocumentListener(new DocChangeListener()); setClickCountToStart(Integer.MAX_VALUE); editorComponent = t; } public Component getTableCellEditorComponent(JTable table, Object value, boolean isSelected, int row, int column) { ((JTextField) editorComponent).setText(value.toString()); return editorComponent; } }

Hi,

Please help me to handle the double click event in cell of JTable.
I added a mouse listener to the table.
The logic is written on mouseclicked method.
But it recognizes only one click. In the second click the cell becomes editable.

My requirement is to enter a code in the cell. If the user knows the code he can enter in the cell or he need to double click on the cell to open a search panel to search and fins the code.

Please help