Hi,
We are using GeoServer 2.0.1 with the SQL Server plugin. When we create a SQL server store with database field populated with the database name, we get an error
Original exception error:
Unable to obtain connection: Cannot create PoolableConnectionFactory (The port number 1433/the-db-name is not valid.)
If i have the database name removed, I am able to go to create a new layer but a list of layers that doesn’t bind with the data in the table (which is expected since I never point to the scheme).
Any clue? We are in the process of setting this up the first time, so never had a working version before. Is this a common problem in SQL or something in SQL settings that need to be corrected.
The test data in the table is geonames data, just want to test out this server but no luck with sql so far.
Best Regards,
Sai
Hi Sai,
So you do get some layers back but not the ones you want? What layers is the server actually returning to you? In a "global" database, some other database, etc...
-Justin
On 1/24/10 9:08 PM, Chow, Sai wrote:
Hi,
We are using GeoServer 2.0.1 with the SQL Server plugin. When we create
a SQL server store with database field populated with the database name,
we get an error
Original exception error:
Unable to obtain connection: Cannot create PoolableConnectionFactory
(The port number 1433/the-db-name is not valid.)
If i have the database name removed, I am able to go to create a new
layer but a list of layers that doesn't bind with the data in the table
(which is expected since I never point to the scheme).
Any clue? We are in the process of setting this up the first time, so
never had a working version before. Is this a common problem in SQL or
something in SQL settings that need to be corrected.
The test data in the table is geonames data, just want to test out this
server but no luck with sql so far.
Best Regards,
Sai
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
Justin,
When I remove the database and scheme field from the data store properties, I have the following layers:
spt_fallback_db
spt_fallback_dev
spt_fallback_usg
spt_monitor
spt_values
I guess they are from the global database? The problem is that, when I put in the "database" property in the database store, I get an error of invalid port number, could this be a bug of some sort since the exception is thrown before an actual connection is established.
Thanks,
Sai
On Jan 25, 2010, at 9:03 AM, Justin Deoliveira wrote:
Hi Sai,
So you do get some layers back but not the ones you want? What layers is
the server actually returning to you? In a "global" database, some other
database, etc...
-Justin
On 1/24/10 9:08 PM, Chow, Sai wrote:
Hi,
We are using GeoServer 2.0.1 with the SQL Server plugin. When we create
a SQL server store with database field populated with the database name,
we get an error
Original exception error:
Unable to obtain connection: Cannot create PoolableConnectionFactory
(The port number 1433/the-db-name is not valid.)
If i have the database name removed, I am able to go to create a new
layer but a list of layers that doesn't bind with the data in the table
(which is expected since I never point to the scheme).
Any clue? We are in the process of setting this up the first time, so
never had a working version before. Is this a common problem in SQL or
something in SQL settings that need to be corrected.
The test data in the table is geonames data, just want to test out this
server but no luck with sql so far.
Best Regards,
Sai
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Hi Sai,
Are these tables in any way "connected" to the user you are logging in as?
Anyways, people have got this to work before so I know it is possible to load the desired tables. However not being able to specifying the database and schema directly is an issue that has been outstanding for quite some time. I will try to look deeper into how exactly the jdbc driver is connecting to the database to see if i can make the connection process a little easier.
-Justin
On 1/25/10 10:47 AM, Chow, Sai wrote:
Justin,
When I remove the database and scheme field from the data store properties, I have the following layers:
spt_fallback_db
spt_fallback_dev
spt_fallback_usg
spt_monitor
spt_values
I guess they are from the global database? The problem is that, when I put in the "database" property in the database store, I get an error of invalid port number, could this be a bug of some sort since the exception is thrown before an actual connection is established.
Thanks,
Sai
On Jan 25, 2010, at 9:03 AM, Justin Deoliveira wrote:
Hi Sai,
So you do get some layers back but not the ones you want? What layers is
the server actually returning to you? In a "global" database, some other
database, etc...
-Justin
On 1/24/10 9:08 PM, Chow, Sai wrote:
Hi,
We are using GeoServer 2.0.1 with the SQL Server plugin. When we create
a SQL server store with database field populated with the database name,
we get an error
Original exception error:
Unable to obtain connection: Cannot create PoolableConnectionFactory
(The port number 1433/the-db-name is not valid.)
If i have the database name removed, I am able to go to create a new
layer but a list of layers that doesn't bind with the data in the table
(which is expected since I never point to the scheme).
Any clue? We are in the process of setting this up the first time, so
never had a working version before. Is this a common problem in SQL or
something in SQL settings that need to be corrected.
The test data in the table is geonames data, just want to test out this
server but no luck with sql so far.
Best Regards,
Sai
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
Justin,
Not that I know of. This user have access to two different databases on the same host. Only one database have one table that contains some geonames US import for testing purposes. It seem that no matter what database name I put in, it thrown an exception of invalid port number "1433/whatever-db-name". It almost sounds like the connection string format might be invalid? I'm using SQL 2008 with the JDBC 2.0 driver. sqljdbc4.jar in my web-inf/lib, removed all other sqljdbc.jar files. So I believe I'm using the correct driver. When I use the sqljdbc.jar library, it complains and tell me to use the newer version.
So to get around this, do I have to have the user name only assign to one database and one table?
Thanks a lot for looking into this.
Sai
On Jan 25, 2010, at 4:00 PM, Justin Deoliveira wrote:
Hi Sai,
Are these tables in any way "connected" to the user you are logging in as?
Anyways, people have got this to work before so I know it is possible to
load the desired tables. However not being able to specifying the
database and schema directly is an issue that has been outstanding for
quite some time. I will try to look deeper into how exactly the jdbc
driver is connecting to the database to see if i can make the connection
process a little easier.
-Justin
On 1/25/10 10:47 AM, Chow, Sai wrote:
Justin,
When I remove the database and scheme field from the data store properties, I have the following layers:
spt_fallback_db
spt_fallback_dev
spt_fallback_usg
spt_monitor
spt_values
I guess they are from the global database? The problem is that, when I put in the "database" property in the database store, I get an error of invalid port number, could this be a bug of some sort since the exception is thrown before an actual connection is established.
Thanks,
Sai
On Jan 25, 2010, at 9:03 AM, Justin Deoliveira wrote:
Hi Sai,
So you do get some layers back but not the ones you want? What layers is
the server actually returning to you? In a "global" database, some other
database, etc...
-Justin
On 1/24/10 9:08 PM, Chow, Sai wrote:
Hi,
We are using GeoServer 2.0.1 with the SQL Server plugin. When we create
a SQL server store with database field populated with the database name,
we get an error
Original exception error:
Unable to obtain connection: Cannot create PoolableConnectionFactory
(The port number 1433/the-db-name is not valid.)
If i have the database name removed, I am able to go to create a new
layer but a list of layers that doesn't bind with the data in the table
(which is expected since I never point to the scheme).
Any clue? We are in the process of setting this up the first time, so
never had a working version before. Is this a common problem in SQL or
something in SQL settings that need to be corrected.
The test data in the table is geonames data, just want to test out this
server but no luck with sql so far.
Best Regards,
Sai
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
Hi Sai,
I just found this topic related to connection string:
http://old.nabble.com/Connection-to-SQL-Server-2008-Spatial-ts20723119.html#a20773501
best regards
Sarah
schow wrote:
It seem that no matter what database name I put in, it thrown an
exception of invalid port number "1433/whatever-db-name". It almost
sounds like the connection string format might be invalid?
So to get around this, do I have to have the user name only assign to one
database and one table?
On Jan 25, 2010, at 4:00 PM, Justin Deoliveira wrote:
Hi Sai,
Are these tables in any way "connected" to the user you are logging in
as?
Anyways, people have got this to work before so I know it is possible to
load the desired tables. However not being able to specifying the
database and schema directly is an issue that has been outstanding for
quite some time. I will try to look deeper into how exactly the jdbc
driver is connecting to the database to see if i can make the connection
process a little easier.
-Justin
On 1/25/10 10:47 AM, Chow, Sai wrote:
Justin,
When I remove the database and scheme field from the data store
properties, I have the following layers:
spt_fallback_db
spt_fallback_dev
spt_fallback_usg
spt_monitor
spt_values
I guess they are from the global database? The problem is that, when I
put in the "database" property in the database store, I get an error of
invalid port number, could this be a bug of some sort since the
exception is thrown before an actual connection is established.
Thanks,
Sai
On Jan 25, 2010, at 9:03 AM, Justin Deoliveira wrote:
Hi Sai,
So you do get some layers back but not the ones you want? What layers
is
the server actually returning to you? In a "global" database, some
other
database, etc...
-Justin
On 1/24/10 9:08 PM, Chow, Sai wrote:
Hi,
We are using GeoServer 2.0.1 with the SQL Server plugin. When we
create
a SQL server store with database field populated with the database
name,
we get an error
Original exception error:
Unable to obtain connection: Cannot create PoolableConnectionFactory
(The port number 1433/the-db-name is not valid.)
If i have the database name removed, I am able to go to create a new
layer but a list of layers that doesn't bind with the data in the
table
(which is expected since I never point to the scheme).
Any clue? We are in the process of setting this up the first time, so
never had a working version before. Is this a common problem in SQL or
something in SQL settings that need to be corrected.
The test data in the table is geonames data, just want to test out
this
server but no luck with sql so far.
Best Regards,
Sai
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts
the
world's best and brightest in the field, creating opportunities for
Conference
attendees to learn about information security's most important issues
through
interactions with peers, luminaries and emerging and established
companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts
the
world's best and brightest in the field, creating opportunities for
Conference
attendees to learn about information security's most important issues
through
interactions with peers, luminaries and emerging and established
companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the
business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
View this message in context: http://old.nabble.com/SQL-Server-Store-creation-problem-tp27301377p27320715.html
Sent from the GeoServer - User mailing list archive at Nabble.com.