Thread: list of sequences

list of sequences

From
Vishnu R
Date:
Hi

Is there any nice way of getting a list of sequences from a db using jdbc?

regards
vishnu


Re: list of sequences

From
Anders Hermansen
Date:
* Vishnu R (Vishnu_R@sifycorp.com) wrote:
> Is there any nice way of getting a list of sequences from a db using jdbc?

Retreive the MetaData with:
connection.getMetaData();

The DatabaseMetaData object has a method getTables, check out the
javadoc:
http://java.sun.com/j2se/1.4.1/docs/api/java/sql/DatabaseMetaData.html

When you set the types parameter to SEQUENCE you will get sequences.


Hope this helps,
Anders

--
Anders Hermansen
YoYo Mobile as


Re: list of sequences

From
Vishnu R
Date:
Thanks a lot Anders.
Another query -  i am sure someone has used this before. I want to try
out replication by creating my own class which implements Statement and
whenever an execute/executeUpdate is called, pass on the sql using TCP
to another application running on a different server which will execute
the sql on the slave DB.
I do understand that this replication using java would not be very good
in terms of performance. But i am not really sure i want to turn on
pgReplicator on my production DB.


Is there anything else i should worry about?

regards
vishnu
Anders Hermansen wrote:

>* Vishnu R (Vishnu_R@sifycorp.com) wrote:
>
>>Is there any nice way of getting a list of sequences from a db using jdbc?
>>
>
>Retreive the MetaData with:
>connection.getMetaData();
>
>The DatabaseMetaData object has a method getTables, check out the
>javadoc:
>http://java.sun.com/j2se/1.4.1/docs/api/java/sql/DatabaseMetaData.html
>
>When you set the types parameter to SEQUENCE you will get sequences.
>
>
>Hope this helps,
>Anders
>
>--
>Anders Hermansen
>YoYo Mobile as
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
>


Re: list of sequences

From
Dave Cramer
Date:
I would think that using a replicator which reads the logs would work
better. How are you going to deal with serialization ? Also you need to
worry about changes made manually in the db?

Regarding the serialization you could have two processes which both
attempt to execute select * from foo from update simultaneously. The
server will serialize these properly, your code may not.

Dave

On Wed, 2003-04-02 at 17:20, Vishnu R wrote:
> Thanks a lot Anders.
> Another query -  i am sure someone has used this before. I want to try
> out replication by creating my own class which implements Statement and
> whenever an execute/executeUpdate is called, pass on the sql using TCP
> to another application running on a different server which will execute
> the sql on the slave DB.
> I do understand that this replication using java would not be very good
> in terms of performance. But i am not really sure i want to turn on
> pgReplicator on my production DB.
>
>
> Is there anything else i should worry about?
>
> regards
> vishnu
> Anders Hermansen wrote:
>
> >* Vishnu R (Vishnu_R@sifycorp.com) wrote:
> >
> >>Is there any nice way of getting a list of sequences from a db using jdbc?
> >>
> >
> >Retreive the MetaData with:
> >connection.getMetaData();
> >
> >The DatabaseMetaData object has a method getTables, check out the
> >javadoc:
> >http://java.sun.com/j2se/1.4.1/docs/api/java/sql/DatabaseMetaData.html
> >
> >When you set the types parameter to SEQUENCE you will get sequences.
> >
> >
> >Hope this helps,
> >Anders
> >
> >--
> >Anders Hermansen
> >YoYo Mobile as
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 3: if posting/reading through Usenet, please send an appropriate
> >subscribe-nomail command to majordomo@postgresql.org so that your
> >message can get through to the mailing list cleanly
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Dave Cramer <Dave@micro-automation.net>