Geoportal: A database communication error has occur

[Mirza_MuhammadWaqar]

HI

Whenever I try to login with admin, publisher or registereduser in geoportal the following error displays:
"A database communication error has occur."

What am I missing?

Thanks

Mirza Waqar

[ErosSy]

hello
with same problem I've solved:
replacing the username="geoportal" property by user="geoportal" in geoportal.xml

helped me a lot.

the root cause was specifying the "type" & "factory" value from geoportal.xml (context.xml)
the specified api uses the "user" not "username" property.

Which is not documented.

Thanks a lot. sbruscoli

[AndrzejBieniek]

Below is working geoportal.xml file (using Oracle Service name)

server_name must be replaced by your real server name
service_name must be replaced with your real service name like ORCL

<!-- Context configuration file for the Geoportal Web App -->
<Context docBase="geoportal" path="/geoportal" debug="0" reloadable="true" crossContext="true">
  <Resource name="jdbc/gpt" auth="Container"
            type="oracle.jdbc.pool.OracleDataSource"
            driverClassName="oracle.jdbc.driver.OracleDriver"
            factory="oracle.jdbc.pool.OracleDataSourceFactory"
            url="jdbc:oracle:thin:@//server_name:1521/service_name"
            user="geoportal"
            password="geoportalpwd"
            maxActive="20"
            maxIdle="10"
            maxWait="-1" />
</Context>

Depending if u are using SID or ServiceName URL is different:

 jdbc:oracle:thin:[USER/PASSWORD]@[HOST][:PORT]:SID
 jdbc:oracle:thin:[USER/PASSWORD]@//[HOST][:PORT]/SERVICE

Sample connect string:

url = "jdbc:oracle:thin:@//myhost:1521/orcl"
url = "jdbc:oracle:thin:@myhost:1521:orcl"

I hope it helps.

regards