"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@localhost:1521:orcl</connec
tion-url>
================
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4192305#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...