Problem with Hibernate and Oracle

[Joe Ess]

I've used Hibernate before with Derby, but I can't seem to get it working with Oracle. I'm using Oracle 9.2.0.1 and Hibernate 4.1.1 and my code is as simple as it can get:

import java.util.*;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class test2{
	
	public static void main(String args[]){

	    SessionFactory sessionFactory;	
	    Configuration cfg = new Configuration()
	    .setProperty("hibernate.connection.driver_class", "oracle.jdbc.driver.OracleDriver")
	    .setProperty("hibernate.connection.url", "jdbc:oracle:thin:@localhost:1521:WWWWW")
	    .setProperty("hibernate.connection.username", "XXXXX")
	    .setProperty("hibernate.connection.password", "YYYYY")
	    .setProperty("default_schema", "ZZZZZ")
	    .setProperty("hibernate.dialect", "org.hibernate.dialect.Oracle9iDialect");

	    sessionFactory = cfg.buildSessionFactory();
	        
	    Session session = sessionFactory.openSession();

	}
}

I get the following when I run this code:

C:\Projects\HibernateTest>java test2
Mar 30, 2012 1:00:03 PM org.hibernate.annotations.common.Version <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {4.0.1.Final}
Mar 30, 2012 1:00:03 PM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.1.1}
Mar 30, 2012 1:00:03 PM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
Mar 30, 2012 1:00:03 PM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
Mar 30, 2012 1:00:03 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000402: Using Hibernate built-in connection pool (not for production use!)
Mar 30, 2012 1:00:03 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000115: Hibernate connection pool size: 20
Mar 30, 2012 1:00:03 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000006: Autocommit mode: false
Mar 30, 2012 1:00:03 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000401: using driver [oracle.jdbc.driver.OracleDriver] at URL [jdbc:oracle:thin:@localhost:1521:cclinic]
Mar 30, 2012 1:00:03 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000046: Connection properties: {user=eccuser, password=****}
Mar 30, 2012 1:00:03 PM org.hibernate.engine.jdbc.internal.JdbcServicesImpl configure
WARN: HHH000341: Could not obtain connection metadata : Unsupported feature
Mar 30, 2012 1:00:03 PM org.hibernate.engine.jdbc.internal.LobCreatorBuilder useContextualLobCreation
INFO: HHH000422: Disabling contextual LOB creation as connection was null
Exception in thread "main" java.lang.NullPointerException
        at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:207)
        at org.hibernate.service.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:
75)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java
:159)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:131)
        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:71)
        at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2273)
        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2269)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1738)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1778)
        at test2.main(test2.java:19)

I've updated my JDBC drivers, searched for hours and I'm at a loss. Anybody see anything wrong with my code?

[Koen Aerts]

I noticed you're using "default_schema" instead of "hibernate.default_schema", not sure if that would cause this issue. I think you also may need to specify a pool size for JDBC connections (hibernate.connection.pool_size).

[Joe Ess]

Thanks, but I still get the same error:

import java.util.*;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class test2{
	
	public static void main(String args[]){

	    SessionFactory sessionFactory;	
	    Configuration cfg = new Configuration()
	    .setProperty("hibernate.connection.driver_class", "oracle.jdbc.driver.OracleDriver")
	    .setProperty("hibernate.connection.url", "jdbc:oracle:thin:@localhost:1521:WWWWW")
	    .setProperty("hibernate.connection.username", "XXXXX")
	    .setProperty("hibernate.connection.password", "YYYYY")
	    .setProperty("hibernate.default_schema", "ZZZZZ")
	    .setProperty("hibernate.dialect", "org.hibernate.dialect.Oracle9iDialect")
	    .setProperty("hibernate.connection.pool_size", "10");

	    sessionFactory = cfg.buildSessionFactory();
	        
		Session session = sessionFactory.openSession();

	}
}

C:\Projects\HibernateTest>java test2
Mar 30, 2012 1:30:30 PM org.hibernate.annotations.common.Version <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {4.0.1.Final}
Mar 30, 2012 1:30:30 PM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.1.1}
Mar 30, 2012 1:30:30 PM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
Mar 30, 2012 1:30:30 PM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
Mar 30, 2012 1:30:30 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000402: Using Hibernate built-in connection pool (not for production use!)
Mar 30, 2012 1:30:30 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000115: Hibernate connection pool size: 10
Mar 30, 2012 1:30:30 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000006: Autocommit mode: false
Mar 30, 2012 1:30:30 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000401: using driver [oracle.jdbc.driver.OracleDriver] at URL [jdbc:oracle:thin:@localhost:1521:cclinic]
Mar 30, 2012 1:30:30 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000046: Connection properties: {user=eccuser, password=****}
Mar 30, 2012 1:30:30 PM org.hibernate.engine.jdbc.internal.JdbcServicesImpl configure
WARN: HHH000341: Could not obtain connection metadata : Unsupported feature
Mar 30, 2012 1:30:30 PM org.hibernate.engine.jdbc.internal.LobCreatorBuilder useContextualLobCreation
INFO: HHH000422: Disabling contextual LOB creation as connection was null
Exception in thread "main" java.lang.NullPointerException
        at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:207)
        at org.hibernate.service.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:
75)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java
:159)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:131)
        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:71)
        at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2273)
        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2269)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1738)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1778)
        at test2.main(test2.java:20)

[Koen Aerts]

I have never used Hibernate like this before; I normally use Hibernate's XML or properties config file. Did you try that approach too? Also, are all relevant jar files included on the java command line; i.e. Oracle driver (i.e. ojdbc14.jar) and Hibernate jars, etc.?

[Joe Ess]

I tried using a hibernate.hbm.xml file with the same settings. I changed it to the programmatic configuration to post here, thinking one fewer file would make the code easier to read. The results were the same.
My classpath contains all the files in the Hibernate required directory as well as the current directory and the Oracle driver:

C:\Projects\HibernateTest>echo %CLASSPATH%
.;C:\oracle\ora92\jdbc\lib\ojdbc14.jar;C:\oracle\ora92\jdbc\ocrs12.zip;C:\Projects\HibernateTest\hibernate-release-4.1.1
.Final\lib\required\antlr-2.7.7.jar;C:\Projects\HibernateTest\hibernate-release-4.1.1.Final\lib\required\dom4j-1.6.1.jar
;C:\Projects\HibernateTest\hibernate-release-4.1.1.Final\lib\required\hibernate-commons-annotations-4.0.1.Final.jar;C:\P
rojects\HibernateTest\hibernate-release-4.1.1.Final\lib\required\hibernate-core-4.1.1.Final.jar;C:\Projects\HibernateTes
t\hibernate-release-4.1.1.Final\lib\required\hibernate-jpa-2.0-api-1.0.1.Final.jar;C:\Projects\HibernateTest\hibernate-r
elease-4.1.1.Final\lib\required\javassist-3.15.0-GA.jar;C:\Projects\HibernateTest\hibernate-release-4.1.1.Final\lib\requ
ired\jboss-logging-3.1.0.GA.jar;C:\Projects\HibernateTest\hibernate-release-4.1.1.Final\lib\required\jboss-transaction-a
pi_1.1_spec-1.0.0.Final.jar

[Piyush Mangal]

Try Changing setProperty("hibernate.default_schema", "ZZZZZ") to setProperty("hibernate.default_schema", "zzzzz") to lower case.

https://forum.hibernate.org/viewtopic.php?f=6&t=998260

[Joe Ess]

Thanks, Piyush. I saw that post and tried it both ways. Same error. For the record, Oracle Enterprise Manager Console shows the schema name as all-caps (and I removed the "real" values from the code I posted and the code you quoted).

[Koen Aerts]

Would the following approach work?

Configuration cfg = new Configuration()   
        .setProperty(...);
ServiceRegistry serviceRegistry = new ServiceRegistryBuilder()
    .applySettings(cfg.getProperties())
    .buildServiceRegistry();
MetadataSources metadataSources = new MetadataSources(serviceRegistry);
SessionFactory sessionFactory = metadataSources.buildMetadata().buildSessionFactory();

[Piyush Mangal]

Joe Ess wrote:Thanks, Piyush. I saw that post and tried it both ways. Same error. For the record, Oracle Enterprise Manager Console shows the schema name as all-caps (and I removed the "real" values from the code I posted and the code you quoted).

Try removing default schema property altogether and see if you are able to get rid of this error. Regarding connection URL jdbc:oracle:thin:@localhost:1521:WWWWW.
Are you sure WWWWW is valid SID?

[Joe Ess]

The code looks like this now:

import java.util.*;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.metamodel .MetadataSources;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;

public class test2{
	
	public static void main(String args[]){

	    SessionFactory sessionFactory;	
	    Configuration cfg = new Configuration()
	    .setProperty("hibernate.connection.driver_class", "oracle.jdbc.driver.OracleDriver")
	    .setProperty("hibernate.connection.url", "jdbc:oracle:thin:@localhost:1521:WWWWW")
	    .setProperty("hibernate.connection.username", "XXXXX")
	    .setProperty("hibernate.connection.password", "YYYYY")
	    .setProperty("hibernate.default_schema", "ZZZZZ")
	    .setProperty("hibernate.dialect", "org.hibernate.dialect.Oracle9iDialect")
	    .setProperty("hibernate.connection.pool_size", "10");

	    ServiceRegistry serviceRegistry = new ServiceRegistryBuilder()  
	    .applySettings(cfg.getProperties())  
	    .buildServiceRegistry();  
	    MetadataSources metadataSources = new MetadataSources(serviceRegistry);  
	    sessionFactory = metadataSources.buildMetadata().buildSessionFactory();  
	        
		Session session = sessionFactory.openSession();

	}
}

I got the same error:

C:\Projects\HibernateTest>java test2
Mar 30, 2012 3:25:53 PM org.hibernate.annotations.common.Version <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {4.0.1.Final}
Mar 30, 2012 3:25:53 PM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.1.1}
Mar 30, 2012 3:25:53 PM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
Mar 30, 2012 3:25:53 PM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
Mar 30, 2012 3:25:53 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000402: Using Hibernate built-in connection pool (not for production use!)
Mar 30, 2012 3:25:53 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000115: Hibernate connection pool size: 10
Mar 30, 2012 3:25:53 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000006: Autocommit mode: false
Mar 30, 2012 3:25:53 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000401: using driver [oracle.jdbc.driver.OracleDriver] at URL [jdbc:oracle:thin:@localhost:1521:cclinic]
Mar 30, 2012 3:25:53 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000046: Connection properties: {user=eccuser, password=****}
Mar 30, 2012 3:25:53 PM org.hibernate.engine.jdbc.internal.JdbcServicesImpl configure
WARN: HHH000341: Could not obtain connection metadata : Unsupported feature
Mar 30, 2012 3:25:53 PM org.hibernate.engine.jdbc.internal.LobCreatorBuilder useContextualLobCreation
INFO: HHH000422: Disabling contextual LOB creation as connection was null
Exception in thread "main" java.lang.NullPointerException
        at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:207)
        at org.hibernate.service.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:
75)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java
:159)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:131)
        at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGenerator
Factory.java:147)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.jav
a:197)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java
:156)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:131)
        at org.hibernate.metamodel.source.internal.MetadataImpl.<init>(MetadataImpl.java:122)
        at org.hibernate.metamodel.source.internal.MetadataBuilderImpl.buildMetadata(MetadataBuilderImpl.java:83)
        at org.hibernate.metamodel.MetadataSources.buildMetadata(MetadataSources.java:112)
        at test2.main(test2.java:27)

[Koen Aerts]

Piyush Mangal wrote:

Joe Ess wrote:Thanks, Piyush. I saw that post and tried it both ways. Same error. For the record, Oracle Enterprise Manager Console shows the schema name as all-caps (and I removed the "real" values from the code I posted and the code you quoted).

Try removing default schema property altogether and see if you are able to get rid of this error. Regarding connection URL jdbc:oracle:thin:@localhost:1521:WWWWW.
Are you sure WWWWW is valid SID?

Did you try the following syntax:

jdbc:oracle:thin:@//localhost:1521/WWWWW

[Piyush Mangal]

Please try following code.

   

  import java.util.*;  
    import org.hibernate.Session;  
    import org.hibernate.SessionFactory;  
    import org.hibernate.cfg.Configuration;  
     
    public class test2{  
          
        public static void main(String args[]){  
      
            SessionFactory sessionFactory;    
            Configuration cfg = new Configuration()  
            .setProperty("hibernate.connection.driver_class", "oracle.jdbc.driver.OracleDriver")  
            .setProperty("hibernate.connection.url", "jdbc:oracle:thin:@localhost:1521:WWWWW")  
            .setProperty("hibernate.connection.username", "XXXXX")  
            .setProperty("hibernate.connection.password", "YYYYY")  
            .setProperty("hibernate.dialect", "org.hibernate.dialect.Oracle9iDialect");  
            sessionFactory = cfg.buildSessionFactory();  
            Session session = sessionFactory.openSession();  
      
        }  
    }  

[Joe Ess]

Piyush Mangal wrote:
Try removing default schema property altogether and see if you are able to get rid of this error. Regarding connection URL jdbc:oracle:thin:@localhost:1521:WWWWW.
Are you sure WWWWW is valid SID?

I removed the schema property. Same error. "WWWWW" appears in the tnsnames.ora and that whole connection URL is a copy/paste from a functioning Plain Old JDBC application. I just gave it a try and it works fine:

C:\cc\StandAloneUtility\DBConnector>java DBConnector LOCALHOST
Testing this LOCALHOST connection
DBConnector is preparing to connect to: jdbc:oracle:thin:@localhost:1521:WWWWW user = XXXXX password = YYYYY
Success: Found 476 records

[Piyush Mangal]

Joe Ess wrote:

Piyush Mangal wrote:

I removed the schema property. Same error. "WWWWW" appears in the tnsnames.ora and that whole connection URL is a copy/paste from a functioning Plain Old JDBC application. I just gave it a try and it works fine:

C:\cc\StandAloneUtility\DBConnector>java DBConnector LOCALHOST
Testing this LOCALHOST connection
DBConnector is preparing to connect to: jdbc:oracle:thin:@localhost:1521:WWWWW user = XXXXX password = YYYYY
Success: Found 476 records

Can you post the content of DBConnector ?

[Piyush Mangal]

PS if you look at the log, the application is trying to use cclinic

Mar 30, 2012 1:30:30 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure  
INFO: HHH000401: using driver [oracle.jdbc.driver.OracleDriver] at URL [jdbc:oracle:thin:@localhost:1521:cclinic]  
M

[Joe Ess]

Piyush Mangal wrote:Please try following code.

Same error as before.

[Koen Aerts]

Well you can always download the Hibernate source code and see if you can find anything there: http://sourceforge.net/projects/hibernate/files/hibernate4/

The null pointer issue seems to originate from org.hibernate.engine.jdbc.internal.JdbcServicesImpl on the last line shown below:

@Override
public void configure(Map configValues) {
  final DialectFactory dialectFactory = serviceRegistry.getService( DialectFactory.class );
  . . .
  dialect = dialectFactory.buildDialect( configValues, null );
  . . .
  SQLExceptionConverter sqlExceptionConverter = dialect.buildSQLExceptionConverter();
  . . .
}

So I suspect that "dialect" is a null object; not sure why. I thought it could have been related to something in ServiceRegistryImplementor, which is something new in Hibernate 4: https://community.jboss.org/wiki/HibernateCoreMigrationGuide40

[Saurabh Pillai]

- Try downloading the hibernate jar again, may be this one is corrupted?
- Try different combinations of dialect and hibernate versions to separate the issue.

Not sure if order of property matters, I have dialect,url,usename,passwprd and driver class. I do not have default schema. and I have 10g dialect.

Good luck!

[Vijitha Kumara]

Joe Ess wrote:I tried using a hibernate.hbm.xml file with the same settings...

You meant the cfg.xml file right? I also suggest first try with a sample form your distribution with xml config and see. If you already done so, did it work?

[Ben Fisher]

To close the loop on this, I had to add the following property to hibernate.cfg.xml to get it to work for me:

<property name="hibernate.temp.use_jdbc_metadata_defaults">false</property>

[Steven Lawrence Hunter]

Ben Fisher wrote:To close the loop on this, I had to add the following property to hibernate.cfg.xml to get it to work for me:

<property name="hibernate.temp.use_jdbc_metadata_defaults">false</property>

Thank you! I had the same problem, which the above resolved.

[Bob Carpenter]

Ben Fisher wrote:To close the loop on this, I had to add the following property to hibernate.cfg.xml to get it to work for me:

<property name="hibernate.temp.use_jdbc_metadata_defaults">false</property>

Thanks Ben! This solved my problem too.

I was working fine on Win7/Oracle 10g DB, but when I moved my build over to SunOS using same 10g DB I was getting the error. Googling the first two lines of the exception brought me here.

Adding the new property didn't hurt my Win7 build either.

--Bob