Vamsi bhujanga

Iam not sure this is the right place to post this.Admin,please move it to the right location...
Do anyone know about what might be the issue for the following error:

[01-17-2009 16:00:33] ERROR (?:?) - terrapin.tuxedo.TuxError: TPETIME - timeout occured : at terrapin.tuxedo.ATMI.tpcommit(Native Method) at com.csgsystems.aruba.connection.Connection.endTransaction(Connection.java:132) at org.lk.dtl.bg.asyn.ord.BGOCOrderCall.executeAPI(Unknown Source) at org.lk.dtl.bg.asyn.BGOrderProcess.run(Unknown Source) at java.lang.Thread.run(Thread.java:570) [01-17-2009 16:00:33] ERROR (?:?) - terrapin.tuxedo.TuxError: TPETIME - timeout occured : at terrapin.tuxedo.ATMI.tpcommit(Native Method) at com.csgsystems.aruba.connection.Connection.endTransaction(Connection.java:132) at org.lk.dtl.bg.asyn.ord.BGOCOrderCall.executeAPI(Unknown Source) at org.lk.dtl.bg.asyn.BGOrderProcess.run(Unknown Source) at java.lang.Thread.run(Thread.java:570)

Let me explain about the scenarios:
1)Our application is developed using java deployed on jboss.We are not using EJB/hibernate/spring etc., kind of advanced technologies.Its purely a core java application where we have used collections,multithreading extensively..
2)We are using a middleware - BEA Tuxedo version 8.0

From one of the Oracle BRM systems, our application receives requests in the form of xml.
Our application act as a backend for the BRM,receives the request and send to some 3rd party billing system API's (Kenan/Amdocs kind of billing system)..and update the tables/run procs etc.,

We are handling multiple requests using multithreading of java.When we receive more than (eg.,)10 records at a time,then we are getting the above error.
Instead,we are able to handle the same number of requests in synchronous way. For this,we have used join() method of the thread.But,this is not the requirement.

Moreover, we are also getting following error before the above exception...
[05-04-2009 16:49:57] ERROR (?:?) - ServiceException in requestResponsecom.csgsystems.aruba.connection.ServiceException: ck_ORACLE_ERROR : {BSD_FORMAT=Oracle error has occurred. Error=(Error in execution of OCI function unused: retcode = -1 (OCI_ERROR) ORA-02049: timeout: distributed transaction waiting for lock
I have googled a lot for both the errors but iam unable to find any solution..
Any suggestions on this - how to handle multiple requests at a time.Let me know,if you need more clarity on this...

We cant save it in the form of a file as we have many challenges in using it.
Is there any other alternate?

I need to store huge data (which is a xml data) in a CLOB datatype which is running on JBoss server.Iam successful in writing the code but my code has a big limitation that it can store upto 32523 (approx) characters.But,my application will be receiving the xml's of upto 2 GB (Approximately). But,iam unable to find the alternate for this.

import java.io.BufferedReader; import java.io.ByteArrayInputStream; import java.io.InputStream; import java.io.InputStreamReader; import java.io.OutputStream; import java.io.Serializable; import java.io.StringReader; import java.io.StringWriter; import java.sql.Connection; import java.sql.ResultSet; import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.Hashtable; import javax.naming.InitialContext; import javax.sql.DataSource; import oracle.sql.CLOB; public class zip1 implements Serializable{ public static void main(String args[]) { boolean i=true; int i1=0; java.sql.Connection connection1 = null; java.sql.CallableStatement cstmt = null; try { String inputXML="sample xml of size 32523 characters will execute. But if it is more than this,it will throw error................................................."; connection1 =getDBPoolConnection(); String clobContent=null; java.io.Writer output = new StringWriter(); output.write(inputXML); output.close(); clobContent = output.toString(); System.out.println(clobContent.length()); cstmt = connection1.prepareCall(" begin TEST_CONNECTION_POOL(?,?);end; "); if(inputXML !=null){ java.io.Reader r = new StringReader(clobContent); cstmt.setCharacterStream(1, r, clobContent.length()); } cstmt.setString(2,"Vamsikiran1"); i1=cstmt.executeUpdate(); System.out.println(i1); if(i1==1) { System.out.println("Success"); } System.out.println("oookk.."); PreparedStatement pstmt1 = null; pstmt1 = connection1.prepareStatement("select * from CLOB_POOL_TEST where STATUS='Vamsikiran1'"); boolean j=pstmt1.execute(); if(j==false){ System.out.println("O"); } if(j==true){ System.out.println("1"); } ResultSet rs1=pstmt1.executeQuery(); rs1.next(); BufferedReader reader = new BufferedReader(new InputStreamReader(rs1.getAsciiStream("INPUT_XML"))); StringBuffer inputxml = new StringBuffer(); String str = reader.readLine(); while(str!=null) { inputxml.append(str); str = reader.readLine(); } System.out.println("output :"+inputxml.toString()); pstmt1.close(); } catch(SQLException e1){ if(i1==1) { System.out.println("Failure"); } System.out.print("exception."); e1.printStackTrace(); } catch(Exception e) { System.out.print("exception."); e.printStackTrace(); } finally { try{ if(connection1!=null) connection1.close(); } catch(Exception d) { System.out.println("exception while closing the connection."); }} } public static Connection getDBPoolConnection() throws Exception { Hashtable ht = new Hashtable(); ht.put(InitialContext.INITIAL_CONTEXT_FACTORY,"org.jnp.interfaces.NamingContextFactory"); ht.put(InitialContext.PROVIDER_URL, "jnp://localhost:1099"); //1099 is the default port. ht.put(InitialContext.URL_PKG_PREFIXES,"org.jboss.naming:org.jnp.interfaces"); InitialContext initContext = new InitialContext(ht); DataSource ds = (DataSource) initContext.lookup("java:TestDS");Connection connection = ds.getConnection(); return connection; } }

When iam using to create CLOB object directly,it is giving Class Cast exception,thats the reason, i have tried using the above code.

I have tried to create clob in the following way which is giving Class cast exception.


oracle.sql.CLOB newClob = oracle.sql.CLOB.createTemporary(getNativeConnection(connection1), true, oracle.sql.CLOB.DURATION_SESSION);

Hence i tried using WrappedConnection of JBoss
CLOB newClob = CLOB.createTemporary(((WrappedConnection)connection1).getUnderlyingConnection() , false, CLOB.DURATION_CALL);
But still throwing class cast exception.
Did anyone had this kind of issue/problem of storing more than 2 GB data into CLOB datatype?Is there any another alternate for this?
Please let me know

Thanks in advance.

Our application is deployed as a sar (inside sar - we have a war)and is deployed in JBoss4.0.3. Its a pure Java based application.
The issue is, when we make some changes in some java file and re-deploy it on JBoss,the new code is not reflecting at all. We have verified in all the ways -- clearing the temporary files inside JBoss,ensured that all the services are started properly... But still no result. We have verified the class files by copying from the server to our hard disk and decompiled it. It has the latest code....But,when running the application, these new changes are not refelecting

As such,the deployment is successful with no errors but latest updations are not updating..

Did anyone faced this kind of issue?Can somebody suggest me a solution or steps to be taken care?
Thanks in advance
Kiran

The chart is being created.
Iam able to save on the hard disk (on Windows OS).
It is a valid image

The same image when i tried to save on AIX server, it is restricting as i told in my above post.
Also, the directory where iam trying to save is not restricted on any security policy of the server.

Ulf Dittmer,
Hope, i answered to all the questions.

In my earlier post, i have mentioned that Adobe- no more supports SVG viewer. I am in search of 3rd party tool to save the image on the AIX. please suggest (Hope, my question is clear now).

I have copied the code of JFreeChart in my previous post (which iam using). What else can be updated in it? IS there anything incorrect or did i miss anything else??

Also,if everything is correct (iam sure it would be), what can be the alternate to save the image in the AIX?

Please suggest.

You mentioned Batik before, but I don't quite understand why that didn't work out. Can you post the specific details of that?

Batik is a bundled with FOP itself. We are even confused and struggling here in displaying SVG.
As i mentioned in my earlier post, SVG viewer is no longer supporting AIX.
Please suggest an alternate solution for this. Is there any 3rd party tool that can be useful to display chart on AIX OS.Iam searching for this kind of tool.Can anybody suggest me.

Thanks in advance.

As i mentioned in the post, some code is modified for some reasons. I have given the server location in place of C:/ directory.
Anyhow, here is the url which states that Adobe is discontinuing the SVG. Now, iam in search of any 3rd party tool which supports SVG on AIX.
Iam sure that some one would be working on this.Any help will be greatly appreciated.

http://www.adobe.com/svg/eol.html

Thanks in advance

Sorry i kept the wrong code initially. I have updated the previous post.

Moreover when we contacted IBM customer care, this is the reply we received.

IBM response:
Unfortunately Adobe's SVG Viewer is no longer available for AIX. We found that Adobe has decided to discontinue it's SVG Viewer product. Please refer the following links for more details.

http://www.adobe.com/svg/eol.html
http://www.adobe.com/svg/pdfs/ASV_EOL_FAQ.pdf

But there are some other Adobe products which currently supports SVG. Also there are a lot of third party SVG viewer products.


Please suggest

For the question: we are unable to see the bar graph chart

Here is the sample code we are using.. (SOme things are changed accordingly)

import java.awt.Color; import java.awt.Dimension; import java.awt.GradientPaint; import java.io.File; import java.io.FileNotFoundException; import java.io.IOException; import java.io.Serializable; import org.apache.fop.util.CommandLineLogger; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.jfree.chart.ChartFactory; import org.jfree.chart.ChartPanel; import org.jfree.chart.ChartUtilities; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.axis.NumberAxis; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.plot.PlotOrientation; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.data.category.CategoryDataset; import org.jfree.data.category.DefaultCategoryDataset; import org.jfree.ui.ApplicationFrame; //import org.jfree.ui.RefineryUtilities; /** * A simple demonstration application showing how to create a bar chart. * */ public class IGHBargraph extends ApplicationFrame { /** * Creates a new demo instance. * * @param title the frame title. * @throws FileNotFoundException */ public IGHBargraph(String title) { super(title); final CategoryDataset dataset = createDataset(); final JFreeChart chart = createChart(dataset); final ChartPanel chartPanel = new ChartPanel(chart); chartPanel.setPreferredSize(new Dimension(500, 270)); setContentPane(chartPanel); // File afile = new File("c:/barChart.jpeg"); try { System.out.println("Hello"); ChartUtilities.saveChartAsJPEG(new File("c:/barChart.jpeg"),chart,500,270); } catch (IOException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } // objControlPWriter.println("datasource="+igh_prop.getProperty("datasource")+"igh_jpg"+instance_id+".jpg"); //File file = new File("myimage.jpg"); // FileImageOutputStream fiis =new FileImageOutputStream(file); //chartPanel.write(fiis); /* try { FileOutputStream file = new FileOutputStream(afile); } catch (FileNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); }*/ } /** * Returns a sample dataset. * * @return The dataset. */ private CategoryDataset createDataset() { // row keys... final String series1 = "First"; final String series2 = "Second"; final String series3 = "Third"; // column keys... final String category1 = "Month"; // final String category2 = "Category 2"; // final String category3 = "Category 3"; //final String category4 = "Category 4"; //final String category5 = "Category 5"; // create the dataset... final DefaultCategoryDataset dataset = new DefaultCategoryDataset(); dataset.addValue(1.0, series1, category1); //dataset.addValue(4.0, series1, category2); //dataset.addValue(3.0, series1, category3); //dataset.addValue(5.0, series1, category4); //dataset.addValue(5.0, series1, category5); dataset.addValue(5.0, series2, category1); // dataset.addValue(7.0, series2, category2); // dataset.addValue(6.0, series2, category3); //dataset.addValue(8.0, series2, category4); //dataset.addValue(4.0, series2, category5); dataset.addValue(4.0, series3, category1); // dataset.addValue(3.0, series3, category2); //dataset.addValue(2.0, series3, category3); //dataset.addValue(3.0, series3, category4); //dataset.addValue(6.0, series3, category5); return dataset; } /** * Creates a sample chart. * * @param dataset the dataset. * * @return The chart. */ private JFreeChart createChart(final CategoryDataset dataset) { // create the chart... final JFreeChart chart = ChartFactory.createBarChart( "Bar Chart Demo", // chart title null, // domain axis label "Amount", // range axis label dataset, // data PlotOrientation.VERTICAL, // orientation true, // include legend true, // tooltips? false // URLs? ); // NOW DO SOME OPTIONAL CUSTOMISATION OF THE CHART... // set the background color for the chart... chart.setBackgroundPaint(Color.white); // chart.setBackgroundPaint(null); // get a reference to the plot for further customisation... final CategoryPlot plot = chart.getCategoryPlot(); plot.setBackgroundPaint(Color.lightGray); plot.setDomainGridlinePaint(Color.white); plot.setRangeGridlinePaint(Color.white); // set the range axis to display integers only... final NumberAxis rangeAxis = (NumberAxis) plot.getRangeAxis(); rangeAxis.setStandardTickUnits(NumberAxis.createIntegerTickUnits()); // disable bar outlines... final BarRenderer renderer = (BarRenderer) plot.getRenderer(); renderer.setDrawBarOutline(false); // set up gradient paints for series... final GradientPaint gp0 = new GradientPaint( 0.0f, 0.0f, Color.blue, 0.0f, 0.0f, Color.lightGray ); final GradientPaint gp1 = new GradientPaint( 0.0f, 0.0f, Color.blue, 0.0f, 0.0f, Color.lightGray ); final GradientPaint gp2 = new GradientPaint( 0.0f, 0.0f, Color.blue, 0.0f, 0.0f, Color.lightGray ); renderer.setSeriesPaint(0, gp0); renderer.setSeriesPaint(1, gp1); renderer.setSeriesPaint(2, gp2); final CategoryAxis domainAxis = plot.getDomainAxis(); domainAxis.setCategoryLabelPositions( CategoryLabelPositions.createUpRotationLabelPositions(Math.PI / 6.0) ); // OPTIONAL CUSTOMISATION COMPLETED. // ChartUtilities.saveChartAsJPEG(afile,chart,400,600); return chart; } // **************************************************************************** // * JFREECHART DEVELOPER GUIDE * // * The JFreeChart Developer Guide, written by David Gilbert, is available * // * to purchase from Object Refinery Limited: * // * * // * http://www.object-refinery.com/jfreechart/guide.html * // * * // * Sales are used to provide funding for the JFreeChart project - please * // * support us so that we can continue developing free software. * // **************************************************************************** /** * Starting point for the demonstration application. * * @param args ignored. */ public static void main(final String[] args) { IGHCommandlineOptions comopt= new IGHCommandlineOptions(args); String igh_prop_file_str= comopt.propertyfile; IGHLogWriter logWriter = new IGHLogWriter(igh_prop_file_str); logWriter.writeProcessLog("INFO","Printing Bargraph"); final IGHBargraph demo = new IGHBargraph("Bar Chart Demo"); logWriter.writeProcessLog("INFO","Printed Bargraph"); } }

This code works fine and creates a jpeg on Windows OS.
But, this doesnot save when we run ON AIX. Basically, we need to save this on the server to do other operations.

We are preparing a bill template (say mobile bill kind of bill) and we need to display a chart for the last 3 months calls in the template.
We are able to display the template which is a pdf file using FOP. But, the actual problem is we need to display a generic graph in the pdf for each customer in the bill template.

We have tried using JFreechart and display the chart. Iam able to save in the windows machine. But, iam unable to save it in the server (this is a part of our busineess logic design where we are trying to store the chart in the server and append this to the pdf.)

For displaying SVG(Scalable Vector Graphics) images on the invoice after running fop-0.94, we need X11 library. But after installing this also, we are unable to see the bar graph chart on the invoice through X Manager (GUI for IBM AIX Server).

Moreover while generating bar graph through Jfreechart taking help of two libraries (jfreechart-1.0.4.jar,jcommon.jar) also, the same thing happens and we are unable to see the bar graph chart on the invoice through X Manager.

But in both the cases, we are getting the bar graph generated on Windows System successfully.

These are the responses from the fop-users and fop-development groups (where i browsed through google):-
If you just want to display SVG images, that requires Apache Batik in the classpath . Batik is bundled with FOP.

For SVG you need the batik libraries, which are part of the fop standard distribution. So the problem here seems to be something else.

I currently know of no FOP extensions that would allow to add bar graphs(you mean charts, right?) in a special XML dialect as part of an
fo:instream-foreign-object. So that means you have to generate SVG graphics from bar graphics using a third-party tool

Findings from the above discussions :-

It may be a case that something is missing in the AIX Operating System which is restricting us to allow/create dynamic images on the invoice through either of the above two methods.

Thanks for the suggestion given to use 'inputstream' which struck me to use the below code.
Here is the code.
String fileContent=null; Writer output = new StringWriter(); PreparedStatement pre=null; output.write("\t"); output.write("vamsi"); output.write("\n"); output.write("bhujanga"); output.close(); fileContent = output.toString(); byte []file = fileContent.getBytes(); InputStream fin = new ByteArrayInputStream(file); Connection con= //u r connection goes here pre = con.prepareStatement("insert into table_name(blob_column) values(?); pre.setBinaryStream(1, fin,(int)file.length); pre.executeUpdate(); con.commit(); pre.close(); con.close();
You can write the above code in try-catch block according to your requirement.

I solved this issue.
If anybody needs assistance,send me a private message

The file is not coming from anywhere.The requirement is to insert the data into the BLOB column in the format i have shown.hence,i tried to create a file.But,as i told you,iam not supposed to create a file.Hence,my question is whether is there any alternate way to insert the data in the same format into BLOB column without creating a file.

Thanks for the reply.I would have kept the sample code as my questions are confusing.
Anyhow,here is the sample code.

PreparedStatement pre=null; [B]File file = new File("c".tsv");//The code is failing here itself[/B] Writer output = null; try{ output = new BufferedWriter(new FileWriter(file)); output.write("Vamsi"); output.write("\n"); output.write("Bhujanga"); output.write("\t"); output.write("sysdate"); output.close(); } catch (IOException e) { e.printStackTrace(); } try{ File tsvFile = new File("c".tsv"); FileInputStream fin = new FileInputStream(tsvFile); pre = con.prepareStatement("insert into FileAttachemt FILE_ATTCHMNT_Data_X) values(?); pre.setBinaryStream(1, fin,(int)tsvFile.length()); pre.executeUpdate(); con.commit(); pre.close(); con.close(); }catch (Exception e){ System.out.println(e.getMessage()); } file.deleteOnExit();

In the above code,while creating a file itself,iam getting security issue as it is directly creating at the server.Later on i understood that iam not supposed to create a file at all (not even in local desk temporarily) but insert the data in the format which i showed above (Line numbers:6 to 10).
Is there any way of inserting the same data into BLOB column.Can you send me the sample code.(Not sure: Can we convert into bytes and insert into BLOB.)
Please suggest