pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedJDBC -- can't create table
3+ messages / 2 participants
[nested] [flat]
* JDBC -- can't create table
@ 1999-01-18 17:31 Glenn Holmer <gholmer@weycogroup.com>
1999-01-19 20:59 ` Re: [INTERFACES] JDBC -- can't create table Peter T Mount <peter@retep.org.uk>
0 siblings, 1 reply; 3+ messages in thread
From: Glenn Holmer @ 1999-01-18 17:31 UTC (permalink / raw)
To: pgsql-interfaces
I am running Postgres 6.3 on a Linux box (S.u.S.E. 5.3, kernel 2.0.35)
and connecting from another Linux box. Both are running Java 1.1.7
from Blackdown. I can connect to the remote machine and even create a
database, but I am unable to create a table.
I've included the code as an attachment. The exact output is as follows:
--------------------------------------------------------
loading JDBC class "postgresql.Driver"...
connecting to jdbc:postgresql://miranda:5432/factory...
creating skid table...
ERROR: cannot create skids
--------------------------------------------------------
I do wind up with an empty file named "skids" on the server at
/var/lib/pgsql/data/base/factory. I can't understand if this is just
some simple permissions problem or something else I overlooked. Does
anybody see anything obvious? Is there a way to get a more detailed
error message than "cannot create skids"? I created the database by
hand with psql as user "factory" on the server before running this
test code.
--
____________________________________________________________
Glenn Holmer gholmer@weycogroup.com
Programmer/Analyst phone: 414.263.8827
Weyco Group, Inc. fax: 414.263.8808
Attachments:
test.java (application/octet-stream, 1.5K) download
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] JDBC -- can't create table
1999-01-18 17:31 JDBC -- can't create table Glenn Holmer <gholmer@weycogroup.com>
@ 1999-01-19 20:59 ` Peter T Mount <peter@retep.org.uk>
1999-01-19 22:43 ` Re: [INTERFACES] JDBC -- can't create table Glenn Holmer <gholmer@weycogroup.com>
0 siblings, 1 reply; 3+ messages in thread
From: Peter T Mount @ 1999-01-19 20:59 UTC (permalink / raw)
To: Glenn Holmer <gholmer@weycogroup.com>; +Cc: pgsql-interfaces
On Mon, 18 Jan 1999, Glenn Holmer wrote:
> I am running Postgres 6.3 on a Linux box (S.u.S.E. 5.3, kernel 2.0.35)
> and connecting from another Linux box. Both are running Java 1.1.7
> from Blackdown. I can connect to the remote machine and even create a
> database, but I am unable to create a table.
>
> I've included the code as an attachment. The exact output is as follows:
>
> --------------------------------------------------------
>
> loading JDBC class "postgresql.Driver"...
>
> connecting to jdbc:postgresql://miranda:5432/factory...
>
> creating skid table...
> ERROR: cannot create skids
>
> --------------------------------------------------------
>
> I do wind up with an empty file named "skids" on the server at
> /var/lib/pgsql/data/base/factory. I can't understand if this is just
> some simple permissions problem or something else I overlooked. Does
> anybody see anything obvious? Is there a way to get a more detailed
> error message than "cannot create skids"? I created the database by
> hand with psql as user "factory" on the server before running this
> test code.
Can you create the table using psql?
I've just compiled and tested your class, and it runs fine here unaltered.
Peter
--
Peter T Mount peter@retep.org.uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] JDBC -- can't create table
1999-01-18 17:31 JDBC -- can't create table Glenn Holmer <gholmer@weycogroup.com>
1999-01-19 20:59 ` Re: [INTERFACES] JDBC -- can't create table Peter T Mount <peter@retep.org.uk>
@ 1999-01-19 22:43 ` Glenn Holmer <gholmer@weycogroup.com>
0 siblings, 0 replies; 3+ messages in thread
From: Glenn Holmer @ 1999-01-19 22:43 UTC (permalink / raw)
To: pgsql-interfaces
Peter T Mount wrote:
>
> On Mon, 18 Jan 1999, Glenn Holmer wrote:
>
> > --------------------------------------------------------
> >
> > loading JDBC class "postgresql.Driver"...
> >
> > connecting to jdbc:postgresql://miranda:5432/factory...
> >
> > creating skid table...
> > ERROR: cannot create skids
> >
> > --------------------------------------------------------
>
> Can you create the table using psql?
>
> I've just compiled and tested your class, and it runs fine here unaltered.
>
> Peter
>
Sometimes (rarely) it "just works" using psql, most of the time
I get that message. I can't seem to isolate the cause (logged in
as database owner, logged in on the same machine, etc). If it's
not Java (that would be a good thing), which mailing list is most
appropriate for a question like this? I am quite new to Postgres.
The relevant portion of pg_hba.conf looks like this:
local all trust
host all 192.168.6.0 255.255.255.0 trust
host all 127.0.0.1 255.255.255.255 trust
--
____________________________________________________________
Glenn Holmer gholmer@weycogroup.com
Programmer/Analyst phone: 414.263.8827
Weyco Group, Inc. fax: 414.263.8808
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-01-19 22:43 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-01-18 17:31 JDBC -- can't create table Glenn Holmer <gholmer@weycogroup.com>
1999-01-19 20:59 ` Peter T Mount <peter@retep.org.uk>
1999-01-19 22:43 ` Glenn Holmer <gholmer@weycogroup.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox