agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] Re: Meta data in pljava
3+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] Re: Meta data in pljava
@ 2005-11-28 13:47
2005-11-28 14:14 ` [Pljava-dev] Re: Meta data in pljava
0 siblings, 1 reply; 3+ messages in thread
From: @ 2005-11-28 13:47 UTC (permalink / raw)
Brice,
The current metadata implementation does not implement table and schema
name correctly. Try using the methods TriggerData.getSchemaName() and
TriggerData.getTableName() instead.
Please post further questions to the pljava-dev at gborg.postgresql.org
mailing-list.
Regards,
Thomas Hallgren
brice rouanet wrote:
> Hi,
>
> i install plajav 1.2 and psql 8.1 to try metadata, and i get not
> result :(
>
> Here my java code :
>
> public class Test1 {
> public static void createFile(TriggerData td) {
> try {
> ResultSet _new = td.getNew();
> ResultSetMetaData rsmd=_new.getMetaData();
> System.out.println("Schema ="+rsmd.getSchemaName(1));
> System.out.println("Table = "+rsmd.getTableName(1));
> String[] args = td.getArguments();
> System.out.println("trigger new : "+_new.getString(args[0]));
> }
> catch (Exception e) {
> e.printStackTrace();
> }
> }
>
> }
>
> and here my psql output :
>
> Schema =
> Table =
> trigger new : Test
>
> Trigger is fire on insert and i use javaU language
>
> Thanks,
> Brice.
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* [Pljava-dev] Re: Meta data in pljava
2005-11-28 13:47 [Pljava-dev] Re: Meta data in pljava
@ 2005-11-28 14:14 `
2005-11-28 15:12 ` [Pljava-dev] Re: Meta data in pljava
0 siblings, 1 reply; 3+ messages in thread
From: @ 2005-11-28 14:14 UTC (permalink / raw)
Thanks,
i try :
td.getSchemaName(); //and getTableName too
and I get :
getSchemaName() not defined to TriggerData type.
an idea ?
Brice.
> Brice,
> The current metadata implementation does not implement table and
> schema name correctly. Try using the methods
> TriggerData.getSchemaName() and TriggerData.getTableName() instead.
>
> Please post further questions to the pljava-dev at gborg.postgresql.org
> mailing-list.
>
> Regards,
> Thomas Hallgren
>
> brice rouanet wrote:
>
>> Hi,
>>
>> i install plajav 1.2 and psql 8.1 to try metadata, and i get not
>> result :(
>>
>> Here my java code :
>>
>> public class Test1 {
>> public static void createFile(TriggerData td) {
>> try {
>> ResultSet _new = td.getNew();
>> ResultSetMetaData rsmd=_new.getMetaData();
>> System.out.println("Schema ="+rsmd.getSchemaName(1));
>> System.out.println("Table = "+rsmd.getTableName(1));
>> String[] args = td.getArguments();
>> System.out.println("trigger new : "+_new.getString(args[0]));
>> }
>> catch (Exception e) {
>> e.printStackTrace();
>> }
>> }
>>
>> }
>>
>> and here my psql output :
>>
>> Schema =
>> Table =
>> trigger new : Test
>>
>> Trigger is fire on insert and i use javaU language
>>
>> Thanks,
>> Brice.
>>
>
>
--
Brice Rouanet
I.N.S.A. Centre de Ressources Informatiques
Complexe Scientifique 135 Avenue de Rangueil
31077 Toulouse Cedex4 (France) tel 0561559374
^ permalink raw reply [nested|flat] 3+ messages in thread
* [Pljava-dev] Re: Meta data in pljava
2005-11-28 13:47 [Pljava-dev] Re: Meta data in pljava
2005-11-28 14:14 ` [Pljava-dev] Re: Meta data in pljava
@ 2005-11-28 15:12 `
0 siblings, 0 replies; 3+ messages in thread
From: @ 2005-11-28 15:12 UTC (permalink / raw)
Brice,
The TriggerData.getSchemaName() was introduced in PL/Java 1.2. I checked
the current pljava downloads and from what I can see, it is indeed
there. Are you sure you're using a 1.2 version?
Regards,
Thomas Hallgren
brice rouanet wrote:
> Thanks,
>
> i try :
>
> td.getSchemaName(); //and getTableName too
>
> and I get :
> getSchemaName() not defined to TriggerData type.
>
> an idea ?
>
> Brice.
>
>> Brice,
>> The current metadata implementation does not implement table and
>> schema name correctly. Try using the methods
>> TriggerData.getSchemaName() and TriggerData.getTableName() instead.
>>
>> Please post further questions to the pljava-dev at gborg.postgresql.org
>> mailing-list.
>>
>> Regards,
>> Thomas Hallgren
>>
>> brice rouanet wrote:
>>
>>> Hi,
>>>
>>> i install plajav 1.2 and psql 8.1 to try metadata, and i get not
>>> result :(
>>>
>>> Here my java code :
>>>
>>> public class Test1 {
>>> public static void createFile(TriggerData td) {
>>> try {
>>> ResultSet _new = td.getNew();
>>> ResultSetMetaData rsmd=_new.getMetaData();
>>> System.out.println("Schema ="+rsmd.getSchemaName(1));
>>> System.out.println("Table = "+rsmd.getTableName(1));
>>> String[] args = td.getArguments();
>>> System.out.println("trigger new : "+_new.getString(args[0]));
>>> }
>>> catch (Exception e) {
>>> e.printStackTrace();
>>> }
>>> }
>>>
>>> }
>>>
>>> and here my psql output :
>>>
>>> Schema =
>>> Table =
>>> trigger new : Test
>>>
>>> Trigger is fire on insert and i use javaU language
>>>
>>> Thanks,
>>> Brice.
>>>
>>
>>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-11-28 15:12 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-28 13:47 [Pljava-dev] Re: Meta data in pljava
2005-11-28 14:14 `
2005-11-28 15:12 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox