driver.OracleDriver() problem

[toddyl]

Hi,

I posted this topic

http://www.tek-tips.com/viewthread.cfm?qid=1162349

under the Oracle 9i section before but got no reply.

Basically I have the following code trying to connect to my Oracle Database but it does not appear to be working:

private boolean getDatabaseConnection(String dbhost, String dbsid, String dbusername, String dbpassword) {
FileOutputStream out; // declare a file output object
PrintStream p; // declare a print stream object

try {
out = new FileOutputStream("C:\\Installs\\nCharge\\tom.txt");
p = new PrintStream( out );
p.println("Params: "+ dbhost + "," + dbsid + "," + dbusername + "," + dbpassword);

String url = "jdbcracle:thin" +dbhost+":1521:" +dbsid;
//String url = "jdbcdbc:"+dbsid;
// Load the Oracle JDBC Driver and register it.
//System.out.println("DB URL: "+url);
p.println("DB URL: "+url);

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
p.println("Setting PrintWriter:");
DriverManager.setLogWriter(new PrintWriter((p)));
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
myCon = DriverManager.getConnection(url, dbusername, dbpassword);
return true;
} catch(SQLException ex) {
try {
//System.out.println("SQL Exception: " + ex.getMessage());
out = new FileOutputStream("C:\\Installs\\nCharge\\tom1.txt");
p = new PrintStream( out );
p.println("SQL Exception: " + ex.getMessage());
} catch (FileNotFoundException ey) {

}
return false;
}catch(Exception e) {
try {
//System.out.println("Exception: " + e.getMessage());
out = new FileOutputStream("C:\\Installs\\nCharge\\tom2.txt");
p = new PrintStream( out );
p.println("Exception: " + e);
p.println("Exception: " + e.getMessage());
e.printStackTrace(p);
} catch (FileNotFoundException ez) {

}
return false;
}
}

The debug from the DriverManager section results in this output:

Params: laptop117,tiger,tom,tom
DB URL: jdbcracle:thinlaptop117:1521:tiger
Setting PrintWriter:
DriverManager.getConnection("jdbcracle:thinlaptop117:1521:tiger")
trying driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDriver@1bc1806]

An exception is raised and the output of this is:

Exception: java.lang.ArrayIndexOutOfBoundsException: 7
Exception: 7
java.lang.ArrayIndexOutOfBoundsException: 7
at oracle.security.o3logon.C1.r(C1)
at oracle.security.o3logon.C1.l(C1)
at oracle.security.o3logon.C0.c(C0)
at oracle.security.o3logon.O3LoginClientHelper.getEPasswd(O3LoginClientHelper)
at oracle.jdbc.ttc7.O3log.<init>(O3log.java)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at CheckDB.getDatabaseConnection(CheckDB.java:49)
at CheckDB.install(CheckDB.java:21)
at com.zerog.ia.installer.actions.CustomAction.installSelf(Unknown Source)
at ZeroGtz.run(Unknown Source)

Under Start --> My Computer (Right Click on it) --> Properties --> Advanced Tab --> Environment Variables I have an entry for CLASSPATH of:

C:\oracle\ora92\jdbc\lib;C:\oracle\ora92\jdbc\lib\ojdbc14.zip;C:\oracle\ora92\jdbc\lib\classes12.zip;C:\oracle\ora92\jdbc\lib\nls_charset12.zip

Can anyone please point out what is going wrong and what I need to do to fix this.

Thanks,

Tom

 

[sedj]

Can you compile the following code, run it, and post back the output.

(obviously replace host, sid, user etc with your particulars).

import java.sql.*;

public class TestConnection {
	public static void main(String args[]) throws Exception {
		String server = "serverIP";
		String sid = "db_sid";
		String user = "user";
		String password = "password";

		Class.forName("oracle.jdbc.driver.OracleDriver");
		Connection c = DriverManager.getConnection("jdbc:oracle:thin:@" +server +":1521:" +sid, user, password);
		System.out.println("got connection : " +c);
	}
}

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[toddyl]

This is what I did and the response I got:

D:\Work>javac TestConnection.java

D:\Work>java TestConnection
Exception in thread "main" java.lang.NoClassDefFoundError: TestConnection

 

[sedj]

before you run it :

set CLASSPATH=%CLASSPATH%;D:\work

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[toddyl]

Cool.
Ran that and got the following:

D:\Work>javac TestConnection.java

D:\Work>java TestConnection
got connection : oracle.jdbc.driver.OracleConnection@1c6f579

 

[Diancecht]

Why is the Class.forName line commented out?

Cheers,
Dian

 

[sedj]

So all you need to do is refactor your code so that the connection is obtained in the manner I've shown you.

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[toddyl]

Ok, I've changed the code to be:

try {
out = new FileOutputStream("C:\\Installs\\nCharge\\tom.txt");
p = new PrintStream( out );
p.println("Params: "+ dbhost + "," + dbsid + "," + dbusername + "," + dbpassword);

Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbcracle:thin" +dbhost+":1521:" +dbsid;
p.println("DB URL: "+url);

Connection myCon = DriverManager.getConnection("jdbcracle:thin" +dbhost+":1521:" +dbsid, dbusername, dbpassword);
return true;
} catch(SQLException ex) {

but its still not working.

The log for this part now just has:

Params: laptop117,tiger,tom,tom
DB URL: jdbcracle:thinlaptop117:1521:tiger

But the Exception log still has the error:

Exception: java.lang.ArrayIndexOutOfBoundsException: 7
Exception: 7
java.lang.ArrayIndexOutOfBoundsException: 7
at oracle.security.o3logon.C1.r(C1)
at oracle.security.o3logon.C1.l(C1)
at oracle.security.o3logon.C0.c(C0)
at oracle.security.o3logon.O3LoginClientHelper.getEPasswd(O3LoginClientHelper)
at oracle.jdbc.ttc7.O3log.<init>(O3log.java)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at CheckDB.getDatabaseConnection(CheckDB.java:47)
at CheckDB.install(CheckDB.java:20)
at com.zerog.ia.installer.actions.CustomAction.installSelf(Unknown Source)
at ZeroGtz.run(Unknown Source)

 

[sedj]

A search on the web seems to point to either a bug in the driver, OR using the wrong driver (eg, using an 8i version of classes12.jar instead of the 9i version.)

Check your drivers, and make sure there are no conflicting drivers on your CLASSPATH.

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[toddyl]

Hi,

I've checked all my drivers and these have the same size and date as those on the Oracle Website so this would indicate that these drivers are up to date. To be safe I downloaded the latest versions from Oracle and replaced the ones I had. Still getting the same result.

My Classpath is set in my environment variables section and this is the only place it appears to be. How can I check what classpath my code is attempting to use?

What other debug info can I put in my Exception handled to try and get further information?

 

[toddyl]

Ok, I've put on extra debugging to get all System info about my setup. Can anyone see anything in this mess that might be causing the problem:

Params: laptop117,TIGER,TOM,TOM DB URL: jdbcracle:thinlaptop117:1521:TIGER
Setting PrintWriter:
java properties: {file.encoding.pkg=sun.io, lax.user.dir=., lax.nl.env.HOMEPATH=\Documents and Settings\tlohan.CARMA,
lax.resource.dir=Windows,
lax.application.name=nCharge,
lax.nl.env.TEMP=C:\DOCUME~1\TLOHAN~1.CAR\LOCALS~1\Temp, java.home=c:\docume~1\tlohan~1.car\locals~1\temp\i1137517156\windows\resource\jre,
lax.nl.env.programfiles=C:\Program Files, lax.nl.env.PROCESSOR_REVISION=0905,
lax.nl.env.exact_case.Path=
C:\j2sdk1.4.2_10\bin;C:\oracle\ora92\jre\1.4.2\bin\client;C:\oracle\ora92\jre\1.4.2\bin;C:\j2sdk
1.4.2_10\bin;C:\Program Files\Java\j2re1.4.2_03\bin;C:\oracle\ora92\jdbc\lib;C:\Program
Files\JavaSoft\JRE\1.3.1\bin;C:\oracle\ora92\bin;.;C:\Program Files\Windows Resource
Kits\Tools\;C:\Program
Files\JavaSoft\JRE\1.3.1\bin;C:\Python-2.3.4_distr\Python;C:\Perl\bin\;I:\Win32.VC6\TAO13a_p3\bi
n;I:\Win32.VC6\TAO13a_p3\lib;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\PROGRA~1
\CA\SHARED~1\SCANEN~1;C:\PROGRA~1\CA\ETRUST~1;C:\Program Files\Rational\ClearCase\bin;C:\Program
Files\ATI Technologies\ATI Control Panel;C:\Program Files\Rational\common;.;C:\Program
Files\UltraEdit;C:\nCharge_Accenture_two\server\bin;C:\nCharge_Accenture_two\server\lib;,
lax.nl.env.ORACLE_SID=TIGER,
lax.nl.env.HOMEDRIVE=C:, lax.nl.win32.microsoftvm.min.version=3167,
lax.nl.env.exact_case.PROCESSOR_ARCHITECTURE=x86, lax.nl.env.OS=Windows_NT,
lax.main.class=com.zerog.ia.installer.Main, java.endorsed.dirs=c:\docume~1\tlohan~1.car\locals~1\temp\i1137517156\windows\resource\jre\lib\endorsed,
lax.stderr.redirect=,
lax.nl.env.ro_rv_home=D:\rv-rating-0.1.19-vfuk, lax.nl.env.systemroot=C:\WINDOWS, lax.nl.env.exact_case.SESSIONNAME=Console, lax.nl.java.option.java.heap.size.max=50331648, lax.nl.env.SYSTEMDRIVE=C:, lax.nl.env.exact_case.ProgramFiles=C:\Program Files,
lax.nl.env.PROGRAMFILES=C:\Program Files, sun.os.patch.level=Service Pack 2,
java.vendor.url=http://java.sun.com/, java.version=1.4.2_04,
lax.nl.env.WINDIR=C:\WINDOWS,
lax.nl.env.exact_case.USERNAME=tlohan, lax.nl.java.option.verify.mode=none,
lax.nl.env.JAVA_HOME=C:\j2sdk1.4.2_10, lax.nl.win32.service=false,
lax.nl.env.logonserver=\\IRLGAL13, java.vendor.url.bug=

http://java.sun.com/cgi-bin/bugreport.cgi,

lax.nl.java.option.check.source=off, lax.nl.env.homepath=\Documents and Settings\tlohan.CARMA,
lax.nl.env.exact_case.windir=C:\WINDOWS, lax.nl.env.COMSPEC=C:\WINDOWS\system32\cmd.exe,
user.name=tlohan,
lax.nl.env.processor_architecture=x86, sun.io.unicode.encoding=UnicodeLittle,
lax.nl.env.ALLUSERSPROFILE=C:\Documents and Settings\All Users,
java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition,
lax.nl.env.USERDOMAIN=CARMA,
java.specification.name=Java Platform API Specification,
user.timezone=Europe/London, path.separator=;,
lax.nl.env.PYTHONPATH= C:\Python-2.3.4_distr\Python;C:\Python-2.3.4_distr\Python\Lib;C:\Python-2.3.4_distr\Python\Lib\s
ite_packages;C:\Python-2.3.4_distr\Python\DLLs;C:\Python-2.3.4_distr\Python\LIB\site_packages\wi
n32;C:\Python-2.3.4_distr\Python\Lib\site-
packages\win32\lib;C:\Python-2.3.4_distr\Python\Lib\site_packages\Pythonwin;C:\nCharge_Accenture
_two\server\ambeo_scripts, file.encoding=Cp1252, lax.nl.env.systemdrive=C:,
lax.nl.env.fp_no_host_check=NO, lax.nl.env.USERNAME=tlohan,
lax.nl.env.allusersprofile=C:\Documents and Settings\All Users,
lax.nl.env.processor_revision=0905,
lax.nl.env.exact_case.SystemRoot=C:\WINDOWS, lax.version=5.0,
lax.nl.env.USERDNSDOMAIN=AMBEO.CORP, java.io.tmpdir=C:\DOCUME~1\TLOHAN~1.CAR\LOCALS~1\Temp\, lax.nl.env.username=tlohan,
lax.nl.env.exact_case.COMPUTERNAME=LAPTOP117, lax.nl.env.exact_case.INOCULAN=
C:\PROGRA~1\CA\ETRUST~1,
user.language=en,
lax.nl.env.exact_case.RO_RV_HOME=D:\rv-rating-0.1.19-
vfuk,
line.separator= , lax.nl.java.launcher.main.class=com.zerog.lax.LAX, lax.nl.env.appdata=C:\Documents and Settings\tlohan.CARMA\Application Data, lax.nl.env.windir=C:\WINDOWS,
lax.nl.env.wf_resources=C:\oracle\ora92\WF\RES\WFus.RES, lax.nl.env.exact_case.ACE_ROOT=I:\Win32.VC6\TAO13a_p3, lax.nl.env.exact_case.ORACLE_SID=TIGER, lax.command.line.args=$CMD_LINE_ARGUMENTS$, java.vm.info=mixed mode,
lax.nl.env.exact_case.TMP=
C:\DOCUME~1\TLOHAN~1.CAR\LOCALS~1\Temp, lax.nl.env.exact_case.USERPROFILE=C:\Documents and
Settings\tlohan.CARMA,
java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory,
lax.nl.java.launcher.main.method=main,
java.vm.specification.name=Java Virtual Machine Specification,
lax.nl.current.vm=resource\jre\bin\java.exe, lax.nl.env.exact_case.TEMP=C:\DOCUME~1\TLOHAN~1.CAR\LOCALS~1\Temp,
lax.nl.env.os=Windows_NT, lax.nl.env.PROCESSOR_IDENTIFIER=x86 Family 6 Model 9 Stepping 5,
GenuineIntel, lax.nl.env.exact_case.ComSpec=C:\WINDOWS\system32\cmd.exe,
lax.nl.env.commonprogramfiles=C:\Program Files\Common Files,
lax.nl.env.SESSIONNAME=Console,
lax.nl.env.exact_case.WF_RESOURCES=C:\oracle\ora92\WF\RES\WFus.RES,
lax.nl.env.processor_identifier=x86 Family 6 Model 9 Stepping 5, GenuineIntel,
lax.nl.env.SYSTEMROOT=C:\WINDOWS,
lax.nl.env.exact_case.CLASSPATH=.;C:\oracle\ora92\jdbc\lib\ojdbc14_g.zip;C:\oracle\ora92\jdbc\li
b\nls_charset12.zip;C:\oracle\ora92\jdbc\lib\ocrs12.zip;C:\nCharge_Accenture_two\jacorb_1_4_1;C:
\nCharge_Accenture_two\jacorb_1_4_1\lib\jacorb.jar;C:\oracle\ora92\jdbc\lib;,
lax.nl.env.NUMBER_OF_PROCESSORS=1, lax.nl.env.computername=LAPTOP117,
java.awt.printerjob=sun.awt.windows.WPrinterJob,
lax.nl.env.classpath=.;C:\oracle\ora92\jdbc\lib\ojdbc14_g.zip;C:\oracle\ora92\jdbc\lib\nls_chars
et12.zip;C:\oracle\ora92\jdbc\lib\ocrs12.zip;C:\nCharge_Accenture_two\jacorb_1_4_1;C:\nCharge_Ac
centure_two\jacorb_1_4_1\lib\jacorb.jar;C:\oracle\ora92\jdbc\lib;,
lax.nl.env.INOCULAN=C:\PROGRA~1\CA\ETRUST~1,
lax.nl.env.pathext=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.pyc;.pyo;.pyw;.py;.pys,
lax.stdout.redirect=, lax.nl.env.exact_case.ORACLE_HOME=C:\oracle\ora92, lax.nl.env.ACE_ROOT=I:\Win32.VC6\TAO13a_p3, lax.nl.env.exact_case.AVENGINE=C:\PROGRA~1\CA\SHARED~1\SCANEN~1,
lax.nl.env.exact_case.USERDOMAIN=CARMA, lax.nl.env.inoculan=C:\PROGRA~1\CA\ETRUST~1,
lax.nl.env.exact_case.HOMEDRIVE=C:,
os.name=Windows XP,
java.specification.vendor=Sun Microsystems Inc., java.vm.name=Java HotSpot(TM) Client VM,
lax.nl.env.exact_case.PROCESSOR_REVISION=0905, lax.nl.env.homedrive=C:,
java.library.path=C:\DOCUME~1\TLOHAN~1.CAR\LOCALS~1\Temp\I1137517156\Windows;.;C:\WINDOWS\system32;C:\WINDOWS;C:\j
2sdk1.4.2_10\bin;C:\oracle\ora92\jre\1.4.2\bin\client;C:\oracle\ora92\jre\1.4.2\bin;C:\j2sdk1.4.
2_10\bin;C:\Program Files\Java\j2re1.4.2_03\bin;C:\oracle\ora92\jdbc\lib;C:\Program
Files\JavaSoft\JRE\1.3.1\bin;C:\oracle\ora92\bin;.;C:\Program Files\Windows Resource
Kits\Tools\;C:\Program
Files\JavaSoft\JRE\1.3.1\bin;C:\Python-2.3.4_distr\Python;C:\Perl\bin\;I:\Win32.VC6\TAO13a_p3\bi
n;I:\Win32.VC6\TAO13a_p3\lib;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\PROGRA~1
\CA\SHARED~1\SCANEN~1;C:\PROGRA~1\CA\ETRUST~1;C:\Program Files\Rational\ClearCase\bin;C:\Program
Files\ATI Technologies\ATI Control Panel;C:\Program Files\Rational\common;.;C:\Program
Files\UltraEdit;C:\nCharge_Accenture_two\server\bin;C:\nCharge_Accenture_two\server\lib;,
lax.nl.env.exact_case.SystemDrive=C:, lax.generated.launcher.name=
C:\DOCUME~1\TLOHAN~1.CAR\LOCALS~1\Temp\I1137517156\Windows\nCharge.exe,
lax.nl.env.ace_root=I:\Win32.VC6\TAO13a_p3, java.class.version=48.0,
lax.nl.env.sessionname=Console,
lax.nl.env.exact_case.JAVA_HOME=C:\j2sdk1.4.2_10, lax.nl.env.exact_case.PROCESSOR_LEVEL=6,
lax.nl.env.COMPUTERNAME=LAPTOP117, lax.nl.win32.i386.microsoft.java.compiler=on,
lax.nl.env.path=
C:\j2sdk1.4.2_10\bin;C:\oracle\ora92\jre\1.4.2\bin\client;C:\oracle\ora92\jre\1.4.2\bin;C:\j2sdk
1.4.2_10\bin;C:\Program Files\Java\j2re1.4.2_03\bin;C:\oracle\ora92\jdbc\lib;C:\Program
Files\JavaSoft\JRE\1.3.1\bin;C:\oracle\ora92\bin;.;C:\Program Files\Windows Resource
Kits\Tools\;C:\Program
Files\JavaSoft\JRE\1.3.1\bin;C:\Python-2.3.4_distr\Python;C:\Perl\bin\;I:\Win32.VC6\TAO13a_p3\bi
n;I:\Win32.VC6\TAO13a_p3\lib;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\PROGRA~1
\CA\SHARED~1\SCANEN~1;C:\PROGRA~1\CA\ETRUST~1;C:\Program Files\Rational\ClearCase\bin;C:\Program
Files\ATI Technologies\ATI Control Panel;C:\Program Files\Rational\common;.;C:\Program
Files\UltraEdit;C:\nCharge_Accenture_two\server\bin;C:\nCharge_Accenture_two\server\lib;,
lax.nl.env.exact_case.PYTHONPATH=
C:\Python-2.3.4_distr\Python;C:\Python-2.3.4_distr\Python\Lib;C:\Python-2.3.4_distr\Python\Lib\s
ite_packages;C:\Python-2.3.4_distr\Python\DLLs;C:\Python-2.3.4_distr\Python\LIB\site_packages\wi
n32;C:\Python-2.3.4_distr\Python\Lib\site-
packages\win32\lib;C:\Python-2.3.4_distr\Python\Lib\site_packages\Pythonwin;C:\nCharge_Accenture
_two\server\ambeo_scripts, sun.boot.library.path=
c:\docume~1\tlohan~1.car\locals~1\temp\i1137517156\windows\resource\jre\bin,
lax.nl.env.AVENGINE=C:\PROGRA~1\CA\SHARED~1\SCANEN~1, lax.nl.env.number_of_processors=1,
lax.nl.env.PATH=
C:\j2sdk1.4.2_10\bin;C:\oracle\ora92\jre\1.4.2\bin\client;C:\oracle\ora92\jre\1.4.2\bin;C:\j2sdk
1.4.2_10\bin;C:\Program Files\Java\j2re1.4.2_03\bin;C:\oracle\ora92\jdbc\lib;C:\Program
Files\JavaSoft\JRE\1.3.1\bin;C:\oracle\ora92\bin;.;C:\Program Files\Windows Resource
Kits\Tools\;C:\Program
Files\JavaSoft\JRE\1.3.1\bin;C:\Python-2.3.4_distr\Python;C:\Perl\bin\;I:\Win32.VC6\TAO13a_p3\bi
n;I:\Win32.VC6\TAO13a_p3\lib;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\PROGRA~1
\CA\SHARED~1\SCANEN~1;C:\PROGRA~1\CA\ETRUST~1;C:\Program Files\Rational\ClearCase\bin;C:\Program
Files\ATI Technologies\ATI Control Panel;C:\Program Files\Rational\common;.;C:\Program
Files\UltraEdit;C:\nCharge_Accenture_two\server\bin;C:\nCharge_Accenture_two\server\lib;,
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, user.variant=,
lax.nl.env.PROCESSOR_ARCHITECTURE=x86, lax.nl.env.TMP=C:\DOCUME~1\TLOHAN~1.CAR\LOCALS~1\Temp,
lax.nl.env.exact_case.LOGONSERVER=\\IRLGAL13, lax.nl.env.processor_level=6,
lax.class.path=../InstallerData/IAClasses.zip;resource/jdglue.zip;../InstallerData/Installer.zip
;InstallerData/Installer.zip;../InstallerData;InstallerData, lax.nl.env.WF_RESOURCES=
C:\oracle\ora92\WF\RES\WFus.RES, lax.nl.env.comspec=C:\WINDOWS\system32\cmd.exe,
lax.nl.env.avengine=C:\PROGRA~1\CA\SHARED~1\SCANEN~1, lax.nl.env.USERPROFILE=C:\Documents and
Settings\tlohan.CARMA, lax.nl.env.tmp=C:\DOCUME~1\TLOHAN~1.CAR\LOCALS~1\Temp,
java.vm.specification.version=1.0, lax.main.method=main, lax.nl.env.java_home=C:\j2sdk1.4.2_10,
lax.nl.java.option.java.heap.size.initial=16777216, awt.toolkit=sun.awt.windows.WToolkit,
lax.nl.env.wv_gateway_cfg=C:\oracle\ora92\Apache\modplsql\cfg\wdbsvr.app,
lax.installer.win32.internal.property.0=bin\java.exe, sun.cpu.isalist=pentium i486 i386,
java.ext.dirs=c:\docume~1\tlohan~1.car\locals~1\temp\i1137517156\windows\resource\jre\lib\ext,
os.version=5.1, lax.nl.env.exact_case.OS=Windows_NT, user.home=C:\Documents and
Settings\tlohan.CARMA, java.vm.vendor=Sun Microsystems Inc., lax.nl.env.COMMONPROGRAMFILES=
C:\Program Files\Common Files, lax.nl.env.exact_case.APPDATA=C:\Documents and
Settings\tlohan.CARMA\Application Data, lax.stdin.redirect=,
lax.nl.env.exact_case.CommonProgramFiles=C:\Program Files\Common Files, user.dir=
C:\DOCUME~1\TLOHAN~1.CAR\LOCALS~1\Temp\I1137517156\Windows, lax.nl.env.oracle_sid=TIGER,
lax.nl.valid.vm.list=J2 J1 MSJ MRJ, lax.nl.env.ORACLE_HOME=C:\oracle\ora92, sun.cpu.endian=
little, lax.nl.env.APPDATA=C:\Documents and Settings\tlohan.CARMA\Application Data,
java.vm.version=1.4.2_04-b05, lax.nl.env.exact_case.USERDNSDOMAIN=AMBEO.CORP, java.class.path=
C:\DOCUME~1\TLOHAN~1.CAR\LOCALS~1\Temp\I1137517156\InstallerData\IAClasses.zip;C:\DOCUME~1\TLOHA
N~1.CAR\LOCALS~1\Temp\I1137517156\Windows\resource\jdglue.zip;C:\DOCUME~1\TLOHAN~1.CAR\LOCALS~1\
Temp\I1137517156\InstallerData\Installer.zip;C:\DOCUME~1\TLOHAN~1.CAR\LOCALS~1\Temp\I1137517156\
Windows\InstallerData\Installer.zip;C:\DOCUME~1\TLOHAN~1.CAR\LOCALS~1\Temp\I1137517156\Installer
Data;C:\DOCUME~1\TLOHAN~1.CAR\LOCALS~1\Temp\I1137517156\Windows\InstallerData;c:\docume~1\tlohan
~1.car\locals~1\temp\i1137517156\windows\resource\jre\lib\jce.jar;c:\docume~1\tlohan~1.car\local
s~1\temp\i1137517156\windows\resource\jre\lib\jsse.jar;c:\docume~1\tlohan~1.car\locals~1\temp\i1
137517156\windows\resource\jre\lib\plugin.jar;c:\docume~1\tlohan~1.car\locals~1\temp\i1137517156
\windows\resource\jre\lib\rt.jar;c:\docume~1\tlohan~1.car\locals~1\temp\i1137517156\windows\reso
urce\jre\lib\sunrsasign.jar;, os.arch=x86, lax.nl.env.userprofile=C:\Documents and
Settings\tlohan.CARMA, lax.nl.env.userdnsdomain=AMBEO.CORP, lax.nl.env.userdomain=CARMA,
lax.nl.env.PROCESSOR_LEVEL=6, lax.nl.env.exact_case.FP_NO_HOST_CHECK=NO,
lax.nl.env.exact_case.HOMEPATH=\Documents and Settings\tlohan.CARMA,
java.vm.specification.vendor=Sun Microsystems Inc., file.separator=\,
lax.nl.env.exact_case.PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.pyc;.pyo;.pyw;.p
y;.pys, lax.nl.env.exact_case.WV_GATEWAY_CFG=C:\oracle\ora92\Apache\modplsql\cfg\wdbsvr.app,
java.runtime.version=1.4.2_04-b05, sun.boot.class.path=
c:\docume~1\tlohan~1.car\locals~1\temp\i1137517156\windows\resource\jre\lib\rt.jar;c:\docume~1\t
lohan~1.car\locals~1\temp\i1137517156\windows\resource\jre\lib\i18n.jar;c:\docume~1\tlohan~1.car
\locals~1\temp\i1137517156\windows\resource\jre\lib\sunrsasign.jar;c:\docume~1\tlohan~1.car\loca
ls~1\temp\i1137517156\windows\resource\jre\lib\jsse.jar;c:\docume~1\tlohan~1.car\locals~1\temp\i
1137517156\windows\resource\jre\lib\jce.jar;c:\docume~1\tlohan~1.car\locals~1\temp\i1137517156\w
indows\resource\jre\lib\charsets.jar;c:\docume~1\tlohan~1.car\locals~1\temp\i1137517156\windows\
resource\jre\classes, lax.nl.env.exact_case.ALLUSERSPROFILE=C:\Documents and Settings\All Users,
lax.nl.env.exact_case.PROCESSOR_IDENTIFIER=x86 Family 6 Model 9 Stepping 5, GenuineIntel,
sun.java2d.fontpath=, user.country=IE, lax.nl.env.FP_NO_HOST_CHECK=NO,
lax.nl.env.PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.pyc;.pyo;.pyw;.py;.pys,
lax.nl.env.exact_case.NUMBER_OF_PROCESSORS=1,
lax.nl.env.CLASSPATH=.;C:\oracle\ora92\jdbc\lib\ojdbc14_g.zip;C:\oracle\ora92\jdbc\lib\nls_chars
et12.zip;C:\oracle\ora92\jdbc\lib\ocrs12.zip;C:\nCharge_Accenture_two\jacorb_1_4_1;C:\nCharge_Ac
centure_two\jacorb_1_4_1\lib\jacorb.jar;C:\oracle\ora92\jdbc\lib;, java.vendor=Sun Microsystems
Inc., lax.nl.env.LOGONSERVER=\\IRLGAL13, lax.nl.env.oracle_home=C:\oracle\ora92,
lax.nl.env.WV_GATEWAY_CFG=C:\oracle\ora92\Apache\modplsql\cfg\wdbsvr.app, lax.nl.env.temp=
C:\DOCUME~1\TLOHAN~1.CAR\LOCALS~1\Temp, java.specification.version=1.4, lax.nl.env.pythonpath=
C:\Python-2.3.4_distr\Python;C:\Python-2.3.4_distr\Python\Lib;C:\Python-2.3.4_distr\Python\Lib\s
ite_packages;C:\Python-2.3.4_distr\Python\DLLs;C:\Python-2.3.4_distr\Python\LIB\site_packages\wi
n32;C:\Python-2.3.4_distr\Python\Lib\site-
packages\win32\lib;C:\Python-2.3.4_distr\Python\Lib\site_packages\Pythonwin;C:\nCharge_Accenture
_two\server\ambeo_scripts, sun.arch.data.model=32}

 

[sedj]

2 problems jump right out :

1) You have multiple versions of JRE's defined in various path variables
2) You do not have classes12.jar defined anywhere

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[toddyl]

I've removed all references to JRE's as it installs its own and have added the classes12.zip to my classpath but no change in the overall result

 

[wangdong]

Params: laptop117,TIGER,TOM,TOM DB URL:
jdbcracle:thinlaptop117:1521:TIGER
No either a username or a password has appeared in the params line.

If TIGER is the username, the conn will be wrong, which should be
jdbcracle:thinlaptop117:1521?TIGER?password

Chinese Java Faq Forum

http://www.4ugo.com/bbs/index.asp