File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Oracle 11g Database schema selection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Reply locked New topic

Oracle 11g Database schema selection

Peter Fernandes

Joined: May 21, 2008
Posts: 10
Hi All

I am using Oracle 11g express, have problem to a particular schema or workspace. How can I connect to a particular schema?

Below configuration works fine. I dont know which schema it is connecting.





<!-- Database connection settings -->

<property name="connection.driver_class">oracle.jdbc.OracleDriver</property>

<property name="connection.url">jdbcracle:thinrnelo/ornelo@localhost:1521:xe</property>

<property name="connection.databaseName">hr</property>
<property name="connection.username">ornelo</property>

<property name="connection.password">ornelo</property>

<!-- JDBC connection pool (use the built-in) -->

<property name="connection.pool_size">1</property>

<!-- SQL dialect -->

<property name="dialect">org.hibernate.dialect.OracleDialect</property>

<!-- Disable the second-level cache -->

<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

<!-- Echo all executed SQL to stdout -->

<property name="show_sql">true</property>

<!-- Drop and re-create the database schema on startup -->

<property name="">create</property>

<!-- <mapping resource="org/hibernate/tutorial/hbm/Event.hbm.xml" /> -->

<mapping class="com.nazare.hibernate.dto.UserDetails"/>


K. Tsang

Joined: Sep 13, 2007
Posts: 3132

Topic continue in


K. Tsang JavaRanch SCJP5 SCJD OCPJP7 OCPWCD5 OCPBCD5 OCPWSD5 OCMJEA5 part 1 part 2/3
I agree. Here's the link:
subject: Oracle 11g Database schema selection
It's not a secret anymore!