Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / General / August 2007

Tip: Looking for answers? Try searching our database.

Help with Java Applet please...

Thread view: 
crab.dae@gmail.com - 08 Aug 2007 17:20 GMT
1st let me say I know very little about java, but I do understand the
basics..

Now here's my problem.  I was given a website to take over last year
that has a applet that connects to an Oracle DB.  That site was
running on an old Sun box with Oracle on the same box.

To make a long story short, I was tasked with rewritting all the old
perl scripts on the Unix box to coldfusion on a Windows box and now
I'm stuck.

I'm stuck because of this Java Applet.  On the old box, it connected
to oracle.  On this new box running windows 2003, I have to get it to
connect to MS SQL 2000.  I did some reading on JDBC, but from what I
can read in the old perl code, I can't figure out how the Applet
connected to the oracle DB.  I decompressed the JAR file and I stall
can't tell how it was connecting because I don't see any reference to
JDBC.  I've also checked with the admin on the Windows server I'm now
on and he says he knows nothing about JDBC.

Can anyone help me?  What should I be looking for in the decompressed
JAR file and is it possible I can make a connection to SQL without
JDBC?

Thanks!!
Manish Pandit - 08 Aug 2007 23:15 GMT
On Aug 8, 9:20 am, crab....@gmail.com wrote:
> 1st let me say I know very little about java, but I do understand the
> basics..
[quoted text clipped - 21 lines]
>
> Thanks!!

Use JAD (http://www.kpdus.com/jad.html) to decompile the code from the
jar file. Hopefully the code is not obfuscated and you can actually
see what kind of calls the applet is using to access the database.

-cheers,
Manish
crab.dae@gmail.com - 09 Aug 2007 18:39 GMT
> On Aug 8, 9:20 am, crab....@gmail.com wrote:
>
[quoted text clipped - 30 lines]
> -cheers,
> Manish

Manish,

Got a problem.  I need to decompile the JAR file 1st and it seems Jad
only does .class files.  Any other suggestions?
Roedy Green - 09 Aug 2007 19:57 GMT
>Got a problem.  I need to decompile the JAR file 1st and it seems Jad
>only does .class files.  Any other suggestions?
You can take the jar apart with winzip or jar.exe
see http://mindprod.com/jgloss/jar.html
Signature

Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com

Roedy Green - 09 Aug 2007 19:54 GMT
>Can anyone help me?  What should I be looking for in the decompressed
>JAR file and is it possible I can make a connection to SQL without
>JDBC?

Most folks avoid letting Applets have access to the JDBC interface .
The problem is hackers can get hold of it and royally screw your
database.  Normally your Applet talks to a servlet that talks to the
database for you.

That would be a major refactoring, but you seem to be in total-rewrite
mode just now.

It like to send GZipped serialised objects back and forth to the
Applet. It is very compact and allows  complex data structure with no
coding effort.
Signature

Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com

Roedy Green - 09 Aug 2007 19:56 GMT
>I'm stuck because of this Java Applet.  On the old box, it connected
>to oracle.  On this new box running windows 2003, I have to get it to
[quoted text clipped - 4 lines]
>JDBC.  I've also checked with the admin on the Windows server I'm now
>on and he says he knows nothing about JDBC.

get a packet sniffer e.g. Ethereal,
http://mindprod.com/jgloss/sniffer.html
And watch the old version of your Applet talking to the sever.  You
will likely discover it is doing HTTP GETs or POSTs to a perl script
on the server.  Probably, they were doing the database access in Perl.

Signature

Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com

RedGrittyBrick - 09 Aug 2007 20:40 GMT
> get a packet sniffer e.g. Ethereal,

Wireshark is probably what you mean (since May 2006).
http://www.wireshark.org/
Roedy Green - 09 Aug 2007 23:50 GMT
>Wireshark is probably what you mean (since May 2006).
>http://www.wireshark.org/

http://ethereal.com/ gives no hint it has been replaced.  I wondered
why they were stuck or version 0.99 so long.
Signature

Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com



Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.