[JMUnderwood]

All character data is returned as “(null)” with Aqua Data Studio 4.7.

Integer data returns OK.

Simple example:

Code:
SELECT * FROM Locations

RESULTS:

ADDRESS ADDRESSEE ADDRESS_ONE ADDRESS_TWO ATTENTION CITY COUNTRY FULL_NAME ISINACTIVE LOCATION_ID NAME PARENT_ID PHONE STATE ZIPCODE
———- ———— ————– ————– ———— ——- ———- ———— ————- ————– ——- ———— ——– ——– ———-
(null) (null) (null) (null) (null) (null) (null) (null) (null) 2 (null) 48 (null) (null) (null)
(null) (null) (null) (null) (null) (null) (null) (null) (null) 3 (null) (null) (null) (null) (null)
(null) (null) (null) (null) (null) (null) (null) (null) (null) 4 (null) 3 (null) (null) (null)
(null) (null) (null) (null) (null) (null) (null) (null) (null) 5 (null) 3 (null) (null) (null)
I have talked extensively with the ADS developer and he assures me it must be a problem with the NetSuiteODBC driver. Perhaps it’s not honoring the “GetObject()” ODBC call.

I have made sure I have the latest updates of ADS and of Java. Problem occurs on two different machines, both running WinXP Pro SP2 with latest updates.

Anyone know how to fix this or get around it?

Thanks,

JMU
This is a cached copy. Click here to see the original post.

[Stephan]

RE: Problem Using Aqua Data Studio with ODBC Driver

Weird that it’s just the alpha data, not numeric. Any chance it’s a unicode issue?

-Stephan

[ivan.parra]

RE: Problem Using Aqua Data Studio with ODBC Driver

Aqua Data Studio is apparently not showing unicode characters. The data can been seen within Excel and Crystal, which implies the issue is within the tool in use and not the driver.

[JMUnderwood]

RE: Problem Using Aqua Data Studio with ODBC Driver

Originally posted by ivan.parra

Aqua Data Studio is apparently not showing unicode characters. The data can been seen within Excel and Crystal, which implies the issue is within the tool in use and not the driver.

Ivan, thanks for your help.

I have further discussed this with the lead ADS developer, and he is still quite sure the problem is with full compliance of the NetSuite ODBC driver with the ODBC spec. Here are his comments, and suggestions for resolution:

From: Niels Gron [mailto:nielsgron@aquafold.com]

Sent: August 14, 2006 12:59 PM

To: Jim Underwood

Subject: Re: Problem Report — Aqua Data Studio 4.7 — All Char Data Returned as (null)

Hi Jim,

I do understand the situation you are in. You have two vendors that point the problem to the other. I am not sure the qualifications of the the support staff that you are dealing with at NetSuite. I am the lead developer of Aqua Data Studio. The only person that can resolve this issue is someone who has access to the NetSuite driver and a server. To make this easier for you or for NetSuite I have attached a simple sample Java application which connects to an ODBC datasource and queries for data in a table and then retreives the data through the ResultSet.getObject() and .getString() methods. Either you are NetSuite can easily run this Java application to test the NetSuite ODBC driver.

This will require at least basic Java knowledge, so if you are interacting with someone in support at NetSuite that doesn’t have any development knowledge then you will need to have them escolate the issue. I am not sure of the quality of the support NetSuite provides, but if they limit your support to staff that do not have development knowledge then they may have an issue resolving this problem for you.

>> The data does show correctly within Excel and Crystal, which impies the issue is

>> within the tool in use and not the driver.

This conclusion is not a correct. The NetSuite driver works with applications that access the driver natively. ADS works with other ODBC drivers without a problem. ADS accesses ODBC drivers with the Java JDBC-ODBC bridge. The issue is either with the ODBC driver or a combination of the ODBC driver and the JDBC-ODBC bridge. The JDBC-ODBC bridge is developed by Sun Microsystems. The ODBC driver is developed by NetSuite.

If NetSuite can run the sample application I provided and have it return the correct data then I can make ADS work. If they can’t, then it means that their driver doesn’t work from any Java application.

regards,

-Niels

Niels Gron

nielsgron@aquafold.com

I don’t know anything about Java. Perhaps if you could contact Niels directly the two of you could quicklly resolve the issue.

Many thanks.

JMU

[ivan.parra]

RE: Problem Using Aqua Data Studio with ODBC Driver

Niels is correct. There are multiple components at work here, all of which can be the source of the problem and can be tested individually. Only by testing each source seperately(NS, NS+Sun JDBC/Bridge, NS+Sun JDBC/Bridge+ADS) will the source of this issue be obviated. Each addition can either expose a bug in the previous step or misconception of the API by the additional step. The only way to find it is by testing.

I have contacted Niels directly and asked for his test. I will respond to this post with the results.

[JMUnderwood]

RE: Problem Using Aqua Data Studio with ODBC Driver

Originally posted by ivan.parra

I have contacted Niels directly and asked for his test. I will respond to this post with the results.

Ivan,

Thanks for being proactive, and doing so very quickly.

I look forward to the results of your test.

Best Regards,

JMU

[ivan.parra]

RE: Problem Using Aqua Data Studio with ODBC Driver

Niels and the support team at OpenAccess have agreed on this conclusion, Sun’s ODBC-JDBC bridge is the source of the bug. To make a long story short, the bridge is required to convert ODBC type data to JDBC type data. The bridge is forgetting to convert the unicode string type from ODBC to JDBC. Sun’s code is downloadable and we agreed that Sun is not handling this particular type correctly.

A possible work around can be applied by ADS, but the real problem exists in the bridge.

[JMUnderwood]

RE: Problem Using Aqua Data Studio with ODBC Driver

Originally posted by ivan.parra

Niels and the support team at OpenAccess have agreed on this conclusion, Sun’s ODBC-JDBC bridge is the source of the bug.

Thanks for working with Niels to understand the source problem so quickly.

Is it possible to use the native Oracle driver to access the NetSuite Oracle database? Both ADS and Microsoft provide support for the Oracle driver.

Thanks,

JMU

[mhuffman]

RE: Problem Using Aqua Data Studio with ODBC Driver

Originally posted by JMUnderwood

Thanks for working with Niels to understand the source problem so quickly.

Is it possible to use the native Oracle driver to access the NetSuite Oracle database? Both ADS and Microsoft provide support for the Oracle driver.

Thanks,

JMU

Unfortunately, the native Oracle driver cannot be used. This feature and the data views are designed only for access through the NetSuite ODBC driver and an ODBC-compliant application.

[Author]

Posts