Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I hope you can help me with this one. Years ago (2005) someone way before me set up a server with WinXP and a custom-written Java/Tomcat-whatever application for monitoring some sensors, the database backend apparently being Oracle Lite 10g (10.0.0.0.0). It has run flawlessly ever since the original setup...

Now, we have the problem that a disk failure (no backups, corrupted FS) rendered the Windows unbootable and I'd like to get that content out of the DB and importing it into MySQL or at least something that's readable by anything modern. We don't have any documentation and no one knows who did the setup.

The problem is that Oracle Lite apparently requires a "full" Oracle server as a "synchronization master", and no one here ever has worked with Oracle before or has any experience with that stuff (we're all Linux+(PHP/Python)+MySQL now).

How do we get out the contents of the database using a fresh WinXP or Win7 setup?

The connection code bits of interest in the Java source are (I hope I got all relevant):

Class.forName("oracle.lite.poljdbc.POLJDBCDriver").newInstance();
con = DriverManager.getConnection("jdbc:polite:system/DBNAME:DBNAME;DataDirectory=C:\\mobileclient\\oldb40\\DBNAME;Database=DBNAME;PWD=PASS", "fm", "PASS");
share|improve this question
    
did you have any luck with this? –  sivann Sep 28 at 15:28

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.