OK It's using the correct driver now but times out trying to connect,
Torben can you check I've got the password etc correct.
Cheers
Ian
Running org.geotools.data.sqlserver.SQLServer3DOnlineTest
Skipping sqlserver tests, resources not available:
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Network error IOException: Connection timed
out)
java.lang.RuntimeException:
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Network error IOException: Connection timed
out)
at org.geotools.jdbc.JDBCTestSupport.isOnline(JDBCTestSupport.java:106)
at
org.geotools.test.OnlineTestCase.checkAvailable(OnlineTestCase.java:144)
at org.geotools.test.OnlineTestCase.run(OnlineTestCase.java:122)
at junit.framework.TestSuite.runTest(TestSuite.java:255)
at junit.framework.TestSuite.run(TestSuite.java:250)
at
org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:84)
at
org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:264)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153)
at
org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:124)
at
org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
at
org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
at
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Network error IOException: Connection timed
out)
at
org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at
org.geotools.data.jdbc.datasource.AbstractManageableDataSource.getConnection(AbstractManageableDataSource.java:48)
at org.geotools.jdbc.JDBCTestSupport.isOnline(JDBCTestSupport.java:101)
... 11 more
Caused by: java.sql.SQLException: Network error IOException:
Connection timed out
at
net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:436)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at
org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 15 more
Caused by: java.net.ConnectException: Connection timed out
at java.net.PlainSocketImpl.socketConnect(Native Method)
at
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at
net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:288)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:251)
at
net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:331)
On Thu, Mar 26, 2015 at 12:57 PM Ian Turton <ijtur...@gmail.com> wrote:
> It seems I do have creds for that :-) I've made the change and kicked off
> a test build
>
>
> Ian
>
> On Thu, Mar 26, 2015 at 11:54 AM Andrea Aime <andrea.a...@geo-solutions.it>
> wrote:
>
>> Hi Ian,
>> it's here in the shell script: http://ares.boundlessgeo.com/
>> jenkins/view/geotools/job/geotools-master-online/configure
>>
>> Do you have the credentials to access the server?
>>
>> Cheers
>> Andrea
>>
>> On Thu, Mar 26, 2015 at 12:46 PM, Ian Turton <ijtur...@gmail.com> wrote:
>>
>>>
>>>
>>> On Wed, Mar 25, 2015 at 6:26 PM Torben Barsballe <
>>> tbarsba...@boundlessgeo.com> wrote:
>>>
>>>> On Wed, Mar 25, 2015 at 11:09 AM, Ian Turton <ijtur...@gmail.com>
>>>> wrote:
>>>>
>>>>> SQL Server on master should be able to pull it's driver via maven by
>>>>> default.
>>>>>
>>>>> Interesting. Right now we are getting:
>>>>
>>>> org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class
>>>> 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
>>>>
>>>> Could this be the wrong class name? If so, the code that generates the
>>>> example fixtures is wrong. Otherwise, I don't know what could be the issue
>>>> here.
>>>>
>>>>
>>> My fixture file looks like:
>>>
>>> #This is an example fixture. Update the values and remove the .example
>>> suffix to enable the test
>>> #Fri May 16 13:57:50 BST 2014
>>> #SQL Server MS Driver
>>> ; user=geotools
>>> ; #port=1433
>>> ; password=geotools
>>> ; url=jdbc\:sqlserver\://SHEIK\\MS2008R2;DatabaseName=geotools
>>> ; #url=jdbc\:sqlserver\://SHEIK:1433;DatabaseName=geotools
>>> ; host=SHEIK
>>> ; instance=MS2008R2
>>> ; database=geotools
>>> ; driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
>>> ; schema=dbo
>>> ; dbtype=sqlserver
>>>
>>> #JTDS
>>> user=geotools
>>> #port=1433
>>> password=geotools
>>> #url=jdbc\:sqlserver\://SHEIK:1433;DatabaseName=geotools
>>> url=jdbc:jtds:sqlserver://SHEIK;instance=MS2008R2;DatabaseName=geotools
>>> host=SHEIK
>>> instance=MS2008R2
>>> database=geotools
>>> driver=net.sourceforge.jtds.jdbc.Driver
>>> ;schema=geotools
>>> dbtype=jtds-sqlserver
>>>
>>>
>>> You need either the instance or port line and the url changes
>>> accordingly.
>>>
>>> If you point me to where the fixture is generated I'll have a go at
>>> changing it if you'd like.
>>>
>>> Ian
>>>
>>>> Torben
>>>>
>>>>
>>> ------------------------------------------------------------
>>> ------------------
>>> Dive into the World of Parallel Programming The Go Parallel Website,
>>> sponsored
>>> by Intel and developed in partnership with Slashdot Media, is your hub
>>> for all
>>> things parallel software development, from weekly thought leadership
>>> blogs to
>>> news, videos, case studies, tutorials and more. Take a look and join the
>>> conversation now. http://goparallel.sourceforge.net/
>>> _______________________________________________
>>> GeoTools-Devel mailing list
>>> GeoTools-Devel@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/geotools-devel
>>>
>>>
>> --
>> ==
>> GeoServer Professional Services from the experts! Visit
>> http://goo.gl/NWWaa2 for more information.
>> ==
>>
>> Ing. Andrea Aime
>> @geowolf
>> Technical Lead
>>
>> GeoSolutions S.A.S.
>> Via Poggio alle Viti 1187
>> 55054 Massarosa (LU)
>> Italy
>> phone: +39 0584 962313
>> fax: +39 0584 1660272
>> mob: +39 339 8844549
>>
>> http://www.geo-solutions.it
>> http://twitter.com/geosolutions_it
>>
>> *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*
>>
>> Le informazioni contenute in questo messaggio di posta elettronica e/o
>> nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
>> loro utilizzo è consentito esclusivamente al destinatario del messaggio,
>> per le finalità indicate nel messaggio stesso. Qualora riceviate questo
>> messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
>> darcene notizia via e-mail e di procedere alla distruzione del messaggio
>> stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
>> divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
>> utilizzarlo per finalità diverse, costituisce comportamento contrario ai
>> principi dettati dal D.Lgs. 196/2003.
>>
>>
>>
>> The information in this message and/or attachments, is intended solely
>> for the attention and use of the named addressee(s) and may be confidential
>> or proprietary in nature or covered by the provisions of privacy act
>> (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
>> Code).Any use not in accord with its purpose, any disclosure, reproduction,
>> copying, distribution, or either dissemination, either whole or partial, is
>> strictly forbidden except previous formal approval of the named
>> addressee(s). If you are not the intended recipient, please contact
>> immediately the sender by telephone, fax or e-mail and delete the
>> information in this message that has been received in error. The sender
>> does not give any warranty or accept liability as the content, accuracy or
>> completeness of sent messages and accepts no responsibility for changes
>> made after they were sent or for other risks which arise as a result of
>> e-mail transmission, viruses, etc.
>>
>> -------------------------------------------------------
>>
>
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
