You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2015-09-09 23:44:17

mbakerDPS
Member
4 posts

mbakerDPS said:

Converting MSSql Spatial Input to Shapefile

First time posting, and just getting started with Talend - hoping this error can crack open this tool and we can really put it to work in our organization.

My first task was to connect to my MSSQL database and convert a table to shapefile.

Everything looks ok, but when I run the job, I get the following error text:


Starting job download_fromDenverGIS at 16:34 09/09/2015.

[statistics] connecting to socket on port 3736
[statistics] connected
Exception in component sShapefileOutput_1_SO
java.lang.NullPointerException
    at org.geotools.data.shapefile.ShapefileDataStore.createSchema(ShapefileDataStore.java:963)
    at org.geotools.data.shapefile.ShapefileDataStore.createSchema(ShapefileDataStore.java:113)
    at test_project.download_fromdenvergis_0_1.download_fromDenverGIS.tMSSqlInput_1Process(download_fromDenverGIS.java:886)
    at test_project.download_fromdenvergis_0_1.download_fromDenverGIS.runJobInTOS(download_fromDenverGIS.java:1561)
    at test_project.download_fromdenvergis_0_1.download_fromDenverGIS.main(download_fromDenverGIS.java:1418)
[statistics] disconnected
Job download_fromDenverGIS ended at 16:34 09/09/2015. [exit code=1]

There doesn't appear to be any other libraries or dependencies required to run this job, so I'm not sure what this means.

Any thoughts are appreciated, and if you need me to post any more information from the job, please let me know.

Great tool and hoping we can get it working!

Last edited by mbakerDPS (2015-09-10 16:38:33)

Offline

#2 2015-09-10 09:44:19

xdshi
Talend Team


xdshi said:

Re: Converting MSSql Spatial Input to Shapefile

Hi mbakerDPS,

Could you please show us your current job design screenshots which will help us to diagnose your issue?

Best regards
Sabrina


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2015-09-10 10:44:03

Fxp
Member
193 posts

Fxp said:

Re: Converting MSSql Spatial Input to Shapefile

Hi, What may give you a hint is to switch to the code view tab and check what is happening in line download_fromDenverGIS.java:886
It may provide info if it fails due to a schema problem, a geometry column or a projection issue maybe ?
HTH
Francois

Offline

#4 2015-09-10 16:35:25

mbakerDPS
Member
4 posts

mbakerDPS said:

Re: Converting MSSql Spatial Input to Shapefile

Fxp wrote:

Hi, What may give you a hint is to switch to the code view tab and check what is happening in line download_fromDenverGIS.java:886
It may provide info if it fails due to a schema problem, a geometry column or a projection issue maybe ?
HTH
Francois

OK I see that -

Does the MSSql input / output support geometry? That might be the issue...

Offline

#5 2015-09-10 16:37:44

mbakerDPS
Member
4 posts

mbakerDPS said:

Re: Converting MSSql Spatial Input to Shapefile

Side question - does the MSSql Input/Output support geometry?

Offline

#6 2015-09-11 07:33:47

xdshi
Talend Team


xdshi said:

Re: Converting MSSql Spatial Input to Shapefile

Hi,

Here is Geometry object DB type in schema setting of tMySqlXXX components.

Best regards
Sabrina

mini_1.png_20150911-0833.png


What we can do is to make sure that Talend will be your best choice!

Offline

#7 2015-09-11 19:57:59

mbakerDPS
Member
4 posts

mbakerDPS said:

Re: Converting MSSql Spatial Input to Shapefile

Looks like that is the MySQL geometry type, which is great - but here is what I see in the MSSQL type - note I can set the 'Type' to geometry, but there is no option under 'DB Type' (see error after screen capture):

mini_mssql_geometry_talend.png.png
Then the error I get is this:

mini_error_mssql.png.png

...which is weird because I'm not using postgis in this job...

Thank you!

Last edited by mbakerDPS (2015-09-11 20:00:13)

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy