fahad siddiqui

I am trying to use jconn4.jar in weblogic (jconnect 7), the latest driver for Sybase database.
When i start weblogic, it throws the following stack:
Unexpected Signal : 10 occurred at PC=0xFED8C844 Function=[Unknown. Nearest: JVM_NewArray+0x65EC] Library=/data/dbarb/arb/arbex/bea_8/jdk142_05/jre/lib/sparc/client/libjvm.so Dynamic libraries: 0x10000 /data/dbarb/arb/arbex/bea_8/jdk142_05/bin/java 0xff370000 /usr/lib/libthread.so.1 0xff3fa000 /usr/lib/libdl.so.1 0xff280000 /usr/lib/libc.so.1 0xff3a0000 /usr/platform/SUNW,Sun-Fire-V445/lib/libc_psr.so.1 0xfec00000 /data/dbarb/arb/arbex/bea_8/jdk142_05/jre/lib/sparc/client/libjvm.so 0xff230000 /usr/lib/libCrun.so.1 0xff210000 /usr/lib/libsocket.so.1 0xff100000 /usr/lib/libnsl.so.1 0xff1c0000 /usr/lib/libm.so.1 0xff0d0000 /usr/lib/libsched.so.1 0xff0b0000 /usr/lib/libmp.so.2 0xff070000 /data/dbarb/arb/arbex/bea_8/jdk142_05/jre/lib/sparc/native_threads/libhpi.so 0xfebd0000 /data/dbarb/arb/arbex/bea_8/jdk142_05/jre/lib/sparc/libverify.so 0xfeb90000 /data/dbarb/arb/arbex/bea_8/jdk142_05/jre/lib/sparc/libjava.so 0xff040000 /data/dbarb/arb/arbex/bea_8/jdk142_05/jre/lib/sparc/libzip.so 0xfc5d0000 /data/dbarb/arb/arbex/bea_8/jdk142_05/jre/lib/sparc/libnet.so 0xfc5a0000 /data/dbarb/arb/arbex/bea_8/weblogic81/server/lib/solaris/libweblogicunix1.so 0xfc690000 /data/dbarb/arb/arbex/bea_8/jdk142_05/jre/lib/sparc/libnio.so 0xfc580000 /usr/lib/librt.so.1 0xfbfe0000 /usr/lib/libaio.so.1 0xfbfc0000 /usr/lib/libmd5.so.1 0xfbfa0000 /usr/lib/libsendfile.so.1 0xfbea0000 /data/dbarb/arb/arbex/bea_8/jdk142_05/jre/lib/sparc/libioser12.so Heap at VM Abort: Heap def new generation total 3648K, used 3638K [0xe5000000, 0xe53a0000, 0xe6630000) eden space 3584K, 99% used [0xe5000000, 0xe537d9a0, 0xe5380000) from space 64K, 100% used [0xe5380000, 0xe5390000, 0xe5390000) to space 64K, 6% used [0xe5390000, 0xe5390f90, 0xe53a0000) tenured generation total 29184K, used 12344K [0xe6630000, 0xe82b0000, 0xf1800000) the space 29184K, 42% used [0xe6630000, 0xe723e0a0, 0xe723e200, 0xe82b0000) compacting perm gen total 20224K, used 20041K [0xf1800000, 0xf2bc0000, 0xf9800000) the space 20224K, 99% used [0xf1800000, 0xf2b92748, 0xf2b92800, 0xf2bc0000) Local Time = Wed Feb 24 06:02:47 2010 Elapsed Time = 16 # # HotSpot Virtual Machine Error : 10 # Error ID : 4F530E43505002EF 01 # Please report this error at # http://java.sun.com/cgi-bin/bugreport.cgi # # Java VM: Java HotSpot(TM) Client VM (1.4.2_05-b04 mixed mode) #
Any advice would be helpful.

I have a stored procedure in which i define a cursor in the start like so:
CURSOR PB_CANCEL_CUR IS SELECT * FROM TB_PB_TRADE_FEED WHERE MATCH_ID = 0 AND ACTION_TYPE = 'C' AND ACTIVE_STATUS = 0 AND ERROR_FLAG ='N' ORDER BY TRADE_REF_NUMBER;

After this, i iterate the loop and upon some conditions, i change the ACTIVE_STATUS and ERROR_FLAG to different values. Upon such an updation, that record should get erased from my cursor.
Hence, after the loop completes, i want to refresh my cursor, so that all such records which i updated during the loop, should now not be present in the cursor anymore.

Please advise urgently. I am using Oracle 8i.
Thanks in advance.

I am using the code:
public static void main(String[] args) throws Exception { MultiThreadedHttpConnectionManager connectionManager = new MultiThreadedHttpConnectionManager(); // HttpClient client = new HttpClient(httpParams, connectionManager); HttpClient client = new HttpClient(connectionManager); client.getState().setCredentials(new AuthScope("https://elink-http4.bankofamerica.com", 443), new UsernamePasswordCredentials("<user>", "<pass>")); /** THE FOLLOWING CREDENTIALS ARE USED FOR ANY PROXY SERVER******** */ client.getState().setProxyCredentials( new AuthScope("https://elink-http4.bankofamerica.com", 443), new UsernamePasswordCredentials("<user>", "<pass>")); // Create a POST method instance. PostMethod method = new PostMethod("https://elink-http4.bankofamerica.com"); // Tell the POST method to automatically handle authentication. The // method will use any appropriate credentials to handle basic // authentication requests. Setting this value to false will cause // any request for authentication to return with a status of 401. // It will then be up to the client to handle the authentication. method.setDoAuthentication(true); // Invoke the method try { // Set the URL and the port int statusCode = client.executeMethod(method); if (statusCode != HttpStatus.SC_OK) { System.out.println("Method failed: " + method.getStatusLine()); } else { } } catch (HttpException e) { e.printStackTrace(); throw e; } catch (IOException ioEx) { ioEx.printStackTrace(); throw ioEx; } catch (Exception exception) { exception.printStackTrace(); throw exception; } finally { method.releaseConnection(); } }

to connect to the boa url. But i get a connection timeout exception.

What am i doing wrong?
Please advise.

DO i need an authenticator to connect to https://verisign.com ?
What are the my proxy host and port? Why do i need to define these?
How do i define this? localhost and any random port?

I had a couple of clarifications in this respect:

If i am connecting to an https site such as verisign then, it doesn't need authentication to open up. So, do i need to setup an authenticator?
What are proxies which i need to setup? How do i find my proxy host?
Why are they needed?

Please advise. I am getting a Connection refused on connecting to the site.

Hi,
I am trying to communicate with a https server using a core java code.
Please provide some leads or sample codes on how to approach this.

I would need to do some authentication with this server as well.

Please advise.

I am converting an xls into csv using jxl.
I have a rate column in excel which displays something like 0.86%

When i read it into jxl, i get the value as .009.
How to overcome this?
Following is the code:

Cell row[] = null; String rowContentsStr = ""; for(int i = 0; i < s.getRows(); i++) { row = s.getRow(i); if(row.length > 0) { bw.write(row[0].getContents()); for(int j = 1; j < row.length; j++) { if(i==0){ if(row[j].getContents().equalsIgnoreCase("Rate") || row[j].getContents().contains("Rate")){ rateVector.add(j); } }else{ //get the value rowContentsStr=row[j].getContents(); System.out.println("this is cell type "+row[j].getType()); if(rateVector.contains(j) && !rowContentsStr.equals("")){ rowContentsStr = (Double.parseDouble(rowContentsStr) * 100)+""; System.out.println("this is the valye "+rowContentsStr); } } CellFormat cf =row[j].getCellFormat(); System.out.println("this is row type "+cf+" "+row[j].getContents()); bw.write(Delimiter); String repl = replace(rowContentsStr, ";", ","); repl = replace(repl, "\n", ""); repl = replace(repl, "\r", ""); bw.write(repl); } } bw.newLine(); }

will max(summit_id) work? the type of the column is varchar and the data is also varchar.

the case statement does work. thanks.

the ids were an example. I need to fetch all the rows in a similar fashion.

i little mistake in my analysis:
tyche_id summit_id 12344 C1234 12344 0 12345 C1235 12345 0 12346 C1223 12346 C1223 12347 0 12347 0

i want to select unique tyche_id's with a good value of summit_id.
good value means, C123.. kind of string in case values are 0 and C123..
0 in case all the values are 0.
Other than zero, the other string value will always be same.

i have a table with tyche_id and summit_id, these are not unique.
so, i have multiple rows of tyche_id with the same summit_id such as shown below:
tyche_id summit_id 12344 C1234 12345 c1235 12344 C1234 12345 c1235

I hope you got the idea of the data in the table.
I want to fetch all the rows from this table with unique tyche_id.
so the fetch should display data something like this
tyche_id summit_id 12344 C1234 12345 c1235

Can you give me a query for this kind of result fetching?
thanks in advance

I am creating an instance of tomcat via java code using the following snippet.
public void startTomcat() throws Exception { Engine engine = null; // Set the home directory System.setProperty("catalina.home", getPath()); // Create an embedded server embedded = new Embedded(); // print all log statments to standard error //embedded.setDebug(1); embedded.setLogger(new SystemOutLogger()); // Create an engine engine = embedded.createEngine(); engine.setDefaultHost("localhost"); // Create a default virtual host host = embedded.createHost("localhost", getPath()+ "\\webapps"); engine.addChild(host); host.setAutoDeploy(true); // Create the ROOT context Context context = embedded.createContext("",getPath() + "\\webapps\\ROOT"); host.addChild(context); // Install the assembled container hierarchy embedded.addEngine(engine); // Assemble and install a default HTTP connector System.out.println("Creating connector and Catlina Port="+catlina_port) ; Connector connector = embedded.createConnector("0.0.0.0", catlina_port, false); embedded.addConnector(connector); // Start the embedded server embedded.start(); }

This uses the catlina jar.
My concern is, can i use this instance as a normal tomcat instance for deploying my war files?
I ran this and got an instance of tomcat running on 8080.
Now, i want some other program to deploy a war file on this running server. Is it possible? Because i am not able to.
Please advise on how to?

If i register a war in this class only right after starting the tomcat, it works, but can't i do this from some other class or something at a later point of time?

I use the following snippet for registering the war:
public void registerWAR(Host host,String contextPath, URL warFile) throws Exception { if ( contextPath == null ) { throw new Exception("Invalid Path : " + contextPath); } if( contextPath.equals("/") ) { contextPath = ""; } if ( warFile == null ) { throw new Exception("Invalid WAR : " + warFile); } Deployer deployer = (Deployer)host; Context context = deployer.findDeployedApp(contextPath); if (context != null) { throw new Exception("Context " + contextPath + " Already Exists!"); } deployer.install(contextPath, warFile); }

FileChannel's lock is not possible, as the operation which provides the live file does not create any lock over the file and so, FileChannel does get a lock over the file which in turn disrupts the writing process.

renameTo, i cant use as the live file cannot be tinkered with. I just need to get a local copy of it for further processing.

Isn't there some unix funda of managing this kind of locking on its own? The live file comes on a unix box.

I have a live location where a file is written. I don't know by what process, could be manual aur programmed.

My process runs and checks the file to modified time changes. and if it changes, i transfer a copy of the file to another location for further processing.
Currently, while the live file is being written, my application picks up and copies the file (this copy is partly, as the file wasnt written completely).

How do i work around this such a lock or something? I dont have any control over the process which creates the live file.

Please advise.

So, then in such a kind of scenario, i cant take it for granted that only one of the reader threads will be notified.

But why does it work properly in the current version, when i have made calculator implements Runnable. Such a variable behaviour should be found in this case also, but it never happens. I tried it on couple of machines. It always notifies a single time.