This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 147797 - When addiding a Postgresql datasource to a hibernate project it is not adding the dialect
Summary: When addiding a Postgresql datasource to a hibernate project it is not adding...
Status: VERIFIED FIXED
Alias: None
Product: javaee
Classification: Unclassified
Component: Hibernate (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker with 1 vote (vote)
Assignee: Vadiraj Deshpande
URL:
Keywords:
Depends on:
Blocks: 140811
  Show dependency tree
 
Reported: 2008-09-21 07:16 UTC by scitronpousty
Modified: 2008-09-26 10:23 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description scitronpousty 2008-09-21 07:16:33 UTC 
When I create a web project with hibernate libraries it does not add the postgresql dialect to the hibernate.cfg.xml
file when I use a postgresql data source. It does not even present me an option to pick that dialect during the create
project wizard. It seems to autodetect the dialect for one of the derby data sources but not for postgresql

Windows XP sp2, Java 6.latestThat is not 10, and netbeans 200809201401
Comment 1 scitronpousty 2008-09-21 08:06:28 UTC 
This may be a blocker for 140811 but I can not be sure. 
I tried this with a MySQL and Derby database and it works fine so this seems to be a postgresql specific issue.
Comment 2 Vadiraj Deshpande 2008-09-21 11:50:46 UTC 
Might be due to missing PostgreSQL dialect in the list of dialects.
Comment 3 Jayashri Visvanathan 2008-09-23 23:50:09 UTC 
This is not a P1. You can always edit the config file and add an entry.
Comment 4 scitronpousty 2008-09-24 00:14:13 UTC 
But I did that and it still didn't work on the reverse engineering tool. It seems like there is something more going on
here. Have you confirmed that Hibernate works if you add it manually?
My understanding is that hibernate is another big push for this release and open source LAMP and LAPP are a major item
as well. This is not working as advertised right now.
Please let me know why this is not a P1.
Comment 5 Jayashri Visvanathan 2008-09-24 00:24:14 UTC 
There is a separate issue 140811 to track Rev. Engg. issue with PostgreSQL. That issue is under investigation.This issue
deals with missing dialect only. Per bug priority guidelines, if there is a work around it is not a P1. This issue has a
work around.

Thanks
Comment 6 scitronpousty 2008-09-24 00:27:58 UTC 
Has someone tested the work around and confirms that it works?
Comment 7 John Baker 2008-09-24 00:30:43 UTC 
Which version of the Postgres driver are you using?

AFAIK, this is the supported version (or later):
http://wiki.netbeans.org/DatabasesAndDrivers#section-DatabasesAndDrivers-PostgreSQLDriverForThePostgreSQLDatabase
Comment 8 scitronpousty 2008-09-24 00:33:32 UTC 
My point is - given that is currently broken and we are proposing a work around. Has anyone actually gone through and
generated a hibernate.cfg.xml through the wizard, added the missing dialect, and insured that it worked. Before you can
say there is a valid workaround you should test to make sure it works.
Comment 9 Jayashri Visvanathan 2008-09-24 00:42:43 UTC 
yes, it should have been tested for officially supported databases/drivers. Our QE engineer can confirm that. As John
pointed out, it will be useful for us to know if you are using the bundled driver or some other version.
Comment 10 scitronpousty 2008-09-24 00:58:24 UTC 
I am using the jdbc4 version that came with PostgreSQL 8.3.3
Comment 11 Vadiraj Deshpande 2008-09-24 09:51:02 UTC 
Fixed the typo in PostgreSQL driver classname.
http://hg.netbeans.org/main/rev/24b7656cbeb1
Comment 12 Martin Fousek 2008-09-26 10:18:06 UTC 
I tested with jdbc4, PostgreSQL 8.3.4 and NetBeans IDE Dev (Build 200809220201) and everything works well.

Verified.
Comment 13 Martin Fousek 2008-09-26 10:23:54 UTC 
Sorry, I copied build number from another NB version. Verified with Build 200809251401.