After submission, you should see an OK next to your new datasource and it is available for use.ĭISCLAIMER: I have no idea if this violates any licensing for Java. This must exactly match the ODBC datasource name in Windows. For Connect string, enter “jdbc:odbc:”. Add a username of “System” and leave password blank. Under “Create new datasource”, give it a name and select “Other-JDBC Driver” and click Create. Confirm that your ODBC datasource is set up in the Windows ODBC manager. You should now have the classes available to set up an ODBC datasource in Lucee. This is typically at C:\lucee\jdk\jre\bin. Copy jdbcodbc.dll from JRE\bin of your JRE 7 installation to Lucee’s JRE\bin. This is typically at C:\lucee\jdk\jre\lib\ext. Copy JDBC.jar to your Lucee lib/ext folder. The above command will create a file named jdbc.jar. Example: “c:\Program Files\Java\jdk1.7.x\bin\jar.exe” -cvf jdbc.jar sun NOTE: You may need the full path to jar.exe in here. 
i.e., you should have the folder structure like below:
Copy sun\jdbc and sun\security\action folders out to a new folder, keep the folder structure.Unzip it (if you have WinRAR installed) or you can rename it to rt.zip and unzip it.Goto JRE\lib folder and find the rt.jar.ClassNotFoundException: JdbcOdbcDriver It happens because in JDK 8 or Java 8, JDBC ODBC Driver class has been removed.
Download a JDK 7 or JRE 7 and install it. Sun jdbc odbc jdbcodbcdriver download jar.First, you will need to extract and repackage the appropriate classes and DLL from a Java 1.7 install.
0 kommentar(er)
