[jboss-user] [JBoss Portal] - Re: No such user admin

[nvipas]

"PeterJ" wrote : I assume that you configured a *-ds.xml file to connect to Oracle. What username and password did you provide in that file? Is it a valid Oracle username and password?

===============

Yes, valid username/password created using sqlplus with all necessary permissions -

1. CREATE SESSION
2. CREATE TABLE
3. CREATE SEQUENCE

===============

Here's the *-ds.xml file -

$ cat portal-oracle-ds.xml
<?xml version="1.0" encoding="UTF-8"?>



    <local-tx-datasource>
        <jndi-name>PortalDS</jndi-name>
        <connection-url>jdbc:oracle:thin:@lp-nvijayapuram:1521:sainaga</connecti
on-url>
        <driver-class>oracle.jdbc.OracleDriver</driver-class>
        <user-name>jbossportal</user-name>
        jbossportal
    </local-tx-datasource>



================================================

Question: This particular line in setup/portal-oracle-ds.xml surprised me, as I not used to seeing un/pw between 'thin:' and '@host', so took off the 'un/pw' in my *-ds.xml file as listed above.

$ grep thin portal-oracle-ds.xml
    <connection-url>jdbc:oracle:thin:SYSTEM/password at localhost:1521:orcl</connec
tion-url>

================


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4192305#4192305

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4192305