JDBC Connection Issue

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
Report Content as Inappropriate

JDBC Connection Issue

This post has NOT been accepted by the mailing list yet.
I am attempting to connect to a database to start a baseline user authentication program. I was able to use the shiro.ini to get user roles, but I'm getting an error when trying to run the program using a JDBC connection. I have tried using both the Microsoft sqljdbc42.jar and the jTDS jar file as well, with no difference in the result. Either way I get the following error:

[ERROR] No plugin found for prefix 'java' in the current project and in the plugin groups [org.apache.maven.plugins, org.codehaus.mojo] available from the repositories [local (C:\Users\mainuser.m2\repository), central (https://repo.maven.apache.org/maven2)] -> [Help 1]

I've seen a couple of different troubleshooting questions for "No plugin found for prefix" but none for 'java', so I'm at a loss as to how to proceed.

Here is my Shiro.ini file, using the jTDS jar:

ds = net.sourceforge.jtds.jdbcx.JtdsDataSource
ds.serverName = SQL5
ds.user = myUser
ds.password = myPassword
ds.databaseName = myDatabase

jdbcRealm = org.apache.shiro.realm.jdbc.JdbcRealm
jdbcRealm.dataSource = $ds
jdbcRealm.permissionsLookupEnabled = true
jdbcRealm.authenticationQuery = "SELECT pswd FROM Users     WHERE user = ?"
jdbcRealm.userRolesQuery = "SELECT role FROM Role WHERE user = ?"
jdbcRealm.permissionsQuery = "SELECT perm FROM Permission WHERE user = ?"

Here is my pom.xml file, using the jTDS jar:

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">

<name>First Apache Shiro Application</name>