-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
 Post subject: Migrate to PostgreSQl Problem
PostPosted: Wed Apr 16, 2008 5:10 am 
Newbie

Joined: Tue Apr 15, 2008 1:50 am
Posts: 8
Hello all,

My project is currently working fine with MySql through hibernate ,but now i want to mygrate my project to postgresql I change the driversettings and the username and password i am not able to connect and work with postgresql any come across with this please share with me.

Regards,
Venkat


Top
 Profile  
 
 Post subject:
PostPosted: Thu Apr 17, 2008 2:33 am 
Newbie

Joined: Tue Apr 15, 2008 9:18 am
Posts: 3
Hello Venkat,

I'm working with postgresql and hibernate without any problems.

here's my db config
Code:
<hibernate-configuration>
    <session-factory>
        <property name="hibernate.connection.driver_class">org.postgresql.Driver</property>
       
        <!-- DB-Einstellungen für den Produktivbetrieb -->
        <property name="hibernate.connection.url">jdbc:postgresql://127.0.0.1/dbname</property>
        <property name="hibernate.connection.username">username</property>
        <property name="hibernate.connection.password">password</property>


Maybe it is a problem with postgres. The pg_hba.conf is always worth a try. Maybe you missed something in your connection setting and postgres doesn't accept connections from your ip or user.

Yours
Christian


Top
 Profile  
 
 Post subject:
PostPosted: Thu Apr 17, 2008 5:34 am 
Newbie

Joined: Tue Apr 15, 2008 1:50 am
Posts: 8
Hello Christian,

That configuration all correct i want to create the table structure by setting the below property its works fine with MySQl but with postgre sql it try to create table names with prefix"." so table are not created u came acroos with this issue

" <property name="hbm2ddl.auto">create</property>"


-Venkat


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.