However there are situations where the application code is dependent on Oracle database. One such example is when you use Oracle Stored procedures and you need to use Oracle Cursor as on output parameter. In such case you will have to cast the Statement to Oracle specific oracle.jdbc.OracleCallableStatement class to get the cursor.
However if you simply cast the java.sql.CallableStatement to oracle.jdbc.OracleCallableStatement you may notice that you get a class cast exception if you configured your DataSource using the above method.
To overcome the class cast exception, you need to configure the data source using a Oracle specific connection factory. The following example will server that purpose. The text in bold are the changes pertaining to the Oracle connection factory.
<Resource name="jdbc/OracleDS" auth="Container" type="oracle.jdbc.pool.OracleDataSource"
user="DBUser"
password="xxxxxx"
driverClassName="oracle.jdbc.OracleDriver"
factory="oracle.jdbc.pool.OracleDataSourceFactory"
url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=your.db.host)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=serviceName)))"
maxActive="?"
maxIdle="?"
maxWait="-1"/>
8 comments:
I have no words for this great post such a awe-some information i got gathered. Thanks to Author.
html5 converter
Thanks a lot man
Nice post. Oracle is a relational database management system produced by oracle corporation. Nowadays most of the multinational companies used this oracle database for storing and managing their data's and programs. So learning Oracle Training in Chennai is one of the best idea to make a bright career.
Such A nice post... thanks For Sharing !!Great information for new guy like Happy New year 2020
Such A nice post... thanks For Sharing !!Great information for new guy like Hanuman Chalisa Lyrics
Oracle Database Link Tomcat Resource Configuration The Database Link Pool function in Tomcat works with most databases, including Oracle. If you want to take ebook writing services so you can contact us.
Web Application Development Software Lets You Build An On-Premise Or Cloud-Based System That Serves Your Every Business Need,Hey this is umair i have been using custom development system since 3 years they are providing their services in best rates,you can also get your customize software that fulfilled your requirment with ease software application development
Oracle is a good database and secure data base as compare to sql and my sql.If you are looking to buy an online Copywriting Service In Karachi to help the students of college and university at an affordable and reasonable price.
Post a Comment