Recuperar a Sequencia do Banco Postgree

Assuntos Gerais
#1

Pessoal,

Estou tentando recuparar a sequencia do banco de dados, porem esta dando o erro abaixo :

Exception Description: Syntax error parsing the query [select nextval(‘cadguia_codguia_seq’) as id ], line 1, column 14: unexpected token [(].
Internal Exception: NoViableAltException(83@[()* loopback of 383:9: (d= DOT right= attribute )*])
AVISO: EJB5184:A system exception occurred during an invocation on EJB CadguiaDao, method: public java.util.List br.uniplan.dao.planouni.CadguiaDao.seq_cadguia()
AVISO: javax.ejb.EJBException
at com.sun.ejb.containers.BaseContainer.processSystemException(BaseContainer.java:5215)
at com.sun.ejb.containers.BaseContainer.checkExceptionNoTx(BaseContainer.java:5044)
at com.sun.ejb.containers.BaseContainer.checkExceptionBeanMgTx(BaseContainer.java:4965)
at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:4865)
at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:2045)
at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1994)
at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:222)
at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:89)
at $Proxy134.seq_cadguia(Unknown Source)
at br.uniplan.dao.planouni.EJB31_Generated__CadguiaDao__Intf____Bean.seq_cadguia(Unknown Source)

Segue abaixo meu codigo

Entidade
public class Cadguia implements Serializable {
    private static final long serialVersionUID = 1L;
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Basic(optional = false)
    @Column(name = "codguia")
    private Integer codguia;
    @Size(max = 1)
    @Column(name = "tipoguia")
    private String tipoguia;



********************************

    @Interceptors({GerenciaTransacaoInterceptor.class})  
    public List<Object> seq_cadguia() {    
        try {      
            
            String query = "select nextval('cadguia_codguia_seq') as  id ";                            
            return (List<Object>) emAux.createQuery(query).getResultList();            
        }
        catch (Throwable ex) {             
                System.err.println("failed.----" + ex);  
                throw new ExceptionInInitializerError(ex);  
        }  
    }


    public void salvar(Cadguia obj) throws Exception {
//        super.salvar(obj);
        
                List<Object> objectList = dao.seq_cadguia();

                Iterator iterator = objectList.iterator();
                
                Integer sequencia_guia = 0;

                while(iterator.hasNext()){
                    Object []objseqguia = (Object[])iterator.next();
                    sequencia_guia =(Integer) objseqguia[0];
                    
                }   
                
                System.out.print("fdsafs"+sequencia_guia);
#2