2 Replies Latest reply on Oct 5, 2012 4:36 PM by Samaresh Sridhar

    Unable to connect to oracle database

    Samaresh Sridhar Newbie

      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 ?