java - Postgis and Oracle spatial queries with GeometryUserType parameters -

-

following configuration of postgis , oracle spatial different hibernate persistence units , have instances of myclass persisted either postgis or oracle database configured in persistence.xml , mapping file.

i have geom attribute annotated :

public abstract class myclass (...) @type(type = "org.hibernatespatial.geometryusertype")   @column(name = "geom", columndefinition="geometry", nullable = true) protected geometry geom; (...)

persistence.xml configured : 

<persistence-unit name="pers_unit_name" transaction-type="jta">     <provider>org.hibernate.ejb.hibernatepersistence</provider>     <jta-data-source>jta_data_source_name</jta-data-source>     <mapping-file>oracle.hbm.xml</mapping-file>

and in oracle.hbm.xml :

<hibernate-mapping>     <typedef name="org.hibernatespatial.geometryusertype" class="org.hibernatespatial.geometryusertype" >         <param name="dialect">org.hibernatespatial.oracle.oraclespatial10gdialect</param>     </typedef> </hibernate-mapping>

postgis configuration work in similar way.

so when query myclass entities pick right dialect. seems work , pick right dialect attribute when inserting or retrieving info database (simple query.list()).

but when filtering on attribute parameter of type :

string querystring = "select new map(m.id, m.geom)" +       "from  myclass m " +       "where within (r.geom, :geometry) = true "; final org.hibernate.query query = session.createquery(querystring); query.setparameter("geometry", geom, geometryusertype.type); return query.list();

it use hibernate dialect configured default particular parameter instead of specified persistence unit, output stacktrace below.

is there way can force use consistent dialect defined in persistence unit particular parameter field in predicate, instead of whatever configured default?

caused by: java.sql.sqlexception: invalid column type     @ oracle.jdbc.driver.oraclepreparedstatement.setobjectcritical(oraclepreparedstatement.java:8921)     @ oracle.jdbc.driver.oraclepreparedstatement.setobjectinternal(oraclepreparedstatement.java:8396)     @ oracle.jdbc.driver.oraclepreparedstatement.setobjectinternal(oraclepreparedstatement.java:9176)     @ oracle.jdbc.driver.oraclepreparedstatement.setobject(oraclepreparedstatement.java:9153)     @ oracle.jdbc.driver.oraclepreparedstatementwrapper.setobject(oraclepreparedstatementwrapper.java:234)     @ org.apache.tomcat.dbcp.dbcp2.delegatingpreparedstatement.setobject(delegatingpreparedstatement.java:188)     @ org.apache.tomcat.dbcp.dbcp2.delegatingpreparedstatement.setobject(delegatingpreparedstatement.java:188)     @ org.hibernatespatial.abstractdbgeometrytype.nullsafeset(abstractdbgeometrytype.java:154)     @ org.hibernatespatial.geometryusertype.nullsafeset(geometryusertype.java:201)     @ org.hibernate.type.customtype.nullsafeset(customtype.java:146)     @ org.hibernate.param.namedparameterspecification.bind(namedparameterspecification.java:67)     @ org.hibernate.loader.hql.queryloader.bindparametervalues(queryloader.java:578)     @ org.hibernate.loader.loader.preparequerystatement(loader.java:1716)     @ org.hibernate.loader.loader.doquery(loader.java:801)     @ org.hibernate.loader.loader.doqueryandinitializenonlazycollections(loader.java:274)     @ org.hibernate.loader.loader.dolist(loader.java:2542)


Comments

Post a Comment

Popular posts from this blog

javascript - Karma not able to start PhantomJS on Windows - Error: spawn UNKNOWN -

-
i lost "unknown" error: karma.conf.js: frameworks: ['mocha', 'should'], plugins: ['karma-mocha', 'karma-should', 'karma-phantomjs-launcher'], ... browsers: ['phantomjs'], error: 23 07 2015 14:35:37.691:warn [karma]: no captured browser, open http://localhost:9876/ 23 07 2015 14:35:37.701:info [karma]: karma v0.13.3 server started @ http://localhost:9876/ 23 07 2015 14:35:37.707:info [launcher]: starting browser phantomjs 23 07 2015 14:35:37.738:error [karma]: { [error: spawn unknown] code: 'unknown', errno: 'unknown', syscall: 'spawn' } error: spawn unknown @ exports._errnoexception (util.js:749:11) @ childprocess.spawn (child_process.js:1093:11) @ exports.spawn (child_process.js:933:9) @ object._execcommand (c:\users\jinga4x\git\mdl-sample-project\node_modules\karma\lib\launchers\process.js:63:21) @ object._start (c:\users\jinga4x\git\md
Read more

c# - Display ASPX Popup control in RowDeleteing Event (ASPX Gridview) -

-
i have aspxgridview includes new , delete button. delete button includs gv_rowdeleting event. want show aspxpopupcontrol (id="pupconfirm"). want user have confirm password delete item. tried: protected void gv_rowdeleting(object sender, devexpress.web.data.aspxdatadeletingeventargs e) { pupconfirm.showonpageload = true; } but nothing happened. please me. !!! you can create template column javascript prompt confirmation. <itemtemplate> <asp:linkbutton id="btndelete" runat="server" text="delete" commandname="delete" onclientclick="javascript:if(!confirm('are sure want delete record?')){return false;}"> </asp:linkbutton> </itemtemplate>
Read more

Nuget pack csproj using nuspec -

-
i want create nuget package contains specified in nuspec file, still version csproj. in order use token have pack like: nuget pack myproj.csproj but when adds dependencies , creates unwanted folder in nuget package. nuspec file is: <?xml version="1.0" encoding="utf-8"?> <package xmlns="http://schemas.microsoft.com/packaging/2011/08/nuspec.xsd"> <metadata> <id>test</id> <version>$version$</version> <title>test</title> <authors>test</authors> <owners>test</owners> <requirelicenseacceptance>false</requirelicenseacceptance> <description>test</description> <summary>test</summary> <releasenotes>test</releasenotes> <copyright>test</copyright> </metadata> <files> <file src="bin\debug\*.dll" target="lib\net45" /> <file s
Read more