Can you open a JIRA issue describing the problem. I can imagine to offer both possibilities on the GUI, having a drop box showing all detected drivers and alternatively an entry field for the class name. Obviously, this is needed to support Informix.
Zitat von thegis <the...@googlemail.com>: > Hi Christian, > > Thanks for your help and tests. Unfortunately I cannot test > authentication on another database. Informix is not crucial for us, > but it would still be nice support it through the new security system. > > Looking at the Informix docs, it seems that the driver needs to be > discovered through Class.forName [1] and instantiated with > DriverManager.getConnection(url) [2]. > > [1] > http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.jdbc_pg.doc/jdbc51.htm > [2] > http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.jdbc_pg.doc/jdbc48.htm > > Cheers, Torsten > > On Thu, Apr 19, 2012 at 8:31 AM, <christian.muel...@nvoe.at> wrote: >> Hi thegis, I did some tests. >> >> In my environment I have installed the following drivers. >> >> oracle >> db2 >> h2 >> postgres >> mysql >> hsqld >> ms sqlserver >> jdbc.odbc bridge >> >> I get all this drivers in the combo box. >> >> I downloaded the informix driver and interestingly, this is the only one NOT >> appearing in the list. >> >> No idea what is going on. Could you choose another database for your tests ? >> >> Christian >> >> Zitat von thegis <the...@googlemail.com>: >> >> >>>>> The question is therefore how to add an additional JDBC driver so that >>>>> it can be selected with the "New Authentication Provider" page? >>> >>> >>>> The panel used DriverManager.getDrivers to find available jdbc drivers. >>>> >>>> 1) Where did you download, I found the drivers here >>>> http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc >>>> >>>> 2) try to put the jar file(s) into JAVA_HOME/jre/lib/ext directory of the >>>> java installation used by geoserver. >>> >>> >>> Thanks Christian, I've tried with an old driver (3.00) and later with >>> the latest version (3.70) from 1), installed it and copied all jar's >>> to JAVA_HOME/jre/lib/ext. The ext folder now contains the following >>> jars: ifxjdbc.jar ifxjdbcx.jar ifxlang.jar ifxlsupp.jar >>> ifxsqlj.jar ifxtools.jar >>> >>> Unfortunately that didn't seem to work as the IfxDriver is still not >>> shown in the driver class dropdown box.. >>> >>> I've tried with Java 1.7 and 1.6 and also added >>> META-INF/services/java.sql.Driver to the jars in case they are needed >>> for the discovery through DriverManager.getDrivers. But that didn't >>> worked either. Any other ideas? >>> >> >> >> >> ---------------------------------------------------------------- >> This message was sent using IMP, the Internet Messaging Program. >> >> > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------------------------------ For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
