Menu
▾
▴
Re: [Geotools-gt2-users] gt-jdbc-h2
|
From: Justin D. <jde...@op...> - 2009-10-09 14:36:01
|
Hi Andrea,
Sorry for the late reply. The error message is a bit confusing. Any
chance you can share the code being used to make the connection to H2?
-Justin
andrea antonello wrote:
> A small update,
> when using all lowercase schemas and tables and no quotes in queries,
> the connection seems to occurr.
> The problem I get now, is that the password is wrong:
> java.lang.RuntimeException: Unable to obtain connection
>
> thrown because of:
>
> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (Wrong user name or password [8004-118])
> at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
> at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
> at org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1373)
> ...
>
> I am quite sure the user and passwd are right, since I am using the
> default of H2, so the parameters get sa and an empty string for the
> passwd.
>
> My guess is that something else is going on, but I can't figure out
> what. Any idea?
>
> Ciao
> Andrea
>
>
>
> On Wed, Sep 30, 2009 at 9:13 AM, andrea antonello
> <and...@gm...> wrote:
>> Hi Justin,
>> thanks for the reply.
>>
>>> One thing that strikes me as off is:
>>>
>>>> params.put(JDBCDataStoreFactory.NAMESPACE.key, "/home/moovida/TMP/");
>>> If you are trying to specify the location of the file just pout in the
>>> DATABASE key. So:
>>>
>>> params.put(JDBCDataStoreFactory.DATABASE.key, "/home/moovida/TMP/database");
>>>
>>> So what it is doing is creating the db in the current working directory, and
>>> it could be that that db does indeed include the table. I would try cleaning
>>> the .db files and trying again.
>> Yes, at some point I noticed that there was a new database in my workspace :)
>> Anyways, I then made it like you suggest, but I had huge problems with
>> case sensitivity of the schema in which the table was created.
>> I am trying out this thing on turn on H2 and Postgres/GIS, and it
>> doesn't work creating the schema uppercase and then using the same for
>> the table reference, i.e. I need to use the schema name lowercase.
>> Probably this is a known thing, and I just never fell into it because
>> using the public schema?
>>
>> Thanks,
>> Andrea
>>
>>
>>> andrea antonello wrote:
>>>> Hi, I am having troubles creating a h2 connection.
>>>> Can anyone please confirm me that the following is the proper way to go:
>>>>
>>>> Map params = new HashMap();
>>>> params.put(JDBCDataStoreFactory.DBTYPE.key, "h2");
>>>> params.put(JDBCDataStoreFactory.DATABASE.key, "database");
>>>> params.put(JDBCDataStoreFactory.NAMESPACE.key,
>>>> "/home/moovida/TMP/");
>>>> params.put(JDBCDataStoreFactory.PORT.key, port);
>>>> params.put(JDBCDataStoreFactory.HOST.key, host);
>>>> params.put(JDBCDataStoreFactory.USER.key, user);
>>>> params.put(JDBCDataStoreFactory.PASSWD.key, passwd);
>>>>
>>>> spatialDataStore = DataStoreFinder.getDataStore(params);
>>>>
>>>> The problem is that is when I try to create a table with:
>>>>
>>>> SimpleFeatureTypeBuilder b = new SimpleFeatureTypeBuilder();
>>>> b.setName("testgeom");
>>>> b.setCRS(DefaultGeographicCRS.WGS84);
>>>> b.add("the_geom", Point.class);
>>>> b.add("id", Long.class);
>>>> SimpleFeatureType featureType = b.buildFeatureType();
>>>> spatialDataStore.createSchema(featureType);
>>>>
>>>> it complains that:
>>>>
>>>> Caused by: org.h2.jdbc.JdbcSQLException: Table testgeom already
>>>> exists; SQL statement:
>>>> CREATE TABLE "testgeom" ( "fid" int AUTO_INCREMENT(1) PRIMARY KEY,
>>>> "the_geom" BLOB COMMENT 'POINT', "id" BIGINT ) [42101-118]
>>>>
>>>> The table doesn't exist, since the command should create it.
>>>> Any idea about what I am doing wrong?
>>>>
>>>> Thanks,
>>>> Andrea
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> Come build with us! The BlackBerry® Developer Conference in SF, CA
>>>> is the only developer event you need to attend this year. Jumpstart your
>>>> developing skills, take BlackBerry mobile applications to market and stay
>>>> ahead of the curve. Join us from November 9-12, 2009. Register now!
>>>> http://p.sf.net/sfu/devconf
>>>> _______________________________________________
>>>> Geotools-gt2-users mailing list
>>>> Geo...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>>> --
>>> Justin Deoliveira
>>> OpenGeo - http://opengeo.org
>>> Enterprise support for open source geospatial.
>>>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry® Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9-12, 2009. Register now!
> http://p.sf.net/sfu/devconf
> _______________________________________________
> Geotools-gt2-users mailing list
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
|