Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL exception when using datasource

 
Ashish Sathaye
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using 2 databases.
One is mysql and c3p0 datasource is created for it in hibernate.properties file. The contents of properties file are pasted below:

hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.username=root
hibernate.connection.password=ENC(7Ba39G6WIPTVKJ1wpe8nSg==)
hibernate.connection.url=jdbc:mysql://localhost:3306/xyz?autoreconnect=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false


Another is oracle and a datasource is created for it in weblogic. Configuration for using this datasource is in separate configuration file abc.configuration.xml file. I am creating a separate session factory using this configuration file when server starts up. The file is like this.

<hibernate-configuration>
<session-factory>
<property name="connection.datasource">ABC0DS</property>
<property name="show_sql">true</property>
<property name="default_schema">SD01</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="jndi.url">t3://localhost:7001</property>
<property name="jndi.class">weblogic.jndi.WLInitialContextFactory</property>
</session-factory>
</hibernate-configuration>

In the process of initializing this session factory hibernate is somehow using user name and password defined in hibernate.properties file and ofcourse the authentication fails. Session factory does not get created.

Can anyone tell me why this may be happening?
 
Shannon McGee
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ashish,

The last time I used Hibernate I discovered that it cannot handle 2 data sources. I don't believe Hibernate has been updated since.

Are you sure you can use 2 data sources?

-Shannon
 
Ashish Sathaye
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Oh yes you can. We have overcome this problem of multiple databases. Indeed you can use as many DB as you want. But i am still wondering why hibernate would use user name and password from one factory into other for authentication. Also it used user name and password for authentication of app server managed datasource. Hence i posted it here.

-Ashish
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic