Grouper Users - Open Discussion List

[Chris Hyzer <>]

Um… not sure what was happening in 2.0.0… if you didn’t specify it, it should use the SQLServerDriver, which maybe was in your classpath but you didn’t realize it?  2.0.0 didn’t do anything with jtds by default… not sure what the issue was…  oh well, moving forward… J

 

Chris

 

From: Klug, Lawrence [mailto:]
Sent: Wednesday, August 08, 2012 10:38 AM
To: Chris Hyzer;
Subject: RE: db driver mismatch

 

You nailed it again, Chris.  Specified the driver in loader config and now it’s running.  Apparently v2.1.1 requires it while 2.0.0 didn’t.

 

Thanks,

 

Lawrence

 

From: Chris Hyzer []
Sent: Tuesday, August 07, 2012 5:37 PM
To: Klug, Lawrence;
Subject: RE: db driver mismatch

 

Are you specifying the driver in the config?  Can you forward it to me (sanitized as you wish, no pass)?  Is it the Grouper DB or a different loader DB (which one)?

 

Thanks,

Chris

 

---

From: Klug, Lawrence []
Sent: Tuesday, August 07, 2012 5:17 PM
To: Chris Hyzer;
Subject: RE: db driver mismatch

Here is another error when running the loader job – scrolling to the bottom:

 

Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

 

Looks like another SQL Driver issue.  We are using jtds, but Grouper is looking for MSSQLDriver.

 

 

- Error on job: SQL_GROUP_LIST__ucla:etc:config:orgsConfig__9d70a670a42c46879323c815fa701ee3

java.lang.RuntimeException: Problems with db: DB: user: mgrgroup, url: jdbc:jtds:sqlserver://vader.qdb.ucla.edu:1433/qdb, driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

     at edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderDb.connection(GrouperLoaderDb.java:57)

     at edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderResultset.<init>(GrouperLoaderResultset.java:224)

     at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$3.runJob(GrouperLoaderType.java:401)

     at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:398)

     at edu.internet2.middleware.grouper.app.loader.GrouperLoader.runJobOnceForGroup(GrouperLoader.java:1004)

     at edu.internet2.middleware.grouper.app.gsh.loaderRunOneJob.invoke(loaderRunOneJob.java:57)

     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 bsh.Reflect.invokeMethod(Unknown Source)

     at bsh.Reflect.invokeStaticMethod(Unknown Source)

     at bsh.Reflect.invokeCompiledCommand(Unknown Source)

     at bsh.Name.invokeLocalMethod(Unknown Source)

     at bsh.Name.invokeMethod(Unknown Source)

     at bsh.BSHMethodInvocation.eval(Unknown Source)

     at bsh.BSHPrimaryExpression.eval(Unknown Source)

     at bsh.BSHPrimaryExpression.eval(Unknown Source)

     at bsh.Interpreter.eval(Unknown Source)

     at bsh.Interpreter.eval(Unknown Source)

     at bsh.Interpreter.eval(Unknown Source)

     at edu.internet2.middleware.grouper.app.gsh.ShellHelper.eval(ShellHelper.java:63)

     at edu.internet2.middleware.grouper.app.gsh.GrouperShell.run(GrouperShell.java:428)

     at edu.internet2.middleware.grouper.app.gsh.GrouperShell.grouperShellHelper(GrouperShell.java:232)

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

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

Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

     at java.net.URLClassLoader$1.run(URLClassLoader.java:202)

     at java.security.AccessController.doPrivileged(Native Method)

     at java.net.URLClassLoader.findClass(URLClassLoader.java:190)

     at java.lang.ClassLoader.loadClass(ClassLoader.java:306)

     at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)

     at java.lang.ClassLoader.loadClass(ClassLoader.java:247)

     at java.lang.Class.forName0(Native Method)

     at java.lang.Class.forName(Class.java:169)

     at edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderDb.connection(GrouperLoaderDb.java:51)

     ... 25 more

 

 

From: Klug, Lawrence
Sent: Tuesday, August 07, 2012 2:08 PM
To: Klug, Lawrence; Chris Hyzer;
Subject: RE: db driver mismatch

 

I think I found it in sources.xml – missing init param, eh?

 

From: On Behalf Of Klug, Lawrence
Sent: Tuesday, August 07, 2012 2:01 PM
To: Chris Hyzer;
Subject: [grouper-users] RE: db driver mismatch

 

This one jumps out:

 

2012-08-07 13:57:31,665: [main] ERROR LdapSourceAdapter.getNeededProperty(522) -  - Property 'SubjectID_formatToLowerCase' is not defined!

 

Did I miss another properly file?

 

Thanks,

 

Larry

 

From: Chris Hyzer
Sent: Tuesday, August 07, 2012 11:57 AM
To: Klug, Lawrence;
Subject: RE: db driver mismatch

 

There should be more logs in the error logs, can you send?

 

Thanks,

Chris

 

---

From: Klug, Lawrence []
Sent: Tuesday, August 07, 2012 1:05 PM
To: Chris Hyzer;
Subject: RE: db driver mismatch

Hi Chris,

 

Also getting this error when invoking loader job:

 

// Error: unable to evaluate command: Sourced file: inline evaluation of: ``loaderRunOneJob(group);'' : Error invoking compiled command: : Error in compiled command: java.lang.RuntimeException: java.lang.RuntimeException: Problems with db: DB: user: someUser, url: jdbc:jtds:sqlserver://someHost

 

thanks,

 

Lawrence

 

 

From: Chris Hyzer
Sent: Tuesday, August 07, 2012 9:28 AM
To: Klug, Lawrence;
Subject: RE: db driver mismatch

 

You can ignore that message, this is fixed in the upcoming 2.1.2 release:

 

https://bugs.internet2.edu/jira/browse/GRP-832 

 

Thanks,

Chris

---

From: [] on behalf of Klug, Lawrence []
Sent: Tuesday, August 07, 2012 11:15 AM
To:
Subject: [grouper-users] db driver mismatch

Seeing this message when running GSH in my v2.1.1 installation:

 

Grouper error: detected mismatch in hibernate.connection.driver_class (net.sourceforge.jtds.jdbc.Driver) and hibernate.dialect (org.hibernate.dialect.SQLServerDialect) in grouper.hibernate.properties

 

Using jtds-1.2.4

 

hibernate.dialect               = org.hibernate.dialect.SQLServerDialect

hibernate.cache.provider_class  = org.hibernate.cache.EhCacheProvider

hibernate.cache.use_query_cache  = true

hibernate.connection.driver_class = net.sourceforge.jtds.jdbc.Driver

 

How to fix this problem?

 

Thanks,

 

Lawrence Klug

IMS Platform Development

310 825-2061

ext 52061