Greetings Ranchers. I'm having the following problem: I need to make a program (executable jar) that connects to an oracle database. Normaly I would do something like this:
BUT I am not allowed to code the username and password into the code, into a properties file or prompt the user for it. According to our database admin I should ommit username and password like this:
In this case, when the databse is called, it should look for the operating system user and give him the correct connection. So I tried his aproach, but everytime I leave out user/pass i get a java.sql.SQLException: Illegal arguments in call (I hope it is the correct translation, it reads: Ung�ltige Argumente in Aufruf) Google always came up with "just give it user/pass", but as I can't do that, I'm rather helpless at the moment.
Can somebody point me into a direction where to find a solution?
Klingon multitasking systems do not support "time-sharing". When a Klingon program wants to run, it challenges the scheduler in hand-to-hand combat and owns the machine
If you want to do this you'll need a driver that supports NTLM. I'm not sure the driver's supplied by Oracle do this; I might be wrong about the OCI driver - its been a long time since I looked at that.
I made some progress, at least I hope this is going into the right direction. I updatet to a better driver and left out the /. Furthermore, my db admin gave me some files with wich to work (libclntsh.so.10.1, libnnz10.so, libnnz10.so, libociei.so and libocijdbc10.sh). With these files I should be able to switch from thin to oci8 (jdbcracleci8:@databasestuff). I no longer get the previous errormessage, now I get: Exception in thread "main" java.lang.UnsatisfiedLinkError: /xxxxx/libocijdbc10.so: ld.so.1: java: fatal: /xxxxx/libocijdbc10.so: wrong ELF class: ELFCLASS64
The libocijdbc10.so file that I use is the same file that a program named sqlplus uses. And with sqlplus my db admin can connect without username/password.
Any ideas why the file wont work for me? [ January 15, 2008: Message edited by: Heiko Graf ]