Unable to connect to oracle database

[ssamaresh]

Hi.

Im trying to connect to an oracle database through the example simpleclient.java. I have deployed all the necessary -ds files and vdb's. When I start the JBoss server it shows that my files have been deployed properly. When I try and query the databse using the simpleclient program I get an exception:

SEVERE: Could not create connection

org.teiid.jdbc.TeiidSQLException: The username and/or password and/or payload token could not be authenticated by any membership domain.

          at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)

          at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)

          at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:56)

          at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)

          at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:249)

          at JDBCClient.getDataSourceConnection(JDBCClient.java:89)

          at JDBCClient.main(JDBCClient.java:61)...

The database that im trying to access is remote. I am able to access all databases that are local.

In a post earlier Ramesh had told to deploy a jdbc.war in Jboss to test the datasources. I tried doing that and I get results.

https://community.jboss.org/thread/154505

But when i execute the client program i get the same error.

Can anyone help resolve this problem ?

[tejones]

Samaresh,

Have you added a user/role in the teiid-security-*.properties files?

{profile}/conf/props

                      /teiid-security-users.properties

                      /teiid-security-roles.properties

Thanks,

Ted

[ssamaresh]

Hi Ted.

I had forgotten to do that.

It works fine now.

Thanks.