subject:"Re\: \[dspace\-tech\] new table in 6.3"

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 {
> 
> if(group == null && eperson == null)
> 
> {
> 
> throw new IllegalArgumentException("We need at least an eperson
> or a group in order to create a resource policy.");
> 
> }
> 
> 
> ResourcePolicy myPolicy = resourcePolicyService.create(context);
> 
> myPolicy.setdSpaceObject(dso);
> 
> myPolicy.setAction(type);
> 
> myPolicy.setGroup(group);
> 
> myPolicy.setEPerson(eperson);
> 
> myPolicy.setRpType(rpType);
> 
> resourcePolicyService.update(context, myPolicy);
> 
> 
> return myPolicy;
> 
> }

I think that you are correct.  xxxService.create() instantiates the
entity.  You set values for its fields.  Then xxxService.update()
saves the instance.

This is all just doing things in Hibernate's cache, which keeps some
entity instances handy and keeps track of whether they have been
altered.  Behind the scenes, Hibernate's cache manager fills these
instances from database rows and uses mutated values to update
database rows.  But often you can think of it as:  .create() INSERTs
an empty row, .find() SELECTs a row, and .update UPDATEs a row.

-- 
Mark H. Wood
Lead Technology Analyst

University Library
Indiana University - Purdue University Indianapolis
755 W. Michigan Street
Indianapolis, IN 46202
317-274-0749
www.ulib.iupui.edu

-- 
All messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: https://duraspace.org/about/policies/code-of-conduct/
--- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/20200318185444.GD3874%40IUPUI.Edu.

signature.asc
Description: PGP signature

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 new IllegalArgumentException("We need at least an eperson
or a group in order to create a resource policy.");

}


ResourcePolicy myPolicy = resourcePolicyService.create(context);

myPolicy.setdSpaceObject(dso);

myPolicy.setAction(type);

myPolicy.setGroup(group);

myPolicy.setEPerson(eperson);

myPolicy.setRpType(rpType);

resourcePolicyService.update(context, myPolicy);


return myPolicy;

}

On Thu, Mar 12, 2020 at 4:39 PM Jose Blanco  wrote:

> 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(context).createSQLQuery("SELECT *
>> FROM
>> > EPerson  WHERE uuid in (SELECT proxy_id from proxies where depositor_id
>> = '"
>> > + depositor_id.toString() + "')");
>> >
>> >q.setResultTransformer(Transformers.aliasToBean(EPerson.class));
>> >
>> >List results = q.list();
>> >
>> >return results;
>> >
>> >
>> >
>> > And I'm getting:
>> >
>> >
>> > org.hibernate.MappingException: No Dialect mapping for JDBC type: 
>> >
>> >
>> > in this line:
>> >
>> >List results = q.list();
>>
>> I haven't dealt with this myself, but the first thing I would check is
>> whether Hibernate understands that proxies.proxy_id is of type UUID.
>>
>> I would guess that you'll continue to fight issues like this so long
>> as "proxies" is not associated with an ORM entity type.  That would
>> mean writing an entity class 'Proxies' to tell Hibernate all about
>> your table.  You can find examples in
>> 'dspace-api/src/main/java/org/dspace/content'.  To fit in with the
>> patterns of DSpace's object-relational mapping, you probably should
>> also write:
>>
>>   ProxiesDAO
>>   ProxiesDAOImpl
>>   ProxiesService
>>   ProxiesServiceImpl
>>
>> You'll also need to add a  element to
>> dspace/config/hibernate.cfg.xml so that Hibernate knows that it should
>> expect to find your entity class.
>>
>> Yes, I know:  it looks like more frosting than cake.  But, if you use
>> Hibernate, then Hibernate needs a lot of information about what it is
>> to manipulate for you.  And, it will be easier to use other types as
>> examples if you follow the complete pattern.
>>
>> --
>> Mark H. Wood
>> Lead Technology Analyst
>>
>> University Library
>> Indiana University - Purdue University Indianapolis
>> 755 W. Michigan Street
>> Indianapolis, IN 46202
>> 317-274-0749
>> www.ulib.iupui.edu
>>
>> --
>> All messages to this mailing list should adhere to the DuraSpace Code of
>> Conduct: https://duraspace.org/about/policies/code-of-conduct/
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "DSpace Technical Support" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to dspace-tech+unsubscr...@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/dspace-tech/20200226141439.GB8836%40IUPUI.Edu
>> .
>>
>

-- 
All messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: https://duraspace.org/about/policies/code-of-conduct/
--- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/CAK%3DKc-sOqGXWE-9GDuX0HeVh42BeCCqCaghwOMBu533RXSd7DA%40mail.gmail.com.

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(context).createSQLQuery("SELECT *
> FROM
> > EPerson  WHERE uuid in (SELECT proxy_id from proxies where depositor_id
> = '"
> > + depositor_id.toString() + "')");
> >
> >q.setResultTransformer(Transformers.aliasToBean(EPerson.class));
> >
> >List results = q.list();
> >
> >return results;
> >
> >
> >
> > And I'm getting:
> >
> >
> > org.hibernate.MappingException: No Dialect mapping for JDBC type: 
> >
> >
> > in this line:
> >
> >List results = q.list();
>
> I haven't dealt with this myself, but the first thing I would check is
> whether Hibernate understands that proxies.proxy_id is of type UUID.
>
> I would guess that you'll continue to fight issues like this so long
> as "proxies" is not associated with an ORM entity type.  That would
> mean writing an entity class 'Proxies' to tell Hibernate all about
> your table.  You can find examples in
> 'dspace-api/src/main/java/org/dspace/content'.  To fit in with the
> patterns of DSpace's object-relational mapping, you probably should
> also write:
>
>   ProxiesDAO
>   ProxiesDAOImpl
>   ProxiesService
>   ProxiesServiceImpl
>
> You'll also need to add a  element to
> dspace/config/hibernate.cfg.xml so that Hibernate knows that it should
> expect to find your entity class.
>
> Yes, I know:  it looks like more frosting than cake.  But, if you use
> Hibernate, then Hibernate needs a lot of information about what it is
> to manipulate for you.  And, it will be easier to use other types as
> examples if you follow the complete pattern.
>
> --
> Mark H. Wood
> Lead Technology Analyst
>
> University Library
> Indiana University - Purdue University Indianapolis
> 755 W. Michigan Street
> Indianapolis, IN 46202
> 317-274-0749
> www.ulib.iupui.edu
>
> --
> All messages to this mailing list should adhere to the DuraSpace Code of
> Conduct: https://duraspace.org/about/policies/code-of-conduct/
> ---
> You received this message because you are subscribed to the Google Groups
> "DSpace Technical Support" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dspace-tech+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/dspace-tech/20200226141439.GB8836%40IUPUI.Edu
> .
>

-- 
All messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: https://duraspace.org/about/policies/code-of-conduct/
--- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/CAK%3DKc-sianA3513_sS_b1p6NKedLk4uF1eJrQOvE6rjMa9tjVA%40mail.gmail.com.

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.setResultTransformer(Transformers.aliasToBean(EPerson.class));
> 
>List results = q.list();
> 
>return results;
> 
> 
> 
> And I'm getting:
> 
> 
> org.hibernate.MappingException: No Dialect mapping for JDBC type: 
> 
> 
> in this line:
> 
>List results = q.list();

I haven't dealt with this myself, but the first thing I would check is
whether Hibernate understands that proxies.proxy_id is of type UUID.

I would guess that you'll continue to fight issues like this so long
as "proxies" is not associated with an ORM entity type.  That would
mean writing an entity class 'Proxies' to tell Hibernate all about
your table.  You can find examples in
'dspace-api/src/main/java/org/dspace/content'.  To fit in with the
patterns of DSpace's object-relational mapping, you probably should
also write:

  ProxiesDAO
  ProxiesDAOImpl
  ProxiesService
  ProxiesServiceImpl

You'll also need to add a  element to
dspace/config/hibernate.cfg.xml so that Hibernate knows that it should
expect to find your entity class.

Yes, I know:  it looks like more frosting than cake.  But, if you use
Hibernate, then Hibernate needs a lot of information about what it is
to manipulate for you.  And, it will be easier to use other types as
examples if you follow the complete pattern.

-- 
Mark H. Wood
Lead Technology Analyst

University Library
Indiana University - Purdue University Indianapolis
755 W. Michigan Street
Indianapolis, IN 46202
317-274-0749
www.ulib.iupui.edu

-- 
All messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: https://duraspace.org/about/policies/code-of-conduct/
--- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/20200226141439.GB8836%40IUPUI.Edu.

signature.asc
Description: PGP signature

Re: [dspace-tech] new table in 6.3

2020-02-25 Thread Jose Blanco

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.setResultTransformer(Transformers.aliasToBean(EPerson.class));

   List results = q.list();

   return results;



And I'm getting:


org.hibernate.MappingException: No Dialect mapping for JDBC type: 


in this line:

   List results = q.list();



On Mon, Feb 24, 2020 at 5:26 PM Jose Blanco  wrote:

> Kind of stuck trying to create a query without having to map it.  This is
> what I have:
>
> @Override
>
> public List findProxiesForDepositor(Context context, UUID
> depositor_id) throws SQLException {
>
>
>
> Query query = getHibernateSession(context).createSQLQuery("SELECT
> * FROM EPerson WHERE uuid in (SELECT proxy_id from proxies where
> depositor_id =:depositor_id)");
>
> query.addEntity(EPerson.class);
>
> query.setParameter("depositor_id", depositor_id);
>
>
> List epersons = query.list();
>
>
> return epersons;
>
>
> }
>
>
> It's telling me that :
>
>
> [ERROR] EPersonDAOImpl.java:[187,14] cannot find symbol
>
> [ERROR] symbol:   method
> addEntity(java.lang.Class)
>
> [ERROR] location: variable query of type org.hibernate.Query
>
>
> I found something on the web that suggested I could do it this way.
>
>
> If someone could correct this query, that would really help me because I
> have others like it.
>
>
> Thank you!
>
> -Jose
>
>
>
> On Thu, Feb 20, 2020 at 4:01 PM Tim Donohue 
> wrote:
>
>> Hi Jose,
>>
>> There is one example of createNativeQuery() in the DSpace codebase itself
>> here:
>>
>>
>> https://github.com/DSpace/DSpace/blob/master/dspace-api/src/main/java/org/dspace/eperson/dao/impl/GroupDAOImpl.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:* 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() would be preferable.  I have 4
>> tables that are not part of the dspace code that I need to manipulate.
>>
>> Thanks!
>> -Jose
>>
>> On Thu, Feb 20, 2020 at 1:01 PM Tim Donohue 
>> wrote:
>>
>> Hi Jose,
>>
>> That error from Hibernate usually means that you are trying to run a
>> straight SQL query when it's expecting you to use HQL (Hibernate Query
>> Language) and a Hibernate Entity object.  So, more than likely you need to
>> do one of the following:
>>
>>
>>- Either, Create a Hibernate Entity class that maps to this Table.
>>See
>>
>> https://docs.jboss.org/hibernate/annotations/3.5/reference/en/html/entity.html
>>  This
>>is how DSpace 6.x (and above) already maps to existing tables...you'll see
>>an Entity object corresponding to every table in the codebase.
>>- Or, you might be able to tell Hibernate this is just a plain old
>>SQL query by using Hibernate's "createNativeQuery()" 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
>>
>> --
>> *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 - 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 messages to this mailing list should adhere to the DuraSpace Code of
>> Conduct: https://duraspace.org/about/policies/code-of-conduct/
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "DSpace Technical Support" group.
>> To unsubscribe from

Re: [dspace-tech] new table in 6.3

2020-02-24 Thread Jose Blanco

Kind of stuck trying to create a query without having to map it.  This is
what I have:

@Override

public List findProxiesForDepositor(Context context, UUID
depositor_id) throws SQLException {



Query query = getHibernateSession(context).createSQLQuery("SELECT *
FROM EPerson WHERE uuid in (SELECT proxy_id from proxies where depositor_id
=:depositor_id)");

query.addEntity(EPerson.class);

query.setParameter("depositor_id", depositor_id);


List epersons = query.list();


return epersons;


}


It's telling me that :


[ERROR] EPersonDAOImpl.java:[187,14] cannot find symbol

[ERROR] symbol:   method
addEntity(java.lang.Class)

[ERROR] location: variable query of type org.hibernate.Query


I found something on the web that suggested I could do it this way.


If someone could correct this query, that would really help me because I
have others like it.


Thank you!

-Jose



On Thu, Feb 20, 2020 at 4:01 PM Tim Donohue  wrote:

> Hi Jose,
>
> There is one example of createNativeQuery() in the DSpace codebase itself
> here:
>
>
> https://github.com/DSpace/DSpace/blob/master/dspace-api/src/main/java/org/dspace/eperson/dao/impl/GroupDAOImpl.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:* 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() would be preferable.  I have 4
> tables that are not part of the dspace code that I need to manipulate.
>
> Thanks!
> -Jose
>
> On Thu, Feb 20, 2020 at 1:01 PM Tim Donohue 
> wrote:
>
> Hi Jose,
>
> That error from Hibernate usually means that you are trying to run a
> straight SQL query when it's expecting you to use HQL (Hibernate Query
> Language) and a Hibernate Entity object.  So, more than likely you need to
> do one of the following:
>
>
>- Either, Create a Hibernate Entity class that maps to this Table. See
>
> https://docs.jboss.org/hibernate/annotations/3.5/reference/en/html/entity.html
>  This
>is how DSpace 6.x (and above) already maps to existing tables...you'll see
>an Entity object corresponding to every table in the codebase.
>- Or, you might be able to tell Hibernate this is just a plain old SQL
>query by using Hibernate's "createNativeQuery()" 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
>
> --
> *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 - 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 messages to this mailing list should adhere to the DuraSpace Code of
> Conduct: https://duraspace.org/about/policies/code-of-conduct/
> ---
> You received this message because you are subscribed to the Google Groups
> "DSpace Technical Support" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dspace-tech+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/dspace-tech/CAK%3DKc-uyfZ8QofBe2Mo9WKyPDSAA8vvOgh4HfsAM%3DJWGPFsNNw%40mail.gmail.com
> <https://groups.google.com/d/msgid/dspace-tech/CAK%3DKc-uyfZ8QofBe2Mo9WKyPDSAA8vvOgh4HfsAM%3DJWGPFsNNw%40mail.gmail.com?utm_medium=email_source=footer>
> .
>
>

-- 
All messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: https://duraspace.org/about/policies/code-of-conduct/
--- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/CAK%3DKc-vTcRvGYgE%2B5oHHeaF5zJD5RSkQafvcHEYz9w_aiFQcrQ%40mail.gmail.com.

Re: [dspace-tech] new table in 6.3

2020-02-20 Thread Tim Donohue

Hi Jose,

There is one example of createNativeQuery() in the DSpace codebase itself here:

https://github.com/DSpace/DSpace/blob/master/dspace-api/src/main/java/org/dspace/eperson/dao/impl/GroupDAOImpl.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: 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() would be preferable.  I have 4 tables that are 
not part of the dspace code that I need to manipulate.

Thanks!
-Jose

On Thu, Feb 20, 2020 at 1:01 PM Tim Donohue 
mailto:tim.dono...@lyrasis.org>> wrote:
Hi Jose,

That error from Hibernate usually means that you are trying to run a straight 
SQL query when it's expecting you to use HQL (Hibernate Query Language) and a 
Hibernate Entity object.  So, more than likely you need to do one of the 
following:


  *   Either, Create a Hibernate Entity class that maps to this Table. See 
https://docs.jboss.org/hibernate/annotations/3.5/reference/en/html/entity.html 
This is how DSpace 6.x (and above) already maps to existing tables...you'll see 
an Entity object corresponding to every table in the codebase.
  *   Or, you might be able to tell Hibernate this is just a plain old SQL 
query by using Hibernate's "createNativeQuery()" 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


From: dspace-tech@googlegroups.com<mailto:dspace-tech@googlegroups.com> 
mailto:dspace-tech@googlegroups.com>> on behalf 
of Jose Blanco mailto:blan...@umich.edu>>
Sent: Thursday, February 20, 2020 10:42 AM
To: DSpace Technical Support 
mailto:dspace-tech@googlegroups.com>>
Subject: [dspace-tech] new table in 6.3

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<mailto:blan...@umich.edu>']

How do I map indiviual_stats table?

Thank you!
-Jose

--
All messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: https://duraspace.org/about/policies/code-of-conduct/
---
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
dspace-tech+unsubscr...@googlegroups.com<mailto:dspace-tech+unsubscr...@googlegroups.com>.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/CAK%3DKc-uyfZ8QofBe2Mo9WKyPDSAA8vvOgh4HfsAM%3DJWGPFsNNw%40mail.gmail.com<https://groups.google.com/d/msgid/dspace-tech/CAK%3DKc-uyfZ8QofBe2Mo9WKyPDSAA8vvOgh4HfsAM%3DJWGPFsNNw%40mail.gmail.com?utm_medium=email_source=footer>.

-- 
All messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: https://duraspace.org/about/policies/code-of-conduct/
--- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/CY4PR2201MB11431A47CAB0178181625EDFED130%40CY4PR2201MB1143.namprd22.prod.outlook.com.

Re: [dspace-tech] new table in 6.3

2020-02-20 Thread Jose Blanco

Looking for an example.  I wonder if someone in the community has done
this. I think using createNativeQuery() would be preferable.  I have 4
tables that are not part of the dspace code that I need to manipulate.

Thanks!
-Jose

On Thu, Feb 20, 2020 at 1:01 PM Tim Donohue  wrote:

> Hi Jose,
>
> That error from Hibernate usually means that you are trying to run a
> straight SQL query when it's expecting you to use HQL (Hibernate Query
> Language) and a Hibernate Entity object.  So, more than likely you need to
> do one of the following:
>
>
>- Either, Create a Hibernate Entity class that maps to this Table. See
>
> https://docs.jboss.org/hibernate/annotations/3.5/reference/en/html/entity.html
>  This
>is how DSpace 6.x (and above) already maps to existing tables...you'll see
>an Entity object corresponding to every table in the codebase.
>- Or, you might be able to tell Hibernate this is just a plain old SQL
>query by using Hibernate's "createNativeQuery()" 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
>
> --
> *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 - 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 messages to this mailing list should adhere to the DuraSpace Code of
> Conduct: https://duraspace.org/about/policies/code-of-conduct/
> ---
> You received this message because you are subscribed to the Google Groups
> "DSpace Technical Support" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dspace-tech+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/dspace-tech/CAK%3DKc-uyfZ8QofBe2Mo9WKyPDSAA8vvOgh4HfsAM%3DJWGPFsNNw%40mail.gmail.com
> 
> .
>

-- 
All messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: https://duraspace.org/about/policies/code-of-conduct/
--- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/CAK%3DKc-stwWTCxeu7C_gcMY30dj1OdXu5Jx5rLqas%3Dc%2BK4puYog%40mail.gmail.com.

Re: [dspace-tech] new table in 6.3

2020-02-20 Thread Tim Donohue

Hi Jose,

That error from Hibernate usually means that you are trying to run a straight 
SQL query when it's expecting you to use HQL (Hibernate Query Language) and a 
Hibernate Entity object.  So, more than likely you need to do one of the 
following:


  *   Either, Create a Hibernate Entity class that maps to this Table. See 
https://docs.jboss.org/hibernate/annotations/3.5/reference/en/html/entity.html 
This is how DSpace 6.x (and above) already maps to existing tables...you'll see 
an Entity object corresponding to every table in the codebase.
  *   Or, you might be able to tell Hibernate this is just a plain old SQL 
query by using Hibernate's "createNativeQuery()" 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


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 - 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 messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: https://duraspace.org/about/policies/code-of-conduct/
---
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/CAK%3DKc-uyfZ8QofBe2Mo9WKyPDSAA8vvOgh4HfsAM%3DJWGPFsNNw%40mail.gmail.com.

-- 
All messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: https://duraspace.org/about/policies/code-of-conduct/
--- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/CY4PR2201MB1143DAEB63142803C1580A87ED130%40CY4PR2201MB1143.namprd22.prod.outlook.com.

Re: [dspace-tech] new table in 6.3

Re: [dspace-tech] new table in 6.3

Re: [dspace-tech] new table in 6.3

Re: [dspace-tech] new table in 6.3

Re: [dspace-tech] new table in 6.3

Re: [dspace-tech] new table in 6.3

Re: [dspace-tech] new table in 6.3

Re: [dspace-tech] new table in 6.3

Re: [dspace-tech] new table in 6.3

9 matches

Site Navigation

Mail list logo

Footer information