Re: [dspace-tech] new table in 6.3

2020-03-18 Thread Mark H. Wood
On Thu, Mar 12, 2020 at 04:45:31PM -0400, Jose Blanco wrote: > I think I see an example: > > @Override > > public ResourcePolicy createResourcePolicy(Context context, > DSpaceObject dso, Group group, EPerson eperson, int type, String rpType) > throws SQLException, AuthorizeException { >

Re: [dspace-tech] new table in 6.3

2020-03-12 Thread Jose Blanco
I think I see an example: @Override public ResourcePolicy createResourcePolicy(Context context, DSpaceObject dso, Group group, EPerson eperson, int type, String rpType) throws SQLException, AuthorizeException { if(group == null && eperson == null) { throw ne

Re: [dspace-tech] new table in 6.3

2020-03-12 Thread Jose Blanco
Mark, I have one question. Can you point me to and example of how a row is inserted into a table. Thanks! Jose On Wed, Feb 26, 2020 at 9:15 AM Mark H. Wood wrote: > On Tue, Feb 25, 2020 at 02:22:01PM -0500, Jose Blanco wrote: > > I just tried: > > > >Query q = getHibernateSession(cont

Re: [dspace-tech] new table in 6.3

2020-02-26 Thread Mark H. Wood
On Tue, Feb 25, 2020 at 02:22:01PM -0500, Jose Blanco wrote: > I just tried: > >Query q = getHibernateSession(context).createSQLQuery("SELECT * FROM > EPerson WHERE uuid in (SELECT proxy_id from proxies where depositor_id = '" > + depositor_id.toString() + "')"); > >q.setResultTr

Re: [dspace-tech] new table in 6.3

2020-02-25 Thread Jose Blanco
pl.java#L170 >> >> I'm sure you could find more examples via Google or StackOverflow as well. >> >> Tim >> >> -- >> *From:* Jose Blanco >> *Sent:* Thursday, February 20, 2020 2:28 PM >> *To:* Tim Donohue >> *Cc:* DSp

Re: [dspace-tech] new table in 6.3

2020-02-24 Thread Jose Blanco
eQuery()" method instead of using >"createQuery()" (as the latter expects a Hibernate Entity). More info on >that is at >https://docs.jboss.org/hibernate/core/4.0/hem/en-US/html/query_native.html > > > Hopefully that helps. > > Tim > > --

Re: [dspace-tech] new table in 6.3

2020-02-20 Thread Tim Donohue
Tim From: Jose Blanco Sent: Thursday, February 20, 2020 2:28 PM To: Tim Donohue Cc: DSpace Technical Support Subject: Re: [dspace-tech] new table in 6.3 Looking for an example. I wonder if someone in the community has done this. I think using createNativeQuery()

Re: [dspace-tech] new table in 6.3

2020-02-20 Thread Jose Blanco
hat is at >https://docs.jboss.org/hibernate/core/4.0/hem/en-US/html/query_native.html > > > Hopefully that helps. > > Tim > > -- > *From:* dspace-tech@googlegroups.com on > behalf of Jose Blanco > *Sent:* Thursday, February 20,

Re: [dspace-tech] new table in 6.3

2020-02-20 Thread Tim Donohue
ve.html Hopefully that helps. Tim From: dspace-tech@googlegroups.com on behalf of Jose Blanco Sent: Thursday, February 20, 2020 10:42 AM To: DSpace Technical Support Subject: [dspace-tech] new table in 6.3 I have a new table in 6.3 - individu

[dspace-tech] new table in 6.3

2020-02-20 Thread Jose Blanco
I have a new table in 6.3 - individual_stats, and I'm seeing this error: org.hibernate.hql.internal.ast.QuerySyntaxException: individual_stats is not mapped [SELECT count(*) FROM individual_stats WHERE email=' blan...@umich.edu'] How do I map indiviual_stats table? Thank you! -Jose -- All mess