When I use Middlegen to generate the ddl for Postgres, it gave me the errors.

Hibernate version:
Hibernate2.1

Mapping documents:
The mapping documents are generated by sqlserver

Code between sessionFactory.openSession() and session.close():
n/a

Full stack trace of any exception that occurs:
Exception in thread "main" java.lang.NoClassDefFoundError: javax/net/ssl/SSLSocket
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at net.sf.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:55
)
at net.sf.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:83
)
at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:118)
at net.sf.hibernate.tool.hbm2ddl.SchemaExport.main(SchemaExport.java:303)

Name and version of the database you are using:
PostgreSQL7, pg74.213.jdbc3.jar jdbc driver

Debug level Hibernate log excerpt:


Another question, which sql type should be used in postgres for java boolean?

thanx in advance.

Ping

SSLSocket exists in java 1.4.2 - what is your java version ?

I generally map java Booleans to char(1) using a 'Y' or 'N' using the yes_no hibernate mapping type.

I am using java 1.4.2_04

Are You sure ? You have another JVM (maybe)

Are You try postgersql example (postgresql-examples.jar) ?

regards

i see. I do have another JVM 1.3.1 which is from the Oracle client installation. how can I choose which one to use?

What is your OS
If You on linux/unix set PATH with
export PATH=VAS_JDK1.4/bin:$PATH

If You on windows You have environ vaariable in Control Panel

Or delete oracle JVM