Free DBMS that supports DataTypes STRUCT, REF, and DISTINCT

View: New views
3 Messages — Rating Filter:   Alert me  

Free DBMS that supports DataTypes STRUCT, REF, and DISTINCT

by jstrunk :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Is there a free DBMS that supports DataTypes STRUCT, REF, and DISTINCT so I can complete the exercises in the JDBC Tutorial? I have MySQL and Derby and neither one supports them.

Thanks.

Re: Free DBMS that supports DataTypes STRUCT, REF, and DISTINCT

by Rick Hillegas-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

jstrunk wrote:
> Is there a free DBMS that supports DataTypes STRUCT, REF, and DISTINCT so I
> can complete the exercises in the JDBC Tutorial? I have MySQL and Derby and
> neither one supports them.
>
> Thanks.
>  
Postgres supports Array types and Composite types. The latter are
created by a CREATE TYPE statement--I believe that they correspond to
ANSI/ISO structured types, which should mean that they are JDBC STRUCT
types.

Hope this helps,
-Rick

Re: Free DBMS that supports DataTypes STRUCT, REF, and DISTINCT

by jstrunk :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I just spent 5 or 6 hours trying to install PostgreSQL on Windows Vista Business and wasnt able to get it to work. The documentation is pretty Unix oriented and not very logical. It starts out telling you to enter "$ createdb mydb", without telling you what to enter it in, or whether/how to start the server, etc.

I found answers to some of my problems in various forums but they were written by hackers for hackers. I couldnt understand them. Do you know of any procedure for installing PostgreSQL on Vista written for a layman? I am used to getting vague and slightly erroneous procedures to work, but this is beyond my limits.
 

Rick Hillegas-2 wrote:
jstrunk wrote:
> Is there a free DBMS that supports DataTypes STRUCT, REF, and DISTINCT so I
> can complete the exercises in the JDBC Tutorial? I have MySQL and Derby and
> neither one supports them.
>
> Thanks.
>  
Postgres supports Array types and Composite types. The latter are
created by a CREATE TYPE statement--I believe that they correspond to
ANSI/ISO structured types, which should mean that they are JDBC STRUCT
types.

Hope this helps,
-Rick