[Pljava-dev] Re: Meta data in pljava

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.
>

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

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.
>>>
>>
>>
>
>