Hello

I am using jboss 4.0.3, and deployed a small hibernate app. when I started to use the app, I have the following problem:

10:05:41,312 WARN [UserSuppliedConnectionProvider] No connection properties specified - the user must supply JDBC connections

However, I do have the connection specified in the hibernate.cfg.xml, and the datasource is defined in oracle-ds.xml in the jboss deploy directory.

<hibernate-configuration>
<session-factory name="java:/hibernate/HibernateFactory">
<property name="show_sql">true</property>
<property name="connection.datasource">java:/comp/env/jdbc/TimeTracker</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
</session-factory>
</hibernate-configuration>


By printing out the connection properties, I confirm that the properties are set


[STDOUT] hibernate.session_factory_name=java:/hibernate/HibernateFactory
[STDOUT] hibernate.cglib.use_reflection_optimizer=true
[STDOUT] hibernate.connection.datasource=java:/comp/env/jdbc/TimeTracker
[STDOUT] hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
[STDOUT] hibernate.show_sql=true

Can anybody help me to figure this out?

thanks in advance

Are you using EJB 3.0 beta?
or,
are you using hibernate directly?

No, I am not using any EJB. I use hibernate directly

Hm...
So, it's not EJB 3.0 configuration...

Post your oracle-ds.xml. Another possibility is oracle datasource config doesn't match the hibernate datasource.

Here is the oracle-ds.xml:

<datasources>
<local-tx-datasource>
<jndi-name>TimeTracker</jndi-name>
<connection-url>jdbc:oracle:thin:@127.0.0.1:1521:test</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>timetracker</user-name>
<password>test</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</local-tx-datasource>
</datasources>

Thanks

I am using jboss 4.0.1, and my datasource name is MySqlDS. My hibernate config is set to have connection.datasource=java:/MySqlDS. It works.

So, try the jndi name of java:/TimeTracker for your datasource.
<property name="connection.datasource">java:/TimeTracker</property>

I tried :
<property name="connection.datasource">java:/TimeTracker</property>
and it did not make any difference.

I read somewhere that the hibernate application needs to be deployed as .har, not .war. jboss 4.0.1 can read from the expanded directory structure, but jboss 4.0.2 has a bug to read from the expanded deployment dir.

Do you mind to post your deployment structure for your working hibernate app?

thanks in advance

I successfully deploy our application as a war file in both JBoss 3.2.6 and 4.0.2.

mssql-ds.xml


hibernate.cfg.xml


When we deploy to Weblogic 8.1, we drop the "java:/" from the datasource property.

I tried on different versions of jboss, tried expanded deployment and compact .ear or .war deployment, and modified the connection.datasource to various format, the results yield the same to me:

the deployment was successful. When I load the jsp page, the log indicates that the configuration file has been located and read, but it always failed by complaining the no connection properties specified.

can anyone point out what is wrong here?

thx

The problem was resolved by explicitly set the connection properties in the application code by this:

System.setProperty("hibernate.connection.datasource", "java:/TimeTracker");
cfg.setProperties(System.getProperties());

I don't think this is the right way to do it even though it makes the app working.