Oracle database - null password given

[tomasa22]

I am using Schemaspy 6.2.4 and trying to connect to Oracle database (Data warehouse) but I am receiving this error:

ORA-01005: null password given; logon denied

even if I have my password in .properties file or try -pfp prompt (I don’t want to have password in cmd history or in text file)

here is my schemaspy.properties file:

{
# type of database. Run with -dbhelp for details
schemaspy.t=orathin
# path to the dowloaded oracle jdbc drivers, for example
schemaspy.dp=C:\Users\0001\programs\Schemaspy\driver\ojdbc8-23.3.0.23.09.jar
# database properties: host, port number, name user, password
schemaspy.host=pdwh1
schemaspy.port=1521
schemaspy.db=DWH
schemaspy.u=a_1111
schemaspy.p=xxxxxx
# output dir to save generated files
schemaspy.o=C:\Users\0001\programs\Schemaspy\output

# db scheme for which generate diagrams
schemaspy.s=DWH_DWH
}

if I try to put random letters still same error: ORA-01005: null password given; logon denied

I tried to connect to my local Postgres DB everything works fine. Even tried Schemacrawler and was able to connect to DWH, but I would prefer Schemaspy

Context

• Database type (e.g. MySQL): ORACLE
• Database driver version (is you use a special one): ojdbc8-23.3.0.23.09
• Full command including arguments how you run SchemaSpy: java -jar .\schemaspy-6.2.4.jar -pfp

Your Environment

• Version used: 6.0.0, 6.1.0, 6.2.0, 6.2.1, 6.2.4
• Operating System and version (e.g. Windows 10): Win10
• Java version: Version 8 Update 131 (build 1.8.0_131-b11)

[npetzall]

Hi can you try to quote the password?

If there are any characters that might mess up the parsing of properties file.

[tomasa22]

Hi, I tried and still same error.

[npetzall]

Hmm, if it works with PostgreSQL but not with oracle, I'm gone assume that I might have to do with the driver.

I.e we might not be providing credentials in the way it expects and as such null.

So I'll need to look into it.

In our automated test we use version 21 of the driver, so I'll bump it and see what happens.

[tomasa22]

Now I used oracle driver version ojdbc8-21.1.0.0 as you mentioned and no more: null password given; logon denied
so I am connected.
but now I have this:

ERROR - Bad config
Catalog (-cat) was not provided and unable to deduce catalog, wildcard catalog can be used -cat %

so yes I think the problem is with drivers

[npetzall]

Whenever using oracle we have used the wildcard. Way back there were som changes to the code so that catalog is required and the driver doesn't return one so we needed the wildcard -cat %