Re: [orientdb] Re: OrientDB 2 new official drivers: PHP and Python!

2015-05-15 Thread Jonathan Rosen
Hi Joel- I think what you propose for an integer value would work fine. The problem comes when you work with strings. SQL injection follows specific rules (i.e. "; delete from users; --"). Since it usually relies on ending the previous statement, injecting a new statement, and then commenting the r

[orientdb] Re: *-lucene missing for 2.0.1 ?

2015-02-07 Thread Jonathan Rosen
It looks like Luca pushed 2.0 final to the develop branch a couple weeks ago: https://github.com/orientechnologies/orientdb-lucene/commits/develop/pom.xml It does not appear that anyone has updated the lucene plugin for 2.0.1 yet. On Saturday, February 7, 2015 at 4:40:39 AM UTC-5, ste...@activ

Re: [orientdb] Re: OrientDB 2 new official drivers: PHP and Python!

2014-12-30 Thread Jonathan Rosen
> Hi Jonathan, > WDYT about contributing at it? We could "upgrade" the OrientDB Doctrine > module to bind the new PHP driver. > > Any volunteer? > > Lvc@ > > > On 30 December 2014 at 16:31, Jonathan Rosen wrote: > >> Good work guys. You should really take

[orientdb] Re: OrientDB 2 new official drivers: PHP and Python!

2014-12-30 Thread Jonathan Rosen
Good work guys. You should really take a look at incorporating some of the Orientdb helper functions from the Doctrine library: https://github.com/doctrine/orientdb-odm The binary protocol is great, but it would be much more useful if it implemented prepared statements (or a client side equival

Re: [orientdb] Re: Fetchplan query does not return IDs in linked records

2014-11-10 Thread Jonathan Rosen
uot;#-2:1", >> "@version": 0, >> "rid": "#5:0", >> "this": "{\"name\":\"admin\",\"password\":\"{SHA-256} >> 8C6976E5B5410415BDE908BD4DEE15DFB167A9C873FC4BB8A81F6F2AB448 >> A918\",\"

[orientdb] Re: Fetchplan query does not return IDs in linked records

2014-11-03 Thread Jonathan Rosen
select @rid, @this.toJSON('fetchPlan:roles:1') from OUser where name='admin' Does that work for you? On Monday, November 3, 2014 12:40:18 PM UTC-5, Dário Marcelino wrote: > > Hi, > > I've noticed that when I do a query using a fetch plan, the linked records > do not contain their ID. For example

Re: [orientdb] lucene spatial - import 1.7.4 db to 1.7.9 throws error

2014-10-24 Thread Jonathan Rosen
still have the plugin also in OrientDB lib directory? > > > > > > 2014-10-23 23:54 GMT+02:00 Jonathan Rosen : > >> nevermind i can just post it. it is pasted below. it says that the plugin >> definition file (plugin.json) is missing. maybe this is the issue? how do i >

Re: [orientdb] Ant build is failing on the develop branch

2014-10-23 Thread Jonathan Rosen
My ant build is also failing for 2.0. The error I'm getting is: [javac] /Users/xxx/Sites/releases/orientdb/enterprise/src/main/java/com/orientechnologies/orient/enterprise/channel/OChannel.java:84: error: no suitable constructor found for OListenerManger(boolean) Full build output here: jon

Re: [orientdb] lucene spatial - import 1.7.4 db to 1.7.9 throws error

2014-10-23 Thread Jonathan Rosen
[Orient] 2014-10-21 19:17:56:063 INFO OrientDB Server shutdown complete [OServer] On Thursday, October 23, 2014 5:53:18 PM UTC-4, Enrico Risa wrote: > > yes thanks :D > > 2014-10-23 23:45 GMT+02:00 Jonathan Rosen > >: > >> yes. i can email it to you if you want. >>

Re: [orientdb] lucene spatial - import 1.7.4 db to 1.7.9 throws error

2014-10-23 Thread Jonathan Rosen
yes. i can email it to you if you want. On Thu, Oct 23, 2014 at 5:35 PM, Enrico Risa wrote: > Seems strange that doesn't find the lucene plugin in the server. > > Do you have the log of the server? > > > > 2014-10-23 23:26 GMT+02:00 Jonathan Rosen : > >> remot

Re: [orientdb] lucene spatial - import 1.7.4 db to 1.7.9 throws error

2014-10-23 Thread Jonathan Rosen
remote. Should I try local? On Thu, Oct 23, 2014 at 5:21 PM, Enrico Risa wrote: > Hi Jonathan > > do you use remote connection or local for the import? > > > 2014-10-23 22:08 GMT+02:00 Jonathan Rosen : > >> Same result with lucene plugin under libs directory. Are t

Re: [orientdb] lucene spatial - import 1.7.4 db to 1.7.9 throws error

2014-10-23 Thread Jonathan Rosen
under you libs directory of OrientDB > > Enrico > > > > 2014-10-22 4:20 GMT+02:00 Jonathan Rosen > > : > >> Here is an error that is thrown when I try to import the 1.7.4 db that >> has a spatial index to 1.7.9: >> >> - Index &#x

[orientdb] lucene spatial - import 1.7.4 db to 1.7.9 throws error

2014-10-21 Thread Jonathan Rosen
Here is an error that is thrown when I try to import the 1.7.4 db that has a spatial index to 1.7.9: - Index 'stores.latlong'...Error on database import happened just before line 0, column 1582755 com.orientechnologies.orient.core.index.OIndexException: Index type: SPATIAL is not supported. Typ

[orientdb] Question on querying lucene geospatial index by traversing graph

2014-06-11 Thread Jonathan Rosen
Is it possible to query a geospatial index through related nodes with the lucene geospatial plugin? here is an example of what i'm trying to do. Let's say you have a simple database with real estate agents and the houses they have shown over time. The db structure looks like this: Vertices: Age

Re: [orientdb] cannot export database in orientdb community edition 1.7 final: java.lang.NullPointerException

2014-06-04 Thread Jonathan Rosen
gt; Providing a full stack trace will speedup fixing. > > > Best regards, > Artem Orobets > > *Orient Technologies the Company behind OrientDB* > > > 2014-06-04 3:50 GMT+03:00 Jonathan Rosen > > : > >> Here is a very simple database creation script for testi

[orientdb] cannot export database in orientdb community edition 1.7 final: java.lang.NullPointerException

2014-06-03 Thread Jonathan Rosen
Here is a very simple database creation script for testing purposes: --begin creation script --create orientdb database create database remote:localhost/testcreate2 root pass plocal graph; --connect to database connect remote:localhost/testcreate2 admin admin; --create class PRODUCTS as graph ver

Re: [orientdb] FETCHPLAN - How to LINK / LINKSET when pointing to same record ?

2014-05-16 Thread Jonathan Rosen
I would like to second this request. It doesn't make sense to have a graph database, where you want to fetch data 1 or 2 levels deep, and have to recursively parse the json in order to do rid replacement on missing objects. This is broken functionality. In cases of self-referencing objects, the

Re: [orientdb] Re: Remove embeddedset item by reference?

2014-04-18 Thread Jonathan Rosen
solved. Any update on that ? > > > On Monday, March 24, 2014 10:33:56 PM UTC+1, Jonathan Rosen wrote: >> >> let's say i have an embedded set field "people" in record #5:12: >> >> ["bob", "jon"] >> >> this doesnt seem to wor

[orientdb] database inconsistency

2014-03-25 Thread Jonathan Rosen
I put unique indexes in place for specific edge types, so that there could only be one kind of each index. However, it appears that for some reason, the edge sets for a specific set of vertices have been duplicated, which violates the rules of the indexes. If I try to create another duplicate e

Re: [orientdb] Remove embeddedset item by reference?

2014-03-25 Thread Jonathan Rosen
:36:30 AM UTC-4, Lvc@ wrote: > > Hi, > You're right, we missed this simple syntax to remove item from Lists: > > update #5:12 remove 0 <- there 0 is the position. > > Please could you open a new issue for that? > > Lvc@ > > > > > On 24 March 2014

[orientdb] Remove embeddedset item by reference?

2014-03-24 Thread Jonathan Rosen
let's say i have an embedded set field "people" in record #5:12: ["bob", "jon"] this doesnt seem to work: update #5:12 remove people[0] this does work however: update #5:12 remove "bob" is there any way to remove items by reference, as in case #1? -- --- You received this message because yo

[orientdb] Re: [SPOILER ALERT!] OrientDB 1.7-rc2: Walk through the graph

2014-03-03 Thread Jonathan Rosen
This looks cool Luca. It would be great to add some features to the REST API that give finer grained control over navigating the graph. For example, when trying to pull all the edges and vertices connected to a specific vertex, there is a lot of extraneous data (i.e. rids of edges connected to

Re: [orientdb] Get RID projection as a String

2014-02-11 Thread Jonathan Rosen
Luca- This seems to me to be a big problem. If you have a graph, for example people->owns_car->cars. Sam->@rid:13:2, name:Honda Sam->@rid: 13:3, name:Toyota Sam->@rid: 13:4, name:Mercedes Sam = @rid: #12:1 if you run this query: select out_owns_car.in.name as names from #12:1 will return name

Re: [orientdb] null pointer exception after deletion of graph vertices

2014-02-06 Thread Jonathan Rosen
.there needs to be a better way to fix these types of inconsistent state problems. On Thu, Feb 6, 2014 at 3:34 AM, Luca Garulli wrote: > What version are you using? > > Sent from Mobile device > Il 05/feb/2014 22:42 "Jonath

[orientdb] null pointer exception after deletion of graph vertices

2014-02-05 Thread Jonathan Rosen
Here is the error message: Error: com.orientechnologies.orient.enterprise.channel.binary.OResponseProcessingException: Exception during response processing. Error: com.orientechnologies.orient.core.exception.OCommandExecutionException: Error on execution of command: sql.select out_carries

Re: [orientdb] something very wrong with rest api in orientdb 1.6.3 (build 0)

2014-01-04 Thread Jonathan Rosen
'application/json'); On Saturday, January 4, 2014 1:51:48 PM UTC-5, Jonathan Rosen wrote: > > Great, thanks for you help! Now I can upgrade to the latest version. I'll > probably just modify the orientdb-odm curl client until this gets rolled > into the next relea

Re: [orientdb] something very wrong with rest api in orientdb 1.6.3 (build 0)

2014-01-04 Thread Jonathan Rosen
der "Accept: application/json" --data > "insert%20into%20stuff(name)%20VALUES%20(%27testing%27)" > http://localhost:2480/command/GratefulDeadConcerts/sql/ > > > Lvc@ > > > > On 4 January 2014 18:54, Jonathan Rosen wrote: > >> I installe

Re: [orientdb] something very wrong with rest api in orientdb 1.6.3 (build 0)

2014-01-04 Thread Jonathan Rosen
e: > > Hi, > that is a simple insert, so the execution time is supposed to be under > half second even with the slowest computer. How can I reproduce it? > > Lvc@ > > > > On 3 January 2014 22:26, Jonathan Rosen >wrote: > >> When I issue a command to the

[orientdb] something very wrong with rest api in orientdb 1.6.3 (build 0)

2014-01-03 Thread Jonathan Rosen
When I issue a command to the rest api in the latest version of orientdb, it takes an inordinately long time for anything to happen. For example, if I issue this post request: url: http://admin:admin@localhost:2480/command/mydb/sql/ body: insert%20into%20stuff(name)%20VALUES%20(%27testing%27) Th

[orientdb] Re: Released OrientDB 1.6.3 + new web site!

2014-01-03 Thread Jonathan Rosen
I was trying to start up 1.6.3 from the binary download package on my mac, and i was seeing similar issues. I noticed that /config/orientdb-server-config.xml was missing the area for the server root user/pass. That seemed odd to me, and doesn't happen when you build from source. Maybe there are

[orientdb] bulk copy from one class to another

2013-12-27 Thread Jonathan Rosen
how do i bulk copy records from one class to another? -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more op

[orientdb] performance implications of subclasses

2013-12-27 Thread Jonathan Rosen
If I create subclasses, does this impact the query performance of the master class? For example, if I have Sporting Goods, then subclasses tennis rackets, golf clubs, etc, when i "select from sportinggoods", does this impact the overall query performance of querying all the subclasses as well?