Re: [Fwd: Q: database schema from JDBC driver and netbeans.]

Dear Kris,

Thank you for your responding.
I'm sorry that I have not been specific.

> It is not clear what Java/JDBC has to do with your question.
At the current stage, I'm not sure whether JDBC or netbeans has
the root cause. So I'm seeking any comments, for JDBC engineers
may think the possible cause. First, I would like to know if
this is known issue or not.

My main purpose is to create a CMP entity bean on netbeans that
accesses to Postgres table.
Now I'm struggling to create a postgres database schema on netbeans.
To create it, I'm using postgres74.214.jdbc3.jar JDBC driver.

There are several steps to create a CMP bean.
1 create JDBC connection pool
2 create JDBC datasource
3 create JDBC persistent manager
4 create a db schema

I was successful from #1 to #3 steps.
I also done #4 step. But the created database schema didn't have
the primary key information. I'm wondering why.

To create a db schema on netbeans.
. Choose a package on explorer and right-click it.
. Choose 'New' -> 'Database' -> 'Database schema'.
. Name the schema on a pop-up window.
. Speciry driver data, database URL, user, pass.
. Choose the database table to be in the schema.
. Then a db scheam will be created.
(However, it does not have <_primary> attribute.)

The reason I showed the pg_dump is to make sure the table in
postgres has the primary key.

I tried to send the db schema xml file. It showed the created
schema doesn't have <_primary> attribute. However, it was rejected
by mail-server, for the file is regarded as a potentially dangerous
file.
Any comment would be appreciated about this primary key issue.

Thanks and regards,
Ryoji

Kris Jurka wrote:
>
> > Hi,
> >
> > I'm using JDBC driver 'postgres74.214.jdbc3.jar' with Sun Java Studio
> > Enterprise 6 (based on netbeans 3.42).
> > I'm struggling to create a database schema from a postgres
> > table. I can create a database schema from it, but it does not
> > have its primary key.
> > If anyone know this issue or has any solution, please kindly share
> > with me. I attached the database schema created by netbeans.
> >
> > The dump data is here. The table 'postalcode' has a primary key.
> > However, I could not create a database schema with primary key.
> >
>
> It is not clear what Java/JDBC has to do with your question. You've shown
> part of pg_dump output said something about netbeans. Are you having
> problems importing your dump? Are you trying to create constraints with
> JDBC? Are you trying to view constraints with DatabaseMetaData? I have
> no idea what you are asking.
>
> Kris Jurka

--