Grouper Developers Forum

["Klug, Lawrence" <>]

Hi Chris,

 

Apparently MS SQLServer has different syntax for creating a table using a SELECT statement.  It uses “select into” rather than “create table as.”

 

Changed the following SQL statement at line 87:

 

create table bak_grouper_attributes as (select * from grouper_attributes);

 

To this:

 

select * into bak_grouper_attributes from grouper_attributes;

 

The other issue I encountered was “commit without corresponding Begin Transaction”  and so I ended up running the script from SQLServer Management Studio a chunk at a time.  After that, the registry check succeeded.

 

Thanks,

 

Lawrence

 

 

 

From: Chris Hyzer [mailto:]
Sent: Saturday, August 13, 2011 6:19 PM
To: Klug, Lawrence; Grouper Dev
Subject: RE: DDL Script error

 

What was the change you made to make it work?

 

Thanks,

Chris

 

---

From: [] on behalf of Klug, Lawrence []
Sent: Friday, August 12, 2011 5:45 PM
To: Grouper Dev
Subject: [grouper-dev] RE: DDL Script error

This has been resolved.  Modified the script for  SQLServer  syntax.

 

From: [mailto:] On Behalf Of Klug, Lawrence
Sent: Friday, August 12, 2011 9:18 AM
To: Grouper Dev
Subject: [grouper-dev] DDL Script error

 

Hi,

 

I’m getting an error when running the Grouper 2  DDL script against SQLServer 2005 - using jtds 1.2 JDBC driver – running from gsh.  Has anyone else seen this behavior?

 

Thanks,

 

Lawrence

 

 

Error running script: C:\Users\lklug\Documents\workspace4\grouper.api-2.0.0\ddlScripts\grouperDdl_20110812_09_01_20_689.sql.tmp, java.sql.SQLException: Incorrec

t syntax near the keyword 'as'.

        at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:463)

        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.sqlRun(GrouperDdlUtils.java:805)

        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.sqlRun(GrouperDdlUtils.java:742)

        at edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:127)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:188)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:128)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:16)

Caused by: java.sql.SQLException: Incorrect syntax near the keyword 'as'.

        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)

        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)

        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)

        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)

        at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)

        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)

        at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664)

        at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1114)

        at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:565)

        at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:535)

        at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:776)

        at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:706)

        at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:449)

        ... 10 more

 

Lawrence Klug

Grouper Integration

UCLA Middleware Services

Office: 310 825-2061

Cell: 818 667-2386