Two Laptop Bag
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: 2987

Topic continue in


K. Tsang JavaRanch SCJP5 SCJD OCPJP7 OCPWCD5 OCPBCD5 OCPWSD5 OCMJEA5 part 1 part 2/3
Have you checked out Aspose?
subject: Oracle 11g Database schema selection
It's not a secret anymore!