Trying to get Java programs working.
Good news, we're running 2017.1
Bad News, we're still running Pervasive v7.9 SP4 (2000i)
When I go to enter the Java settings (SM-T), the first thing I get is an error that windows can't find pvddl.exe. Pressing OK bypasses that bit. At the SM-T screen everything looks ok, but when I test the connection, it says connection unsuccessful. The .log file should follow.
When I go to fiddle with the Databases in PCC, I can't add a new database to our Pervasive server, it's saying it cannot retrieve the database names, but the database I want to use for JAVA (EVOB) is there already and it's pointing to our Evo Default folder for our main company files. So that's weird.
Some Google searching led me to think maybe the server securities were messed up. I read mention of "Pervasive_Admin" group being needed, so I added a group named that and then made sure I was in that group.
With these settings if I try to run BM-N, I get the following in my log file:
Code:------------------------------------------------------------
SEVERE -- BOM Tree -- Wed Mar 22 15:44:33 PDT 2017
---------------------------
Error getting items
Caller: com.evoerp.bomtree.javafx.NewTreePane$ItemStubWaitTask failed
---------------------------
Build date = 9-16-2014
Version = 2.2.5
Company = B
DB Host = Wire
DB Port = 1583
DB Name = EVOB
Report Dest = \\Wire\mrp\DBAMFG\REPORTS
Pervasive = ?
Evo Version = 2017.1
Company ID = null
User Name = null
---------------------------
java.util.concurrent.ExecutionException: java.lang.NullPointerException
at java.util.concurrent.FutureTask.report(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at com.evoerp.bomtree.javafx.NewTreePane$ItemStubWaitTask.call(NewTreePane.java:364)
at com.evoerp.bomtree.javafx.NewTreePane$ItemStubWaitTask.call(NewTreePane.java:352)
at javafx.concurrent.Task$TaskCallable.call(Task.java:1423)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
at com.evoerp.sql.DatabaseWorkerService.getThreadLocalConn(DatabaseWorkerService.java:86)
at com.evoerp.bomtree.sql.TreeWorkerService.access$800(TreeWorkerService.java:22)
at com.evoerp.bomtree.sql.TreeWorkerService$ItemStubTask.call(TreeWorkerService.java:243)
at com.evoerp.bomtree.sql.TreeWorkerService$ItemStubTask.call(TreeWorkerService.java:233)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at com.evoerp.sql.DatabaseWorkerService$ConnectionClosingThreadFactory.lambda$newThread$0(DatabaseWorkerService.java:174)
... 1 more
------------------------------------------------------------
Here's the SM-T error info.
Code:Test Settings Attempt -- Wed Mar 22 15:37:42 PDT 2017
----------------------------------------------------------
company = B
serial = Ahem!
db host = Wire
db port = 1583
db name = EVOB
----------------------------------------------------------
[03:37:42 pm] java.util.concurrent.ExecutionException: java.sql.SQLException: java.net.ConnectException: Connection timed out: connect -- java.sql.SQLException: java.net.ConnectException: Connection timed out: connect
java.util.concurrent.ExecutionException: java.sql.SQLException: java.net.ConnectException: Connection timed out: connect
at java.util.concurrent.FutureTask.report(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at javax.swing.SwingWorker.get(Unknown Source)
at ui.ProgressFrame$1.done(ProgressFrame.java:103)
at javax.swing.SwingWorker$5.run(Unknown Source)
at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(Unknown Source)
at sun.swing.AccumulativeRunnable.run(Unknown Source)
at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(Unknown Source)
at javax.swing.Timer.fireActionPerformed(Unknown Source)
at javax.swing.Timer$DoPostEvent.run(Unknown Source)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.sql.SQLException: java.net.ConnectException: Connection timed out: connect
at com.pervasive.jdbc.v2.Connection.<init>(Connection.java:151)
at com.pervasive.jdbc.v2.Driver.connect(Driver.java:57)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at ui.ProgressFrame$1.doInBackground(ProgressFrame.java:76)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
[03:37:42 pm] java.sql.SQLException: java.net.ConnectException: Connection timed out: connect -- java.net.ConnectException: Connection timed out: connect
java.sql.SQLException: java.net.ConnectException: Connection timed out: connect
at com.pervasive.jdbc.v2.Connection.<init>(Connection.java:151)
at com.pervasive.jdbc.v2.Driver.connect(Driver.java:57)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at ui.ProgressFrame$1.doInBackground(ProgressFrame.java:76)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)