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

Hi,

Let me respost my email.
I removed the attachment, for I was told that it's potentially dangerous.
Any comment would be appreciated.

Thanks and regards,
Ryoji

-------- Original Message --------
Subject: Q: database schema from JDBC driver and netbeans.
Date: Thu, 05 Aug 2004 18:48:40 +0900
From: "Ryoji Sawa" <Ryoji(dot)Sawa(at)Sun(dot)COM>
Reply-To: Ryoji(dot)Sawa(at)Sun(dot)COM
To: pgsql-jdbc(at)postgresql(dot)org
CC: Ryoji(dot)Sawa(at)Sun(dot)COM

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.

-------- Start ---------
--
-- PostgreSQL database dump
--

SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;

SET SESSION AUTHORIZATION 'postgres';

.. <snip> ..

--
-- TOC entry 7 (OID 17161)
-- Name: postalcode; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE postalcode (
code character varying(7) NOT NULL,
prefecture character varying(10),
city character varying(20),
town character varying(50)
);

.. <snip> ..

--
-- Data for TOC entry 11 (OID 17161)
-- Name: postalcode; Type: TABLE DATA; Schema: public; Owner: postgres
--

--
-- TOC entry 8 (OID 17163)
-- Name: postalcode_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY postalcode
ADD CONSTRAINT postalcode_pkey PRIMARY KEY (code);

.. <snip> ..
-------- End ---------

Thanks and regards,
Ryoji

> 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

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

--