#10914: Thows java.lang.NullPointerException in triggers in Sybase ASE.

nileshhmali reported 2013-11-28T10:01:04Z · last modified 2014-06-20T23:28:49Z

Thows java.lang.NullPointerException in triggers in Sybase ASE.

Dev	ivangron
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	App - Visual Editing
Version	15.0

Operating Environment: Windows 8 (6.2, amd64) / Cp1252 / en / IN / Oracle Corporation 1.7.0_21-b11

Memory: Max=704,643,072; Total=282,984,448; Free=84,279,344; CPUs=8

Database version: Sybase ASE 15.7

ADS version: ADS-windows-x64-15.0.0-dev-37

@Ivan: To reproduce go to Sybase ASE 15.7 at 11.82 and aquafold database, use Schema Script generator and try to script the trigger and you get NPE.

Connect Sybase ASE 15.7

Create trigger

CREATE TRIGGER "dbo"." "

ON "dbo"."test_emp"

FOR INSERT

INSERT INTO "dbo"."test_company"("col1", "col2")

VALUES('Dimentrix', 'Pune')

Go to trigger tree node->Right click on "dbo"." " this trigger->Tools->Select schema script generator->select schema from drop down list->select

database from drop down list->check trigger from object types->check "dbo"." " from objects.->click on next button->Script is not generated.

Now you will observe that thows java.lang.NullPointerException in view log file.

2 attachments

Schema_script.jpg

2013-11-28T10:01:04Z

251 KB
view_log.jpg

2013-11-28T10:01:05Z

87 KB

All Comments (6) Change History

nileshhmali 2013-11-28T10:01:30Z

java.lang.NullPointerException

at \\...\\ .\\हिñçêČάй語简�?한\\.s⡸⠫⢔ꄸ.a(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.Nꄻꉭꄜꇹ.a(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.iꉤꍳꀷꈻ 4.c(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.iꉤꍳꀷꈻ 4.b(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.iꉤꍳꀷꈻ 4.run(Unknown Source)

tariqrahiman 2013-11-29T19:41:44Z

Not able to reproduce in our lab. How are you creating the trigger ? Using the visual editor ? I get Incorrect syntax near the keyword 'on'. when i try to create using the visual editor and using the query window.

nileshhmali 2013-12-02T04:45:27Z · (edited)

Below step are followed on query analyzer window

Step-01

Create table

CREATE TABLE "dbo"."test_employee" (

"E_id" bigint NULL,

"E_name" varchar(25) NULL,

"Address" varchar(25) NULL

)

CREATE TABLE "dbo"."test_project" (

"project_id" bigint NULL,

"p_name" varchar(25) NULL

)

Step-02

Create trigger

CREATE TRIGGER "dbo"." "

ON "dbo"."test_employee"

FOR INSERT

INSERT INTO "dbo"."test_project"("project_id", "p_name")

VALUES(1, 'ADS')

tariqrahiman 2013-12-02T06:31:10Z

This might not be an Aqua Data Studio error. We do not validate on whether user can create database objects with blank names. If the Sybase ASE Server permits to create objects with blank names the Null Pointer Exception would occur due to that fact.

Is it reproducible in any other RDBMS ? SQL Server, Oracle, DB2 etc ?

ranarohitp(*) 2013-12-02T07:08:33Z

Hi Tariq,

Database like SQL Server and Sybase ASE do allow us to create DB objects with blank space.But when we perform operations like extracting script from database in case of sql server we don't get null pointer exceptions where as in case of Sybase ASE we do. It may be the case that when dev is doing extract over database object and if object is coming as null they might not be catching that exception in case of Sybase ASE and is displaying in logs as null pointer exception, so it can be ADS issue as well. Can you please have another look.

ivangron 2014-06-20T23:28:49Z

DO NOT test by creating objects with blank or multiple blank spaces as its name. Database vendors specify that doing these may cause data corruption and they can not guarantee the data integrity. Data studio may or may not be able to handle these objects. If a user wishes to do this data studio may not be the tool for him to use as there would be no way for us to know if the blank string returned to us by the catalog tables is one two three or whatever amount of blank spaces used to create the object as the name is not returned qualified.

Search Tips

Aqua Data Studio / nhilam

Thows java.lang.NullPointerException in triggers in Sybase ASE.

2 attachments

Issue #10914

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Thows java.lang.NullPointerException in triggers in Sybase ASE.

2 attachments

Issue #10914

Completion