rubbal sandhu

Greenhorn
+ Follow
since Dec 20, 2010
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
2
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by rubbal sandhu

Hi I am getting The requested resource (/CompleteApp/home/WEB-INF/views/Login.jsp) is not available if we use the url as http://localhost:8080/CompleteApp/home/app?new but the Login.jsp is called when I ommit da 'app'
in url that is http://localhost:8080/CompleteApp/home?new.

Debugger tells me that same function is being called and its even returning the same string. But I dont understand why the first request is not giving me Login.jsp

My code is



and dispatcher servlet is :


Thanks in Advance
12 years ago
Hi Uttam,

Thanks for your help.
I have put the oracle-ds.xml file in the server\default\deploy
also I have tried putting both ojdbc.jar and classes12.jar in server\default\lib

I am still getting javax.naming.NameNotFoundException: jdbc not bound

here is my oracle-ds.xml file

<?xml version="1.0" encoding="UTF-8"?>

<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->

<!-- $Id: oracle-ds.xml,v 1.6 2004/09/15 14:37:40 loubyansky Exp $ -->
<!-- ==================================================================== -->
<!-- Datasource config for Oracle originally from Steven Coy -->
<!-- ==================================================================== -->


<datasources>
<local-tx-datasource>
<jndi-name>MYCoreDS</jndi-name>
<connection-url>jdbc:oracle:thin:@192.166.6.115:1521:MYDB</connection-url>
<!--
See on WIKI page below how to use Oracle's thin JDBC driver to connect with enterprise RAC.
-->
<!--
Here are a couple of the possible OCI configurations.
For more information, see http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/toc.htm

<connection-url>jdbc:oracle:oci:@youroracle-tns-name</connection-url>
or
<connection-url>jdbc:oracle:oci:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))</connection-url>

Clearly, its better to have TNS set up properly.
-->
<driver-class>oracle.jdbc.pool.OracleDataSourcer</driver-class>
<user-name>m_demo</user-name>
<password>*****</password>

<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>

<!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
<!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name-->
<!-- Checks the Oracle error codes and messages for fatal errors -->
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->

<!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->

<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
</local-tx-datasource>

</datasources>




13 years ago
Hi
I am sorry but I am new to jboss, do I need to have oracle-datasource.xml in my WAR file?
Among the long error logs, 'jdbc not bound' caught my eye.
I have made following changes in jboss:
in default/deploy/ hsqldb-ds.xml
I have added,

<jndi-name>jdbc/MYCoreDS</jndi-name>
<connection-url>jdbc:oracle:thin:@192.166.6.115:1521:MYDB</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

<!-- The login and password -->
<user-name>m_demo</user-name>
<password>m_demo</password>

and in default/conf/ standardjbosscmp-jdbc.xml
<datasource>java:/MYCoreDS</datasource>
I have taken the above elements from datasource file produced by my jdev
Also I have put classes12.jar in jboss lib folder and also in my WAR file.


uttam kumar wrote:You need to deploy oracle-ds.xml for making connection with oracle database. No need to change hsqldb-ds.xml. Are you facing any kind of error while deploying you war? If so, please post the entire error log along with the changes that you have done in JBoss.

Thanks,
Uttam Kumar

13 years ago

uttam kumar wrote:Which JBoss version you are using? For making a connection with database you have to deploy a corresponding *-ds.xml file. See <JBOSS_HOME>\docs\examples\jca.



Thanks!!
I am using jboss 5.0.0 I have made changes in hsqldb-ds.xml and standardjbosscmp-jdbc.xml, do I need to make any change in my war file as well
13 years ago
thanks for you concern, finally I got sucess, I was using abbreviation in the subject line which I was not looking at. I will this post.
13 years ago
I have a WAR file which runs fine on IBM websphere, now I want to run it on jboss. I am able to run a static website by putting it in the deploy folder, but for the dynamic website I need to make an oracle connection. Can any one please help where all I need to make changes. I am not using EJB's do I still need jbosscmp-jdbc.xm?

Regards
13 years ago
I am not able to make a post even I am not using any abbreviation, can any one what should I do?
13 years ago