From bash, I ran the following:

java -Djdbc.drivers=$DRIVERS -Ddbd.port=9001 com.vizdom.dbd.jdbc.Serve +r^Zexport CLASSPATH=dbd_jdbc.jar:/oracle/jdbc/classes111.zip:$CLASSPA +TH DRIVERS=oracle.jdbc.driver.OracleDriver java -Djdbc.drivers=$DRI +VERS -Ddbd.port=9001 -Ddbd.trace=tedious com.vizdom.dbd.jdbc.Server

and I received the following error:

Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/ +logging/log4j/LogManager at com.vizdom.dbd.jdbc.Server.<clinit>(Server.java:70) Caused by: java.lang.ClassNotFoundException: org.apache.logging.log4j. +LogManager at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass( +BuiltinClassLoader.java:641) at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.l +oadClass(ClassLoaders.java:188) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java: +520)

So, that would lead me to believe that the environment variables, are not set up properly. However, My environment variables point to the C:\jars folder. And, in this folder, I have the following files: dbd_jdbc.jar, log4j2.properties, tdgssconfig.jar, and log4j-1.2.13.jar - so, am I missing a file?

Here is my class path:

C:\Users\pMalle001>echo %CLASSPATH%. .;C:\jars\*;C:\Program Files\Teradata\Client\16.20\bin\;C:\Program Fil +es\Teradata\Client\16.20\bin\tdgeospatial.jar;C:\Program Files (x86)\ +Teradata\Client\16.20\bin\;C:\Program Files (x86)\Teradata\Client\16. +20\bin\tdgeospatial.jar;C:\Program Files\Teradata\Client\16.20\bin\;C +:\Program Files\Teradata\Client\16.20\bin\jmsam.jar;C:\Program Files +(x86)\Teradata\Client\16.20\bin\;C:\Program Files (x86)\Teradata\Clie +nt\16.20\bin\jmsam.jar;C:\Users\pMalle001\Downloads\trino-jdbc-362.ja +r;.

Here is my path:

C:\Users\pMalle001>echo %PATH% C:\Program Files\Teradata\Client\16.20\bin;C:\Program Files (x86)\Tera +data\Client\16.20\bin;C:\Program Files (x86)\Teradata\Client\16.10\bi +n;C:\Program Files\Java\jdk-17\bin;C:\Program Files\Common Files\Orac +le\Java\javapath;C:\Program Files (x86)\Common Files\Oracle\Java\java +path;C:\Strawberry\c\bin;C:\Strawberry\perl\site\bin;C:\Strawberry\pe +rl\bin;C:\Users\pMalle001\AppData\Local\Programs\Python\Python311\;C: +\Oracle\product\11.2.0\client_1\64Bit;C:\Oracle\product\11.2.0\client +_1;C:\Windows\System32;C:\Windows;C:\Windows\System32\wbem;C:\Windows +\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Pro +gram Files (x86)\Symantec\VIP Access Client\;C:\Program Files (x86)\W +inSCP\;C:\Program Files (x86)\GnuPG\bin;C:\Program Files\nodejs\;C:\P +rogramData\chocolatey\bin;C:\Program Files\Microsoft SQL Server\Clien +t SDK\ODBC\170\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Serve +r\150\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\Tools\Bin +n\;C:\Program Files\Microsoft SQL Server\150\DTS\Binn\;C:\Program Fil +es (x86)\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files\Azure Da +ta Studio\bin;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C +:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\Program F +iles (x86)\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\ +Microsoft SQL Server\130\DTS\Binn\;C:\Program Files (x86)\Microsoft S +QL Server\140\DTS\Binn\;C:\Work\Programming\sharepointDrive\powerShel +l\PSTools;C:\Program Files\Git\cmd;C:\Users\pMalle001\AppData\Local\P +rograms\Python\Python311\Scripts\;C:\Users\pMalle001\AppData\Local\Pr +ograms\Python\Python311\;C:\Users\pMalle001\AppData\Local\Microsoft\W +indowsApps;C:\Users\pMalle001\AppData\Roaming\npm;C:\Program Files\Az +ure Data Studio\bin;C:\Users\pMalle001\AppData\Local\GitHubDesktop\bi +n

Any thoughts or ideas as to where I'm going wrong would be appreciated.


In reply to Re^2: Trying to connect to DBD::JDBC - com.vizdom.dbd.jdbc.Server by mallett76
in thread Trying to connect to DBD::JDBC - com.vizdom.dbd.jdbc.Server by mallett76

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.